ES
Data Engineering Specialist.
Epsilon Solutions LTD
🇨🇦 Canada
On-site
2 months ago
- Power BI
- SQL
- Python
- Data Modeling
- DAX
- Power Query
- ETL
- ELT
- ERP
- Oracle
- Oracle Cloud
- SAP
- Ariba
- Excel
- Microsoft Fabric
- Azure Data Factory
- AI
- Copilot
2 months ago
Montreal, QC
Contract
Job Summary
We are seeking a Analytics Engineer who thrives on turning complex, raw data into reliable, well-modeled data products and insightful Power BI reports. You will sit at the intersection of data engineering and analytics: designing SQL data warehouse structures, building dimensional models (fact and dimension tables), and delivering the semantic and reporting layer that the business relies on. You are equally comfortable writing performant SQL and Python as you are shaping a data model in Power BI and partnering with stakeholders to understand what they actually need. Procurement domain knowledge is a nice-to-have; engineering rigor and development speed are the priority.
Key Responsibilities
Data Modeling & Warehousing
· Design, build, and maintain dimensional models (star schemas, fact/dimension tables) from complex source systems.
· Develop and optimize SQL data warehouse objects — tables, views, stored procedures, and transformation logic.
· Establish a clean, reusable semantic layer that standardizes business logic across reports.
BI Development & Delivery
· Build and maintain Power BI datasets, dashboards, and reports with optimized DAX and M (Power Query).
· Own the Power BI development lifecycle and deploy through Dev/Test/Prod pipelines.
· Automate data preparation and reporting tasks with Python where it adds efficiency.
Governance & Operations
· Manage Power BI workspaces, dataflows, refresh schedules, row-level security, and access.
· Monitor performance and continuously tune models, queries, and refreshes.
· Document data models, lineage, and business definitions for auditability and traceability.
Requirements & Stakeholders
· Partner with business teams to capture reporting requirements and prioritize the request backlog.
· Translate ambiguous asks into precise technical specs and deliver solutions that fit real needs.
Required Skills & Experience
·3-5 yearsin BI development, analytics engineering, or data warehouse development.
· Expert SQL and hands-on experience building/modeling SQL data warehouses.
· Strong dimensional modeling — fact and dimension design from complex data.
· Advanced Power BI: DAX, M (Power Query), dataset design, and lifecycle management.
· Python for ETL/ELT, automation, and analytics.
· Power BI Service governance: workspaces, gateways, security, deployment pipelines.
· Ability to gather requirements and communicate with non-technical stakeholders.
Nice to Have
· Working knowledge of procurement / supply chain business processes and KPIs (spend, savings, supplier performance, S2P/P2P)
· Previous work with ERPs such as Oracle R12, Oracle R11, Oracle Cloud, SAP Ariba
· Advanced Excel and Microsoft Office (Power Query in Excel, pivot models).
· Familiarity with Microsoft Fabric, Azure Data Factory, Synapse, or similar cloud data platforms.
· Proficiency with AI-assisted coding and development — preference for candidates who use tools such as GitHub Copilot, or Microsoft 365 Copilot to speed up SQL, Python, DAX, and M development, prototype data models and transformations faster, and shorten build cycles, with disciplined review and testing of AI-generated code.
Key Competencies
·Technical craftsmanship —builds clean, performant, well-documented data models and reports that others can trust and maintain.
·Business translation —listens to stakeholders, clarifies vague requests, and converts them into clear reporting requirements and specs.
·Ownership —takes a request end-to-end, from data sourcing to a published, validated dashboard.
·Attention to detail —obsessive about data accuracy, reconciliation, and version control.
·Collaboration —works fluidly with data engineers, analysts, and non-technical business users.
·Continuous improvement —constantly optimizes queries, refreshes, and workspace governance.
Data Engineering Specialist. · Epsilon Solutions LTD