Data Product and Integration Analyst

Genworth • Richmond, VA

23h • $84,400 - $127,000 • Hybrid

About The Position

The Data Product & Integration Analyst serves as a key connector between business stakeholders, analytics teams, data engineering, and technology partners to strengthen how enterprise data is defined, integrated, governed, and used. This role is responsible for helping create trusted, curated data assets that support customer segmentation, business reporting, analytics, and informed decision-making across critical policy, customer, and risk-related domains.

The individual will translate business needs into clear data requirements, validate data mappings and business rules, document definitions and lineage, and support data quality controls that improve consistency, usability, and trust. The role also contributes to continuous improvement by identifying opportunities to enhance data accessibility, streamline data processes, strengthen governance practices, and enable scalable data products for reporting and strategic analytics.

Requirements

• Bachelor's degree in Information Systems, Data Analytics, Computer Science, Business, Statistics, or a related field, or equivalent work experience.
• Minimum of 5 years’ experience in data analysis, business analysis, data governance, data stewardship, data modeling, or data engineering in a dynamic environment.
• Minimum of 5 years’ experience with SQL, including authoring highly complex queries to extract, transform, and analyze large data sets.
• Minimum of 3 years’ experience using Power BI, with proficiency in semantic models, dataflows, gateways, and publishing to Power BI Server.
• Minimum of 3 years’ experience with scripting languages, such as Python or R.
• Minimum of 3 years’ experience supporting data governance, metadata management, or data quality initiatives.
• Minimum of 3 years’ experience working within Azure or other cloud environments and related data services, including familiarity with data warehouse, data lake, and modern data architecture concepts.
• Strong understanding of data governance, data quality, metadata management, and data lineage concepts, including familiarity with enterprise data catalog and governance platforms.
• Experience with Git-based source code management tools and practices.
• Advanced Microsoft Excel skills, including developing pivot tables, connecting to external data sources, and automating tasks with VBA.
• Experience with Agile delivery methodologies.
• Critical Thinking: Strong analytical and problem-solving skills, including the ability to apply quantitative and qualitative insights to support business strategy and effective execution.
• Results Orientation: Strong sense of urgency and accountability, with a consistent focus on delivering high-quality work within deadlines.
• Self-Motivation: Ability to manage multiple and changing priorities independently while maintaining a drive for results in a fast-paced environment.
• Communication: Deliver clear and effective verbal and written communications to both technical and non-technical audiences.
• Understand, analyze, and document complex business processes.
• Translate business requirements into practical technical data solutions.
• Teamwork & Collaboration: Build relationships and collaborate effectively with cross-functional teams, influencing outcomes and contributing as a strong team player.
• Demonstrate excellent stakeholder management and cross-functional collaboration skills.

Nice To Haves

• Master’s degree in Data Analytics or a related discipline.
• Experience supporting customer segmentation or advanced analytics initiatives.
• Experience migrating legacy data systems to Azure or other cloud platforms.
• Experience leveraging big data technologies such as Azure Databricks to process large datasets, enable advanced analytics, and increase data throughput.
• Advanced Power BI experience designing and implementing interactive dashboards for executive leadership to enable real-time, data-driven decision-making.
• Python or R experience building predictive models to forecast customer or claims experience.
• Database and ETL experience developing and maintaining SQL Server databases and ETL pipelines that support seamless integration of diverse data sources.
• Experience using Alteryx to automate complex data preparation workflows, streamline ETL processes, and improve data accuracy for analytics and reporting.
• Familiarity with Apache Airflow for workflow orchestration and data pipeline management.
• Experience working with insurance, policy administration, risk management, or customer data domains.
• Long Term Care insurance product and claims process knowledge, including a strong understanding of LTC insurance products and claims workflows.

Responsibilities

• Design and maintain curated datasets that integrate data across multiple systems and domains supporting customer segmentation, and critical business reporting needs.
• Partner with data engineering teams to identify, source, and transform data from multiple systems into trusted enterprise data assets.
• Validate data mappings, lineage, and business rules to ensure accuracy, consistency, and traceability across data domains.
• Support the development and maintenance of data products that enable reporting, analytics, and informed business decision-making.
• Apply enterprise data governance principles to strengthen data quality, integrity, consistency, and usability.
• Develop and maintain business metadata, data dictionaries, business glossaries, and lineage documentation.
• Define and monitor data quality controls, identify issues, and coordinate remediation activities with appropriate stakeholders.
• Partner with business and technology stakeholders to establish common definitions and governance standards across data domains.
• Act as a liaison between business stakeholders and technical teams, translating business needs into clear, actionable data requirements.
• Analyze business processes to understand how data is generated, consumed, and used across the organization.
• Facilitate discussions to align stakeholders on data definitions, requirements, priorities, and expected outcomes.
• Partner with reporting and analytics teams to ensure data solutions support business objectives and decision-making needs.
• Identify opportunities to improve data accessibility, data quality, process efficiency, and governance practices.
• Perform exploratory analysis to validate business assumptions and support strategic initiatives.
• Recommend enhancements to data models, data flows, and governance processes.
• Support enterprise initiatives involving customer segmentation, risk analytics, and operational reporting.
• Serve as a subject matter resource for data assets within assigned business domains.
• Provide guidance to team members and stakeholders on data governance standards and best practices.
• Lead small projects or workstreams involving data integration, governance, or process improvement.
• Build strong relationships across business, analytics, data engineering, and technology teams.

Benefits

• Competitive Compensation & Total Rewards Incentives
• Comprehensive Healthcare Coverage
• Multiple 401(k) Savings Plan Options
• Auto Enrollment in Employer-Directed Retirement Account Feature (100% employer-funded!)
• Generous Paid Time Off – Including 12 Paid Holidays, Volunteer Time Off and Paid Family Leave
• Disability, Life, and Long Term Care Insurance
• Tuition Reimbursement, Student Loan Repayment and Training & Certification Support
• Wellness support including gym membership reimbursement and Employee Assistance Program resources (work/life support, financial & legal management)
• Caregiver and Mental Health Support Services

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level