Data Steward - I (Basic)

Title: Data Steward - I (Basic)

Location: Madison, NJ

Duration: 10 Months with high possibility of extension

Qualifications:

Education: Minimum Bachelor and Masters is Good to Have Required Skills - SQL (intermediate to advanced) ? Postgres/Redshift a plus - ETL tool experience ? Alteryx is our current platform - Strong Excel Skills required - especially in the areas of Excel, SQL, ETL and analytical tools like Power BI/Tableau (note: we use Power BI, but Tableau users can transition).

SQL skills need to be more than simple data queries, they need to know how to perform inner/outer/full joins, aggregate functions, windowing functions, etc.

Good PowerPoint skills are ideal.

Please note ? This is a Hybrid role and candidates need to be onsite 2-3 days /week (High possibility of Ext/FTE) Also Manager is not looking for data scientists or programmers here but data science/programming experience is still positive.

Interview Mode: Phone screening followed by Teams or an Onsite.

Responsibilities:

The Integrated customer experience team at Merck is seeking a Business Analysts to help our marketing organization provide data and analysis support. Insights and strategic perspectives from this individual will help brand managers leverage quantitative reporting to help make decisions about overall brand P&L and marketing programs.

Critical thinking, problem-solving and communication skills to influence without authority and drive decision in a fast pace business unit are critical skills in this role.

? As a data-driven member of the team, this role will serve as an analytics expert and key demand planner using meaningful insight from data to help leader make better business decisions.

? Beside day-to-day analytic leadership, this high-impact role will also provide demand planning duties including estimating future product demand, analyzing inventory flow, and developing forecast models. ? Be a subject-matter expert in the key business processes, systems, and data sources that facilitate enterprise-level thinking from P&L perspective.

? Ability to make effective decision-making by retrieving and aggregating data from various sources and compiling into a digestible meaningful format Gathers data from multiple sources, normalizes and analyses those data providing Companion Animal & Equine business with unique data insights to drive programs effectiveness and efficiency

? Be the main contact person for all brand analytic needs working directly with Marketing, Sales, Management, Commercial Operations and Supply Chain teams.

? Provides ongoing business/operational metrics, developing predictive forecasting models, calculating business financial analytics and designing data needs for future business analytics.

? Collaborate with cross-functional commercial teams to ensure alignment between business needs and solutions.

? Develop, track and analyze key performance indicators for marketing and selling programs.

? Provide Business leads with operational metrics across multiple programs to measure ROI and opportunity to improve for future executions

? Plan and coordinate multiple projects on a tight timeline to support executive stakeholders

? Understand and use statistical predictive models such as correlation, regression, ANOVA and time series models to identify trends, make forecasts and provide projected figures

? Work closely with data engineering, data science, scrum masters, and project managers to successfully partner with brand leads to unlock growth opportunities

? Collaborate with other business functions with data collection methods and centralization of data as well as extending current data sources with Third party data vendors

? Propose and implement business metrics with data scientists from commercial operations to develop analytic infrastructure to support business strategies and opportunities for improvement.