Job Description

Senior Data Engineer, EIM

Department: Enterprise Information Technology

Employment Type: Full Time

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.