Data Management Analyst

The Rundown AI, Inc.; New York (NY); On-site; USD 124,000 - 176,000; Full time

Job summary

A leading company is seeking a Data Management Analyst to enhance their data architecture and governance. This role will focus on optimizing data processes, ensuring data quality, and supporting AI applications. The ideal candidate will have extensive experience in SQL, data modeling, and governance, and will collaborate across teams to drive data-driven insights.

Qualifications

• 5+ years of experience with Advanced SQL and relational databases.
• 5+ years in Data Architecture and data modeling, including Kimball techniques.
• 3+ years with Visualization tools like Tableau or Power BI.

Responsibilities

• Develop and implement data architecture and models for data strategy.
• Design metrics aggregation and computation layer for analytics.
• Act as a bridge between Business and Engineering teams.

Skills

Advanced SQL

Data Architecture

Data Governance

Data Stewardship

Business Intelligence

Python

Tools

Tableau

Looker

Power BI

Job description

This role will be instrumental in building a robust semantic layer, comprising business-curated data layers that facilitate seamless access to People data. The successful candidate will govern the ecosystem of People data, ensuring data quality, integrity, and security, while driving faster speed to insights and analytics by optimizing data architecture and processes. A critical component of this role is preparing data for AI applications, enabling conversational analytics and AI-driven decision-making, ultimately shaping the future of conversational analytics and AI on Analytics.

Data Management Analyst Responsibilities:

1. Data Architecture Design: Develop and implement data architecture that complements data engineering design and policies, optimizing querying processes to reduce time to insight. This includes designing data models, data warehousing solutions, and data integration frameworks that support the organization's data strategy.
2. Metrics Aggregation and Computation Layer: Design and develop a holistic metrics aggregation and computation layer across people analytics, enabling the optimization of standard report production, enhancement of dashboard performance, and driving self-service analytics. This involves creating a unified framework for metric calculation, data aggregation, and data visualization.
3. Subject Matter Expertise: Leverage subject matter expertise and business data process knowledge to design optimal data architecture that meets the needs of stakeholders. This requires an understanding of business operations, data flows, and data requirements.
4. Business Partnership: Act as a bridge between the Business, People Analytics, and Engineering teams, facilitating collaboration, communication, and data-driven insights for efficient decision-making.
5. Ontology and AI-Consumable Data Architecture: Build ontology and AI-consumable data architecture and metadata, supporting the development of AI and machine learning solutions. This involves creating data structures, taxonomies, and metadata frameworks that support AI applications.
6. Data Governance Framework: Develop comprehensive data governance policies, procedures, standards, and guidelines that ensure data quality, security, and compliance, providing a 360-degree view of metrics and supporting data literacy and catalog development.
7. Data Governance Implementation: Drive certification of metric definitions, implement data quality rules (reactive and proactive), validate data lineage, and modernize data governance across People Analytics, including risk management practices.

Minimum Qualifications:

1. 5+ years of experience with Advanced SQL, PL/SQL, relational databases, and data modeling.
2. 5+ years of experience in Data Architecture and data modeling, with working knowledge of Kimball STAR Schema and Vault modeling techniques.
3. 3+ years of experience with Visualization and Business Intelligence tools such as Tableau, Looker, or Power BI.
4. 5+ years of QA, testing, and data analysis skills, including experience with scenario analysis and advanced analytics.
5. 5+ years of experience in Data Governance implementation.
6. 4+ years of Data Stewardship experience, including data quality rules and metadata management.

Preferred Qualifications:

1. 8+ years of experience in SQL and developing last-mile data architecture.
2. 3+ years of Python coding experience, particularly in building data pipelines.
3. 7+ years of experience in Data Governance and Data Management workstreams.
4. Knowledge of semantic layer creation for BI tools.

About Meta:

Meta builds technologies that help people connect, find communities, and grow businesses. From Facebook's launch in 2004 to apps like Messenger, Instagram, and WhatsApp, Meta continues to innovate towards immersive experiences in augmented and virtual reality, shaping the future of social technology. We are an Equal Employment Opportunity and Affirmative Action employer, committed to diversity and inclusion, and we consider qualified applicants with criminal histories. We participate in E-Verify where required and may use AI and machine learning in our recruitment process.

Meta is dedicated to providing reasonable accommodations for candidates with disabilities. For assistance, contact [e-mail].

Salary range: $124,000 to $176,000 per year plus benefits. Compensation varies based on skills, experience, and location. Benefits information is available on Meta's website.