Data Quality / Profiling Analyst

  • 1460 Broadway, New York, NY 10036, USA
  • Employees can work remotely
  • Full-time

Company Description

With a focus on management, monetization, and governance, DataCatalyst converts information into actionable growth plans. From data sourcing and enrichment to analytics and stewardship, our team crafts customized solutions you need to thrive in today’s data-driven environment.  

We specialize in Data Strategy and MDM/PIM implementations using proprietary software accelerators that reduce risk and maximize business outcomes. We focus on financial services, healthcare, manufacturing/distribution, and retail spaces. Setting us apart is deep knowledge in both the tech and business sectors -- with an average of 15 years of experience, our associates offer expert, pragmatic strategies to fuel success. Learn more at datacatalyst.com.

Job Description

We are seeking a talented and experienced Data Quality & Profiling Analyst to become an integral part of our team! DataCatalyst is a mid-sized global consulting firm that specializes in Data Management, Monetization, and Governance. We are looking for full-time consultants who are business and technology savvy and interested in joining an exceptional team of innovators who successfully deliver value for our clients.

Roles & Responsibilities:

  • Analyze and decipher data using statistical techniques

  • Perform data analytics, evaluate the quality of the data, identify and interpret trends or patterns in data sets. Act as an agent of change to help drive data best practices and the concept of data as an asset

  • Participate in data analysis, as well as in the design of data and mapping requirements 

  • Work with SMEs and business representatives to understand current data and define the appropriate mapping; resolving discrepancies during data definition as well as providing testing support.

  • Work with cross functional teams to provide missing data and cleanse data

  • Contribute to the development of the migration rules, documenting these rules, developing user test cases for migration test runs, testing the rules during the migration runs.

  • Collect and formulate business requirements via interviews and user discussions

  • Document functional requirements, business processes, use-cases and other project artifacts

  • Write, execute and debug SQL queries to confirm data completeness, correctness, data transformation and data quality testing     

  • Leverage industry profiling tools (SAP Information Steward) 

  • Create data scorecards within Information Steward for inbound data feeds

  • Create, define and document maps for inbound data feeds to internal targets using industry toolsets

Qualifications

Requirements/Qualifications:

  • Bachelor's degree in mathematics, computer science, information management, or statistics

  • 2-3 years of data management experience

  • Good knowledge of data profiling tools and analytical methods

  • Experience with SQL or equivalent database querying language

  • Good interpersonal and communication skills

  • Critical thinker who can optimally identify, fix and solve problems

  • Proficiency with Business Intelligence platforms and visualization tools (i.e. Tableau, OBIEE, Looker, Business Objects, QlikView) a plus

  • Excellent data analysis skills, including the ability to work with and profile large data sets

  • Experience working within waterfall and agile project management frameworks

  • Understanding of master data management and data governance practices

  • Excellent attention to detail

  • Able to work independently and productively under pressure

  • Ability to work remotely but located on the East Coast

Additional Information

What We Offer:

We are looking for leaders that will effectively drive the future success of our firm and our clients. We have been growing at double-digit rates and expect the career and growth opportunities for our consultants to be equally exciting.

We offer a competitive compensation package where you’ll be rewarded based on your performance and recognized for the value you bring to our business. In addition, our package includes medical and dental coverage, 401(k) plans, and vacation plus 9 observed holidays. Plus, we offer:

  • Support and coaching from some of the most engaging colleagues in the industry

  • Opportunities to develop new skills and progress your career within a fast-moving entrepreneurial environment

  • The freedom and flexibility to handle your role in a way that’s right for you

  • All your information will be kept confidential according to EEO guidelines.