Job was saved successfully.
Job was removed from Saved Jobs.

Job Details

Merck & Co, Inc

Data Solutions Architect (Remote)


Data Architect


Madison, New Jersey, United States

Job Description

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 Opportunity:

This is a rare opportunity to join a start-up hub built within a major multinational with the goal to build a world class data platform / data mesh network for the division.

The Team:

The Data Platform team at our Animal Health Intelligence division of our company (MAHI) provides the development, support, and roadmap for the advanced analytics data platform. The team’s area of responsibilities is the capture, ingestion, transformation, storage, architecture, implementation of ML models and end user consumption end points such as self-service and APIs. The platform provides deep analytical insights for reporting and development of products for the market to aid in animal traceability, monitoring, well-being, actions, and other features based on descriptive, predictive, and prescriptive analytics.

About the Role:

Working at the cutting edge of the Animal Health Intelligence division of our company (MAHI), we seek a self-motivated, well communicative, experienced active hands-on Data Architect that will design, establish, and review architectures with new and existing data sources for ingestion as well as design for both internal an external consumption via self-serve analytics, developed APIs, and consumption layers and monitoring egress. Engineer enterprise-class, large scale deployments, and deliver Cloud-based data solutions to our customers.

You will work closely with engineering, ML Ops, data science, technical and business stakeholders, cloud engineers, data engineers, enterprise architecture, cloud teams, and foundational teams to architect the optimal platform for the Data Platform Team including cost efficiency. There will be a mixture of various environments, which are both within private and public subnets as well as infrastructures and regions.

You would bring your energy and skills to:

  • Data Architecture – Drive the architecture for the platform including best models for ingress and egress, ingestion, and microservices based APIs

  • Adaptation – Formulate the architectural strategy for ease of use for data consumers via data catalogs.

  • Optimizations of Models – Design and suggest the best models to use for both structured and unstructured data in the global data mesh architecture.

  • Communications - Manage timely and succinct communications to leadership and across teams to ensure accountability.

  • Agility - Lead with an agile first mindset while balancing urgency and prioritizations

We love to know more about you because:

  • You are great at modeling – You can easily take each use case and find the correct model for all sorts of data via batch or streaming capabilities and evaluate various data storage systems and propose plans for optimization, including RDS, Dynamo, S3, Mongo, DynamoDB, and others.

  • You are super confident in your skills – You have designed and implemented modern data platforms with self-serve federated mesh concepts preferably on Delta

  • You can evangelize – Define and evangelize the adoption of Data Architecture capabilities and standards and build architectural data processes that create repeatable and reusable capabilities to transform how the company collects, curates and consumes data

  • You see the vision – You understand both the big picture and the details.

  • You deal easy with change – You can demonstrate adaptability, resilience, and ability to thrive with changes and in ambiguity

  • You really understand agile – You have a firm understanding and have led true IT agile process

  • You are pragmatic – You know the right balance between progress and perfection.

  • You find your own work – You possess a strong sense of self-motivation, proactivity, takes initiatives and works independently with minimum direction.

Principle Duties and Responsibilities

  • Hand on experience designing and developing micro-services-based architectures and APIs

  • Present regular demos to stakeholders based on the features for each release

  • Identify risks both technical and functional as they pertain to the build-out of both the foundational ecosystem as well as the customer-facing features within

  • Design, develop, enhance, and help maintain an end-to-end micro-services for every main category of an modern data platform and application environment

