Sr. Data Engineer

3 weeks ago


Oakville, Canada Sagen Full time

2060 Winston Park Dr, Oakville, ON L6H 5R7, Canada

Job Description

Posted Wednesday, January 17, 2024 at 5:00 AM

Job Summary

In collaboration with the Manager, Data Operations , the Senior Data Engineer is responsible for the data, architecture, and model of our Enterprise Data & Analytics environment. This role will maintain the current data warehouse solution and be an active participant in decommissioning legacy solutions.

Responsibilities

  • Plan, coordinate, develop and support data model development, including architecting table structure, building ETL process, documentation, and long-term preparedness.
  • Analyze, design, develop, implement, and maintain technical solutions in AWS using data ETL technologies, including Amazon S3, AWS Glue Studio, AWS Glue Data Catalog, Lake Formation, Glue crawlers, AWS Athena, and Snowflake.
  • Maintain the current data warehouse solution and be an active participant in decommissioning legacy solutions.
  • Develop cross-validation rules to ensure data accuracy.
  • Define technical approach documents (define calculated logic, process flow).
  • Meet business requirements of the projects as new data sources are added.
  • Document steps needed to migrate database objects between various environments, including Development, UAT, Staging, and Production.
  • Provide regular project updates to shared team resources and management as needed.
  • Communicate issues, risks, and concerns proactively to manage and engage colleagues while working in a hybrid Agile/Scrum process.
  • Document pipelines thoroughly to allow peers to assist with support as needed.
  • Provide technical assistance and task delegation to a flexible team of staff engineers, consultants, and interns in close coordination with the team Manager and Data Architect.
  • Nights, weekends, and non-regular hours may be required to deploy and make ready solutions that need support and collaboration from resources.

Skills and Qualifications

  • Bachelor's degree in computer science or related field and five plus years’ experience in data engineering and data warehouse technologies with a focus on the AWS platform in the past five years to present.
  • A minimum of 5 + years’ experience in progressive data engineering roles.
  • Expert knowledge in SQL, ETL architecture, data architecture and BI architecture.
  • 5+ years’ experience in Python for data and analytics.
  • Experience with Amazon S3, AWS Glue Studio, AWS Glue Data Catalog, Lake Formation, Glue crawlers, AWS Athena, and Snowflake or could data warehouse.
  • Knowledge of best practices in enterprise-wide database implementation, availability, and security configuration.

Qualifications/Experience Preferred:

  • Experience in migrating from Informatica to AWS.
  • Informatica, POWER BI, and Alteryx experience.
  • Previous experience with Snowflake implementation.
  • Knowledge using AWS EMR and Sagemaker.
  • RESTful API experience.
  • Data pipeline experience (e.g., Kafka).
  • Statistical software experience (e.g., JMP, Minitab).

#LI-Hybrid

At Sagen, we offer:

  • Annual Performance Bonus Plan
  • Medical, Dental, Prescription Drug, and EFAP Benefits
  • Company funded Pension Plan
  • Company matching RRSP, TFSA and/or Non-registered Savings Plan
  • Competitive vacation policy
  • Life Insurance and Accidental Death & Dismemberment
  • Short Term and Long-Term Disability programs
  • Reimbursement programs for special occasions, health and wellness, mortgage insurance and tuition
  • Work from Anywhere Days

S agen is committed to creating a diverse and inclusive workforce. We welcome, respect and value people from all backgrounds and abilities and create a sense of belonging that inspires our employees to be their authentic self.

We encourage applications from people with disabilities and will provide accommodations upon request throughout the selection and hiring process to meet individual needs.

Job Function IT

Pay Type Salary

Education Level Bachelor’s Degree

Travel Required No

2060 Winston Park Dr, Oakville, ON L6H 5R7, Canada

