Job Description

Data Architect Job Description

Our company is searching for a highly skilled and experienced Data Architect to join our talented team. Your central responsibility as the Data Architect will be to design, implement, and manage scalable data architecture solutions that support business objectives.

Ideal candidate will ensure the organization's data systems are efficient, secure, and assigned with modern data governance and analytics requirements; also have proven experience in data analysis & management and excellent problem-solving abilities.

Key Responsibilities

• Data Architecture Design

  • Design and maintain robust scalable, and efficient data models and architecture.

  • Develop and document data flows and integration strategies.

• Data Modelling

  • Develop, implement and maintain conceptual, logical and physical data models

  • Optimize database designs for performance, scalability and flexibility.

  • Validate data Architecture to ensure they meet all functional and non-functional requirements.

• Integration and Interoperability

  • Design ETL/ETL process to enable seamless integration of diverse data sources.

  • Collaborate with developers to integrate data architecture with applications and systems.

• Collaboration

  • Work with cross-functional team to understand the business needs and translate hem into technical requirements.

  • Partner with data engineers, analysts, and business stake holders to optimize data solutions.

  • Educate staff members through training and individual support.

  • Publish and present technical papers to external audiences and participate in significant internal publications, sharing new ideas and knowledge.

  • Publish and present technical papers to external audiences and participate in significant internal publications, sharing new ideas and knowledge.

• Technology evaluation

  • Evaluate and recommend technologies, tools, and platform to enhance the organization data capabilities.

  • Stay updated on Industry Trends and emerging technologies.

• Data Management & Governance

  • Establish and enforce data architecture best practice and standards.

  • Ensure data Architecture, data Models, Data Integration comply with Data governance & standards.

• Performance Optimization

  • Monitor and optimize performance of data storage layer, scalability.

  • Implement strategies for improving data accessibility and query efficiency.

Qualifications:

• Education:Bachelor's degree in computer science or equivalent experience.

• Experience:

  • 5+ years of experience in data architecture, data modelling or related roles

  • Proven experience as a Data Architect or in similar role

• Skills

  • Proficiency in data modelling, metadata management and database design

  • Strong understanding of database systems (SQL, NoSQL, Open format - Delta tables, Hudi, Iceberg)

  • Experience with cloud platforms - AWS, Azure.

  • Hands-on experience with modern Data Lake technologies (Databricks, Redshift)

  • Hands-on experience with ETL/ELT Tools (Matillion, dbt, Informatica IDMC and Databricks - pyspark, SQL)

  • Strong Analytics and problem-solving skills

  • Experience with data warehousing concepts and technologies.

  • Knowledge on data governance, data quality and data lineage

  • Excellent analytics and problem-solving skills.

  • Effective communication, collaboration, and documentation skills

  • Growth mindset - thrive on experimenting with emerging AI technologies, continuous learning, innovation and derive best practices.

  • Relevant certifications such as AWS , TOGAF, Certified data management/Architect professional are a plus and will be considered a strong advantage.

  • Knowledge in Machine Learning - Lifecycle management, feature engineering , data processing, pipelines, and Operations.

  • Knowledge in using next Gen - AI techniques in Data Architecture and Data modelling.

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.

We are an Equal Opportunity Employer, committed to fostering an inclusive and diverse workplace. All qualified applicants will receive consideration for employment without regard to race, color, age, religion, sex, sexual orientation, gender identity, national origin, protected veteran status, or disability status, or other applicable legally protected characteristics. For more information about personal rights under the U.S. Equal Opportunity Employment laws, 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.

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

U.S. Hybrid Work Model

Effective September 5, 2023, employees in office-based positions in the U.S. will be working a Hybrid work consisting of three total days on-site per week, Monday - Thursday, although the specific days may vary by site or organization, with Friday designated as a remote-working day, unless business critical tasks require an on-site presence.This Hybrid work model does not apply to, and daily in-person attendance is required for, field-based positions; facility-based, manufacturing-based, or research-based positions where the work to be performed is located at a Company site; positions covered by a collective-bargaining agreement (unless the agreement provides for hybrid work); or any other position for which the Company has determined the job requirements cannot be reasonably met working remotely. Please note, this Hybrid work model guidance also does not apply to roles that have been designated as "remote".

The Company is required to provide a reasonable estimate of the salary range for this job in certain states and cities within the United States. 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 US salary range:

Available benefits include bonus eligibility, long term incentive if applicable, health care and other insurance benefits (for employee and family), retirement benefits, paid holidays, vacation, and sick days. A summary of benefits is listed here.

San Francisco Residents Only:We will consider qualified applicants with arrest and conviction records for employment in compliance with the San Francisco Fair Chance Ordinance

Los Angeles Residents Only:We will consider for employment all qualified applicants, including those with criminal histories, in a manner consistent with the requirements of applicable state and local laws, including the City of Los Angeles' Fair Chance Initiative for Hiring Ordinance

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:

Relocation:

VISA Sponsorship:

Travel Requirements:

Flexible Work Arrangements:

Shift:

Valid Driving License:

Hazardous Material(s):

Required Skills:

Preferred Skills:

Job Posting End Date:

*A job posting is effective until 11:59:59PM on the day BEFOREthe listed job posting end date. Please ensure you apply to a job posting no later than the day BEFORE the job posting end date.

Requisition ID:R339014