Data & Product Analyst

Data & Product Analyst

PLEASE NOTE: It is a 100% Onsite position in McLean, VA KEY REQUIRED SKILLS: SQL and relational databases such as SQL Server, Sybase, MySQL, or Snowflake, Master Data Management (MDM), ETL/ELT workflows. SQL, MDM, and Product Analytics is a must. Need additional candidates in the pipeline. JOB DESCRIPTION: As a Data & Product Analyst, you will play a critical role in transforming enterprise data into meaningful insights that drive product strategy, business performance, and operational excellence. You will collaborate with product managers, business stakeholders, data engineers, architects, and QA teams to analyze complex datasets, improve data quality, support Master Data Management (MDM) and data governance initiatives, and deliver actionable analytics within the mortgage domain. The ideal candidate is highly analytical, proficient in SQL, and experienced in enterprise data management and product analytics. KEY RESPONSIBILITIES: Analyze large and complex datasets to identify trends, patterns, anomalies, and business opportunities across product and mortgage domains. Design, develop, and maintain dashboards, KPIs, scorecards, and analytical reports to support business and product decision-making. Write, optimize, and maintain advanced SQL queries, stored procedures, functions, and validation scripts across enterprise databases. Collaborate with product managers, business stakeholders, data engineers, architects, and QA teams to support product analytics, ETL validation, and enterprise data initiatives. Support Master Data Management (MDM) implementation and maintenance to ensure data consistency, accuracy, and integrity across enterprise systems. Contribute to enterprise data governance initiatives by improving data quality, metadata management, and data lineage practices. Translate business requirements into analytical solutions and provide data-driven recommendations to technical and non-technical stakeholders. Perform ETL/ELT data validation and reconciliation to ensure data accuracy throughout the data lifecycle. Monitor product performance metrics and identify opportunities to improve customer experience and business outcomes. Participate in Agile ceremonies and contribute to continuous improvement of analytics and reporting processes. REQUIREMENTS REQUIRED SKILLS: 8+ years of experience as a Data Analyst, Product Analyst, Business Data Analyst, or a similar analytics role. Strong expertise in SQL with experience writing complex queries, joins, CTEs, window functions, stored procedures, and performance optimization. Experience working with relational databases such as SQL Server, Sybase, MySQL, or Snowflake. Hands-on experience with Master Data Management (MDM), ETL/ELT processes, and enterprise data governance practices. Strong understanding of data quality, data validation, metadata management, and data lineage concepts. Experience developing dashboards, KPIs, scorecards, and analytical reports for business and product teams. Knowledge of mortgage business processes and the role of data in supporting operational and strategic business functions. Strong analytical, problem-solving, and stakeholder management skills with the ability to translate business requirements into data-driven solutions. Experience collaborating with cross-functional teams including Product Management, Engineering, Architecture, QA, and Business stakeholders. Excellent communication and presentation skills with the ability to explain complex data insights to diverse audiences. Experience working in Agile or fast-paced software development environments. PREFERRED QUALIFICATION: Experience working with Snowflake or other cloud-based data platforms. Familiarity with Informatica, Talend, or other enterprise ETL and data integration tools. Experience with product analytics, feature adoption analysis, product health metrics, and digital product optimization. Knowledge of A/B testing, experimentation frameworks, and customer behavior analytics. Understanding of enterprise data governance frameworks, metadata management, and data quality best practices. Previous experience in the mortgage, banking, financial services, or other regulated industries is preferred. Exposure to business intelligence and data visualization tools such as Tableau, Power BI, or similar platforms is a plus.