Sr. Data Engineer

3 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 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. Lead, Data Engineering

    2 weeks ago

    Burlington, ON, Canada TransUnion Full time

    Sr. Lead, Data Engineering page is loaded Sr. Lead, Data Engineering Apply locations Burlington, Canada time type Full time posted on Posted 16 Days Ago job requisition id 19029206 TransUnion's Job Applicant Privacy Notice What We'll Bring: At TransUnion, we are dedicated to finding ways information can be used to help people make better and...

  • Sr Data Engineer

    3 weeks ago

    Toronto, ON, Canada CG Consulting Group Full time

    Sr Data Engineer This is with a global IT services firm for a leading investment/wealth management services firm. Client Location is downtown Toronto Ont. Hybrid - In Office 3-4 days per week. Contract - 6 months, possible renewal Sr Data Engineer Join one of the most respected and fastest growing institutional investors in the world. Our client is a...

  • Sr/Lead Data Engineer

    5 days ago

    Toronto, ON, Canada Asset Management Industry Full time

    Good day Data Engineers ! Insight Global is looking for 6 Sr or Lead Data Engineers to join a large Asset Management company in Toronto on a full time basis. The successful candidates will be responsible for leading projects end-to-end within the Data Distribution Team or Asset Management Team . This role is heavily hands on and requires strong...

  • Sr/Lead Data Engineer

    4 weeks ago

    Toronto, ON, Canada Asset Management Industry Full time

    Good day Data Engineers ! Insight Global is looking for 6 Sr or Lead Data Engineers to join a large Asset Management company in Toronto on a full time basis. The successful candidates will be responsible for leading projects end-to-end within the Data Distribution Team or Asset Management Team . This role is heavily hands on and requires strong...

  • Sr/Lead Data Engineer

    2 weeks ago

    Toronto, ON, C6A, Ontario, Canada Asset Management Industry Full time

    Good day Data Engineers !Insight Global is looking for 6 Sr or Lead Data Engineers to join a large Asset Management company in Toronto on a full time basis. The successful candidates will be responsible for leading projects end-to-end within the Data Distribution Team or Asset Management Team . This role is heavily hands on and requires strong experience...

  • 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...

  • 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...

  • Sr. Data Engineer

    4 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...

  • Sr Product Engineer

    3 weeks ago

    Toronto, ON, Canada Chipright Full time

    Sr Product Engineer Permanent Role – Ireland Minimum BSc or BEng with minimum 5+ years of relevant industrial experience Knowledge of Semiconductor fabrication and package assembly. Displaying Critical thinking and problem solving skills required, along with the ability to plan both Tactical and Strategic projects. Prior experiences with Power...

  • Sr. Electrical Engineer

    3 weeks ago

    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...

  • Sr. Data Analyst, Risk

    1 day 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...

  • Sr. Data Analyst, Risk

    1 day 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...

  • Sr. Data Analyst, Risk

    2 days 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...

  • Sr. Data Analyst, Risk

    4 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...

  • Sr. Juniper Network Engineer

    3 weeks ago

    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...

  • Sr. Electrical Engineer

    3 weeks ago

    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...

  • Sr. Data Engineer

    3 weeks ago

    Toronto, ON, Canada Paytm Full time

    About Paytm Labs: At Paytm Labs, we’re on a mission to provide useful technological solutions that enrich and empower millions of people in their daily lives. We apply big data, artificial intelligence, and machine learning to bring the next generation of financial products and services to global markets. We recently soft-launched Pi, our full...

  • Sr. PHP Engineer

    3 weeks ago

    Toronto, ON, Canada AcceptLocal Online Ltd. Full time

    Our Client (a start-up Company with a large investment) is looking for Sr. PHP Engineer to join their growing team (50+) based in Toronto, Canada. On this permanent role, you will be part of the highly professional team in the unique environment. The desired candidate is expected to be an intermediate / senior level Engineer with an experience of a large...

  • Lead data engineer

    4 weeks ago

    Toronto, ON, Canada Asset Management Industry Full time

    Good day Data Engineers ! Insight Global is looking for 6 Sr or Lead Data Engineers to join a large Asset Management company in Toronto on a full time basis. The successful candidates will be responsible for leading projects end-to-end within the Data Distribution Team or Asset Management Team . This role is heavily hands on and requires strong...

  • Consultant - Sr&ed Technology & Innovation Grants

    6 days ago

    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...