Duration: 6 months to start (with potential for conversion)
Job Description
- We are seeking a highly skilled and experienced Senior Analytics Engineer with expertise in Microsoft technologies to join our dynamic team
- The ideal candidate will be responsible for designing, developing, and maintaining business intelligence solutions, with a strong emphasis on semantic layer design and scalable data modeling.
- This role will involve collaborating with cross-functional teams to gather requirements, design data models, and implement robust BI solutions to support business objectives.
Design and Development of BI Solutions:
- Architect, design, and develop end-to-end business intelligence solutions using the Microsoft BI stack.
- Design, develop, and maintain scalable semantic layers to support enterprise reporting and analytics.
- Define data models, metrics, and KPIs for reporting and analytics.
- Lead efforts to design and optimize scalable multidimensional and tabular data models using SSAS/AAS and modern semantic modeling approaches.
- Demonstrate strong proficiency in DAX, Power Query, and SQL, along with designing intuitive and interactive Power BI dashboards.
- Work with modern data platforms including Snowflake to support analytics and reporting workloads.
- Manage project timelines, priorities, and deliverables effectively.
- Collaborate with cross-functional teams to deliver high-quality BI solutions.
- Communicate effectively with stakeholders to gather and refine requirements.
- Serve as a best practices resource for BI and analytics initiatives.
- Conduct training sessions and enablement for business users on modern BI tools.
- Mentor and guide junior team members on BI and data modeling best practices.
- Monitor and administer Power BI service capacities and environments.
- Troubleshoot, debug, and optimize BI solutions (reports, cubes, and semantic models).
- Define and maintain BI frameworks, semantic layers, and metadata repositories to support data governance.
- Document data warehouse structures, BI solutions, and metadata.
- Act as an escalation point for Power BI-related issues.
- Create and maintain technical documentation for BI tools and solutions.
- Bachelor’s degree in Computer Science, Engineering, or related field.
- 5–7 years of experience designing and developing BI solutions using Microsoft technologies.
- Strong proficiency in SQL, SSAS/AAS tabular modeling, DAX, Power BI, Paginated Reports, Gateway, Service, and Security.
- Experience working with Azure-based BI solutions (Azure SQL, Synapse, Data Factory, Data Lakes).
- Experience working with Snowflake, including data modeling and delivering analytics via Power BI.
- Strong experience designing semantic layers (core requirement).
- Experience with Power BI Service administration and capacity governance.
- Strong problem-solving, analytical, and communication skills.
- Hands-on experience with ETL development and data integration.
- Extensive knowledge of Microsoft AAS/SSAS in developing cubes.
- Extensive knowledge of Microsoft Fabric and related tools.
- Strong expertise in semantic layer design and data modeling.
- Advanced knowledge of Power Query and DAX.
- Experience using Git for version control and deployment.
- Must have hands-on experience working with Snowflake.
- Experience working with Databricks.
- Experience with AI-driven analytics and reporting, including tools such as Microsoft Copilot and Snowflake Cortex.
- Relevant certifications (e.g., Microsoft Certified: Data Analyst Associate, Azure Data Engineer Associate, Power BI).
- Experience with PowerShell.
- Experience coding in Python.
- Experience on MCP server integration and LLM models.
- Experience working and configuring AI Data Agents. Behavioral Competencies:
- Self-motivated with strong problem-solving abilities.
- Ability to work effectively across all levels of the organization.
- High attention to detail and commitment to quality.
- Ability to operate with urgency in ambiguous or high-risk situations.
- Strong collaboration skills and team-oriented mindset.
#LI-Hybrid
