Senior Data Warehouse Developer

4 weeks ago


Chicago, Illinois, United States AbbVie Full time
Job Summary

We are seeking a highly skilled Data Warehouse Developer to join our team at AbbVie. The successful candidate will be responsible for designing and developing data warehouse applications and ETL jobs utilizing databases such as Oracle, SQL Server, NoSQL, Postgres, and Teradata.

Key Responsibilities:

  • Design and develop data warehouse applications and ETL jobs utilizing databases such as Oracle, SQL Server, NoSQL, Postgres, and Teradata.
  • Responsible for understanding end-to-end operational data warehouses, including system integrations, data quality, and harmonization rules.
  • Design data models for data marts and warehouses using TOAD, Erwin data modeler, and SQL Developer tools.
  • Utilize advanced analytical SQL functions and performance tuning SQL queries.
  • Develop Unix shell scripts, Python, and Java scripts for file/data processing activities.
  • Responsible for reporting and visualizing data using business intelligence tools such as QlikView, Cognos, Spotfire, and using statistics coding tools (e.g., SAS, R, etc.).
  • Employ experience in developing and building enterprise data warehouses by ETL jobs using PL/SQL, Informatica.
  • Employ software development experience following Agile models and utilizing tools such as Oracle SQL, PL/SQL, Unix Shell Scripting, XML, and JSON.
  • Employ experience using version control systems such as GitHub, AWS CodeCommit, and Microsoft Team Foundation Server.
  • Act as a dedicated team player and interface with stakeholders from various internal IT disciplines (i.e., DBAs, architects, data scientists, infrastructure teams, etc.).
  • Responsible for maintaining cloud knowledge and exposure in AWS, Azure, and GCP.

Qualifications:

  • Must possess a Bachelor's degree or foreign academic equivalent in Computer Science, Information Technology, or a highly related field of study with at least 3 years of related experience in the following:
  • Designing and developing data warehouse applications and ETL jobs utilizing databases such as Oracle, SQL Server, NoSQL, Postgres, and Teradata.
  • Designing data models for data marts and warehouses using TOAD, Erwin data modeler, and SQL Developer tools.
  • Developing Unix shell scripts, Python, and Java scripts for file/data processing activities.
  • Reporting and visualizing data using business intelligence tools such as QlikView, Cognos, Spotfire, and using statistics coding tools (e.g., SAS, R, etc.).
  • Software development experience following Agile models and utilizing tools such as Oracle SQL, PL/SQL, Unix Shell Scripting, XML, and JSON.
  • Version control systems such as GitHub, AWS CodeCommit, and Microsoft Team Foundation Server.

What We Offer:

  • A comprehensive package of benefits including paid time off (vacation, holidays, sick), medical/dental/vision insurance, and 401(k) to eligible employees.
  • This job is eligible to participate in our short-term and long-term incentive programs.

About AbbVie:

AbbVie is an equal opportunity employer and is committed to operating with integrity, driving innovation, transforming lives, serving our community, and embracing diversity and inclusion.

