Senior Data Engineer (remote)

Job description

Are you looking to make a difference in a patient’s life? At AmerisourceBergen, you will find an innovative and collaborative culture that is patient focused and dedicated to making a difference. As an organization, we are united in our responsibility to create healthier futures. Join us and Apply today!
What you will be doing
An individual in this role understands how to integrate disparate data sources like SAP ECC, SAP HANA, Salesforce, etc. to build a modern enterprise data warehouse using Microsoft Azure. This person must have a solid understanding of Data Warehousing and ETL/ELT design principles. The Senior Data Engineer will be a subject matter expert for data related to Enterprise Analytics. Senior Data Engineer will be a mentor and support for junior team members.
Position can be based out of our Headquarters located in Conshohocken, PA - or remote possibilities.
  • Design and develop code for data frameworks and data pipelines using industry best practices.
  • Leads major projects/ programs, providing subject matter expertise and technical direction and oversight.
  • Bridge the gap between business and technology by leading technical requirements gatherings and establishing integration approaches
  • Participate in design, implementation, and support of a data lake, warehouse and analytics platform utilizing Azure offerings
  • Design and implement ETL/ELT processes to bring data from disparate sources into Azure Data Lake and subsequently load to Azure Synapse
  • Promotes effective use of information technology by educating users on new functionalities.
  • Assists in the development of user guides and training documentation for systems.
  • Contributes to strategic planning meetings and provides guidance and expertise on system options, risk, cost vs. benefits, and impacts on business processes and goals.
  • Works closely with Enterprise architects and other teams to assure all systems are in line with IT long-term strategy.
  • Ensures adherence to standards, policies and procedures. Reviews modules for quality assurance.
  • Consults Delivery Management team on batch/bulk data load scheduling to optimize performance
  • Works with stakeholders to gather requirements on merging, de-duping, cleansing rules.
  • Develops reports and presentations for senior management, as needed.
  • Recognizes and resolves conflicts between models, ensuring that data models are consistent with the enterprise model (e.g. entity names, relationships and definitions)
  • Works with Delivery Management team to understand potential impacts to physical/virtual infrastructure and assists with remediation planning. Works with others to determine analytics data consumption alternatives and recommend optimal approach based on analytics requirements.
  • Transfers knowledge of data access/consumption mechanisms to business stakeholders, data visualization specialists and/or data scientists.
  • Defines, documents, and maintains all data definitions, data sources, business meaning and usage of information.
  • May provide technical direction and oversee testing of business analytics solutions.
  • Bachelor’s degree in Programming/Systems or Computer Science or Engineering Or equivalent work experience.
  • Five or more years of experience in technologies relevant to data/information management, such as SQL, RDBMS, Data Lake, SSIS, Informatica PowerCenter, etc.
  • Experience with Azure Data lake, Azure Data factory, Azure Synapse
  • Broad level of understanding surrounding information systems and application architecture standards.
  • Solid scripting experience with T-SQL/ SQL Procedure, Exposure to Azure Logic Apps, Azure Function will be preferred
  • Nice to have Experience with Databricks / Python programming
  • Prior experience in integration of SAP BW/ SAP HANA with Azure would be added an advantage
What your background should look like
  • Bachelor’s degree in Programming/Systems or Computer Science or other related field. Or equivalent work experience.
  • Five (5) to (10) ten years of experience in technologies relevant to data/information management, such as SQL, RDBMS, Data Lake/Hadoop, MDM, Metadata, Data Quality, etc.
  • Has a broad level of understanding surrounding information systems and application architecture standards.
  • Experience in leading small project teams and streams.
  • Demonstrated ability to analyze and interpret complex problems or processes that span multiple business areas, identify and understand requirements, and develop alternate solutions.
  • Experience designing, developing and testing applications using proven or emerging technologies in a variety of technologies and environments.
As of August 24, 2021, AmerisourceBergen requires all U.S. team members to be fully vaccinated and show proof of completed vaccine status at time of hire. If you cannot receive the COVID-19 vaccine due to a disability/medical reason or sincerely held religious belief you will be required to follow AmerisourceBergen’s policy and process to apply for an exemption/accommodation.
What AmerisourceBergen offers

We offer competitive total rewards compensation. Our commitment to our associates includes benefit programs that are comprehensive, diverse and designed to meet the various needs across our associate population.

Throughout our global footprint and various business units, we take a balanced approach to the benefits we offer. Many benefits are company-paid, while others are available through associate contributions. Specific benefit offerings may vary by location, position and/or business unit.
Full time
Salary Range*
  • This Salary Range reflects a National Average for this job. The actual range may vary based on your locale. Ranges in Colorado-specific locations may be up to 10% lower than the minimum salary range, and 12% higher than the maximum salary range.
Affiliated Companies:
Affiliated Companies: AmerisourceBergen Services Corporation
Equal Employment Opportunity
AmerisourceBergen is committed to providing equal employment opportunity without regard to race, color, religion, sex, sexual orientation, gender identity, genetic information, national origin, age, disability, veteran status or membership in any other class protected by federal, state or local law.

Please let the company know that you found this position on this Job Board as a way to support us, so we can keep posting cool jobs.