Senior Analytics Engineer

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.

Key Responsibilities:

1. Design and Development of BI Solutions:

a. Architect, design, and develop end-to-end business intelligence solutions using the Microsoft BI stack.

b. Design, develop, and maintain scalable semantic layers to support enterprise reporting and analytics.

c. Define data models, metrics, and KPIs for reporting and analytics.

d. Lead efforts to design and optimize scalable multidimensional and tabular data models using SSAS/AAS and modern semantic modeling approaches.

e. Demonstrate strong proficiency in DAX, Power Query, and SQL, along with designing intuitive and interactive Power BI dashboards.

f. Work with modern data platforms including Snowflake to support analytics and reporting workloads.

1. Project Management and Collaboration:

a. Manage project timelines, priorities, and deliverables effectively.

b. Collaborate with cross-functional teams to deliver high-quality BI solutions.

c. Communicate effectively with stakeholders to gather and refine requirements.

d. Serve as a best practices resource for BI and analytics initiatives.

e. Conduct training sessions and enablement for business users on modern BI tools.

f. Mentor and guide junior team members on BI and data modeling best practices.

1. Administration and Documentation:

a. Monitor and administer Power BI service capacities and environments.

b. Troubleshoot, debug, and optimize BI solutions (reports, cubes, and semantic models).

c. Define and maintain BI frameworks, semantic layers, and metadata repositories to support data governance.

d. Document data warehouse structures, BI solutions, and metadata.

e. Act as an escalation point for Power BI-related issues.

f. Create and maintain technical documentation for BI tools and solutions.

We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to View email address on click.appcast.io learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy:

Skills and Requirements

• 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.