Senior Data Engineer, EIM
$129,200–$174,800 year
RemoteToronto, Ontario, Canada or Canada
Job Summary
Design and implement a scalable data warehouse from the ground up, creating source-to-target data mappings and ETL transformation rules for HubSpot, Salesforce, and ADP WFN. Build and validate near real-time data pipelines using Snowflake, Python, and Fivetran while enforcing security and data governance standards. Partner with stakeholders to deliver a next-generation data architecture that unifies product usage, marketing effectiveness, and employee retention metrics. Drive the execution of the technical vision by evolving team maturity, automating operating models, and fostering data literacy across the organization through sprint-based delivery and continuous integration.
Required Qualifications
- 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
- Strong programming skills in SQL, Python and data integration tools such as Fivetran, and Stitch
- 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
- 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
Desired Qualifications
- Snowflake
- Fivetran
- Stitch
- A love of learning, a drive for self-improvement and a desire to help everyone be better
- Interest in AI and willingness to explore AI-driven solutions to enhance performance and drive efficiencies
Hiring someone like this?
Get your role in front of qualified candidates on Sorce.