Analytics Data Modeler

Genworth Financial • Lynchburg, VA

27d • $120,000 - $195,000 • Hybrid

About The Position

The Analytics Data Modeler plays a vital role in transforming raw data into meaningful business insights, which is essential for unlocking the value of data within organizations. This professional is responsible for designing, developing, and maintaining robust data models that empower organizations to make informed decisions based on accurate and accessible information. Working at the intersection of business needs, data architecture, and advanced analytics, the Analytics Data Modeler ensures that data flows seamlessly and can be leveraged to derive actionable intelligence to empower teams to uncover insights, drive strategy, and achieve business success in the data-driven age.

Requirements

• Bachelor’s degree in Computer Science, Information Systems, Data Science, Mathematics, or related field.
• Deep familiarity with modern data modeling techniques, database management, and analytics platforms.
• Minimum 3 years of experience in data modeling in a Lakehouse analytics environment.
• Experience in insurance industry which can be P&C, Life, or healthcare.
• Proficiency in a data modeling tool such as ER Studio.
• Solid understanding of DataBricks Delta tables and Postgres database platforms.
• Experience with big data technologies and platforms (e.g., DataBricks, Spark, AWS, Azure).
• Expert level in DDL and SQL development
• Experience with data governance, quality frameworks, and metadata management, and how this connects to data modeling practices and needs.
• Strong analytical, problem-solving, and critical thinking skills needed for data modeling
• Excellent communication and interpersonal abilities.
• Ability to understand business processes, goals, and pain points to design data models that solve real-world problems.
• Strong team player who can interact with developers, analysts, and non-technical stakeholders.
• Ability to thrive in a fast-paced, dynamic environment and quickly pivot between projects.

Nice To Haves

• Master’s degree preferred.
• Understanding of PII and PHI data and how they are governed and secured
• Experience working on an agile team using agile tools, and associated practices.
• Knowledge of business intelligence tools (e.g., Power BI, Spotfire).
• Data taxonomies in insurance down to two or three levels
• Knowledge of typical data quality issues with insurance data
• Knowledge of cloud data management, data lakes, and ETL (Extract, Transform, Load) processes.
• Ability to work independently and collaboratively in a cross-functional team environment.
• Strong attention to detail and commitment to data accuracy.

Responsibilities

• Develop conceptual, logical, and physical data models for business intelligence, analytics, and reporting solutions. Transform requirements into scalable, flexible, and efficient data structures that can support advanced analytics.
• Collaborate with business analysts, stakeholders, and subject matter experts to gather and interpret requirements for new data initiatives. Translate business questions into data models that can answer these questions.
• Work closely with data engineers to integrate data from multiple sources, ensuring consistency, accuracy, and reliability. Map data flows and document relationships between datasets.
• Design and optimize database schemas using the medallion architecture which includes relational, star schema and denormalized data sets for BI and ML data consumers.
• Team with the data governance team so detailed documentation on data definitions, data lineage, and data quality statistics are available to data consumers.
• Establish master data management and data modeling practices that preserve historical context, explain data changes resulting from remediation or repairs, and enable consumers to understand variances from source systems.
• Serve as a bridge between technical teams and business units, clearly communicating the value and limitations of various data sources and structures.
• Stay abreast of emerging trends in data modeling, analytics platforms, and big data technologies. Recommend enhancements to existing data models and approaches.
• Monitor and optimize data models for query performance and scalability. Troubleshoot and resolve performance bottlenecks in collaboration with database administrators.
• Ensure that data models and processes adhere to regulatory standards and organizational policies regarding privacy, access, and security.

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: Senior