Data Analyst

About the Role

The Data Analyst on the Database Infrastructure Development Team plays a crucial role in examining, validating, and interpreting metadata from enterprise databases. This supports the ongoing operation, governance, and enhancement of the broad metadata repository across the organization. Collaboration is key as this position works closely with developers, architects, database administrators, and governance teams to ensure metadata is precise, comprehensive, actionable, and complies with organizational standards.

Key Responsibilities

• Analyze metadata sourced from diverse database environments including Oracle, PostgreSQL, DB2, SQL Server, and cloud-based database services.
• Assess data quality by identifying irregularities and providing critical feedback to engineering and DBA teams.
• Validate ingestion results, schema mappings, lineage information, and configuration baselines.
• Formulate business rules alongside data quality checks and validation mechanisms to maintain metadata uniformity.
• Create dashboards, reports, and visual tools to aid in monitoring operations, compliance, governance, and promote platform adoption.
• Generate analytical insights related to platform coverage, data ingestion health, real-time data freshness, and lineage thoroughness.
• Collaborate with developers to optimize data models, data ingestion methods, and validation pipelines.
• Partner with governance groups to facilitate stewardship, data lineage, auditing, and regulatory compliance.
• Contribute towards the establishment of metadata standards, naming conventions, relevant quality metrics, and validation criteria.
• Continuously monitor pipeline outputs, compare actual data against expectations, and investigate causes of discrepancies.
• Offer recommendations to enhance metadata accuracy, reliability of data ingestion, and precision of reporting.
• Engage in Agile ceremonies and support backlog refinement oriented by insights drawn from data analyses.

Qualifications

• A bachelor’s degree in Data Analytics, Information Systems, Computer Science, or a related discipline, or equivalent practical experience.
• Between 2 to 5 years of experience in data analysis, business intelligence, or a similar analytical position.
• Advanced proficiency in SQL and working knowledge of relational database technologies.
• Strong capability to interpret complex database architectures including data definition language, schema relationships, and metadata.
• Experience with BI and reporting platforms such as Power BI, Tableau, or equivalents.
• Excellent analytical thinking and problem-solving aptitude, with strong attention to detail.
• Hands-on experience programming in Python (Pandas, data validation scripting) or comparable tools used for data processing and preparation.
• Expertise in Microsoft Excel, data profiling techniques, and implementing data quality frameworks.
• Effective communication skills to translate complex technical data into clear, actionable insights for stakeholders.