Lead Analytics Architect​/Engineer

Salary: Competitive, dependent on experience

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.

• 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, One Lake and modern lakehouse architecture.
• Design effective integration patterns across Direct Lake, Import and Direct Query.
• Improve semantic model performance, refresh strategies and platform reliability.
• Support the development of reusable, enterprise-wide analytical data products.

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

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

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, One Lake, Direct Lake, Import and Direct Query
  .
• 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.

• 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,…