Key Responsibilities
* 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.
Data Modeling & Querying
The successful candidate will have a proven ability to develop semantic data models, craft efficient SQL queries, ensure data quality through Power Query transformations, design intuitive dashboards using advanced Power BI visualizations and DAX measures, and establish proper security protocols.
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.
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.
Continuous Improvement
* Stay current with emerging Power BI capabilities, DAX best practices, SQL performance enhancements, and analytics trends.
* Contribute to the development of best practices for analytics, data governance, and solution design.
Required Skills and Qualifications
* A strong background in data modeling and query optimization using SQL.
* Experience with Power BI development, including data modeling, Power Query, and DAX.
* Technical skills: Power BI, SQL, ETL tools and processes, version control, and CI/CD pipelines for BI solutions.
Benefits
* Competitive salary and flexible PTO.
* Company-provided computer and stock options.
Other Requirements
* C1 English proficiency is required.