Senior ETL Developer

EmergencyMD; Chicago (IL); Remote; USD 80,000 - 120,000; Full time

Job summary

Join a forward-thinking company as a Senior ETL Developer, where your problem-solving skills and creativity will shine. In this role, you will support critical projects for Chicago Public Schools, managing the Enterprise Data Warehouse and developing ETL components that ensure data integrity and quality. Collaborate with a diverse team to create innovative solutions that make a real impact in the educational sector. This position offers the opportunity to work remotely while being part of a company that values integrity, quality, and diversity. If you're ready to take your career to the next level, this is the perfect opportunity for you.

Benefits

Competitive Compensation

Excellent Benefits

Opportunities for Growth

Diverse Work Environment

Qualifications

• 10+ years of experience in Enterprise Data Warehouse and ETL development.
• Strong expertise in ANSI SQL and REST API development.

Responsibilities

• Maintain and manage the existing CPS Enterprise Data Warehouse.
• Build ETL components and create REST API integrations.

Skills

Enterprise Data Warehouse

ETL Development (SSIS, Ab Initio)

ANSI SQL

REST API Development

Data Modeling/Star Schema

C#, Python, JavaScript

Documentation Skills

Job Scheduling

Compliance Reporting

Aspen SIS Database Knowledge

Education

Bachelor's Degree in Computer Science

Tools

SQL Server 2012/2019

ETL Tools (SSIS, Ab Initio)

SalesForceBULK API

Job description

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. Citizenship
• Bachelor's degree in computer science or related field.
• 10+ years of Enterprise Data Warehouse experience
• 5+ 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 Schema
• Strong 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 later
• Preferred: 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 effectively move on tasks despite ambiguous or changing requirements.

Join the team at Barrow Wise Consulting, LLC for a fulfilling and engaging experience! Our team is dedicated to providing innovative solutions to our clients in an ethical and diverse work environment. We offer competitive compensation packages, excellent benefits, and opportunities for growth and advancement.

Barrow Wise is an equal opportunity, drug-free employer committed to diversity in the workplace. Minority/Female/Disabled/Protected Veteran/LBGT are welcome to apply.

Our employees stand behind Barrow Wise's core values of integrity, quality, innovation, and diversity. We are confident that Barrow Wise's core values, business model, and team focus create positive career paths for our employees.

Barrow Wise will continue to lead the industry in delivering new solutions to clients and persevere until the client is overjoyed.