The Hartford Senior Data Modeler in HARTFORD, Connecticut

Title: Senior Data Modeler

Location: United States-Connecticut-Hartford

Job Number: 1800583

Ready to grow your career leveraging the latest DATA technologies?

Join a fast-paced and talented Agile Scrum team to unlock Data Capabilities for The Hartford’s Enterprise Data organization in IT to support Commercial Line of Business initiatives. You will have an opportunity to participate in the entire software development lifecycle process in support of continuous DATA delivery, while growing your knowledge with emerging technologies. We use the latest DATA technologies, software engineering practices, Agile delivery framework, and are passionate about technology and building well architected and innovative solutions that drive optimal business value generation.

This cutting edge and forward focused team presents the opportunity for collaboration, self-organization within the Scrum Team and visibility as we focus on continuous Business data delivery.

The position is primarily a self-directing individual contributor with skills at matrixed and virtual team contribution/integration and with experience in leading and directing other team members. Thoughtful analysis, option development, and delivery estimation and planning rigor are requisite.

What’s in it for you?

  • Experience deeper understanding of Data analytics, Emerging technologies and Development practices

  • Collaboration with a high-performing, forward-focused team, Product Owner(s) and Business stakeholders engagement

  • Work with Data Architects and Business leaders to understand the architectural roadmaps that support and fulfill business strategy.

  • Designing Logical Data Models and stewarding the data design of the asset and ensuring alignment with the larger roadmap goals

  • Enable and influence the timely and successful delivery of business data capabilities and/or technology objectives

  • Act as a lead data modeler and mentor colleagues with less experience’

  • Opportunity to expand your communication, analytical, interpersonal, and organization capabilities

  • Experience working in a fast paced environment – driving business outcomes in Agile ways of working

  • Enhance your entrepreneurial mindset – network opportunity and influencing outcomes

  • Supporting environment that fosters can-do attitude and opportunity for growth and advancement based on consistent demonstrative performance

  • Optimize business value by leveraging your DATA experience and depth

  • Be part of a Scrum Team – driving work independently or collaboratively towards achieving business outcomes


What is The Hartford looking for?

  • Translate business and data requirements into data models in support of Enterprise Data Models, Data Warehouse and Analytical systems.

  • Develop Data Warehouse Dimensional modeling constructs; Develop and maintain the Data Warehouse Bus Matrix Architecture.

  • Perform rigorous data analysis and data discovery and data profiling.

  • Ensure data design follows the prescribed reference architecture and framework; Ensure design reflects appropriate business rules, and facilitates data integration, data conformity and data integrity; Ensure data structures are designed for flexibility to support future business needs and enhancements.

  • Understand the relationships across business information and units of data; collaborate with Business Analysts, Data Stewards and Business Customers to identify data usage patterns and to formulate Business names, definitions and data quality rules for data elements.

  • Maintain Data Mapping documents, Bus Matrix and other Data Design artifacts that define technical data specifications and transformation rules;

  • Understand database performance factors and trends pertaining to very large database design and collaborate with DBAs to implement mitigating physical modeling solutions; provide data structures optimized for information entry and retrieval;

  • Effectively communicate data design to other members of the team to ensure proper implementation and utilization of the data structures; support development team during process design and during performance tuning; support QA team during Test Strategy and test case development;

  • Adopt quality assurance practices to include following an appropriate modeling methodology; helping to establish department standards and procedures; reviewing and critiquing data models produced by others, participating in walkthroughs and audits; ensuring appropriate documentation is produced at all points in the process;

  • Pursue continuous improvements based on lessons learned and industry best practices. All processes include consideration for data integrity and data quality;

  • Understand the goals and risks associated with the business and technical requirements, and offer counsel on risk mitigation and the alignment of data solution with objectives;

  • Educate project team members and the business community on the impact of proposed and alternative data solution and technologies;

  • Demonstrate a team orientation by working closely and effectively with business partners, development teams and outside services;

  • Demonstrate solid business and organizational skills, and leadership in the use of data analysis and design tools and methodologies.


  • Masters or Bachelor’s degree

  • 5 years of experience in Data Modeling, data warehousing and data design

  • Very strong Dimensional modeling and 3NF modeling skills

  • Experience in Data Management best practices, Data Integration, Data Rationalization and Data Patterns.

  • Strong Data Analysis experience

Additional Qualifications:

  • Experience with Metadata Management and Metadata Products

  • Experience with industry data models like IBM IAA, ACORD

  • P&C Insurance expertise

What criteria do we use to Assess, Hire, Develop & Reward our workforce?

· Data Analysis- Input, understand, analyze and act on data

· Business Owner Mindset- Operate with keen business knowledge, expense, risk & controls driven mindset

· Communication- Influence through a consultative approach

· Customer Driven- Focus on “Harvest” – (our enterprise continuous improvement effort), innovative problem solving, and efficient local decision making for continuous improvement

· Growth & Development- Maximize development of self and others

What Else Can You Tell Me?

The Hartford is committed to the education and growth of our Information Technology Professionals. A number of IT Certifications are available to enhance your career and growth potential. IT Professionals at The Hartford may qualify for a stipend up to $1000 per year for additional certifications

Behaviors at the Hartford

· Deliver Outcomes – Demonstrate a bias for speed and execution that serves our shareholders and customers.

· Operate as a Team Player – Work together to drive solutions for the good of The Hartford.

· Build Strong Partnerships – Demonstrate integrity and build trust with others.

· Strive for Excellence – Motivate yourself and others to achieve high standards and continuously improve.

Equal Opportunity Employer/Females/Minorities/Veterans/Disability/Sexual Orientation/Gender Identity or Expression/Religion/Age


Job: Database Management

Primary LocationUnited States-Connecticut-Hartford

Other Locations


Job LevelIndividual Contributor

Education LevelBachelor's Degree (±16 years)

Job TypeStandard

ShiftDay Job

Employee StatusRegular

Overtime StatusExempt

TravelYes, 10 % of the Time

PostingFeb 16, 2018, 11:26:33 AM

Remote Worker OptionNo

The Hartford is an equal employment and affirmative action employer. All qualified applicants will receive consideration without regard to race, color, sex, religion, age, national origin, disability, veteran status, sexual orientation, gender identity or expression, marital status, ancestry or citizenship status, genetic information, pregnancy status or any other characteristic protected by law. The Hartford maintains a drug-free workplace and is committed to building inclusion and leveraging diversity.