Data Engineer

This is a fully remote position, open to applicants in Canada.

📋 Description

• Integrate various data sources and provide clear business insights to prepare data for AI applications.

• Create semantic views, controlled metrics, and contextual layers on Snowflake.

• Develop and sustain business context, including terminology, glossaries, metric definitions, guidelines, and hierarchies.

• Design, construct, validate, and publish governed Snowflake semantic views alongside a versioned metric registry.

• Establish canonical master datasets, such as master vehicle/VIN, dealer, and incentives datasets.

• Generate PDFs, glossaries, FAQs, and data dictionaries for easy retrieval using Snowflake Cortex Search.

• Collaborate with AI engineers to link semantic views, metrics, and search services with Cortex Analyst and Cortex Agents.

• Design, troubleshoot, and execute repeatable data pipelines on Snowflake and Google Cloud/BigQuery during the transition phase.

• Ensure pipeline reliability and data quality.

• Collect and comprehend data processing requirements from stakeholders.

• Contribute to new product development, features, and innovative products or methodologies.

• Lead comprehensive data engineering projects.

• Mentor and support junior data engineers.

• Work collaboratively with Customer Success, Product Management, Product Development, Technology/Architecture, Data Engineering, Data Science, AI Engineering, and Data Visualization teams.

⛳️ Requirements

• Strong hands-on expertise in Python and SQL.

• Demonstrated production experience in designing, building, and managing ETL/ELT pipelines from diverse data sources.

• Proven track record of ensuring pipeline robustness and output data quality, including idempotent jobs, monitoring and alerting, and automated data quality assessments.

• Software engineering knowledge or experience is advantageous, encompassing Git, code review, automated testing, CI/CD, and modular reusable code.

• Significant hands-on experience with Snowflake is highly preferred, including Snowpark, Dynamic Tables, and role-based access control.

• Familiarity with semantic layers or governed metrics and dimensional modeling.

• Understanding of RAG, embeddings and vector search, context and prompt design, tool invocation, AI agents, and MCP.

• Knowledge of ontologies, knowledge graphs, data catalogs, metadata management, and data governance.

• Experience with AI coding assistants and practical daily development use.

• Ability to creatively and effectively resolve data challenges.

• Independent professional capable of executing a vision with minimal guidance.

• Bachelor's degree is mandatory; a background in statistics, machine learning, computer science, finance, engineering, or mathematics is preferred.

• Minimum of 5 years of full-time professional experience with a Bachelor's degree or 3 years with a Graduate degree in data engineering and quantitative analytics.

• Strong written and verbal communication skills across multiple functions.

• Willingness and ability to learn in a fast-paced environment.

• Candidates must have legal authorization to work in the country where the job is offered.

• JD Power does not provide employment sponsorship for this position.

🏝️ Benefits

• Medical, dental, vision, disability, and life insurance.

• Retirement savings programs.

• Paid time off.

• Wellness programs.

• Additional company-sponsored benefits.

• Flexible work arrangements.

• Opportunities for learning and development.