Senior Specialist, Data Management & Reporting

| New York, NY, USA +80 more | Remote | Hybrid
Employer Provided Salary: $107,600-$169,400 Annually
Salary data is provided by the employer. Please note this is not a guarantee of compensation.
Sorry, this job was removed at 2:38 a.m. (CST) on Tuesday, March 5, 2024
Find out who's hiring in New York City, NY.
See all Data + Analytics jobs in New York City, NY
Apply
By clicking Apply Now you agree to share your profile information with the hiring company.

Job Description
This role will work cross-functionally with a variety of areas to maximize the value the Operations Data Layer provides to the organization primarily in Data Management and Database Reporting. This includes helping to facilitate and understand requirements, defining solution functionality, designing solutions as well as developing and enhancing solutions over time. The Team member role will be hands-on and have demonstrated experience in maintaining the EDI Sales and other Reference/Master data in support of multiple species for all Sales Reporting and Business Intelligence needs.
Data Management:

  • Maintain Standard pricing across all species at multiple Units of Measure
  • Be the Customer Master Data Steward for mapping customers internally and assist in deduplication of customer data
  • Troubleshoot and develop a long-term fix for ongoing EDI pricing exception and AHN-SAP mapping issues
  • Investigate and create a Data Modification Request to update incorrect EDI Sales data in Datamart
  • Troubleshoot and recommend any fixes for downstream applications
  • Support and enhance existing PL/SQL Stored Procedures and Functions for automating the loading and validation of all Master data entities in the centralized Master Data Repository
  • Develop and execute automated scripts to provide data and context to incoming field requests from Salesforce system
  • Be responsible for Master data updates and enhancements especially with data shared with external partners


Database Development and Reporting:

  • Build Database views for master data and sales reporting via internal applications and data visualization tools
  • Support Spotfire/Power BI dashboards in self-service mode primarily fixing data issues and enhancing backend database views in collaboration with IT
  • Create and automate SQL scripts for providing reports/ data to internal (Sales, Marketing, Finance) and Pricing Portal for Distribution
  • Create UNIX scripts for automating delivery of operational reports


Education:
Bachelor's degree Required in Computer Science or Engineering
Required Skills and Experience:

  • At least 7 years of relevant work experience
  • Experience working in tools and applications such as SQL Loader, Toad, Workbench for AWS Redshift, SQL Developer for Oracle
  • Proficiency in using Programming Languages such as SQL, PL/SQL, Oracle DDL, Unix Shell Scripts
  • Knowledge of Oracle Databases
  • Exposure to Data Stewardship tools like Informatica
  • Strong troubleshooting, analytical and problem-solving skills balanced with a creative mindset
  • Ability to facilitate continuous improvement efforts collaboratively with team and peers
  • Self-starter and be able to handle multiple tasks and priorities
  • Work collaboratively across teams to design and build solutions with the IT department
  • Provide support to other team members to trouble shoot and resolve data related issues
  • Provide end user support for handling data accuracy and quality related questions and for escalating technical issues to appropriate IT support individuals


NOTICEFORINTERNALAPPLICANTS
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 separationpackage, then you are no longer eligible for your separation benefits package. To discuss in more detail, please contact your HRBP or Talent Acquisition Advisor.
Employees working in roles that the Company determines require routine collaboration with external stakeholders, such as customer-facing commercial, or research-based roles, will be expected to comply not only with Company policy but also with policies established by such external stakeholders (for example, a requirement to be vaccinated against COVID-19 in order to access a facility or meet with stakeholders). Please understand that, as permitted by applicable law, if you have not been vaccinated against COVID-19 and an essential function of your job is to call on external stakeholders who require vaccination to enter their premises or engage in face-to-face meetings, then your employment may pose an undue burden to business operations, in which case you may not be offered employment, or your employment could be terminated. Please also note that, where permitted by applicable law, the Company reserves the right to require COVID-19 vaccinations for positions, such as in Global Employee Health, where the Company determines in its discretion that the nature of the role presents an increased risk of disease transmission.
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, generally Tuesday, Wednesday and either Monday or 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".
Under New York State, Colorado State, 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:
$107,600.00 - $169,400.00
Available benefits include bonus eligibility, health care and other insurance benefits (for employee and family), retirement benefits, paid holidays, vacation, and sick days. For Washington State Jobs, a summary of benefits is listed 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:
Regular
Relocation:
Domestic
VISA Sponsorship:
No
Travel Requirements:
10%
Flexible Work Arrangements:
Shift:
1st - Day
Valid Driving License:
No
Hazardous Material(s):
N/A
Requisition ID:R258756

