Data Engineer with DB2, ETL and Python

2 weeks ago

Montreal, Quebec, Canada Amaze Systems Full time $80,000 - $120,000 per year

Job Position: Data Engineer with
DB2, ETL and Python

Location: Montreal, QC - Onsite

This is a data engineer role in the team responsible for developing the firm's data messaging platforms and data stores that holds both transactional, reference data and aggregated risk measures for real time and archive processing and getting it into the operational data stores (ODS), archives and DataMart.

The global team consists of highly technical team members who are adaptable and hands on in software development and life cycle management and proficient in devops. We deliver multiple projects for multiple business areas in parallel. The business owners and subject matter experts are globally distributed, making communication to be important. The candidate is expected to collaborate closely with our users and support partners. The development is to be performed using an agile methodology which is based on scrum (time boxing, daily scrum meetings, retrospectives, etc.) and XP (continuous integration, refactoring, unit testing, etc.) best practices. Candidates must therefore be able to work collaboratively, demonstrate good ownership and be a team player

Primary Responsibilities

  1. Translate business requirement into queries against a set of relational tables and produce reporting based on the requirements.

  2. Design and build scalable and performant databases.

  3. Database and ETL development, including stored procedures, queries, performance tuning, archiving, etc.; using python, SQL and ETL tools.

4.Build efficient automation scripts (using Python etc.). The current global team members are all very skilled in domain modeling, database design (both relational and noSQL), big data, kafka, and messaging so this is an excellent opportunity to play a key role in the growing team.

Technical Skills Requirement:

-Strong relational database skills especially with DB2/Sybase/SQL Server or/and Postgres/Greenplum.

Kafka and MongoDB knowledge is a plus. However, willing to train.

-Knowledge of Spark, Snowflake, and Databricks is desirable.

-Create high quality and optimized stored procedures and queries.

-Experience with Power Designer or some similar modeling tool.

-Python and Unix/K-Shell.

-Strong knowledge base of relational database performance and tuning such as proper use of indices, database statistics/roorgs, de-normalization concepts.

-Familiar with lifecycle of a trade and flows of data in an investment banking operation.?

Experienced in Agile development process.

-Effective communication skills.

  • Data Engineer

    1 week ago

    Montreal, Quebec, Canada Yochana Full time $80,000 - $120,000 per year

    This is a data engineer role in the team responsible for developing the firm's data messaging platforms and data stores that holds both transactional, reference data and aggregated risk measures for real time and archive processing and getting it into the operational data stores (ODS), archives and DataMart.The global team consists of highly technical team...

  • Data Engineer

    1 week ago

    Montreal, Quebec, Canada Integrass Full time $83,200 - $93,600 per year

    Job Title: Data EngineerLocation: Montreal, QC (Hybrid)Experience Required: 7-8 YearsTo Reach - | Position Introduction:This is a data engineer role in the team responsible for developing the firm's data messaging platforms and data stores that holds both transactional, reference data and aggregated risk measures for real time and archive processing and...

  • Lead ETL Developer

    6 days ago

    Montreal, Quebec, Canada Info-Ways Full time $80,000 - $120,000 per year

    Company Description IT Job Description Role: Lead ETL DeveloperLocation: Montreal, QCDuration: FulltimeBGV will be done for the selected candidates. The position carries the following responsibilities:- Will need to engage with Project Managers, Business Analysts and Application DBA to implement ETL Solutions- Must be able to multi-task between various...

  • Data Engineer

    1 week ago

    Montreal, Quebec, Canada Tata Consultancy Services (TCS) Full time $104,000 - $156,000 per year

    Inclusion without Exception:Tata Consultancy Services (TCS) is an equal opportunity employer, and embraces diversity in race, nationality, ethnicity, gender, age, physical ability, neurodiversity, and sexual orientation, to create a workforce that reflects the societies we operate in. Our continued commitment to Culture and Diversity is reflected in our...

  • Data Engineer

    6 days ago

    Montreal, Quebec, Canada Gala Solutions Inc Full time $80,000 - $120,000 per year

    You will be responsible for:-Collaborating with cross-functional teams to understand data requirements, and design efficient, scalable, and reliable ETL processes using Python and DataBricks-Developing and deploying ETL jobs that extract data from various sources, transforming it to meet business needs.-Taking ownership of the end-to-end engineering...

  • Python Snowflake Developer

    2 weeks ago

    Montreal, Quebec, Canada Aptino, Inc. Full time $80,000 - $120,000 per year

    We're looking for a skilledPython Developerwith a strong background indatabase development and data engineeringto join our dynamic team in Montreal. In this role, you'll design and implementscalable data solutions, build reporting dashboards, and collaborate with business and technology teams within a fast-paced financial environment.Key...

  • Data Engineer

    24 hours ago

    Montreal, Quebec, Canada Bounteous Full time $80,000 - $120,000 per year

    Bounteous is a premier end-to-end digital transformation consultancy dedicated to partnering with ambitious brands to create digital solutions for today's complex challenges and tomorrow's opportunities. With uncompromising standards for technical and domain expertise, we deliver innovative and strategic solutions in Strategy, Analytics, Digital Engineering,...

  • Data Engineering Lead

    1 week ago

    Montreal, Quebec, Canada TJ2H and Associates Limited Full time US$100,000 - US$180,000 per year

    DATA ENGINEER LEADMontreal, Hybrid ( 2 days at the office)We are seeking a Data Engineering Lead to head our Data Engineering practice within our growing and diverse team. You will act as the principal architect of solutions and guide a team of Data Engineers to design and deliver integrations, APIs, and cloud-based data infrastructure for both internal and...

  • Data Engineer

    1 week ago

    Montreal, Quebec, Canada KData AI Full time $80,000 - $120,000 per year

    Job Title:Data Engineer (Bilingual – Onsite, Rive-Sud)Location:Onsite, 5 days per week – Rive-Sud officeDuration:12 monthsHours:37.5 hours per weekLanguage Requirement: Bilingual (French & English) – MandatoryAbout the RoleWe are seeking an experiencedData Engineerto join a cross-functional team and contribute to the design, development, and...

  • Data Engineering Lead

    14 hours ago

    Montreal, Quebec, Canada US Mobile Full time $180,000 - $270,000 per year

    US Mobile is on a mission to revolutionize connectivity. Imagine a world where you can go into a single app and buy terabytes of data for every one of your devices: phone, smart devices, car, home broadband, and more. That's the future that US Mobile is building: a software platform built truly for the 21st century and the age of 5G and IoT, with world class...