Senior Data Engineer / Architect

Job Description

Subject to applicable law, all prospective hires will be required to demonstrate that they have been fully vaccinated for COVID-19 or intend to be vaccinated for COVID-19 by November 1, 2021, or qualify for a medical or religious accommodation to this vaccination requirement. Hired candidates who are not vaccinated by November 1, 2021, and who have not been approved for a legally-required medical or religious accommodation will be subject to disciplinary action up to and including termination of employment, in accordance with applicable law.

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.

The Cloud Engineer will be part of the Animal Health Technology Delivery team focused on Amazon Web Services (AWS) Cloud platform application development.

As member of the cloud team, Cloud Platform Engineer will be responsible for:
  • Engineering & Management of AWS platform to stay current with internal policies & procedure and advancement of the platform to support current & emerging business needs.
  • Partnering with business partners organization to build cloud native solutions for Animal Health users both internal and external.
  • Collaborate with our AWS Cloud engineering team to ensure appropriate security controls are in place for AWS platform and solutions leveraging cloud services.
  • Design and implement Data Lake technologies across Animal Health division focused on Cloud Architecture best practices.
  • Driving Infrastructure as code for service deployment as well as configuration management.
  • Developing and maintain Software Development Lifecycle (SDLC) documentation for the platform.
  • Actively participating in promoting best practices through community of practice and learning sessions.


Responsibilities:
  • Experience with AWS cloud implementation using EC2 instance, S3 storage, Redshift and different services.
  • Proficiency to create and runAWS Glue, Electronic Medical Record (EMR) , StreamSets, DataBricks or other Extract, Transform, Load (ETL) toolsets. Multiple toolsets knowledge is preferable.
  • Demonstrate ability to design and develop complex database loads and maintenance process.
  • Developing Data Lake solutions on Redshift and developing data ingestion pipelines through AWS S3using python.
  • Highly proficient in the use of SQL for developing complex Stored Procedures, Triggers, Functions, Performance Tuning and Query Optimization.
  • Deliver on data-driven projects through organization of team efforts and hands-on approach working.
  • Actively listen, and collaboratively translate commercial and business questions into data analysis and commercial solutions.
  • Perform data management releases following our company's standard SDLC including hyper-care and follow-ups.
  • Partner with domain experts to verify and drive model capabilities and translate modeling outputs into business language.


Education: B.S. in Computer Science, Math, Business or related field.

Qualifications:
  • 5+ plus years of experience developing database loads and ETL tools.
  • 5+ plus Experience in developing and / or deploying complex Business Analytics solutions.
  • 3+ years of delivering end-to-end data analysis including working with large data sets.
  • Must have worked with Business Intelligence / Data Warehouse projects.
  • AWS Solution Architect Associate Certified.


Preferred Skills

Experience with Enterprise data sets - Across Value chain of Commercial, Supply chain, and Research.

Managed vendor teams that handle technical development and support.

BI development experience for Online Analytical Processing (OLAP) cubes with Spotfire / Qlik / PowerBI, etc

Our Support Functions deliver services and make recommendations about ways to enhance our workplace and the culture of 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 ...

Imagine getting up in the morning for a job as important as helping to save and improve lives around the world. Here, you have that opportunity. You can put your empathy, creativity, digital mastery, or scientific genius to work in collaboration with a diverse group of colleagues who pursue and bring hope to countless people who are battling some of the most challenging diseases of our time. Our team is constantly evolving, so if you are among the intellectually curious, join us—and start making your impact today.

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

Current Contingent Workers apply HERE

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 if you need an accommodation during the application or hiring process.

For more information about personal rights under Equal Employment Opportunity, visit:

EEOC Poster

EEOC GINA Supplement​

OFCCP EEO Supplement

Pay Transparency Nondiscrimination

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.

Employee Status:
Regular

Relocation:
No relocation

VISA Sponsorship:
No

Travel Requirements:
10%

Flexible Work Arrangements:
Remote Work

Shift:
Not Indicated

Valid Driving License:
Yes

Hazardous Material(s):

Number of Openings:
1

Requisition ID:R142805