PLEASE NOTE:
- It is 100% onsite position
in McLean, VA.
Skill Set:
- SQL,
MDM, and Product Analytics is a must.
Job Description:
We are seeking a highly analytical and detail-oriented Data & Product
Analyst with strong SQL expertise and hands-on experience across data
management, product analytics, ETL processes, and data governance. In this
role, you will partner closely with product managers, business stakeholders,
data engineers, architects, and QA teams to transform complex datasets into
actionable insights that support strategic business and product decisions.
You will play a key role in improving data quality, supporting governance
initiatives, and delivering meaningful analytics within the mortgage domain.
The ideal candidate combines technical capability with strong business acumen,
communication skills, and a passion for solving complex data challenges.
- Analyze complex datasets to identify trends, anomalies, and business opportunities
within mortgage and product domains
- Develop dashboards, KPIs, scorecards, and analytical reports to support
business and product decision-making
- Write and optimize advanced SQL queries, stored procedures, functions,
and validation scripts across enterprise data platforms
- Partner with cross-functional teams to support product analytics, ETL
validation, master data management, and governance initiatives
- Present data-driven insights and recommendations to both technical and
non-technical stakeholders.
Requirements
Requirements:
- +7 Years writing complex
SQL queries, working w/ relational databases such as SQL Server, Sybase, MySQL,
Snowflake, etc. Product analytics, Master Data Management, ETL & Data
Integrations, etc
- +8 Years of experience with SQL and relational databases such as SQL
Server, Sybase, MySQL, or Snowflake
- +8 years of experience working with Master Data Management (MDM), ETL/ELT
workflows, and enterprise data governance practices. Support implementation and
maintenance of MDM frameworks.
- Knowledge of mortgage business processes and understanding of how data
supports operational and strategic outcomes
- Strong analytical, problem-solving, and stakeholder management skills
with the ability to translate business needs into data solutions
- Experience collaborating across product, engineering, architecture, QA,
and business teams in agile or fast-paced environments
- Develop meaningful KPIs, dashboards, scorecards, and analytical reports for
business and product teams.
Preferred Qualification:
- Experience with Snowflake and modern cloud-based data platforms
- Familiarity with Informatica, Talend, or similar ETL and data integration
tools
- Exposure to A/B testing, experimentation frameworks, and customer
behavior analytics
- Understanding of data lineage, metadata management, and data quality
frameworks
- Previous experience supporting product health metrics, feature adoption
analysis, or digital product optimization
Skills Required
- 7+ years writing complex SQL queries
- 8+ years of experience with SQL and relational databases
- 8+ years of experience with Master Data Management (MDM)
- Familiarity with cloud-based data platforms like Snowflake
- Experience with ETL and data integration tools
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.
