> Markdown version of [/jobs/ext/2042320-senior-etl-developer](https://www.wearedevelopers.com/jobs/ext/2042320-senior-etl-developer). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Senior ETL Developer - **Company:** Barrow Wise Consulting - **Location:** Chicago, IL, United States (Remote available) - **Experience:** Expert - **Salary:** $80,000.0 - $130,000.0 - **Contract:** Permanent contract - **Skills:** JavaScript (Programming Language), Application Programming Interfaces (APIs), C Sharp (Programming Language), Code Review, Databases, Data Integrity, Extract Transform Load (ETL), Data Warehousing, Software Debugging, Windows Communication Foundation, JSON, Python (Programming Language), Microsoft SQL Server, Simple Object Access Protocol (SOAP), SQL Server Integration Services, System Testing, Ab Initio, Ansi Sql, Information Technology, Restful APIs - **Published:** August 13, 2026 - **Apply:** https://www.careerjet.com/jobad/us7a06fc0eec8b4febb3b329f372ddbd1d ## About the Role Enjoy problem-solving, need a venue to display your creativity, and emerging technologies pique your interest; if so, Barrow Wise Consulting, LLC is for you. As a multi-disciplined leader, you understand the gifts that set you apart from everyone else. Demonstrate innovative solutions to our clients. Join Barrow Wise Consulting, LLC today.Responsibilities: The Sr. ETL Developer will support Barrow Wise's Chicago Public Schools (CPS) project and perform the following duties:Maintain and manage the existing CPS Enterprise Data Warehouse and ODS builds.Model extensions to the existing Data Warehouse.Build ETL components according to ETL specifications. Code must address performance, dependency, auditing, error handling, and data quality issues.Create REST API integrations with CPS vendors and Partners.Support post-deployment by debugging, fixing, and participating in maintenance.Create reports to meet business requirements and address data needs.Create Dashboard pages and metrics within the CPS custom dashboard solution.Maintain data integrity and quality within the Dashboard presentation layer.Participate in code reviews and ensure that all solutions align with pre-defined architectural specifications; identify/troubleshoot code-related issues; and review and provide feedback on the final user documentation.Read and understand business requirements, write functional requirements, develop detailed technical designs, and build/unit/system test ETL code.Work remotely.An ideal candidate has the following: S. CitizenshipBachelor's degree in computer science or related field.10+ years of Enterprise Data Warehouse experience5+ years of experience with an ETL product (SSIS, Ab Initio, etc.) in a development role (administrative knowledge a plus)Good knowledge of data modeling/Star SchemaStrong expertise in ANSI SQL, SQL Server 2012/2019, and REST API development.Experience with C#, Python, JavaScript, JSON, XMS, and an understanding of HTTP/HTTPS and RESTful design.Ability to develop and organize high-quality documentation.Experience with at least one job scheduler.Experience in CPS or large school district and knowledge of CPS Selective Enrollment process.Experience with compliance reporting (State and DOE)Knowledge of the Aspen SIS database and OneRoster 1.1 or laterPreferred: Knowledge of SalesForceBULK API and ISBE WCF SOAP Protocol.Strong written and oral communication skills.Proven ability and initiative to quickly learn and research new concepts, ideas, and technologies.Strong systems/process orientation with demonstrated analytical thinking, organizational skills, and problem-solving skills.Ability to work in a team-oriented, collaborative environment.Ability to quickly pick up new tools and technologies.Willingness and ability to train and teach others.Ability to facilitate meetings and follow up with resulting action items.Ability to prioritize and execute tasks in a high-pressure environment.Strong presentation and interpersonal skills., Ability to ## Description Important Update: At Northwestern Medicine safety is always a top priority. In response to the COVID-19 pandemic, Northwestern Medicine has moved to a more virtual recruitment proc… + 21 days ago + ## Related Videos - [Cloud Vendor Lock-In - Is it just a new version of the Database Abstraction Layers?](https://www.wearedevelopers.com/videos/1185-cloud-vendor-lock-in-is-it-just-a-new-version-of-the-database-abstraction-layers) - [Tips and Tricks for Working with JSON](https://www.wearedevelopers.com/videos/1229-tips-and-tricks-for-working-with-json) - [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt) - [Introducing JSON Structure](https://www.wearedevelopers.com/videos/100219-introducing-json-structure) - [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering) - [JSON and Beyond](https://www.wearedevelopers.com/videos/968-json-and-beyond) ## Related Articles - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Best Coding Boot Camps in Germany](https://www.wearedevelopers.com/magazine/237-best-coding-boot-camps-in-germany) - [Should senior developers refuse interview coding challenges?](https://www.wearedevelopers.com/magazine/29-should-senior-developers-refuse-interview-coding-challenges) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [Is Software Engineering Over-Saturated?](https://www.wearedevelopers.com/magazine/418-is-software-engineering-over-saturated) - [Dev Digest 121 - AI goes offline](https://www.wearedevelopers.com/magazine/456-dev-digest-121-ai-goes-offline)