ETL/Data Architect

Key Responsibilities

Define & enforce development standards for ETL/Data Warehousing.

Design, code, test, & document reusable objects using Snowflake & IICS.

Lead full lifecycle Data Warehousing & integration projects from requirements to deployment.

Collaborate with Data Engineering team to implement solutions aligned with business needs.

Optimize infrastructure & reduce Data platform costs.

Implement operational improvements, including processes, controls, & code reviews.

Education & Experience

• Must have a Bachelor’s or foreign education equivalent in Engineering, Computer Science or Biotechnology, or foreign education equivalent & 4 years of experience as a data architect or in related field.
• Must have 4 years of experience:
  • working in data integration, data warehousing, cloud-related initiatives, & development & implementation of data solutions;
  • writing complex SQL queries;
  • partnering with external vendors or implementation partners to optimize service delivery;
  • working with data warehousing, data technologies, & ETL solutions;
  • leading end-to-end data engineering & data modelling activities, including design, implementation, testing, deployment, & support;
• Must have 3 years of experience:
  • applying architecture patterns & data integration design principles;
  • working in a matrix organization, balancing customer needs against organizational goals;
  • identifying & recommending appropriate product/service offerings to meet functional needs;
  • executing project delivery & client relationship management within a technology environment;
  • preparing data visualizations using Clik & PowerBI.

Salary Range

$160,555 - $178,500 per year

Benefits

• Paid time off (vacation, holidays, sick)
• Medical/dental/vision insurance
• 401(k)