Online since 1999 | 11,056 IT Jobs Live NOW

$115K - Data Analyst - TSQL, PLSQL

Premium Job From Nigel Frank International
Recruiter: Nigel Frank International
Listed on: 21st July
Location: USA
Salary Notes: Negotiable
Type: Permanent

Client is establishing a brand-new Master Data Management (MDM) practice in the Customer Master domain. The Data Analyst will support the MDM Architect on the new team by analyzing data and ensuring data quality. Data analysis will be done to ingest master data related to frequent merger and acquisition (M&A) activity as well for data enrichment and data cleanup purposes. The individual is expected to be a technical resource who is well versed in utilizing a variety of tools and techniques for analyzing data. This person will work with a team of both technical and business resources to enforce good MDM practices. The individual may also be asked to assist with the Collibra Metadata Management system. * Profile new data for quality assurance purposes * Perform preliminary analysis and cleanup of M&A master data before handing over to the business for further review and cleanup. * Assist with determining the appropriate hierarchy when bringing in Account Master Data from an acquired company. * Analyze data in existing systems to identify quality and completeness issues and to aid with cleanup. * Identify duplicate Account and Contact data across systems and within systems. * Transform data into required format for ingestion into various systems * Perform ETL operations on new (M&A) or existing data sources Develops, designs, and optimizes complex SQL/T-SQL queries in data analysis and transformation * Perform analysis on data from 3rd party providers that will ultimately be used for data enrichment * Understand business definitions, rules, and processes around master data to establish data analysis processes that ensure meaningful data. * Provide support to the MDM Architect on other data related activities as needed. * Contribute to the data catalog * Share administration/configuration duties on the Collibra Metadata Management system. * Collaborate with the MDM Lead and Global Data Steward on the business side to provide data support * Communicate status updates and open issues to both technical and business resources in a manner that can be clearly understood. Qualifications: * 5+ years as a Data Analyst * 5+ years' experience with T-SQL or PL-SQL * 2+ years of experience with data profiling/quality tools * 1+ years moving/transforming data using an ETL tool * Experience in analyzing and ingesting data from CSV and other delimited file formats * Experience working with large datasets * Experience working directly with key business stakeholders * Experience in collaboration and communication with both technical and business resources * Experience learning and documenting business definitions, rules, and processes * Ability to take initiative and work under limited supervision

Preferred: * Experience with XML and JSON is a plus. * Experience working with data modeling is preferred. * Exposure to Data Governance key concepts like Metadata Management, Business Glossary, Cataloging, Lineage etc. is preferred. * Experience with a Metadata Management platform (especially Collibra) is preferred. * Experience in executing projects in an Agile environment is preferred.

Contact Name: Haleigh Williams
Reference: TJ/3086/JOB_1658409144
Job ID: 3120193



Browse all skill types