Job Title: Business Intelligence Analyst - Data Modeler
">
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.
">
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 & Qualifications
">
Experience:
* 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: 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.
">
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
">
Salary, flexible PTO, company-provided computer, and stock options make this an attractive opportunity.
"],