W2 - Data / Product Analyst

Job Title: Data / Product Analyst Location: McLean, VA (Hybrid) Interview Mode: Video Interview Employment Type: Cliff Services W2 Visa: No Visa Restrictions Job Description We are seeking a highly analytical and detail-oriented Data / Product Analyst with strong SQL expertise and hands-on experience in Master Data Management (MDM), ETL processes, and Data Governance practices. The ideal candidate will collaborate with product managers, business stakeholders, engineering teams, and data architects to transform complex datasets into actionable business insights and support strategic product initiatives. Key Responsibilities Data Analysis & Insights: Analyze large and complex datasets to identify trends, anomalies, and business opportunities Develop KPIs, dashboards, scorecards, and analytical reports Perform ad hoc analysis and root-cause investigations Translate business requirements into analytical solutions Support mortgage business process analysis and product lifecycle insights SQL & Database Management Write complex and optimized SQL queries for extraction, transformation, and analysis Work across SQL Server, Sybase, MySQL, and Snowflake environments Create and maintain views, stored procedures, functions, and validation scripts Perform query optimization and performance tuning Product Analytics Partner with Product Managers to define product metrics and success criteria Analyze customer behavior, feature adoption, and usage trends Support A/B testing and experimentation frameworks Build data models to measure product performance and business impact Master Data Management (MDM) Support MDM implementation and governance initiatives Define data standards, hierarchies, golden records, and reference data Participate in data cleansing, deduplication, and harmonization efforts ETL & Data Integration Support ETL/ELT workflows and data pipelines Validate source-to-target data movement and reconciliation processes Monitor ETL performance and resolve data quality issues Data Governance & Quality Support enterprise data governance and compliance initiatives Implement and monitor data quality checks and controls Document metadata, lineage, business rules, and governance processes Stakeholder Collaboration Work closely with business, product, engineering, QA, and architecture teams Gather and document requirements from technical and non-technical stakeholders Present analytical findings and recommendations clearly and effectively Required Qualifications 5+ years of experience in Data Analysis, Product Analytics, or related roles Advanced SQL expertise with complex query writing and optimization skills Experience with SQL Server, Sybase, MySQL, and Snowflake Strong understanding of MDM concepts and data governance frameworks Experience with ETL/ELT processes and tools like Informatica or Talend Knowledge of data quality, lineage, metadata, and compliance standards Experience creating dashboards, KPIs, and analytical reports Strong communication, analytical, and problem-solving skills Familiarity with ODS/EDW data modeling concepts is a plus Preferred Skills Mortgage or Financial domain experience preferred Snowflake Informatica / Talend Data Governance MDM Product Analytics A/B Testing ETL/ELT SQL Performance Tuning Dashboarding & Reporting If interested, please share your updated resume along with contact details and work authorization.