Job Summary:
We are seeking a motivated and detail-oriented Power BI Developer to join our growing data and analytics team. The ideal candidate will have a passion for data visualization and a strong analytical mindset. You will be responsible for transforming raw business data into actionable insights by developing interactive and visually appealing dashboards and reports. This role requires a foundational understanding of data warehousing, strong SQL skills, and the ability to translate business requirements into technical solutions.
Key Responsibilities:
- Design, develop, and deploy visually compelling and interactive Power BI dashboards and reports to support business decision-making.
- Collaborate with stakeholders to study, analyze, and understand business requirements for business intelligence solutions.
- Identify and define key performance indicators (KPIs) and metrics relevant to business objectives.
- Write and optimize complex SQL queries to extract, transform, and load data from various sources.
- Develop and run DAX queries and functions to create robust calculations and models within Power BI.
- Apply data modeling techniques to structure data effectively for reporting and analysis.
- Analyze historical and present data to identify trends, patterns, and opportunities for improvement.
- Translate business requirements into clear technical specifications and documentation.
- Create and maintain comprehensive data documentation for algorithms, parameters, models, and data sources.
- Perform detailed analysis and troubleshooting on new and existing Power BI reports to ensure accuracy and performance.
Qualifications and Skills:
Required:
- Bachelor's degree in Computer Science, Information Systems, Business Analytics, or a related field.
- 2-3 years of hands-on experience in a data analysis or business intelligence role.
- Proven proficiency in Microsoft Power BI, including creating complex reports, dashboards, and data visualizations.
- Strong expertise in SQL for data querying and manipulation.
- Solid understanding of Data Warehousing (DWH) concepts and principles.
- Experience with data modeling concepts and best practices.
- Proficiency in writing DAX queries and functions.
- Excellent analytical and problem-solving skills with the ability to understand business needs.
- Strong written and verbal communication skills.
- Ability to work both independently and as part of a collaborative team.
Nice to Have:
- Experience with Microsoft Dynamics 365 (D365) backend data structures.
- Experience with cloud data platforms such as Azure SQL Database, Azure Synapse Analytics, etc.
- Understanding of ETL processes.