Senior Data Warehouse & ETL Architect

Executive Staff Recruiters / ESR Healthcare; North Chicago (IL); On-site; USD 110,000 - 140,000; Full time

Job summary

ETL/Data Warehousing N Chicago, IL position focused on design, coding, testing and documentation of reusable objects using Snowflake and IICS. Lead end-to-end data warehousing and integration projects from requirements through deployment.

Collaborate with the Data Engineering team to implement solutions that meet business needs, while optimizing infrastructure and reducing data platform costs. Implement operational improvements, including controls, processes, and code reviews.

Qualifications

• Bachelor's or foreign education equivalent in Engineering, Computer Science or Biotechnology, or foreign education equivalent with 4 years of experience as a data architect or related field.
• 4 years in data integration, data warehousing, cloud initiatives, and development/implementation of data solutions; 3 years applying architecture patterns and data integration design principles; experience with data warehousing technologies and ETL.
• Experience partnering with vendors or implementation partners to optimize service delivery and leading end-to-end data engineering and data modelling activities.

Responsibilities

• Design, code, test and document reusable objects using Snowflake and IICS.
• Lead full lifecycle data warehousing and integration projects from requirements to deployment.
• Collaborate with Data Engineering team to implement solutions aligned with business needs.
• Optimize infrastructure and reduce data platform costs.
• Implement operational improvements, including processes, controls, and code reviews.

Skills

Snowflake

IICS

Data warehousing

ETL

SQL queries

Data modelling

Vendor management

Education

Bachelor's degree in Engineering/ Computer Science / Biotechnology

Tools

Clik

PowerBI

Job description

ETL/Data Warehousing N Chicago, IL position focused on design, coding, testing and documentation of reusable objects using Snowflake and IICS. Lead end-to-end data warehousing and integration projects from requirements through deployment.

Collaborate with the Data Engineering team to implement solutions that meet business needs, while optimizing infrastructure and reducing data platform costs. Implement operational improvements, including controls, processes, and code reviews.