NeverHard

Analytics Engineer I at Kronos Consulting — NeverHard

Analytics Engineer I at Kronos Consulting in Montréal, Québec. Skills: Data Modeling, Data Warehousing, Power BI, Python, SQL. Apply on NeverHard.

Company
Kronos Consulting
Location
Montréal, Québec
Type
full_time

Required skills:

Job DescriptionJob Description Kronos has a long history of avionics engineering working with some of the largest aircraft integrators in the world. We always provide our partners with 100% customers satisfaction and on time delivery. If you are excited about working for a company that takes its job seriously and does not cut corners you will have a home with Kronos. Analytics Engineer 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 years in 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. Company DescriptionKronos always provides our partners with 100% customer satisfaction and on time delivery. If you are excited about working for a company that takes its job seriously and does not cut corners you will have a home with Kronos.Company DescriptionKronos always provides our partners with 100% customer satisfaction and on time delivery. If you are excited about working for a company that takes its job seriously and does not cut corners you will have a home with Kronos.