Jobs
>
Chicago

    Senior ETL Developer - Chicago, United States - Barrow Wise Consulting, LLC

    Default job background
    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.

  • The University of Chicago

    Etl Developer

    2 weeks ago


    The University of Chicago Chicago, United States

    Department · BSD CRI - Data Warehouse · About the Department · We are committed to increasing diversity, equity, and inclusion for the benefit of our team members, our institution, our clients, and our community. We will accomplish this by incorporating our values into hiring pra ...

  • University of Illinois

    Etl Developer

    1 week ago


    University of Illinois Chicago, United States

    **ETL Developer - Office of the Vice Chancellor for Research** · **Hiring Department**: Office of the Vice Chancellor for Research · **Location**: Chicago, IL USA · **Requisition ID**: · **Posting Close Date**: 6/14/2024 · **About the University of Illinois Chicago** · UIC is am ...

  • CyberTec

    ETL Developer

    3 weeks ago


    CyberTec Chicago, United States

    Let me know if you have a candidate currently living in one of the approved states (attached form), and willing to perform a 100% remote position supporting our client Client Cross Association (BCBSA) in Chicago, IL starting on February 26, 2024. · Our client only accepts candid ...

  • Hexaware Technologies

    ETL Developer

    1 week ago


    Hexaware Technologies Chicago, United States

    Role:- ETL Developer · FTE · Chicago IL · Job Description · 8+ years of Strong ETL & Data warehousing concepts · DB2 and MongoDB database working experience. · AWS service utilization experience with services like EC2, EMR, S3, Step Functions Glue and Dynamo · Control M experien ...

  • Ask Staffing

    ETL Developer

    3 weeks ago


    Ask Staffing Chicago, United States

    Pay Range - $75 to $79 · Location: Remote Chicago, IL · ETL Developer · Qualifications: · • Must have strong experience ETL Tools, Oracle Data Integrator (1-5 years) · • Must have strong experience Oracle SQL, PL/SQL (1-5 years) · • Should have strong understanding in BI/ ...

  • Hexaware Technologies

    ETL Developer

    1 week ago


    Hexaware Technologies Chicago, United States

    About the job · What Working at Hexaware offers: · Hexaware is a dynamic and innovative IT organization committed to delivering cutting-edge solutions to our clients worldwide. We pride ourselves on fostering a collaborative and inclusive work environment where every team member ...

  • Vanator

    Etl Developer only W2

    3 weeks ago


    Vanator Chicago, United States

    **ETL Developer [ONLY W2 Remote]** · **Description**: · - Hands on experience in Ab Initio ETL Projects, Ab Initio solution design and development. Ab initio experience including GDE, Plans, EME, m-hub and DQE. · - Strong knowledge and hands-on experience in SQL, Unix shell scrip ...

  • w3r Consulting

    ETL Developer

    3 weeks ago


    w3r Consulting Chicago, United States

    :Hands on experience in Ab Initio ETL Projects, Ab Initio solution design and development. Ab initio experience including GDE, Plans, EME, m-hub and DQE. · Strong knowledge and hands-on experience in SQL, Unix shell scripting. · Excellent grasp on all Components of Ab Initio - ...

  • CyberTec

    ETL Developer

    2 weeks ago


    CyberTec Chicago, United States

    · Let me know if you have a candidate currently living in one of the approved states (attached form), and willing to perform a 100% remote position supporting our client Client Cross Association (BCBSA) in Chicago, IL starting on February 26, 2024. · Our client only accepts can ...

  • Hirewell

    ETL Developer

    3 weeks ago


    Hirewell Chicago, United States

    Senior ETL Developer Job Description · We are seeking an experienced Senior ETL Developer to design, implement, and optimize ETL processes for multiple data sources using SQL, SSIS, or similar ETL tools. The ideal candidate will have strong communication, analytical, and problem- ...

  • Saxon Global

    ETL Developer

    1 week ago


    Saxon Global Chicago, United States

    Work Location: Prefer local to Chicago (Hybrid work schedule 3 days/week), but open to Remote for the right candidate Project Overview: Looking for an experienced DataStage ETL developer responsible for enhancing and supporting data ingest\egress integrations with Risk & Complian ...

  • EmergencyMD

    Senior ETL Developer

    3 weeks ago


    EmergencyMD Chicago, United States

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

  • Saxon Global

    ETL Developer

    1 week ago


    Saxon Global Chicago, United States

    Work Location: Prefer local to Chicago (Hybrid work schedule 3 days/week), but open to Remote for the right candidate · Project Overview: · Looking for an experienced DataStage ETL developer responsible for enhancing and supporting data ingestegress integrations with Risk & Com ...

  • ShiftCode Analytics

    ETL Developer/BigData

    3 weeks ago


    ShiftCode Analytics Chicago, United States

    Client Location - Chicago (will go to office 2nd and 4th Wednesdays of the month - Could change to once a week) · -Duration - 6+ months (need 6 months conversion waiver) · -Interview Process - 2 video interview · -Visa - USC,GC,GC-EAD,H4, L2 · Must Have - Requirements: · Re ...


  • RBC Technology Solutions LLC Chicago, United States

    Ab initio ETL developer: Location: Chicago,IL Strong knowledge and hands-on experience in SQL, Unix shell scripting. Excellent grasp on all Components of Ab Initio - GDE, PSETS, PDL Programming, Meta Programming etc. Good understanding in various Ab-initio parallelism techniques. ...


  • USG Chicago, United States

    USG is an industry-leading manufacturer of building products and innovative solutions. For over 120 years, Chicago-based USG has developed award-winning wall, ceiling, flooring, sheathing, and roofing products that enable customers to build outstanding spaces where people live, w ...

  • Revive Staffing Solutions Inc

    Sr. ETL Developer

    3 weeks ago


    Revive Staffing Solutions Inc Chicago, United States

    Senior ETL Developer · The Senior ETL Developer will be held accountable for the following responsibilities: · Maintain and Manage the existing Client Enterprise Data Warehouse and ODS builds. · Model extensions to the existing Data Warehouse · Builds ETL components according to ...


  • Saransh Inc Chicago, United States

    Role: ETL Snowflake Developer (SQL Database) · Location: Chicago, IL (Onsite from Day 1) · Job Type: Contract · Job Description: · 10+ years of strong Data warehouse experience. · Strong database (Oracle, MS SQL) skills in writing and optimizing SQL queries. · 4+ years of experie ...


  • TalentRupt Inc. Chicago, United States

    Job Description: · The ideal candidate will have hands-on experience in Ab Initio ETL projects, solution design, and development. Specific qualifications include: · Ab Initio Experience: Proficiency with GDE, Plans, EME, m-hub, and DQE. · Technical Skills: Strong knowledge and ha ...

  • Barrow Wise Consulting, LLC

    Senior ETL Developer

    3 weeks ago


    Barrow Wise Consulting, LLC Chicago, United States

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