Senior ETL & Data Warehouse Engineer (Remote)

Barrow Wise Consulting, LLC; Chicago (IL); On-site; USD 80,000 - 130,000; Full time

Benefits offered by this job

Competitive compensation

Excellent benefits

Growth opportunities

Job summary

Barrow Wise Consulting, LLC seeks a senior data warehouse engineer to maintain CPS Enterprise Data Warehouse and build robust ETL processes.

You will model data extensions, develop REST API integrations with CPS vendors, and create dashboards and reports to meet district needs. The role emphasizes performance, data quality, and documentation, with remote work available and a competitive compensation package.

Qualifications

• Bachelor's degree in computer science or related field.
• 10+ years of Enterprise Data Warehouse experience.
• 5+ years with an ETL product (SSIS, Ab Initio, etc.).
• Strong knowledge of data modeling/Star Schema.
• Expertise in ANSI SQL, SQL Server 2012/2019, and REST API development.
• Experience with C#, Python, JavaScript, JSON, and HTTP/REST design.
• Excellent written and verbal communication skills.
• Experience with CPS or large school districts and CPS Selective Enrollment.
• Knowledge of CPS compliance reporting and OneRoster 1.1+

Responsibilities

• Maintain and manage the CPS Enterprise Data Warehouse and ODS builds.
• Model extensions to the existing Data Warehouse.
• Build ETL components per ETL specifications.
• Code with attention to performance, auditing, error handling, and data quality.
• Create REST API integrations with CPS vendors and partners.
• Support post-deployment via debugging and maintenance.
• Create reports and dashboards to meet business needs.
• Participate in code reviews and uphold architectural specs.

Skills

ANSI SQL

REST API development

C#

Python

JavaScript

JSON

Data modeling

Communication

Education

Bachelor's degree in computer science or related field

Tools

SSIS

Ab Initio

Aspen SIS

OneRoster 1.1+

Salesforce BULK API

Job description

Barrow Wise Consulting, LLC seeks a senior data warehouse engineer to maintain CPS Enterprise Data Warehouse and build robust ETL processes.

You will model data extensions, develop REST API integrations with CPS vendors, and create dashboards and reports to meet district needs. The role emphasizes performance, data quality, and documentation, with remote work available and a competitive compensation package.