What are the responsibilities and job description for the Lead Data Analyst (hybrid/remote) position at Grange Insurance?
It’s ok if you don’t meet every requirement. At Grange, we prioritize creating a diverse, equitable and inclusive workplace. If you're enthusiastic about this role but your previous experience only partially matches qualifications in the job description, we still encourage you to apply. We believe in fostering growth and providing opportunities for continuous learning and development of skills as you progress in your career with us.
Summary: This position is responsible for improving the use, management, and integrity of data to support the enterprise’s critical business objectives to grow revenues, reduce expense, and control risk. High priority initiatives include enabling digital transformation, increasing operational efficiencies, meeting new regulatory requirements, supporting advanced analytics, and promoting end-user analytic self-service. The Grange Enterprise Data Office’s (EDO) goal is to achieve greater business value by enabling Grange’s highest priority initiatives through the use of data.
What You’ll Be Doing:
Grange Insurance Company, with $3.2 billion in assets and more than $1.5 billion in annual revenue, is an insurance provider founded in 1935 and based in Columbus, Ohio. Through its network of independent agents, Grange offers auto, home and business insurance protection. Grange Insurance Company and its affiliates serve policyholders in Georgia, Illinois, Indiana, Iowa, Kentucky, Michigan, Minnesota, Ohio, Pennsylvania, South Carolina, Tennessee, Virginia, and Wisconsin and holds an A.M. Best rating of "A" (Excellent).
Grange understands that life requires flexibility. We promote geographical diversity, allowing hybrid and remote options and flexibility in work hours (role dependent). In addition to competitive traditional benefits, Grange has also created unique benefits based on employee feedback, including a cultural appreciation holiday, family formation benefits, compassionate care leave, and expanded categories of bereavement leave.
Who We Are:
We are committed to an inclusive work environment that welcomes and values diversity, equity and inclusion. We hire great talent from various backgrounds, and our associates are our biggest strength. We seek individuals that represent the diversity of our communities, including those of all abilities. A diverse workforce's collective ideas, opinions and creativity are necessary to deliver the innovative solutions and service our agency partners and customers need. Our core values: Be One Team, Deliver Excellence, Communicate Openly, Do the Right Thing, and Solve Creatively for Tomorrow.
Our Associate Resource Groups help us create a more diverse and inclusive mindset and workplace. They also offer professional and personal growth opportunities. These voluntary groups are open to all associates and have formed to celebrate similarities of ethnicity/race, nationality, generation, gender identity, and sexual orientation and include Multicultural Professional Network, Pride Partnership & Allies, Women's Group, and Young Professionals.
Our Diversity, Equity and Inclusion Council, created in 2016, is focused on professional development, networking, business value and community outreach, all of which encourage and facilitate an environment that fosters learning, innovation, and growth. Together, we use our individual experiences to learn from one another and grow as professionals and as people.
We are committed to maintaining a discrimination-free workplace in all aspects, terms and conditions of employment and welcome the unique contributions that you bring from education, opinions, culture, beliefs, race, color, religion, age, sex, national origin, handicap, disability, sexual orientation, gender identity or expression, ancestry, pregnancy, veteran status, and citizenship.
Grange Enterprise is proud to be part of the CEO Action for Diversity and Inclusion™, a national initiative of more than 1400 CEOs working for the advancement of diversity and inclusion within the workplace.
Summary: This position is responsible for improving the use, management, and integrity of data to support the enterprise’s critical business objectives to grow revenues, reduce expense, and control risk. High priority initiatives include enabling digital transformation, increasing operational efficiencies, meeting new regulatory requirements, supporting advanced analytics, and promoting end-user analytic self-service. The Grange Enterprise Data Office’s (EDO) goal is to achieve greater business value by enabling Grange’s highest priority initiatives through the use of data.
What You’ll Be Doing:
- Provide hands-on technical leadership to research, source, interpret, catalog, and improve Grange’s structured and unstructured data assets to facilitate effective use.
- Help develop and implement enterprise data standards, working closely with business stakeholders, EDO leadership, data management associates, and IT resources.
- Work with a team of offshore analysts to perform data analysis across a variety of systems, identify data quality issues, determine root causes behind variances, provide resolution, and build routines for monitoring, based on data management best practices.
- Track and document data element lineage, record metadata, and contribute to data dictionaries and business glossaries.
- Lead development of key performance indicators, reports, scorecards, and dashboards that supply the enterprise with data performance results.
- Support architectural strategies designed to enhance data reliability and minimize redundancies.
- Deliver data analysis training as needed to relevant stakeholders.
- Bachelor’s degree in Computer Science, Information Systems, Mathematics, or a related discipline; master’s degree preferred.
- 7 years of related work experience (e.g. data analysis, data governance/management, data warehousing, database administration).
- Minimum of 3 years as a Data Analyst, ideally in Property and Casualty Insurance.
- Experience working with offshore resources preferred.
- Extensive experience profiling and analyzing data in mainframe and relational databases is essential. Experience with non-relational databases is a plus.
- Advanced SQL and Microsoft Excel skills.
- Experience using tools and processes for the collection, analysis and remediation of data quality issues. Newer approaches in identifying data quality problems (e.g. machine learning, neural networks, etc.) are a plus.
- Experience using data dictionaries, glossaries, and lineage-tracking tools.
- Experience building reports in tools such as MicroStrategy, Qlikview, Power BI, Tableau, etc.
- Knowledge of best practices in data management, data governance, master data management, metadata management, and business intelligence.
- Demonstrated analytical and problem-solving skills with the ability to understand business and technical functions, process information quickly, and assess impacts to data elements.
- Applied experience in following Agile methodologies preferred.
- Ability to communicate and work effectively with a diverse range of people in technical and business functions of the organization.
- Ability to independently learn new technologies and data related approaches and educate stakeholders on the same.
Grange Insurance Company, with $3.2 billion in assets and more than $1.5 billion in annual revenue, is an insurance provider founded in 1935 and based in Columbus, Ohio. Through its network of independent agents, Grange offers auto, home and business insurance protection. Grange Insurance Company and its affiliates serve policyholders in Georgia, Illinois, Indiana, Iowa, Kentucky, Michigan, Minnesota, Ohio, Pennsylvania, South Carolina, Tennessee, Virginia, and Wisconsin and holds an A.M. Best rating of "A" (Excellent).
Grange understands that life requires flexibility. We promote geographical diversity, allowing hybrid and remote options and flexibility in work hours (role dependent). In addition to competitive traditional benefits, Grange has also created unique benefits based on employee feedback, including a cultural appreciation holiday, family formation benefits, compassionate care leave, and expanded categories of bereavement leave.
Who We Are:
We are committed to an inclusive work environment that welcomes and values diversity, equity and inclusion. We hire great talent from various backgrounds, and our associates are our biggest strength. We seek individuals that represent the diversity of our communities, including those of all abilities. A diverse workforce's collective ideas, opinions and creativity are necessary to deliver the innovative solutions and service our agency partners and customers need. Our core values: Be One Team, Deliver Excellence, Communicate Openly, Do the Right Thing, and Solve Creatively for Tomorrow.
Our Associate Resource Groups help us create a more diverse and inclusive mindset and workplace. They also offer professional and personal growth opportunities. These voluntary groups are open to all associates and have formed to celebrate similarities of ethnicity/race, nationality, generation, gender identity, and sexual orientation and include Multicultural Professional Network, Pride Partnership & Allies, Women's Group, and Young Professionals.
Our Diversity, Equity and Inclusion Council, created in 2016, is focused on professional development, networking, business value and community outreach, all of which encourage and facilitate an environment that fosters learning, innovation, and growth. Together, we use our individual experiences to learn from one another and grow as professionals and as people.
We are committed to maintaining a discrimination-free workplace in all aspects, terms and conditions of employment and welcome the unique contributions that you bring from education, opinions, culture, beliefs, race, color, religion, age, sex, national origin, handicap, disability, sexual orientation, gender identity or expression, ancestry, pregnancy, veteran status, and citizenship.
Grange Enterprise is proud to be part of the CEO Action for Diversity and Inclusion™, a national initiative of more than 1400 CEOs working for the advancement of diversity and inclusion within the workplace.
