McKesson/CoverMyMeds is looking for a Sr Associate Data Engineer to join a team that focuses on transactional data, helping transform analytics and master data to feed back into production applications. The role involves building data models that directly support production traffic and solving business problems by delivering solutions.
Requirements
- Strong, hands-on experience as a technologist working with data warehouse solutions, cloud technology, relational databases and dashboarding tools such as Postgres, SQL Server, Databricks, Qlik, Kafka, etc.
- Worked with structured and unstructured data and within batch and real-time data streaming environments
- Experience supporting OLTP Applications, Real time Analytics, Systems Integration, and Data Governance
- Demonstrated expertise in database design and modeling for transactional systems
- Expert knowledge of cloud data technologies
- Experience with business-critical applications
- Experience on large-scale implementation programs
Responsibilities
- Under the guidance of a senior engineer, design and develop solutions and commissions of complex data across systems for McKesson/CoverMyMeds internal and external customers
- Develop Data Ingestion and Integration pipelines from various sources to application data stores
- Work with databases, files and unstructured data to identify, transport and quality test the data required to drive our data synchronization tasks to perform regular and incremental loads of data
- Write program/code in SQL and / or cloud based tools such as Snowflake or Databricks to cleanse, apply business logic and standardize the data according to business rules, enabling more effective data governance along with clear and efficient end-user reporting
- Design conceptual data model based on business reporting requirements, interacting with business partners to understand the business logic and end-use of the data
- Work with the application development teams to determine data flow in the source system and architect an appropriate flow into productions systems.
Other
- Our preferred candidate must reside in the Columbus, OH area.
- Position allows for primarily working from home, with occasional in-office time.
- At this time, we are not able to offer sponsorship for employment visas.
- Candidates must be authorized to work in the United States on a permanent basis without the need for current or future sponsorship.
- Excellent written and verbal communication skills; timely communication with clear expectations; an active listener and clear communicator; can lead by influence.
