Merck Senior Data Engineer in Columbia, South Carolina
Our IT team operates as a business partner proposing ideas and innovative solutions that enable new organizational capabilities. We collaborate internationally to deliver the services and solutions that help everyone to be more productive and enable innovation.
As our Human Health Insights Engine US Data Hub SR Data Engineer at Merck, you will be part of inventing tomorrow. Our Innovative centers are where great people come together and deliver solutions that save and improve lives.
We are seeking motivated talent interested in solving problems to improve tomorrow.
The primary responsibility of the senior data engineer will be to perform elicit data requirements, profile datasets and drive the delivery of innovative, quality data products for the Human Health Insights Engine US Data Hub which is a data warehouse that supports US commercial operations. This will include the following:
Profile datasets and partner with data suppliers and data owners to prepare data technical metadata/data dictionary and assess the data fit for the requested business purpose
Partner with business and IT teams to understand their data needs and to design conformed datasets which can be broadly used to fulfil those requirements
Define the data acquisition patterns to be used for new datasets prioritized in the data product backlog
Design curated datasets which fulfill the user needs prioritized in the data product backlog. These datasets may include creation of new metrics; application of business rules; harmonization/deduplication of datasets across multiple sources; and aggregation of datasets
Actively assess performance and quality of existing datasets to identify opportunities for improvement
Identify new data patterns and design standardized methods for addressing those patterns in partnership with the solution architect
Provide 3rd line support to investigate complex production data issues which cannot be resolved by production support teams
As a data subject matter expert, support the Business in the understanding and interpretation of commercial data and help to derive approaches for how data can be used to support effective commercial operations
Communicate requirements to and direct data product developers/testers who will implement the data acquisition and curation activities
Define and manage metadata describing the curated and conformed datasets contained within the US Data Hub
Present data requirements and outcomes of data analysis to the Business and internal IT colleagues.
Actively facilitate in project scoping and/or business requirement sessions
Collaborate with vendors to drive solutions and influence product solution road map
Provide support to design, construction and testing phases of the project(s)
Collaborate with other team members (involved in the requirements gathering, testing, roll-out and operations phases) to ensure seamless transitions.
Mentor junior analysts to drive best practice analysis on all projects
You will work and learn more about:
US Merck Commercial strategy
Enabling data products to support business strategy
Working within the market and leveraging the hub network
Utilizing external and internal data to support Business driven commercial insights
- B.S. or M.S. in IT, Engineering, Computer Science, or related field
A minimum of 5 years of relevant work experience, with demonstrated expertise in the BI and Analytics space
Experience doing data analysis and engineering, using SQL, GLUE and other standard data querying and profiling tools.
Experience with database and ETL Tools
Experience with leading requirements sessions with clients and project teams.
Excellent written and oral communication skills along with the ability to present clear and concise solutions to stakeholders and IT partners
4+ years of data engineering and design experience
2+ years of experience with cloud-based data warehouse and/or data lake solutions
Deep understanding of data management best practices and data analytics
Ability to distill complex concepts into easy-to-understand frameworks and presentations
Experience with agile development methodologies and best practices.
Knowledge of data profiling tools (i.e. Glue).
Experience working with pharmaceutical commercial data
Up to speed with latest technologies in data engineering, data warehousing, and data management
Ability to work independently in a complex environment
Experience working with on and off-shore engineering resources, including vendor delivery teams
High Proficiency in Information Management, Data Analysis and Data Requirement Elicitation
Strong communication and leadership skills and possess the ability to forge strong working relationships with various stakeholders
Experience with data warehouse/data lake design and data modeling concepts.
Our Support Functions deliver services and makes recommendations about ways to enhance our workplace and the experience of working at our organization. Our Support Functions include HR, Finance, Information Technology, Legal, Procurement, Administration, Facilities and Security.
Who we are …
We are known as Merck & Co., Inc., Kenilworth, New Jersey, USA in the United States and Canada and MSD everywhere else. For more than a century, we have been inventing for life, bringing forward medicines and vaccines for many of the world's most challenging diseases. Today, our company continues to be at the forefront of research to deliver innovative health solutions and advance the prevention and treatment of diseases that threaten people and animals around the world.
What we look for …
In a world of rapid innovation, we seek brave Inventors who want to make an Impact in all aspects of our business, enabling breakthroughs that will affect generations to come. We encourage you to bring your disruptive thinking, collaborative spirit and diverse perspective to our organization. Together we will continue Inventing For Life, Impacting Lives while Inspiring Your Career Growth .
Invent. Impact. Inspire.
NOTICE FOR INTERNAL APPLICANTS
In accordance with Managers' Policy - Job Posting and Employee Placement, all employees subject to this policy are required to have a minimum of twelve (12) months of service in current position prior to applying for open positions.
If you have been offered a separation benefits package, but have not yet reached your separation date and are offered a position within the salary and geographical parameters as set forth in the Summary Plan Description (SPD) of your separation package, then you are no longer eligible for your separation benefits package. To discuss in more detail, please contact your HRBP or Talent Acquisition Advisor.
Current Employees apply HERE (https://wd5.myworkday.com/msd/d/inst/1422$1533/rel-task/3001$14.htmld)
Current Contingent Workers apply HERE (https://wd5.myworkday.com/msd/d/task/1422$4020.htmld)
US and Puerto Rico Residents Only:
Our company is committed to inclusion, ensuring that candidates can engage in a hiring process that exhibits their true capabilities. Please click here (https://survey.sogosurvey.com/r/aCdfqL [survey.sogosurvey.com]) if you need an accommodation during the application or hiring process.
For more information about personal rights under Equal Employment Opportunity, visit:
EEOC Poster (https://www.dol.gov/sites/dolgov/files/ofccp/regs/compliance/posters/pdf/eeopost.pdf)
EEOC GINA Supplement
OFCCP EEO Supplement (https://www.dol.gov/ofccp/regs/compliance/posters/pdf/OFCCP_EEO_Supplement_Final_JRF_QA_508c.pdf)
We are proud to be a company that embraces the value of bringing diverse, talented, and committed people together. The fastest way to breakthrough innovation is when diverse ideas come together in an inclusive environment. We encourage our colleagues to respectfully challenge one another’s thinking and approach problems collectively. We are an equal opportunity employer, committed to fostering an inclusive and diverse workplace.
Search Firm Representatives Please Read Carefully
Merck & Co., Inc., Kenilworth, NJ, USA, also known as Merck Sharp & Dohme Corp., Kenilworth, NJ, USA, does not accept unsolicited assistance from search firms for employment opportunities. All CVs / resumes submitted by search firms to any employee at our company without a valid written search agreement in place for this position will be deemed the sole property of our company. No fee will be paid in the event a candidate is hired by our company as a result of an agency referral where no pre-existing agreement is in place. Where agency agreements are in place, introductions are position specific. Please, no phone calls or emails.
Flexible Work Arrangements:
Remote Work, Telecommuting
Valid Driving License:
Number of Openings:
Requisition ID: R113414