Senior ETL Developer

Barrow Wise Consulting, LLC; Chicago (IL); Presencial; USD 80.000 - 130.000; Jornada completa

Ventajas ofrecidas por este puesto de trabajo

Competitive compensation

Excellent benefits

Growth opportunities

Descripción de la vacante

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.

Formación

• 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+

Responsabilidades

• 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.

Conocimientos

ANSI SQL

REST API development

C#

Python

JavaScript

JSON

Data modeling

Communication

Educación

Bachelor's degree in computer science or related field

Herramientas

SSIS

Ab Initio

Aspen SIS

OneRoster 1.1+

Salesforce BULK API

Descripción del empleo

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

• 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 FollowingS.

• 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.

Salary: $80000 - $130000 per year