Senior Data Analyst - MDM/SQL/Python

Job Title: Senior Data Analyst

New York, NY 10007

Duration: 12 Months, extension possible based on needs and performance

Due Date: 4th July

Remote: Monday- Friday; 9-6

Job Description / Justification:

• Looking Senior Data Analyst to support integration of administrative data across multiple agencies at the city and state level within a master data management (MDM) platform.
• This role will lead data governance strategies that define data standards, identify data merge and de-duplication rules, resolve data conflicts and maintain data documentation across participating agencies.
• The ideal candidate should have experience gathering data requirements for MDM solutions, developing data governance frameworks and managing complex public sector data projects.

Scope Of Services:

• Client works with City agencies and their data to help serve New Yorkers more equitably and effectively. This work takes three main forms: analyzing data to improve Cityagency operations; making Open Data more accessible to all New Yorkers; and advancing citywide data infrastructure, integration, and sharing.
• Seeks a Senior Data Analyst role to manage data governance and strategy for its master data management (MDM) platform. ODA s MDM platform supports entity resolution and data record linkage of businesses and organizations from multiple City IT systems.

Tasks:

• Profile and analyze undocumented data sources to identify overlaps, gaps, and integration opportunities.
• Develop golden record strategies to merge duplicate entities into a single verifiable record.
• Work with stakeholders to develop data standards that will conform disparate data fields to a uniform set of values for public use.
• Define and maintain data governance plans to ensure continuous data quality and consistency.
• Serve as the ODA project lead in cross-division project planning and scheduling.
• Facilitate stakeholder meetings to gather, document, and refine business and data requirements.
• Develop and manage data dictionaries and metadata to support transparency and interoperability.
• Collaborate with technical teams to translate business needs into actionable technical requirements and data specifications.
• Monitor data quality metrics and contribute to issue resolution workflows to improve the reliability of shared data assets.
• Develop data analyses, reports and dashboards that help communicate data metrics to a diverse audience.
• Perform special projects and initiatives as assigned.

Mandatory Skills/Experience

Tasks:

• 8+ years of experience of data query and analysis using SQL, Python or R.
• Direct experience working with government agencies to profile undocumented data sources.
• Direct experience managing data or requirements for master data management (MDM) solutions involving the entity resolution of people, organizations or locations.
• Understanding of key MDM concepts and use cases within the public sector.
• Strong knowledge of data governance principles and best practices, including data quality, stewardship, and metadata management.
• Business analysis expertise, including requirements gathering, process mapping, and stakeholder engagement.
• Knowledge and experience managing large public sector data integration projects.
• Familiarity with federal, state and local data privacy laws.
• Excellent communication and facilitation skills, with the ability to bridge business and technical perspectives.

Desirable skills/experience:

• Experience working in or with public sector organizations, especially in a data management capacity.
• Experience working with data or systems within with New York City agencies.
• Knowledge of enterprise data architecture concepts and integration patterns (e.g., APIs, ETL pipelines).
• Hands-on experience with data governance tools such as Collibra, Alation, or Informatica.
• Understanding of Agile project management methodologies and tools (e.g., Jira, Confluence).
• Exposure to data ethics frameworks and responsible data use practices.
• CDMP or IIBA certification