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

#J-18808-Ljbffr



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


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


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


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


  • 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: Ø  Design a high performing Enterprise Data Warehouse; Ø  Collaborate with the stakeholders and build solutions. Ø  Participate in process...


  • Chicago, United States UScellular Full time

    About This RoleEmployer : U.S. Cellular Corporation Job Title : Senior Data Warehouse ArchitectLocation : 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 improvement initiatives and in setting best practice standards;Provide...


  • Chicago, Illinois, United States UScellular Full time

    About This RoleEmployer : U.S. Cellular Corporation Job Title : Senior Data Warehouse ArchitectLocation : 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 improvement initiatives and in setting best practice standards;Provide...


  • Chicago, United States UScellular Full time

    About This RoleEmployer : U.S. Cellular Corporation Job Title : Senior Data Warehouse ArchitectLocation : 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 improvement initiatives and in setting best practice standards;Provide...


  • Chicago, Illinois, United States UScellular Full time

    About This RoleEmployer : U.S. Cellular Corporation Job Title : Senior Data Warehouse ArchitectLocation : 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 improvement initiatives and in setting best practice standards;Provide...


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


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


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


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


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


  • Chicago, IL, United States UScellular Full time

    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 initiatives and in setting best practice...


  • Chicago, IL, 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...


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


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


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


  • Chicago, United States Enova Full time

    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 builds data strategy and provides data solutions and tools across the organization. We...