As a Data Analytics Expert, you will design and develop robust reporting solutions using Power BI. With a strong background in SQL, you will create semantic data models that accurately represent business logic and support optimal report performance.
Data Modeling & Querying
* Develop and maintain star/snowflake schemas in Power BI, leveraging advanced SQL queries.
* Create semantic models that effectively translate business requirements into actionable insights.
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 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:
Experience:
* At least 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.
* Technical skills: Power BI, SQL, ETL tools and processes, version control, and CI/CD pipelines.
Benefits:
* Competitive salary
* Company-provided computer
* Stock options
* Flexible PTO