#J-18808-Ljbffr
  • Sr. Data Engineer

    10 hours ago


    Oakville, Canada Sagen Full time

    2060 Winston Park Dr, Oakville, ON L6H 5R7, Canada Job Description Posted Wednesday, January 17, 2024 at 5:00 AM Job Summary In collaboration with the Manager, Data Operations , the Senior Data Engineer is responsible for the data, architecture, and model of our Enterprise Data & Analytics environment. This role will maintain the current...

  • Sr. Data Engineer

    4 weeks ago


    Oakville, ON, Canada Sagen Full time

    2060 Winston Park Dr, Oakville, ON L6H 5R7, Canada Job Description Posted Wednesday, January 17, 2024 at 5:00 AM Job Summary In collaboration with the Manager, Data Operations , the Senior Data Engineer is responsible for the data, architecture, and model of our Enterprise Data & Analytics environment. This role will maintain the current data warehouse...


  • Oakville, Canada Sagen Full time

    Reporting to the Director, Risk Analytics, the Sr. Data Analyst will play a key role in data storytelling and leveraging data science algorithms to extract trends, patterns, and insights from our organization’s data to identify emerging risks and risk mitigation strategies. Responsibilities Creating solutions and strategies to business problems using...


  • Oakville, Canada Sagen Full time

    Reporting to the Director, Risk Analytics, the Sr. Data Analyst will play a key role in data storytelling and leveraging data science algorithms to extract trends, patterns, and insights from our organization’s data to identify emerging risks and risk mitigation strategies. Responsibilities Creating solutions and strategies to business problems using...


  • Oakville, Canada Sagen Full time

    Reporting to the Director, Risk Analytics, the Sr. Data Analyst will play a key role in data storytelling and leveraging data science algorithms to extract trends, patterns, and insights from our organization’s data to identify emerging risks and risk mitigation strategies. Responsibilities Creating solutions and strategies to business problems using...

  • Sr. Data Analyst, Risk

    10 hours ago


    Oakville, Canada Sagen Full time

    Reporting to the Director, Risk Analytics, the Sr. Data Analyst will play a key role in data storytelling and leveraging data science algorithms to extract trends, patterns, and insights from our organization’s data to identify emerging risks and risk mitigation strategies. Responsibilities Creating solutions and strategies to business problems using...


  • Oakville, Canada Sagen Full time

    Reporting to the Director, Risk Analytics, the Sr. Data Analyst will play a key role in data storytelling and leveraging data science algorithms to extract trends, patterns, and insights from our organization's data to identify emerging risks and risk mitigation strategies. Responsibilities Creating solutions and strategies to business problems...


  • Oakville, Canada PeopleToGo Full time

    Job Title: Sr. Juniper Network EngineerType: 6 month contract Location: Oakville, ON Starts: Immediate Our client is seeking a Sr. Juniper Network Engineer to become a part of their growing team! This is an incredible opportunity to work with a rapidly expanding organization that will utilize cutting edge technology to realize their goals! Role:-Day to day...


  • Oakville, Canada ProMach Full time

    The Sr. Electrical Engineer is responsible for the design and specification of the electrical system on Zarpac projects and initiatives.Create full electrical design packages including BOM, schematics, assembly drawings and layouts;Check & validate all final design documentation, parts lists and drawings according to design & contract requirements, to ensure...


  • Oakville, Canada EVAMAX Group Full time

    If you’ve graduated from a university engineering or science-based program (i.e., Mechatronics, Computer Science, Computer Engineering, Mechanical or Electrical Engineering etc.) and have excellent verbal and written communication skills, this role is the right fit for you. - **Job** Responsibilities**: **Client Management**: - Provide clients with timely...


  • Oakville, Canada EVAMAX Group Full time

    If you’ve graduated from a university engineering or science-based program (i.e., Mechatronics, Computer Science, Computer Engineering, Mechanical or Electrical Engineering etc.) and have excellent verbal and written communication skills, this role is the right fit for you. - **Responsibilities**: **Client Management**: - Provide clients with timely and...


  • Oakville, Canada ProMach Full time

    Did you love building as a kid? Do you enjoy taking something apart, just to figure out how to put it back together? Do you geek out on robots? Our engineers drive packaging innovation, creating new ways to improve – and increase – performance. We’re passionate about designing custom equipment that exceeds our customers’ expectations. Our engineers...


  • Oakville, ON, Canada ProMach Full time

    The Sr. Electrical Engineer is responsible for the design and specification of the electrical system on Zarpac projects and initiatives. Create full electrical design packages including BOM, schematics, assembly drawings and layouts; Check & validate all final design documentation, parts lists and drawings according to design & contract requirements, to...

  • Data Engineer

    4 days ago


    Oakville, Ontario, Canada Finsana Full time

    Salary: SUMMARYFINSANA is a global fintech company that specializes in catering to underserved and underbanked consumers. Our organization has a passion for helping people financially through our technology solutions which has allowed us to serve millions of consumers globally.Headquartered in Montreal, Canada with offices in the United States and Latin...

  • Data Engineer

    5 days ago


    Oakville, Canada Finsana Full time

    Salary: SUMMARYFINSANA is a global fintech company that specializes in catering to underserved and underbanked consumers. Our organization has a passion for helping people financially through our technology solutions which has allowed us to serve millions of consumers globally.Headquartered in Montreal, Canada with offices in the United States and Latin...

  • Sr. Data Scientist

    4 weeks ago


    Oakville, Canada Sagen Full time

    Posted Tuesday, November 28, 2023 at 5:00 AM Job Summary Reporting to the VP Modeling, Senior Data Scientist will contribute to the various stages of Machine Learning Model (ML) development and deployment pipelines in a dynamic business environment. Responsibilities Support the development, calibration, validation implementation, automation,...

  • Sr. Data Scientist

    4 weeks ago


    Oakville, Canada Sagen Full time

    Posted Tuesday, November 28, 2023 at 5:00 AM Job Summary Reporting to the VP Modeling, Senior Data Scientist will contribute to the various stages of Machine Learning Model (ML) development and deployment pipelines in a dynamic business environment. Responsibilities Support the development, calibration, validation implementation, automation,...

  • Sr. Data Scientist

    3 weeks ago


    Oakville, Canada Sagen Full time

    Posted Tuesday, November 28, 2023 at 5:00 AM Job Summary Reporting to the VP Modeling, Senior Data Scientist will contribute to the various stages of Machine Learning Model (ML) development and deployment pipelines in a dynamic business environment. Responsibilities Support the development, calibration, validation implementation, automation,...

  • Sr. Data Scientist

    10 hours ago


    Oakville, Canada Sagen Full time

    Posted Tuesday, November 28, 2023 at 5:00 AM Job Summary Reporting to the VP Modeling, Senior Data Scientist will contribute to the various stages of Machine Learning Model (ML) development and deployment pipelines in a dynamic business environment. Responsibilities Support the development, calibration, validation implementation, automation,...


  • Oakville, Canada Sagen Full time

    2060 Winston Park Dr, Oakville, ON L6H 5R7, Canada Job Description Posted Thursday, December 14, 2023 at 5:00 AM Job Summary Reporting to the Manager, Software Engineering, the Sr. Application Developer is primarily responsible for designing, developing, and maintaining scalable and reliable software engineering solutions in a timebound agile...