IT Jobs in Canada
Job Description
Live Assets | IT Staffing Solutions is hiring a Senior Data Engineer for one of its clients to work on service innovation, program review, and digital transformation projects across large-scale enterprise environments.
Key Responsibilities
- Design, build, and maintain data pipelines on-premises and in the cloud (Azure, GCP, AWS) to ingest, transform, and store large datasets. Ensure pipelines are reliable and support multiple business use cases.
- Create and optimize dimensional models (star/snowflake) to improve query performance and reporting. Ensure models are consistent, scalable, and easy for analysts to use.
- Integrate data from SQL, NoSQL, APIs, and files while maintaining accuracy and completeness. Apply validation checks and monitoring to ensure high-quality data.
- Improve ETL/ELT processes for efficiency and scalability. Redesign workflows to remove bottlenecks and handle large, disconnected datasets.
- Build and maintain end-to-end ETL/ELT pipelines with SSIS and Azure Data Factory. Implement error handling, logging, and scheduling for dependable operations.
- Automate deployment, testing, and monitoring of ETL workflows through CI/CD pipelines. Integrate releases into regular deployment cycles for faster, safer updates.
- Manage data lakes and warehouses with proper governance. Apply security best practices, including access controls and encryption.
- Partner with engineers, analysts, and stakeholders to translate requirements into solutions. Prepare curated data marts and fact/dimension tables to support self-service analytics.
- Analyze datasets to identify trends, patterns, and anomalies. Use statistical methods, DAX, Python, and R to generate insights that inform business strategies.
- Develop interactive dashboards and reports in Power BI using DAX for calculated columns and measures. Track key performance metrics, share service dashboards, and present results effectively.
- Build predictive or descriptive models using statistical, Python, or R-based machine learning methods. Design and integrate data models to improve service delivery.
- Present findings to non-technical audiences in clear, actionable terms. Translate complex data into business-focused insights and recommendations.
- Deliver analytics solutions iteratively in an Agile environment. Mentor teams to enhance analytics fluency and support self-service capabilities.
- Provide data-driven evidence to guide corporate priorities. Ensure strategies and initiatives are backed by strong analysis, visualizations, and models.
Required Skills
- 5+ years of experience as a Data Engineer and/or Data Analyst
- 3+ years of experience ensuring data quality, security, and governance
- 3+ years of experience designing efficient dimensional models (star and snowflake schemas) for data warehousing and analytics
- 3+ years of experience developing and maintaining reports, dashboards, and visualizations using Power BI, DAX, Tableau, or Python libraries
- 5+ years of experience manipulating and extracting data from diverse on-premises and cloud-based sources
- Experience performing migrations across on-premises, cloud, and cross-database environments
- Experience using Git, collaborative workflows, CI/CD pipelines, containerization (Docker/Kubernetes), and Infrastructure as Code (Terraform, ARM, CloudFormation) to deploy and migrate data solutions
- Experience with SSIS, Azure Data Factory (ADF), and APIs for extracting and integrating data across multiple platforms and applications
Nice-to-Have Skills
- Exposure to AI/ML tools and workflows relevant to data engineering, such as integrating AI-driven analytics or automation within cloud platforms (e.g., Databricks, Azure).
- Experience with databases and data integration, including PostgreSQL, MongoDB, Azure Cosmos DB, and data integration tools such as Synapse Pipelines, Fabric Data Factory, Informatica, Talend, DBT, and Airbyte.
- Experience in application development, with knowledge of object-oriented and functional programming/scripting languages.
Salary range is expected to be between
If you are applying for this role outside of the primary location, please contact careers@liveassets.ca for the salary range for your location. The actual salary will vary depending on local market conditions, geography, and relevant job-related factors such as knowledge, skills, qualifications, experience, and education/training.
This is a new position/Vacancy.
Live Assets is a premier IT agency dedicated to delivering excellence in tech solutions across various industries.
Our agency is renowned for its expertise in engineering, and we take pride in our track record of delivering outstanding IT projects with precision and innovation.
With a wide spectrum of clients spanning different industries, we cater to both permanent and contract IT opportunities.
Discover more about our agency and stay updated on our latest developments through our social media channels:
LinkedIn – Twitter – Facebook –Youtube – Glassdoor
