Semantic Modeling and DAX

• Design, build, and optimize Power BI semantic models using Power BI Desktop, Tabular Editor, and related modeling tools.

• Develop advanced DAX measures and calculations to support complex business logic, reporting requirements, and analytical use cases.

• Ensure semantic models are scalable, maintainable, high-performing, and aligned with enterprise standards and best practices.

• Optimize semantic models within Microsoft Fabric, including performance tuning, model architecture, refresh processes, and usability.

• Troubleshoot Power BI models, measures, and refresh processes to improve reliability, efficiency, and user experience.

Microsoft Fabric and Analytics Engineering

• Develop and maintain Power BI datasets, reports, dataflows, and related assets supporting enterprise analytics solutions.

• Implement row-level security, incremental refresh, and other Power BI capabilities to support secure and efficient reporting.

• Work within Microsoft Fabric to deliver analytics solutions across lakehouse, warehouse, data pipeline, and semantic model components.

• Apply data modeling, analytics engineering, and performance optimization techniques to meet business and technical requirements.

• Support the design and delivery of scalable and governed enterprise analytics platforms.

Collaboration, Governance, and Enablement

• Partner with data engineers, analysts, business stakeholders, and report developers to understand requirements and deliver trusted analytics solutions.

• Support BI governance initiatives through documentation, data quality practices, Microsoft Purview alignment, and version control processes.

• Provide technical guidance, training, and support to end users, analysts, and junior developers.

• Promote standards for semantic model design, naming conventions, documentation, security, governance, and lifecycle management.

Behaviors and Competencies

• Communication: Can effectively communicate complex ideas and information to diverse audiences and can facilitate effective communication between others.

• Listening: Can actively engage in listening by asking clarifying questions and providing feedback that shows a deep understanding of the conversation.

• Presenting: Can design and deliver engaging presentations, adapting the content and style to suit the audience, context, and medium.

• Adaptability: Can proactively adapt to challenging situations, anticipate changes, and make modifications to meet the demands of changing circumstances.

• Problem-Solving: Can proactively identify potential problems, initiate preventive measures, and propose and contribute to innovative solutions.

• Initiative: Can proactively seek out challenges, initiate projects, and contribute to innovative ideas.

• Prioritization: Can proactively identify high-impact tasks, initiate action plans, and contribute to process improvements.

• Time Management: Can consistently use time effectively, balance multiple tasks, and meet deadlines.

• Technical Expertise: Can apply technical knowledge and skills effectively in complex situations and can guide others in the application of technical knowledge and skills.

• Teamwork: Can lead a team effectively, facilitating cooperation, sharing information, and ensuring that all team members are able to contribute to their full potential.

Skill Level Requirements

• Advanced expertise in analytics engineering, semantic modeling, and enterprise reporting solutions.

• Strong proficiency with DAX, including the ability to design and implement complex business calculations.

• Deep understanding of data warehousing concepts, dimensional modeling, star schema design, and analytics modeling best practices.

• Experience applying data modeling, optimization, and performance tuning techniques to enterprise analytics solutions.

• Strong analytical, troubleshooting, problem-solving, communication, and collaboration skills.

• Ability to work effectively with technical teams and business stakeholders.

• Experience implementing reporting security, governance standards, and data quality best practices.

• Familiarity with Agile delivery methodologies and version control practices.

Other Requirements

• Bachelor's degree in Computer Science, Software Engineering, or a related field, or relevant work experience required

• 5+ years of experience developing Power BI solutions, including semantic models, reports, and enterprise analytics assets.

• Hands-on experience with Power BI tools such as Tabular Editor, DAX Studio, and ALM Toolkit.

• Experience working with Microsoft Fabric, including semantic models and analytics workloads.

• Familiarity with lakehouse storage concepts and file formats such as Parquet and Delta.

• Experience with Agile delivery practices and version control using GitHub or similar tools.

• Ability to travel 10%

Preferred

• Certification in Microsoft Power BI, Microsoft Fabric, Azure, or related Microsoft data platforms.

• Experience using Python for data analysis, automation, or analytics engineering workflows.

• Experience with PowerApps automation and Copilot Studio.