Read Full Job Description
Apply Now
By clicking Apply Now you agree to share your profile information with the hiring company.
Candidate Location Eligibility:
Albuquerque, NM
Ann Arbor, MI
Atlanta, GA
Austin, TX
Baltimore, MD
Baton Rouge, LA
Birmingham, AL
Boise, ID
Boston, MA
Buffalo, NY
Charleston, SC
Charlotte, NC
Chicago, IL
Cincinnati, OH
Cleveland, OH
Colorado, CO
Columbus, OH
Dallas-Fort Worth, TX
Dayton, OH
Des Moines, IA
Detroit, MI
Fayetteville-Springdale-Rogers, AR
Greensboro, NC
Hampton Roads, VA
Hartford, CT
Houston, TX
Huntsville, AL
Indianapolis, IN
Jacksonville, FL
Kansas City, MO
Las Vegas, NV
Lexington, KY
Lincoln, NE
Little Rock, AR
Los Angeles, CA
Louisville, KY
Madison, WI
Memphis, TN
Miami, FL
Milwaukee, WI
Minneapolis–Saint Paul, MN
Nashville, TN
New Orleans, LA
New York City, NY
Ogden, UT
Oklahoma City, OK
Omaha, NE
Orlando, FL
Other US Location
Palm Bay-Melbourne-Titusville
Pensacola, FL
Peoria, IL
Philadelphia, PA
Phoenix – Mesa – Scottsdale, AZ
Pittsburgh, PA
Portland, ME
Portland, OR
Providence, RI
Provo, UT
Raleigh-Durham, NC
Reno, NV
Richmond, VA
Rochester, NY
Sacramento, CA
Salt Lake City, UT
San Antonio, TX
San Diego, CA
San Francisco, CA
San Luis Obispo, CA
Santa Cruz, CA
Seattle, WA
Spokane, WA
St. Louis, MO
Tallahassee, FL
Tampa Bay, FL
Tucson, AZ
Tulsa, OK
Washington DC
Wichita, KS
Wilmington, NC

Technology we use

  • Engineering
    • C#Languages
    • C++Languages
    • GolangLanguages
    • JavaLanguages
    • JavascriptLanguages
    • KotlinLanguages
    • PerlLanguages
    • PHPLanguages
    • PythonLanguages
    • RLanguages
    • RubyLanguages
    • ScalaLanguages
    • SqlLanguages
    • SwiftLanguages
    • TypeScriptLanguages
    • D3JSLibraries
    • FluxLibraries
    • jQueryLibraries
    • jQuery UILibraries
    • ModemizrLibraries
    • ParseLibraries
    • ReactLibraries
    • ReduxLibraries
    • Twitter BootstrapLibraries
    • ZeptoLibraries
    • ASP.NETFrameworks
    • Backbone.jsFrameworks
    • CaffeFrameworks
    • CakePHPFrameworks
    • CircleCIFrameworks
    • CodeIgniterFrameworks
    • DjangoFrameworks
    • Ember.jsFrameworks
    • ExpressFrameworks
    • FlaskFrameworks
    • FlexFrameworks
    • HadoopFrameworks
    • JestFrameworks
    • JSFFrameworks
    • JupyterFrameworks
    • LaravelFrameworks
    • MeteorFrameworks
    • Node.jsFrameworks
    • PlayFrameworks
    • PlaywrightFrameworks
    • Ruby on RailsFrameworks
    • Sails.jsFrameworks
    • SparkFrameworks
    • SpringFrameworks
    • SymfonyFrameworks
    • TensorFlowFrameworks
    • TheanoFrameworks
    • TorchFrameworks
    • Vue.jsFrameworks
    • ZendFrameworks
    • AccessDatabases
    • CassandraDatabases
    • DB2Databases
    • FileMakerDatabases
    • HBaseDatabases
    • HiveDatabases
    • InformixDatabases
    • MariaDBDatabases
    • MemcachedDatabases
    • Microsoft SQL ServerDatabases
    • MongoDBDatabases
    • MySQLDatabases
    • Neo4jDatabases
    • OracleDatabases
    • PostgreSQLDatabases
    • RedisDatabases
    • SAP HANADatabases
    • SnowflakeDatabases
    • SQLiteDatabases
    • TeradataDatabases

What are Merck Perks + Benefits

Merck Benefits Overview

Our commitment to you
We promise a Merck experience based on
a foundation of…
Culture
We are committed to fostering an environment where all colleagues
feel welcomed, respected and valued.
Responsibility
We are committed to tackling the world’s biggest health challenges by
discovering better ways to make a difference in everything we do.
Career development
We are committed to encouraging professional career development that
aligns to our business strategy.
Rewards
We are committed to offering plans, programs and resources that provide
you and your family what you need, when you need it

Culture
Volunteer in local community
Partners with nonprofits
Open door policy
OKR operational model
Team based strategic planning
Open office floor plan
Employee resource groups
Flexible work schedule
Remote work program
Diversity
Documented equal pay policy
Dedicated diversity and inclusion staff
Mandated unconscious bias training
Diversity employee resource groups
Hiring practices that promote diversity
Health Insurance & Wellness Benefits
Flexible Spending Account (FSA)
Disability insurance
Dental insurance
Vision insurance
Health insurance
Life insurance
Pet insurance
Wellness programs
Team workouts
Mental health benefits
Transgender health care benefits
Financial & Retirement
401(K)
401(K) matching
Company equity
Performance bonus
Charitable contribution matching
Pension
Child Care & Parental Leave Benefits
Childcare benefits
Generous parental leave
Family medical leave
Adoption Assistance
Return-to-work program post parental leave
Company sponsored family events
Fertility benefits
Vacation & Time Off Benefits
Generous PTO
Paid volunteer time
Sabbatical
Paid holidays
Paid sick days
Flexible time off
Bereavement leave benefits
Company-wide vacation
Office Perks
Commuter benefits
Company-sponsored outings
Onsite office parking
Recreational clubs
Relocation assistance
Fitness stipend
Home-office stipend for remote employees
Onsite gym
Professional Development Benefits
Job training & conferences
Tuition reimbursement
Lunch and learns
Promote from within
Mentorship program
Continuing education stipend
Continuing education available during work hours
Online course subscriptions available
Customized development tracks
Virtual coaching services

More Jobs at Merck

Apply Now
By clicking Apply Now you agree to share your profile information with the hiring company.
Learn more about MerckFind similar jobs like this