The Role
Analyze enterprise datasets to drive product strategy and operational improvements in the mortgage domain. Build dashboards, KPIs, and reports; write and optimize advanced SQL; validate ETL/ELT pipelines; support Master Data Management and data governance; collaborate with product, engineering, architecture, and QA teams to deliver actionable analytics and improve data quality.
Summary Generated by Built In
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 DESCREIPTION:
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.
Skills Required
- 8+ years experience as Data Analyst, Product Analyst, Business Data Analyst, or similar
- Strong expertise in SQL including complex queries, joins, CTEs, window functions, stored procedures, and performance optimization
- Experience with relational databases (SQL Server, Sybase, MySQL, Snowflake)
- Hands-on experience with Master Data Management (MDM)
- Experience with ETL/ELT processes and ETL validation/reconciliation
- Strong understanding of data quality, data validation, metadata management, and data lineage
- Experience developing dashboards, KPIs, scorecards, and analytical reports
- Knowledge of mortgage business processes and the role of data in mortgage operations
- Experience collaborating with Product Management, Engineering, Architecture, QA, and business stakeholders
- Excellent communication and presentation skills for technical and non-technical audiences
- Experience working in Agile or fast-paced software development environments
- Familiarity with Informatica, Talend, or other enterprise ETL/data integration tools
- Experience with product analytics, feature adoption analysis, product health metrics, A/B testing and experimentation frameworks
- Exposure to BI/data visualization tools such as Tableau or Power BI
- Previous experience in mortgage, banking, financial services, or other regulated industries
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
Omm IT Solutions is a leading provider of IT consulting, analysis, and advisory services, specializing in delivering technical solutions for federal and state government agencies. Their offerings include application development, cybersecurity services, cloud advisory, network modernization, and data analytics.
