Job Title: Data Analytics Specialist
About the Role:
We are seeking an experienced Power BI Engineer to join our team. The ideal candidate will have a strong background in data modeling, DAX, and Power Query, as well as excellent communication skills to collaborate with stakeholders and translate technical findings into actionable insights.
Key Responsibilities:
* Develop and maintain data models in 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 data models (star/snowflake schema) in Power BI, leveraging advanced SQL queries.
* 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 (e.g., relational databases, APIs, CSV files).
Report & Dashboard Development:
* Design and build interactive, user-friendly Power BI dashboards and reports that convey insights effectively.
* Develop, optimize, and maintain DAX calculations, measures, and KPIs.
Security & Governance:
* Implement Row-Level Security (RLS) or other relevant Power BI security features to protect sensitive data.
* 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.
* Diagnose and resolve report rendering and data refresh performance issues.
Qualifications:
* 3+ years of professional experience with Power BI development, including data modeling, Power Query, and DAX.
* Strong SQL proficiency, including complex joins, stored procedures, and performance tuning.
Benefits:
* Competitive salary
* Company-provided computer
* Stock options
* Flexible PTO