Join our dynamic team at Barrow Wise Consulting, LLC and take your career to the next level as a Senior ETL Developer! As a key member of our team, you will have the opportunity to work on exciting projects, collaborate with talented professionals, and contribute to the development of innovative solutions for our clients. Whether you work from our Remote hub or from the comfort of your own home, you will be an integral part of our team and play a vital role in driving our success.
We offer a competitive salary and a comprehensive benefits package to attract and retain top talent. If you are a motivated and experienced ETL Developer looking for a new challenge, we encourage you to apply for this exciting opportunity.
At Barrow Wise Consulting, LLC, we value innovation, creativity, and emerging technologies. Our team is dedicated to providing cutting-edge solutions to our clients, and we are looking for a talented Senior ETL Developer to join our ranks. As a multi-disciplined leader, you will have the opportunity to demonstrate your skills and expertise, think outside the box, and develop innovative solutions that exceed our clients’ expectations.
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, ensuring performance, dependency, auditing, error handling, and data quality issues are addressed
- 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
- Read and understand business requirements, write functional requirements, develop detailed technical designs, and build/unit/system test ETL code
- Work remotely and collaborate with our team to achieve our goals
Ideal Candidate:
- 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
- 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 SalesForce BULK 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
Why Join Us?
At Barrow Wise Consulting, LLC, we offer a fulfilling and engaging work environment that values diversity, integrity, quality, and innovation. We provide competitive compensation packages, excellent benefits, and opportunities for growth and advancement. Our team is dedicated to delivering innovative solutions to our clients, and we are committed to making a positive impact in our community.
We are an equal opportunity employer committed to diversity in the workplace. Minority/Female/Disabled/Protected Veteran/LBGT candidates are encouraged to apply.
Take the Next Step
Are you ready for this challenge? Apply now and let’s discuss how you can become a vital part of our success story.
