Technical Business Analyst (Data & Analytics)

Job Description

We are seeking an experienced Technical Business Analyst to join our Data & Analytics (DnA) organization. This role focuses on translating business needs into clear actionable and technically detailed requirements for data engineering governance and analytics teams. If you are passionate about data pipelines transformations metadata access governance and modern data engineering practices this is the perfect opportunity for you. Join our company and work closely with Product Managers Architects and Data Engineers to ensure our data products are scalable well-governed and fit for purpose across the enterprise.

Responsibilities

• Translate business needs into clear technically detailed requirements including data mappings transformation logic and acceptance criteria
• Define requirements for data ingestion and integration transformation logic and dbt models curated/semantic data zones and data contracts
• Interpret and document SQL transformations schema changes table structures and data quality business rules
• Work daily with Data Engineers on Databricks pipelines and notebooks dbt models DAGs and tests
• Review pipeline logic and validate outputs for correctness completeness and alignment to requirements
• Support debugging of Databricks job failures schema drift and lineage gaps dbt test failures and data quality issues
• Contribute to backlog grooming refinement and story scoping for data engineering squads
• Perform process mapping and documentation of current state and future state data flows
• Partner with Product Management Architecture Governance Value Teams and Engineering to ensure alignment and effective delivery
• Champion data quality metadata completeness and governance standards across data products

Qualifications

Required

• Bachelors degree in Business Information Systems Computer Science Analytics or a related field
• 3 years of experience as a Business Analyst Technical Business Analyst or Data Analyst in a data-centric environment
• Experience working in mid-to-large enterprise data platforms with cross-functional dependencies
• Proven ability to operate effectively in agile or iterative delivery models
• Expert level SQL for data analysis validation and transformation
• Familiarity with Databricks and dbt including models testing and documentation
• Understanding of data pipelines orchestration and data quality controls
• Excellent problem-solving and troubleshooting skills in complex data environments
• Ability to translate ambiguous business questions into precise technical requirements
• Strong written and verbal communication skills across technical and non-technical audiences
• Detail-oriented with a strong focus on data correctness and traceability
• Comfortable working in fast-paced matrixed environments

Preferred

• Familiarity with data domains in finance or procurement workplace services sustainability business development human resources
• Experience with BI or visualization tools such as Power BI or Tableau
• Exposure to Python or R for data analysis or automation
• Experience working with enterprise systems such as SAP Oracle or Anaplan
• Advanced degrees or certifications are a plus but not required

Join our company and be part of an exciting work environment where you can learn and grow professionally. We offer a hybrid working model with flexible role patterns competitive salary incentive pay and comprehensive benefits. Our supportive team culture is focused on modern data practices and collaboration.

Ready to take up the challenge Apply now! Know anybody who might be interested Refer this job!

Required Skills:

Preferred Skills:

Current Employees apply HERE

Current Contingent Workers apply HERE

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

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.