Senior Data Engineer, EIM

Vena Solutions; Toronto; Hybrid; CAD 129,200 - 174,800; Full time

Job summary

Vena Solutions is seeking an experienced Data Engineer to design and implement our internal data platform with scale in mind.

You will drive data integration and warehousing work across multiple apps, build automated pipelines, and partner with stakeholders to promote data governance and a data-driven culture. The role offers flexible work options in Canada, with remote, hybrid, or Toronto office paths.

Qualifications

• 4+ years building and deploying data integration (ETL) workflows from multiple sources.
• Experience with cloud data warehouses such as Snowflake or Redshift.
• Strong SQL, Python and data integration tooling skills (Fivetran, Stitch).
• Ability to design source-to-target mappings and ETL transformations.
• Experience with near real-time data pipelines and scalable architectures.
• Familiarity with CI/CD and automated testing in data projects.

Responsibilities

• Drive the execution of the technical vision of our internal Data Infrastructure.
• Evolve technical excellence across the EIM organization.
• Build an all-inclusive data program combining data from multiple apps for product usage and business insights.
• Create agile data workflows that iterate in sprints with MVP mindset.
• Design strategies to improve growth and productivity via automated operating models.
• Create data models and mappings; build and validate ETL activities.
• Partner with stakeholders to deliver scalable data architecture aligned with governance.
• Foster data literacy and data-driven culture across the company.

Skills

ETL pipelines

SQL

Python

Data integration

Agile/Scrum

Data modeling

Communication

Leadership

Data warehousing

Tools

Snowflake

Redshift

Fivetran

Stitch

Job description

Department: Enterprise Information Technology

Location: Canada - Remote (0002)

Description
This is a flexible position and has the option of working in our Toronto office full time, hybrid throughout the week or working entirely remotely within Canada.
Are you looking to play an integral role in designing and implementing a Data Warehouse from the ground up? Vena has embarked on the journey of becoming a more data-driven organization and we realize that data is one of our most important assets. It’s an exciting time to join our growing Enterprise Information Management team, which is currently working on a large program to fundamentally transform the way we leverage data to drive business outcomes. We are looking for an experienced Data Engineer who will play an integral role in designing, implementing, monitoring and evolving our internal data platform with scale in mind.

We have many critical business systems and an ambitious data strategy to execute against to enable us to unlock value, insights and improve decision-making. The ideal candidate is both a data engineer and leader, who can design and enforce standards, best practices and methodologies, enable scalability of data engineering, quality assurance and analysis, and has strong interpersonal skills and can demonstrate the ability to work with nuanced data concepts.

How You\'ll Make An Impact

• Drive the execution of the technical vision of our internal Data Infrastructure.
• Evolve the maturity and the level of technical excellence across your group and the entire EIM organization.
• Build an all-inclusive data program that is source agnostic and brings together data from various business applications to provide product usage, marketing effectiveness, employee retention, LTV, all in one place.
• Create true agility within the data team to work sprint-by-sprint and build progressively, embracing the concept of MVP and backlogs.
• Design and implement strategies that will achieve growth and productivity through process automation of existing and new operating models.
• Create data models, data mapping and the necessary ETL design. Build and validate activities for various data integrations.
• Partner with key stakeholders teams to deliver a scalable next generation data architecture, and solid data engineering processes that align with corporate Security and Data Governance.
• Foster data-driven culture and the creation of related competencies and data literacy across the organization.
  

We\'d Love to See

• 4+ years of building and deploying data integration (ETL) workflows from multiple business applications (HubSpot, Salesforce, ADP WFN), databases, flat files, JSON/XML, APIs with proven working experience in an agile or scrum environment.
• Direct experience with Redshift, Snowflake, or similar cloud data warehouse technology. Snowflake is preferred.
• Strong programming skills in SQL, Python and data integration tools such as Fivetran, and Stitch. Fivetran is preferred.
• Skilled in creating source-to-target data mapping and ETL transformation rules.
• Experience developing and/or managing near real-time data pipelines and fast data architectures.
• Experience with creating reusable ETL framework/components, automated testing, continuous integration and automated build pipelines.
• Excellent understanding of relational and dimensional data modelling.
• The ability to influence through strong communication and interpersonal skills.
• A love of learning, a drive for self-improvement and a desire to help everyone be better.
• Understanding of complex business processes and subject matter, able to grasp and simplify the expression of complex scenarios in a way that helps business partners get to solutions;
• Customer service minded and strong client interaction skills.
• A top performer with a diligent work ethic and commitment to excellence.
• Interest in AI and willingness to explore AI-driven solutions to enhance performance and drive efficiencies
  

The base salary range for this role is $129,200 - 174,800 CAD.

• Our salaries are tailored to roles, levels and locations. Your individual pay within this range is influenced by factors like work location, skills, experience and education. As you progress in your role, your compensation may adapt, offering flexibility for growth beyond initial levels. For specifics, your recruiter will provide details and address any questions during the hiring process.