> Markdown version of [/jobs/ext/611477-data-analytics-engineer-enterprise-intelligence](https://www.wearedevelopers.com/jobs/ext/611477-data-analytics-engineer-enterprise-intelligence). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# Data & Analytics Engineer (Enterprise Intelligence)

- **Company:** AllSTEM Connections
- **Location:** Ontario, CA, United States
- **Experience:** Expert
- **Contract:** Temporary contract
- **Skills:** Adaptable Database Systems, Big Data, Code Review, Data Profiling, Data Intelligence, Raw Data, Power BI, SQL Stored Procedures, SQL Databases, Freeform SQL, Powerquery, Data Lakes, Data Analytics, Data Pipelines, Databricks
- **Published:** June 24, 2026
- **Apply:** https://www.dice.com/job-detail/796eeb19-0fd0-4ee5-a803-25ddf8454b3c

## About the Role

Technical Expertise:
Expert-level proficiency in Power BI, SQL, and Databricks.
Deep experience with Delta Lake architecture and notebook-based transformations.
Advanced knowledge of DAX, Power Query, and semantic model optimization.
Experience:
Proven track record of building data pipelines for large-scale, complex datasets.
Experience translating business requirements into technical documentation and KPIs.
Previous experience in a lead or mentorship capacity.
Skills: Strong analytical rigor, excellent communication skills, and the ability to perform complex data reconciliation. Equal Opportunity Employer / Disabled / Protected Veterans

## Description

We are seeking a high-caliber Senior Data & Analytics Engineer to serve as a Subject Matter Expert (SME) within our enterprise data organization. In this role, you will be responsible for the end-to-end lifecycle of data intelligence-from building robust pipelines in Databricks to delivering executive-level insights in Power BI. You will bridge the gap between complex raw data and scalable business KPIs, ensuring that our analytical models are high-performing, governed, and accurate. Beyond technical execution, you will act as a mentor and lead, providing code reviews and establishing best practices for our internal analytics teams., SQL Mastery: Design, optimize, and maintain complex SQL queries, views, and stored procedures. Support self-service reporting environments and implement rigorous data quality controls.
Databricks Engineering: Build and manage Databricks notebooks and Delta tables. Develop sophisticated data pipelines to transform large-scale datasets into curated, audit-ready analytical layers.
Power BI Leadership: Lead the development and enhancement of Power BI dashboards and semantic models. Ensure reports provide actionable insights for both executive and operational stakeholders.
Data Modeling & Strategy: Collaborate with business SMEs to translate complex requirements into scalable data models and KPIs across diverse organizational use cases.
Governance & Validation: Perform advanced data profiling and reconciliation across multiple source systems to ensure adherence to enterprise governance and performance standards.
Technical Mentorship: Provide SME-level guidance and best-practice coaching. Conduct code reviews for internal teams to ensure high standards in SQL, Databricks, and Power BI development.


## Related Videos

- [Data Governance in the Era of AI](https://www.wearedevelopers.com/videos/1622-data-governance-in-the-era-of-ai)
- [Alibaba Big Data and Machine Learning Technology](https://www.wearedevelopers.com/videos/37-alibaba-big-data-and-machine-learning-technology)
- [Beyond Dashboards: Fixing Text-to-SQL with Semantic RAG](https://www.wearedevelopers.com/videos/2036-beyond-dashboards-fixing-text-to-sql-with-semantic-rag)
- [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works)
- [Data Analytics with Microsoft Fabric: End-to-End Use Case with Data Agents](https://www.wearedevelopers.com/videos/1547-data-analytics-with-microsoft-fabric-end-to-end-use-case-with-data-agents)
- [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt)

## Related Articles

- [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story)
- [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know)
- [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk)
- [Coffee with Developers - Maria Apazoglou - Making AI understandable for all in production](https://www.wearedevelopers.com/magazine/475-coffee-with-developers-maria-apazoglou-making-ai-understandable-for-all-in-production)
- [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers)
- [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk)