Senior Data Warehouse Developer

3 weeks ago

Chicago, United States Mavens Guild Full time
What we would like to see:

Ideal candidate for this role will not only help us procure, curate and model various transactional data but also turn it into information, generating insights and aid in business decisions based on the analytical results. Incumbent's responsibilities will include conducting full development lifecycle — requirements, analysis, development, testing and production deployment whilst managing various everyday data warehouse related processes (SSIS, SSRS, SSAS) and MS SQL Server performance.

We expect you to possess analytical mindset with creative approach to tasks and experience in working with entire Microsoft BI stack with sound understanding of SQL Server and advanced SQL tuning for performance.

A typical day as a senior data warehouse developer:

  • Design and develop ETL and reporting processes using SSIS/SSRS tools based on established enterprise standards

  • Engage with business units to gather requirements and perform iterative data analysis in a fast paced agile environment

  • Architect SQL Server database structures and objects, fine tune SQL queries for performance and monitor latencies during batch processes

  • Identify, analyze, and interpret trends or patterns in complex data sets

  • Design and develop reports, and flat file extracts for consumption by business users and external vendors

  • Collaborate with management to prioritize business and information needs

  • Find and evaluate new process improvement opportunities

What you will need to bring to the table:

8+ years' experience of working as a data warehouse developer or ETL specialist with a deep understanding of relational databasesSolid experience of working with data models, database design development, performance tuning techniques


Solid experience in working with voluminous databases, creating database objects and tuning complex SQL queries for performance


Solid experience using ETL and reporting tools like SSIS, SSRS, SSAS, Informatica and Business Objects


Strong analytical thinking is vital to succeed in this role. You will be constantly asked to understand the business premise before employing your technical skills


Ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy


Good knowledge of documentation and code versioning


Good knowledge of working with enterprise automation tools


BS degree in Computer Science or relevant experience in lieu of a college degree for exceptional candidates


