Lead Analytics Architect/Engineer

Taskr; United States; Remote; USD 140,000 - 200,000; Full time

Job summary

Taskr Global is partnering with an established US-based organisation to hire a Lead Analytics Architect & Analytics Engineer. You will own enterprise analytics architecture with a focus on Power BI, Azure Databricks and modern data platforms.

This role blends hands-on engineering with architectural leadership, shaping governance, data models and reusable analytics products across the organisation. You'll collaborate with senior stakeholders, data engineers and BI teams to deliver scalable,

Qualifications

• 8+ years' experience across BI, Analytics Engineering, Data Architecture or related disciplines.
• Extensive hands-on experience with Microsoft Power BI, including enterprise semantic model design and administration.
• Strong expertise in Azure Databricks, Delta Lake and SQL-based data transformations.
• Advanced SQL skills, including developing, testing and optimising complex transformations.
• Expert knowledge of DAX, dimensional modelling, tabular models and performance optimisation.
• Experience with Microsoft Fabric, OneLake, Direct Lake, Import and DirectQuery.
• Knowledge of lakehouse architecture, medallion patterns and reusable data products.
• Experience establishing data governance, quality, security and deployment standards.
• Knowledge of version control, automated testing, deployment processes and platform monitoring.
• Proven ability to lead technical architecture decisions and communicate effectively with both technical and non-technical stakeholders.
• Experience troubleshooting complex data-quality, integration, semantic-model and refresh issues.

Responsibilities

• Lead the architecture, development and ongoing optimisation of enterprise Power BI semantic models.
• Design and build curated analytical datasets, tables and views within Azure Databricks.
• Translate business requirements and KPI definitions into scalable SQL transformations and reusable data models.
• Develop dimensional models, DAX measures, calculation groups and optimised data relationships.
• Establish best practices for data modelling, performance, scalability and maintainability.
• Develop, maintain and optimise SQL-based transformations within Azure Databricks.
• Work with Delta Lake, Microsoft Fabric, OneLake and modern lakehouse architecture.
• Design effective integration patterns across Direct Lake, Import and DirectQuery.
• Improve semantic model performance, refresh strategies and platform reliability.
• Support the development of reusable, enterprise-wide analytical data products.
• Provide technical direction and architectural guidance to BI developers, analysts and data engineering teams.
• Lead design reviews and establish reusable development standards.

Skills

Power BI

Azure Databricks

DAX

SQL

Leadership

Tools

Microsoft Fabric

OneLake

Direct Lake

Import

DirectQuery

Delta Lake

Job description

Salary: Competitive, dependent on experience

The Opportunity

Taskr Global is partnering with an established US-based organisation seeking an experienced Lead Analytics Architect & Analytics Engineer to take ownership of its enterprise analytics architecture, with a particular focus on Power BI, Azure Databricks and modern data platforms.

This is an excellent opportunity for a technically strong analytics professional who enjoys combining hands-on engineering with architectural leadership.

You'll play a central role in developing a scalable, governed analytics environment, ensuring business-critical data is accurate, accessible and consistently structured across the organisation.

The position offers significant technical ownership, the opportunity to influence enterprise-wide data strategy, and close collaboration with senior stakeholders, data engineers and business intelligence teams.

This is a fully remote position, open to candidates based anywhere within the United States.

Key Responsibilities

Analytics Architecture & Data Engineering

• Lead the architecture, development and ongoing optimisation of enterprise Power BI semantic models.
• Design and build curated analytical datasets, tables and views within Azure Databricks.
• Translate business requirements and KPI definitions into scalable SQL transformations and reusable data models.
• Develop dimensional models, DAX measures, calculation groups and optimised data relationships.
• Establish best practices for data modelling, performance, scalability and maintainability.

Databricks, Power BI & Microsoft Fabric

• Develop, maintain and optimise SQL-based transformations within Azure Databricks.
• Work with Delta Lake, Microsoft Fabric, OneLake and modern lakehouse architecture.
• Design effective integration patterns across Direct Lake, Import and DirectQuery.
• Improve semantic model performance, refresh strategies and platform reliability.
• Support the development of reusable, enterprise-wide analytical data products.

Data Governance, Quality & Security

• Establish standards for data modelling, KPI definitions, documentation and governance.
• Implement data validation, reconciliation and quality assurance processes.
• Maintain appropriate security controls, including row-level and object-level security (RLS/OLS).
• Support data lineage, access management and audit requirements.
• Ensure consistency and accuracy between source systems and reporting environments.

Technical Leadership & Collaboration

• Provide technical direction and architectural guidance to BI developers, analysts and data engineering teams.
• Lead design reviews and establish reusable development standards.
• Work closely with Finance, IT, ERP and wider business stakeholders to understand analytical requirements.
• Troubleshoot complex issues involving SQL, DAX, data transformations, integrations and model performance.
• Develop technical documentation, architecture standards and best-practice guidance.

Required Experience

We're interested in speaking with candidates who can demonstrate:

• 8+ years' experience across Business Intelligence, Analytics Engineering, Data Architecture or related disciplines.
• Extensive hands-on experience with Microsoft Power BI, including enterprise semantic model design and administration.
• Strong expertise in Azure Databricks, Delta Lake and SQL-based data transformations.
• Advanced SQL skills, including developing, testing and optimising complex transformations.
• Expert knowledge of DAX, dimensional modelling, tabular models and performance optimisation.
• Experience with Microsoft Fabric, OneLake, Direct Lake, Import and DirectQuery.
• A strong understanding of lakehouse architecture, medallion patterns and reusable data products.
• Experience establishing data governance, quality, security and deployment standards.
• Knowledge of version control, automated testing, deployment processes and platform monitoring.
• Proven ability to lead technical architecture decisions and communicate effectively with both technical and non-technical stakeholders.
• Experience troubleshooting complex data-quality, integration, semantic-model and refresh issues.

The following would be advantageous

• Experience working with ERP data and enterprise finance, manufacturing, logistics or supply chain systems.
• Microsoft Power BI, Fabric or Azure certifications.
• Experience with Microsoft Purview and Unity Catalog.
• Familiarity with Power BI and Fabric APIs, scripting and automation.
• Experience with infrastructure as code and enterprise deployment practices.
• Knowledge of data cataloguing, metadata management and advanced platform governance.
• Previous experience providing technical leadership or mentoring BI and Analytics Engineers.

What Makes This Opportunity Attractive?

• 100% remote working across the USA.
• Ownership of enterprise-wide Power BI semantic architecture and Databricks analytics engineering.
• Opportunity to shape technical standards, architecture and data governance.
• Modern Microsoft data technology stack, including Power BI, Databricks and Fabric.
• A hands-on technical leadership position rather than a purely managerial role.
• Exposure to complex enterprise data environments and senior business stakeholders.
• The opportunity to build scalable, reusable analytics solutions with long-term business impact.

Interested?

If you're an experienced Analytics Architect, BI Architect or Lead Analytics Engineer with strong Power BI and Databricks expertise, we'd be keen to hear from you.