What you need to have:

  • 5+ years of working experience in Cloud Data Architecture with implementation

  • Significant working experience in the realm of data management consulting or industry experience in driving Architecture, Data Engineering, Data Catalogs and Lineage, Data Modeling, Data Governance, Data Quality and Master Data Management

  • Extensive hands-on experience implementing Lakehouse architecture using Databricks Data Engineering platform, SQL Analytics, Delta Lake, and Unity Catalog

  • Extensive hands-on experience implementing serverless real-time/near real-time architecture using Cloud native services (i.e., Azure, AWS or GCP Tech Stack), and Spark technologies (e.g., Spark Streaming, Spark ML)

  • Deep understanding of modern data architecture including processes for both batch and streaming (CDC + IoT) data as well as modern cloud-based data technology (e.g. Databricks / Spark, Snowflake)

  • Demonstrated experience designing for enterprise-class applications and delivering highly available distributed, fault tolerant, globally accessible services at scale.

  • Create great technical documentation and present on demand

  • Expert technologies like Big Data, Data Lakes, Cloud Native Architecture, Cloud Security, Data Architecture, Data Orchestration, and Data Ingestion Production support experience with full regard to SLAs.

  • Deep understanding of structured and unstructured data architectures, data lakes, data warehousing, data orchestration as well as tools for data gathering and processing

  • Data modeling experience working with various types of data models (RDBMS, NoSQL, Graph, Columnar, Document)

  • Experience in implementation and performance tuning MPP databases (Snowflake, Redshift, EMR, Databricks)

  • Strong Knowledge and architecting for Data Governance, privacy, and regulations, GDPR

  • Experience with tools like Airflow and data storage formats such as JSON, Parquet, etc

  • Proficiency with AWS cloud services such as: EC2, EMR, RDS, Lambda, Glue, S3, Redshift

  • Programming Languages: Strong hands-on Python, Shell, Scala, Go, or other language

  • Outstanding verbal and written communication

  • Outstanding presenting skills to both technical and executive audiences whether impromptu on a whiteboard or using presentations and demos.

Additional things that would make you a superstar:

  • Extensive hands-on experience in data warehousing design, tuning and ETL/ELT process development

  • Experience building and deploying with container technologies such as Docker and Kubernetes and leveraging them throughout the CICD process

  • Current understanding of best practices regarding system security measures

  • 2+ years as a solutions architect

  • Strong API development

  • Experience as a Data Engineer

Education Minimum Requirements:

  • High School Diploma

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., Rahway, 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.


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.

For positions located in the United States and Puerto Rico – Subject to applicable law, all new hires (including internal transfers) must demonstrate that they are fully vaccinated against COVID-19 or that they qualify for a medical or religious exemption to this vaccination requirement. New hires (including internal transfers) to a position that, as determined by the Company, requires routine collaboration with external stakeholders (such as roles in health services or customer-facing commercial or research-based roles) (“Customer-Facing Role”) who are not vaccinated must qualify for a medical or religious exemption and be in a position that the Company determines can accommodate unvaccinated employees without causing an undue burden to business operations. If, following dialog with the candidate as appropriate, it is determined that the candidate either a) does not qualify for a religious or medical exemption or, b) for candidates applying for Customer-Facing roles, it is determined that allowing the candidate to work without vaccination would cause an undue burden to the Company, the candidate will be ineligible for hire or transfer, or any offer of employment or transfer (if applicable) will be revoked. Please note that notwithstanding the approval of any reasonable accommodation, the Company reserves the right to monitor, modify, or revoke any such accommodation if it is determined, following dialog with the employee, that the accommodation is no longer effective or results in an undue burden to the Company.

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 Know Your Rights

EEOC GINA 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.

Under New York City, Washington State and California State law, the Company is required to provide a reasonable estimate of the salary range for this job. Final determinations with respect to salary will take into account a number of factors, which may include, but not be limited to the primary work location and the chosen candidate’s relevant skills, experience, and education.

Expected salary range:

$117,600.00 - $200,100.00

For Washington State Jobs, a summary of benefits is listed here.

Learn more about your rights, including under California, Colorado and other US State Acts

Search Firm Representatives Please Read Carefully
Merck & Co., Inc., Rahway, NJ, USA, also known as Merck Sharp & Dohme LLC, Rahway, 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:



No relocation

VISA Sponsorship:


Travel Requirements:


Flexible Work Arrangements:

Hybrid, Remote Work


Valid Driving License:

Hazardous Material(s):

Number of Openings:


Requisition ID:R212214