Complimentary skills sets like background in Java programming, Python and/or experience in other databases like Oracle, Netezza, Mongo DB, Teradata is a huge plus

  • Senior Data Warehouse Developer

    2 weeks ago

    Chicago, United States Mavens Guild Full time

    What we would like to see: Ideal candidate for this role will not only help us procure, curate and model various transactional data but also turn it into information, generating insights and aid in business decisions based on the analytical results. Incumbent's responsibilities will include conducting full development lifecycle — requirements, analysis,...

  • Senior Data Warehouse Architect

    4 weeks ago

    Chicago, United States UScellular Full time

    Senior Data Warehouse Architect-INF001877 Employer : U.S. Cellular Corporation Job Title : Senior Data Warehouse Architect Location : 8410 W. Bryn Mawr Avenue, Chicago, IL 60631 Job Duties : ØDesign a high performing Enterprise Data Warehouse; ØCollaborate with the stakeholders and build solutions. ØParticipate in process improvement...

  • Data Warehouse Developer

    7 days ago

    Chicago, United States Syntricate Technologies Full time

    Remote role- Market rate Qualifications:Data Warehouse & ETL Developer At least five years of experience in data warehousing development, implementation, and support. Strong SQL analysis skills and experience in database tuning and optimization. Experience two years experience with data modeling. At least three years of experience in Oracle Data Integrator...

  • Data Warehouse Developer

    7 days ago

    Chicago, United States Ask Staffing Full time

    Pay Range - $72 to $76 Location: 6045 S. Kenwood Avenue, Chicago, IL 60637 (This is a Hybrid role with 2 days in office) Data Warehouse Developer Requirements: • At least 7 years of experience in data warehousing development, implementation, and support. • Strong SQL analysis skills and experience in database tuning and optimization. •...

  • Senior Data Warehouse Architect

    1 week ago

    Chicago, United States U.S. Cellular Full time

    About This Role Employer : U.S. Cellular Corporation Job Title : Senior Data Warehouse Architect Location : 8410 W. Bryn Mawr Avenue, Chicago, IL 60631 Job Duties: O Design a high performing Enterprise Data Warehouse; O Collaborate with the stakeholders and build solutions. O Participate in process improvement initiatives and in setting best practice...

  • Senior Data Warehouse Architect

    5 days ago

    Chicago, United States UScellular Full time

    About This RoleEmployer :       U.S. Cellular Corporation Job Title :        Senior Data Warehouse Architect Location :        8410 W. Bryn Mawr Avenue, Chicago, IL 60631 Job Duties: Ø  Design a high performing Enterprise Data Warehouse; Ø  Collaborate with the stakeholders and build solutions. Ø  Participate in process improvement...

  • Senior Data Warehouse Architect

    4 weeks ago

    Chicago, United States UScellular Full time

    Job DescriptionAbout This RoleEmployer :       U.S. Cellular Corporation Job Title :        Senior Data Warehouse Architect Location :        8410 W. Bryn Mawr Avenue, Chicago, IL 60631Job Duties: Ø  Design a high performing Enterprise Data Warehouse;Ø  Collaborate with the stakeholders and build solutions. Ø  Participate in process...

  • Senior Data Warehouse Architect

    1 month ago

    Chicago, United States UScellular Full time

    About This RoleEmployer :       U.S. Cellular Corporation Job Title :        Senior Data Warehouse Architect Location :        8410 W. Bryn Mawr Avenue, Chicago, IL 60631 Job Duties: Ø  Design a high performing Enterprise Data Warehouse; Ø  Collaborate with the stakeholders and build solutions. Ø  Participate in process improvement...

  • Senior Systems Engineer

    1 hour ago

    Chicago, United States VetsEZ Full time

    **Senior Systems Engineer (Data Warehouse)** * Chicago, IL * Full-Time * Senior Systems Engineer (Data Warehouse) VetsEZ (Veterans EZ Info, Inc.), a verified Service-Disabled Veteran-Owned Small Business (SDVOSB), is a leading provider of information technology services to commercial and Government markets. VetsEZ is a company of Subject Matter Experts with...

  • Senior Systems Engineer

    21 hours ago

    Chicago, United States VetsEZ Full time

    **Senior Systems Engineer (Data Warehouse)** * Chicago, IL * Full-Time * Senior Systems Engineer (Data Warehouse) VetsEZ (Veterans EZ Info, Inc.), a verified Service-Disabled Veteran-Owned Small Business (SDVOSB), is a leading provider of information technology services to commercial and Government markets. VetsEZ is a company of Subject Matter Experts...

  • Sr. Data Architect

    19 minutes ago

    Chicago, United States Wellbe Senior Medical Full time

    Job Summary: WELLBE INTRODUCTION The WellBe care model is a Physician Led Advanced Practice clinician driven geriatric care (care of older adults) team focused on the care of the frail, poly-chronic, elderly Medicare Advantage patients. This population is typically underserved and very challenged with access to care. To address these problems, we have...

  • Informatica Developer

    1 month ago

    Chicago, United States Cogent Data Solutions Full time

    Informatica Developer Job Description We are looking for the persons who has minimum one of year of experience and interested to work as a Informatica PowerCenter developer to develop and enhance mappings (ETL&39;s) from various sources into an Oracle /Teradata Data Warehouse. Responsibilities - Develop Informatica workflows to collect data from multiple...

  • Data Warehouse Engineer Chicago

    4 days ago

    Chicago, United States Reddit Full time

    **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 than 50 million people visiting 100,000+ communities daily, it is home to the most...

  • Informatica Developer

    1 month ago

    Chicago, Illinois, United States Cogent Data Solutions Full time

    Informatica Developer Job Description We are looking for the persons who has minimum one of year of experience and interested to work as a Informatica PowerCenter developer to develop and enhance mappings (ETL&39;s) from various sources into an Oracle /Teradata Data Warehouse. Responsibilities Develop Informatica workflows to collect data from multiple data...

  • Senior Data Engineer

    1 week ago

    Chicago, United States ULINE Full time

    Senior Data Engineer Corporate Headquarters 12575 Uline Drive, Pleasant Prairie, WI 53158 Fuel the future of data engineering and analytics for our growing North American company! As a Senior Data Engineer at Uline, you’ll play a pivotal role in constructing and maintaining our new, cutting-edge data collection systems and analytics platform. Better...

  • Lead Data Warehouse Engineer

    1 day ago

    Chicago, United States Motion Recruitment Full time

    Are you passionate about data and its transformative power in finance? We are working with a Chicago-based company with a mission to help everyday Americans escape the cycle of debt. As the Lead Data Warehouse Engineer, you'll play a pivotal role in defining best practices and standards within their data warehouse environment. Collaborating closely with...

  • Senior Data Solutions Engineer

    3 days ago

    Chicago, United States Epsilon Full time

    Job Description We are looking for a senior data solutions engineer with extensive experience in the big data and data warehouse ecosystems. The Epsilon Digital Data Organization builds and maintains MPP, HDFS and Elastic platforms to capture all data generated from the Ad Stack and external sources to support all aspects of the business. The candidate...

  • Lead Data Warehouse Engineer

    21 hours ago

    Chicago, United States Motion Recruitment Partners LLC Full time

    Are you passionate about data and its transformative power in finance? We are working with a Chicago-based company with a mission to help everyday Americans escape the cycle of debt. As the Lead Data Warehouse Engineer, you'll play a pivotal role in defining best practices and standards within their data warehouse environment. Collaborating closely with...

  • Senior Data Engineer

    4 days ago

    Chicago, United States IT Associates Full time

    Cloud Data Architect / Sr. Cloud Data Engineer ( Hands-On Role )Direct Hire / Fulltime / PermanentFull Benefits + BonusHybrid in Ann Arbor, MI- 2 days/weekMulti-Million Dollar E-commerce clientOpen to all. Client is open for Visa transfer and will provide relocation assistance.As a Cloud Data Solutions Architect focused on Data Solutions and Data Management,...

  • Senior Data Engineer

    1 day ago

    Chicago, United States IT Associates Full time

    Cloud Data Architect / Sr. Cloud Data Engineer ( Hands-On Role )Direct Hire / Fulltime / PermanentFull Benefits + BonusHybrid in Ann Arbor, MI- 2 days/weekMulti-Million Dollar E-commerce clientOpen to all. Client is open for Visa transfer and will provide relocation assistance.As a Cloud Data Solutions Architect focused on Data Solutions and Data Management,...