Job#: 3034358

Job Description:

Apex Systems is a global IT services provider and our consulting practice has an opening for a Data Engineer with strong ETL, Medallion Architecture and python to place at our client, a Big Five Bank for an important and growing project.

Client: Big Five Bank – Data Engineering

Terms: 6 month rolling contract.

Perks: Be part of an internationally recognized organization and a highly cohesive, friendly, high performance team!

Location: Halifax/Bedford (Primary), Toronto GTA (Secondary) - Hybrid (4 days/week in office)

Application Process: It is best to apply via the medium on which you are seeing this posting. If you encounter technical difficulties submitting your resume, please send a Word version of your resume to Eric Somerville [email protected] Please reference: Data Risk Analyst

Overview

A leading enterprise organization is building a centralized Data Hub within its data office to enable self-service reporting and data democratization across business units.

The platform will act as a single, unified access layer for enterprise data, supporting both domain-specific and enterprise-wide use cases. The environment is currently a hybrid architecture, with Phase 1 primarily on-prem (PostgreSQL) and a strategic shift toward Snowflake as a federated data layer.

This role will focus on designing and delivering scalable data pipelines and transformation frameworks to support this initiative.

Key Responsibilities

• Design and build end-to-end data pipelines from source systems into target platforms (PostgreSQL / Snowflake)
• Ingest data from a variety of sources, including:
  • Metadata management tools
  • Legacy systems
  • Structured and unstructured datasets
• Implement and maintain a medallion architecture:
  • Raw (Bronze)
  • Curated (Silver)
  • Business-ready semantic (Gold)
• Develop transformation logic using:
  • Python (primary language)
  • SQL (stored procedures, materialized views, database objects)
• Leverage platform capabilities such as tasks, stored procedures, and internal tooling
• Support containerized data processing and deployment frameworks
• Apply data warehousing best practices, including:
  • Schema design
  • Fact/dimension modeling
  • Slowly changing dimensions (SCDs)

Technical Requirements

• Strong programming experience in Python (primary focus)
• Advanced SQL skills (querying, optimization, stored procedures)
• Experience building and maintaining ETL / ELT pipelines
• Experience with:
  • PostgreSQL
  • Snowflake (preferred)
• Solid understanding of data warehousing principles:
  • Star schema design
  • Fact and dimension tables
  • Slowly changing dimensions
• Experience working within a medallion architecture (bronze/silver/gold)
• Ability to process both structured and unstructured data

Soft Skills & Profile

• Highly detail-oriented with strong analytical and problem-solving abilities
• Resourceful and self-sufficient, able to navigate ambiguity
• Strong sense of ownership and accountability
• Comfortable working independently while collaborating across teams
• Proactive in identifying and resolving data challenges

This a great opportunity to join a Big Five Bank and continue your career in the financial domain. Be a part of a great work environment with a very well organized team and colleagues who will help you succeed.

This is a position that impacts the bank enterprise wide with great opportunity for career growth within the bank.

If you are not a 99% match to the above, and want to be considered for other opportunities at our enterprise clients, register for our Talent Network where you can receive job alerts about new opportunities that match your interests. 

Click here to Register for our Talent Network   

EEO Employer

Apex is an Equal Employment Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, sexual orientation, gender identity, national origin, disability, protected veteran status, or any other characteristic protected by law. Apex will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law. If you have visited our website in search of information on employment opportunities or to apply for a position, and you require an accommodation in using our website for a search or application, please contact our Employee Services Department at [email protected] or 844-463-6178.

Everforth Apex is a world-class IT services company that serves thousands of clients across the globe. When you join Everforth Apex, you become part of a team that values innovation, collaboration, and continuous learning. We offer quality career resources, training, certifications, development opportunities, and a comprehensive benefits package. Our commitment to excellence is reflected in many awards, including ClearlyRateds Best of Staffing® in Talent Satisfaction in the United States and Great Place to Work® in the United Kingdom and Mexico.

Everforth Apex Benefits Overview: In terms of professional development, Everforth Apex hosts an on-demand training program, provides access to certification prep and a library of technical and leadership courses/books/seminars once you have 6+ months of tenure, and certification discounts and other perks to associations that include CompTIA and IIBA.