It is AbbVie's policy to employ qualified persons of the greatest ability without discrimination against any employee or applicant for employment because of race, color, religion, national origin, age, sex (including pregnancy), physical or mental disability, medical condition, genetic information, gender identity or expression, sexual orientation, marital status, status as a protected veteran, or any other legally protected group status.



  • Chicago, Illinois, United States Syntricate Technologies Full time

    Data Warehouse DeveloperQualifications: We are seeking a highly skilled Data Warehouse Developer to join our team at Syntricate Technologies. The ideal candidate will have at least five years of experience in data warehousing development, implementation, and support. Strong SQL analysis skills and experience in database tuning and optimization are essential....


  • Chicago, Illinois, United States RIT Solutions, Inc. Full time

    Data Warehouse DeveloperThe Data Warehouse Developer will be responsible for coding and testing DW and ETL-related programs and processes. This role will work closely with a DW/ETL architect, DW and BI developers, source application developers, and database administrators to achieve a cross-functional, integrated reporting and analysis environment for...


  • Chicago, Illinois, United States Global Channel Management Full time

    About the RoleData Warehouse Developer is a key position at Global Channel Management, responsible for designing, developing, and maintaining our data warehouse using Oracle database and Oracle Data Integrator (ODI) for ETL.Key Responsibilities Design and develop data models using Kimball methodology for data warehousing design. Work with stakeholders to...

  • Senior Data Architect

    1 month ago


    Chicago, Illinois, United States The Kraft Heinz Company Full time

    Job Title: Senior Data ArchitectJob Summary:The Senior Data Architect will design, develop, and maintain data architecture and pipelines that adhere to ELT principles and business goals. The ideal candidate will have a strong background in data engineering, experience with Snowflake data modeling, and expertise in ELT using Snowflake SQL.Key...


  • Chicago, Illinois, United States The Chefs' Warehouse Full time

    Job SummaryThe Chefs' Warehouse is seeking a highly skilled Warehouse Operations Manager to oversee the daily operations of our distribution center. As a key member of our team, you will be responsible for ensuring the efficient and effective management of our warehouse operations, including inventory control, shipping and receiving, and supply chain...

  • Data Analyst

    4 weeks ago


    Chicago, Illinois, United States Prairie Full time

    Data Warehouse and Analytics ProfessionalAt Prairie, we are seeking a highly skilled Data Warehouse and Analytics Professional to join our team. As a key member of our data analytics team, you will be responsible for designing and implementing data warehouses, developing complex SQL queries, and analyzing large datasets to identify trends and patterns.Key...

  • Data Scientist

    4 weeks ago


    Chicago, Illinois, United States Prairie Full time

    Data Warehouse Expert WantedAt Prairie, we are seeking a highly skilled Data Warehouse Expert to join our team. As a Data Warehouse Expert, you will be responsible for designing and implementing data warehouses, ensuring data quality and integrity, and providing data analysis and insights to support business decisions.Key Responsibilities:Design and...


  • Chicago, Illinois, United States Guidehouse Full time

    About the RoleWe are seeking an experienced Data Warehouse Engineer to join our team at Guidehouse. This role will involve analyzing data and developing data models using Microsoft technology stacks, participating in development and maintenance of our corporate data warehouse and data lake, and collaborating with cross-functional teams to ensure seamless...

  • Senior Data Architect

    4 weeks ago


    Chicago, Illinois, United States Top Prospect Group Full time

    Drive innovation in data solutions as a seasoned data engineering professional with a proven track record in designing and implementing robust data architectures on the Azure platform.Key Responsibilities:Design, develop, and maintain robust and scalable data pipelines using SQL and Azure.Implement ETL processes to ingest and transform data from various...


  • Chicago, Illinois, United States Cyclotron, Inc. Full time

    Job DescriptionSr. Data EngineerLevel: SeniorDepartment: AzureLocation: Fully RemoteType: Full-TimeJob SummaryCyclotron, Inc. is seeking a highly skilled Senior Data Engineer to lead the creation of high-value data-driven solutions leveraging our proven implementation methodology and solutions for enterprise projects. The ideal candidate will have extensive...

  • Senior Data Scientist

    1 month ago


    Chicago, Illinois, United States Gateway Recruiting, INC. Full time

    Job Title: Senior Machine Learning EngineerGateway Recruiting, INC. is seeking a highly skilled Senior Machine Learning Engineer to join our team. As a key member of our data engineering team, you will be responsible for designing and implementing high-quality data pipelines for advanced analytics solutions.Key Responsibilities:Analyze complex data sets to...

  • Senior Data Engineer

    1 month ago


    Chicago, Illinois, United States Oak Street Health Full time

    Job SummaryOak Street Health is seeking a highly skilled Senior Data Engineer to join our team. As a Senior Data Engineer, you will be responsible for designing, developing, and implementing modern data solutions using cutting-edge technology.Key ResponsibilitiesDesign and develop cloud-based data solutions using Azure cloud infrastructureDevelop and...

  • Senior Data Architect

    3 weeks ago


    Chicago, Illinois, United States Hexaware Technologies Full time

    Job Description:At Hexaware Technologies, we are seeking a highly skilled Data Warehouse Specialist to join our team. As a key member of our data team, you will be responsible for designing and implementing comprehensive data warehousing solutions for our clients. Key Responsibilities:Design and build complete data pipelines, moving and transforming data for...


  • Chicago, Illinois, United States RIT Solutions, Inc. Full time

    We are seeking a highly skilled Senior Data Quality Developer to join our team at RIT Solutions, Inc. The ideal candidate will have hands-on experience in large-scale data conversion projects, particularly involving Db2 and IBM mainframe systems transitioning into MS SQL Server.The successful candidate will have strong ERP expertise, with a comprehensive...

  • Senior Data Engineer

    15 hours ago


    Chicago, Illinois, United States Oak Street Health Full time

    Role OverviewOak Street Health is seeking a highly skilled Data Engineer to join our team. The ideal candidate will have extensive knowledge of modern programming languages, designing and developing data solutions, and experience with cloud orchestration and automation tools.Key ResponsibilitiesDesign and develop data solutions to consume data from multiple...


  • Chicago, Illinois, United States United Software Group Full time

    Job Summary:We are seeking a highly skilled Data Engineer with Palantir Expertise to join our team at United Software Group. As a key member of our data engineering team, you will be responsible for designing, developing, and implementing effective analytics solutions and models using Palantir.Key Responsibilities:Expertise in Palantir Data Foundry,...


  • Chicago, Illinois, United States Perfict Global, Inc. Full time

    About Perfict Global, Inc.We are a leading IT consulting services provider focused on delivering innovative business workforce solutions to Fortune 500 companies.Our team of trained and experienced professionals strives to bring together the best technologies available to manage clients' complex business and technology needs.We offer excellent benefits,...


  • Chicago, Illinois, United States JS Consulting Full time

    Job Title: Hyperion DeveloperJob Description:At JS Consulting, we are seeking a skilled Senior Oracle Hyperion Developer to join our team. As a key member of our finance team, you will be responsible for designing, developing, and maintaining Oracle Hyperion solutions, including Hyperion Financial Management (HFM), Hyperion Planning, and...

  • Data Modeler

    4 weeks ago


    Chicago, Illinois, United States Prairie Full time

    We are seeking a Senior Data Modeler / Sr Data Engineer to join our team at Prairie. The ideal candidate will have exceptional data modeling and SQL skills, with experience in designing, analyzing, and documenting complex data models.Key Responsibilities:Build and adapt complex data models supporting application development frameworks, ensuring they are...

  • Senior Data Architect

    3 weeks ago


    Chicago, Illinois, United States Hexaware Technologies Full time

    Job DescriptionWe are looking for a highly skilled Technical Architect to join our team at Hexaware Technologies.Key Responsibilities:Design and build complete data pipelines for ODS, Staging, Data Warehousing, and Data Marts using SQL Server Integration Services (ETL) or other related technologies.Implement Data Warehouse solutions (Star Schema, Snowflake...