**Job Description:**
We are seeking a highly skilled Power BI Developer with a strong background in SQL to design, build, and maintain robust reporting solutions.
Key Responsibilities:
* Develop and maintain data models using Power BI, leveraging advanced SQL queries.
* Create semantic models that accurately represent business logic and support optimal report performance.
Data Modeling & Querying:
* Develop and maintain star/snowflake schema data models in Power BI.
* Create semantic models that accurately represent business logic and support optimal report performance.
ETL & Data Transformations:
* Utilize Power Query for data shaping, cleaning, and transformation, ensuring data integrity and consistency.
* Collaborate with data engineering teams to integrate various data sources.
Report & Dashboard Development:
* Design and build interactive, user-friendly Power BI dashboards and reports.
* Develop, optimize, and maintain DAX calculations, measures, and KPIs.
Security & Governance:
* Implement Row-Level Security (RLS) or other relevant Power BI security features.
* Work with management teams to ensure adherence to data governance and regulatory requirements.
Performance Tuning & Troubleshooting:
* Optimize Power BI data models, queries, and measures for performance and scalability.
* Determine and resolve report rendering and data refresh performance issues.
Collaboration & Stakeholder Engagement:
* Partner with business stakeholders to gather requirements and deliver actionable reports and insights.
* Provide training, documentation, and support to end-users and other internal teams.
Required Skills and Qualifications:
1. 3+ years of professional experience with Power BI development, including data modeling, Power Query, and DAX.
2. Strong SQL proficiency, including complex joins, stored procedures, and performance tuning.
3. Technical Skills:
* Power BI: Data modeling, DAX, Power Query M.
* SQL: SQL, query optimization, data warehousing concepts.
* ETL Tools & Processes: Understanding of data pipelines, transformations, and integration.
* Version Control (e.g., Git) and CI/CD pipelines for BI solutions (a plus).
* Familiarity with Row-Level Security and other Power BI security features.
* Experience with Azure Data Services (e.g., Azure Synapse, Azure Analysis Services) is a plus.
4. Soft Skills:
* Strong communication skills to collaborate with stakeholders and translate technical findings into actionable insights.
* Adaptable team player who can work in an agile environment.
* Proven problem-solving skills and high attention to detail.
Benefits:
* Competitive salary
* Company-provided computer
* Stock options
* Flexible PTO