Job descriptionNew Value Solutions, a national IT consulting company, is seeking a Data Engineer to support the delivery of enterprise data and analytics solutions for a major Core Services Metrics (CSM) initiative. This role is responsible for designing, developing, and enabling the end-to-end analytics data platform, including data ingestion, transformation, integration, and dataset creation to support reporting and analytical needs. The successful candidate will work with a variety of enterprise data sources such as ServiceNow (SNOW), Dynatrace, and Azure DevOps (AzDO), while collaborating closely with Data Services, Data Analytics & Delivery teams, and project stakeholders to deliver scalable and reliable data architecture and analytics solutions.The ideal candidate is a Data Engineer with experience in data architecture and analytic solutions.
Responsibilities:
Ingesting relational, structured, semi-structured, and unstructured data from on premise, cloud, external, document, and other data sources.Monitoring & developing guidelines for data ingestion streams for the project.Designing logical data models.Centralizing business rules and logic for the purpose of efficient, accurate, and consistent analytics solution delivery.Implementing logic, such as calculations, derivations, table relationships, data cleansing and standardization, data mapping and linking, etc. in a way which minimizes future efforts for changes.Data modelling and data ingestion experience with one or more of the following products or systems is an asset: ServiceNow, Azure DevOps, Dynatrace.Blending data from multiple sources into a single information context.Ensure data meets entity an attribute quality requirement.Ensure data lineage; ensure standardization for common format data elements.
Requirements:
5+ years of experience in Data Engineering.Experience with Databricks. Familiar with reporting and analytics tools.Advanced SQL skills including stored procedures and data transformation.Advanced API integration skills (for data ingestion).Expertise in Power Query (M) for data cleansing, transformation, and building reusable dataflows.Experience designing optimized data models and star schemas for high-performance reporting.Ability to implement row-level security and manage workspace permissions in Power BI Service.Skilled in developing interactive dashboards & visualizations tailored to executive and operational needs.Advanced DAX skills to create complex measures, calculated tables, and dynamic KPIs.Familiarity with performance tuning techniques (aggregations, incremental refresh, query folding).
If you have this expertise, and are able to work in Canada, submit your resume. While we thank all candidates in advance for their application, only those candidates who are shortlisted will be contacted.