Description of the job
Job Overview: We are seeking a talented and detail-oriented Business Intelligence (BI) Specialist with expertise in Microsoft Excel and Power BI to join our team. The ideal candidate will design, develop, and implement data-driven solutions to support strategic decision-making. This role involves creating advanced dashboards, conducting data analysis, and ensuring data quality while collaborating across teams.
Key Responsibilities:
• Develop and maintain interactive dashboards and reports using Power BI to meet business requirements.
• Leverage advanced Excel functionalities (e.g., Power Query, Pivot Tables, VBA) to analyze and visualize data effectively.
• Collaborate with stakeholders to understand data and reporting needs and translate them into technical deliverables.
• Ensure data accuracy, integrity, and consistency through rigorous quality control and validation.
• Design and optimize data models in Power BI for efficient and effective reporting.
• Integrate data from various sources and manage ETL (Extract, Transform, Load) processes.
• Provide training and support to end-users for Power BI and Excel tools.
• Continuously improve BI solutions by staying updated with the latest features and best practices in Power BI and Excel.
Core Skill Sets:
• Required:
? Microsoft Excel: Proficiency in advanced Excel features including Power Query, Pivot Tables, and macros.
? Power BI Development: Expertise in designing, developing, and deploying dashboards and reports.
? Data Analysis: Strong analytical skills to interpret complex data and provide actionable insights.
? Quality Control: Commitment to maintaining high data quality and consistency.
? Team Collaboration: Effective communication skills to work seamlessly across teams.
? Project Management: Ability to manage multiple projects and meet deadlines.
• Bonus:
? CRM Integration: Experience integrating Power BI with Customer Relationship Management systems.
? API Integration: Knowledge of API-based data extraction and integration.
? AI Integration: Familiarity with AI and machine learning for enhanced BI capabilities.
? Healthcare Experience: Understanding of healthcare industry data and compliance requirements.
Qualifications:
• Proven experience as a BI Specialist, Power BI Developer, or in a similar role.
• Proficiency in Power BI (DAX, Power Query) and advanced Excel features.
• Strong knowledge of database management, SQL, and data modeling.
• Familiarity with data governance and best practices in business intelligence.
• Knowledge of other BI tools (e.g., Cognos) is a plus.
Preferred Attributes:
• Highly detail-oriented with a focus on producing accurate and reliable results.
• Self-driven and able to work independently or as part of a team.
• Passion for continuous learning and staying updated with BI trends and advancements.
If you are passionate about transforming data into actionable insights and have the technical expertise to develop cutting-edge BI solutions, we encourage you to apply. Join us and contribute to empowering data-driven decision-making across our organization!
PM20