Senior ETL Developer

Senior ETL Developer

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:

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