Senior Data Analyst

We are seeking a highly skilled Senior Data Analyst with over 10 years of experience to join our financial-services analytics program. This role focuses on data discovery, profiling, and gap analysis across diverse enterprise data sources. The ideal candidate will be instrumental in determining data availability, sourcing additional data, and identifying missing data points necessary for developing reliable business and management metrics. WHAT YOU’LL DO: Perform data discovery and profiling across various platforms including Jira, Rally, GitHub, Clarity, Remedy, and other enterprise sources. Document available datasets, ownership, grain, keys, history, refresh cadence, access constraints, and metric suitability. Build and maintain a Data Availability Inventory and field-level gap assessment to classify metric inputs as available, partially available, derivable, or missing. Utilize SQL, BigQuery, and Python to assess data completeness, uniqueness, validity, consistency, timeliness, distributions, outliers, and referential integrity. Analyze cross-system relationships and define business keys, joins, mappings, code translations, hierarchies, precedence, and reconciliation rules. Decompose various metrics into required fields, grain, dimensions, period logic, formulas, exclusions, targets, and organizational rollups. Create source-to-metric traceability from source fields through BigQuery transformations to semantic measures and reports. Collaborate with business stakeholders, metric owners, Data Architects, Data Engineers, and BI teams to define extraction scope and quality controls. Maintain Confluence documentation, data issue logs, UAT evidence, and concise status reports covering assessments, gaps, blockers, and dependencies

Experience Required: 10+ Years Data Analytics, SQL Skills, Data Discovery, Availability & Gap Analysis: Proven ability to discover and assess structured and semi-structured data across enterprise systems. SQL, BigQuery & Python: Strong SQL skills for profiling and complex joins; working knowledge of BigQuery and practical Python skills. Metrics, Modeling & Traceability: Ability to decompose KPIs into source fields and document source-to-metric lineage. Source Systems & Data Formats: Experience analyzing platforms like Jira, Rally, GitHub, and working with various data formats. Data Quality, Documentation & Delivery: Experience defining data quality checks and producing comprehensive documentation. Stakeholder Collaboration & Financial Services: Ability to work with various stakeholders in regulated financial services environments. PREFERRED SKILLS: Google Cloud certification or equivalent analytics certification. Experience with Power BI, Tableau, and ETL processes. Exposure to GCP services such as Cloud Storage, Dataflow, and Cloud Run. Understanding of Agile/Scrum methodologies and data-quality frameworks. Expertise You’ll Bring: The successful candidate will bring a wealth of experience in data analytics, a strong understanding of financial services, and the ability to collaborate effectively with cross-functional teams.