Jobs
>
Chicago

    Data Warehouse Engineer - Chicago, United States - Busey Bank

    Default job background
    Description
    Position Summary
    The Data Warehouse Engineer is a key technical role responsible for the design, development, maintenance, and optimization of data warehouse processes. This includes creating and maintaining ETL (Extract, Transform, Load) processes, defining database architecture, and assisting in cloud migration efforts. The Data Warehouse Engineer collaborates with cross-functional teams to deliver data solutions that support Business Intelligence and analytics, ensuring data is accurate, timely, and easily accessible

    Duties & Responsibilities
    • Design, develop, and maintain data warehouse ETL processes to ensure accurate and timely data availability for business intelligence and analytics.
    • Define and implement efficient database architecture, including data modeling, indexing, partitioning, and performance tuning.
    • Collaborate with cross-functional teams to gather requirements, define data integration and transformation strategies, and deliver data solutions.
    • Assist in migrating existing on-premise data infrastructure to cloud platforms (e.g., AWS, Azure, or Google Cloud Platform).
    • Monitor and troubleshoot data pipeline performance, ensuring data quality, and addressing any data-related issues.
    • Stay up-to-date with the latest data engineering best practices, tools, and technologies to continuously improve and optimize data warehouse processes.
    • Develop and maintain technical documentation, including data flow diagrams, data dictionaries, and system specifications.
    Education & Experience

    Knowledge of:
    • Proficiency in SQL and experience with various database management systems (e.g., MySQL, PostgreSQL, Oracle, SQL Server).
    • Solid understanding of data warehouse concepts, including star schema, snowflake schema, and dimensional modeling.
    • Experience with ETL tools such as Microsoft SQL Server Integration Services (SSIS).
    • Knowledge of cloud platforms and experience in cloud migration, specifically with AWS, Azure, or Google Cloud Platform.
    • Strong programming skills in languages such as Python, Java, or Scala.
    • Knowledge of data visualization tools such as IBM Cognos, Tableau, or Power BI.
    Ability to:
    • Excellent problem-solving skills, attention to detail, and ability to work effectively both independently and in a team environment.
    • Strong communication skills, with the ability to explain complex technical concepts to non-technical stakeholders
    • Ability to lead and influence discussions across a variety of stakeholders to achieve results and proactively address sources of conflict
    • Self-starter with great communication skills (verbal and written)
    Education and Training:
    • Bachelor's degree in Computer Science, Engineering, Information Systems, or a related field. A Master's degree is preferred.
    • Minimum two years of experience in the technology industry, knowledge of the Financial Industry is a plus.
    • 3+ years of experience in data engineering, ETL development, and database management.
    • Certifications in data engineering, database management, or cloud platforms is a plus.
    • Requires knowledge of Microsoft Office.
    Busey values a diverse and inclusive workplace and strives to recruit, develop and retain individuals with exceptional talent. A team with diverse talent, working together, is essential to Busey's commitment of delivering service excellence. Busey is an Equal Opportunity Employer including Disability/Vets. Visit to learn more about Busey's Equal Opportunity Employment.


  • Busey Bank Chicago, United States

    Position SummaryThe Data Warehouse Engineer is a key technical role responsible for the design, development, maintenance, and optimization of data warehouse processes. This includes creating and maintaining ETL (Extract, Transform, Load) processes, defining database architecture, ...


  • Reddit Chicago, United States

    **Data Warehouse Engineer** · at Reddit Chicago Our mission is to bring community and belonging to everyone in the world. Reddit is a community of communities where people can dive into anything through experiences built around their interests, hobbies, and passions. With more t ...


  • Reddit Chicago, United States

    **Data Warehouse Engineer** · at Reddit · Chicago · Our mission is to bring community and belonging to everyone in the world. Reddit is a community of communities where people can dive into anything through experiences built around their interests, hobbies, and passions. With m ...


  • Beyond Finance, Inc. Chicago, United States

    At Beyond Finance, we've made it our mission to help everyday Americans escape the endless cycle of crippling debt and step into a brighter financial future. Through compassionate, individualized care,a culture focused on compliance and ethics, supportive user-centric technology, ...


  • Enova Chicago, United States

    We are interested in every qualified candidate who is eligible to work in the United States. However, we are not able to sponsor visas or take over sponsorship at this time. · About the role: · The Data Engineering, Warehouse, and Operations Team effectively and sustainably bui ...


  • beBee Handyman McCook, IL, United States Freelance

    I am in need of a service to complete an engineering project with the following characteristics in McCook, IL:Engineering branch for which the project is needed · Industrial · Type of project · Facilities · Type of construction · Industrial warehouse · When is the service needed? ...

  • TD Synnex - SHI for Chicago Public Schools (Central Office)

    Data Architect

    2 weeks ago


    TD Synnex - SHI for Chicago Public Schools (Central Office) Chicago, United States

    Chicago Public Schools (CPS) is one of the largest school districts in the United States, serving over 320,000 students in 600+ schools and employing approximately 40,000 people, most of them teachers. CPS has set ambitious goals to ensure that every student, in every school and ...

  • Ascendion

    Developer

    2 weeks ago


    Ascendion Chicago, United States

    **Description**: · **About Ascendion** · Ascendion is a full-service digital engineering solutions company. We make and manage software platforms and products that power growth and deliver captivating experiences to consumers and employees. Our engineering, cloud, data, experienc ...


  • OPEX Corporation Chicago, United States

    Field Service Technician - WA · For over 40 years, OPEX Corporation has received global recognition as a leader in the design, manufacture, and service of business process automation equipment. With their recent expansion into the Warehouse Automation market, OPEX has experienced ...


  • CENTSTONE SERVICES LLC North Chicago, United States

    **Job Title**: **Snowflake AWS Integration Architect** · **Location: Chicago, IL Hybrid** · **Duration: 10+ Months** · **Interview Process: Video** · Position's Contributions to Work Group: · Actual job title would be an Snowflake/AWS Integration Architect As an architect / Engi ...

  • eMeasurematics, Inc

    Area Sales Manager

    2 weeks ago


    eMeasurematics, Inc Chicago, United States

    **Company Description** · eMeasurematics - Is a well established company providing Autonomous Solutions and Robotics in Heavy Industries. eM is a team of energetic and ambitious young professionals from the innovative engineering industry. The company excels in the design, produc ...


  • Microsoft Chicago, United States

    As Microsoft Circular Center Inventory & Asset Technician (CC DIAT), you will perform destruction of data bearing device (DBD) destruction per policies and procedures, harvest and test parts from decommissioned devices. You will also oversee any third party DBD destruction proces ...


  • AbbVie North Chicago, United States

    **Company Description** · Support the Drawing Management team as a CAD software SME and Facility CAD Designer for the Engineering Project Teams,.Prepare CAD drawing and administering the CAD portion of projects per the Drawing Management Procedures & Standards. This will involve ...


  • Onward Technologies Inc. Chicago, United States

    **Snowflake AWS Architect role / **(IT Software 38372) · **Location: 540 W. Madison Avenue in Chicago, IL** · **Hybrid role** · **Pay Rate: $79.00 to $80.00 per hour** · You will love working as a Snowflake / AWS Architect in Chicago, Illinois. This is a hybrid role and you will ...

  • Metra

    Cartographer

    3 weeks ago


    Metra Chicago, United States

    Metra is one of the largest and most complex commuter rail systems in North America, serving Cook, DuPage, Will, Lake, Kane, and McHenry Counties. The agency is linking communities in Northeastern Illinois by providing safe, reliable, and efficient commuter service. · The Asset M ...

  • JLL

    Data Developer 2

    3 weeks ago


    JLL Chicago, United States

    JLL supports the Whole You, personally and professionally. · JLL Technologies Enterprise Data team is a newly established central organization that oversees JLL's data strategy. We are seeking data professionals to work with our colleagues at JLL around the globe in providing sol ...


  • Sevita Chicago, United States

    At Sevita we believe that everyone deserves to live well. For more than 50 years, our team members have provided home and community-based health care for adults, children and their families across the United States. As a member of our corporate team, you'll help shape the work th ...


  • Belvedere Trading Chicago, United States

    Belvedere Trading is a leading proprietary trading firm proudly headquartered in downtown Chicago. Our traders work hard to provide liquidity to the market through their market-making activities and are the masters of a diverse set of commodities, interest rates, exchange-traded ...

  • Purple Carrot

    Logistics Analyst

    3 weeks ago


    Purple Carrot Chicago, United States

    **About Purple Carrot** · Purple Carrot started with just a seed of an idea in 2014. Our vision is a world where plant-based eating is at the core of living well. Every day, on this mission, we're breaking boundaries with plant-based eating. We value learning from customers, an o ...


  • Health Talent Pro Chicago, United States

    The Operations Manager is responsible for leading and providing direction for the safe, reliable, and cost-effective operation of the facility. The Operations Manager generates tremendous value through: · - Health, Safety & Environmental and Reliability Leadership · - People Lead ...