Senior Data Warehouse Consultant (Hybrid/Remote)

If you're excited about this role but don't meet every qualification, we still encourage you to apply! At Grange, we value growth and are committed to supporting continuous learning and skill development as you advance in your career with us.

Summary: This position is responsible for leading, designing and implementing complex data warehouse ELT and ETL processes. Mentoring junior associates and assisting with onboarding of contract resources.

What You'll Be Doing:

• Act independently under general supervision using established software and standards.
• Evaluate proposed system changes on applications to determine effort, impact, and timeline within their area of responsibility and some broad knowledge of relevant applications.
• Provides technical and business leadership, mentoring, and training.
• Designs, supervises, plans, and coordinates medium to large sized projects.
• Work with Data Science, Research, IT, and business units to collect and write business requirements.
• Interpret business and technical requirements (written or oral) as an input to design, code and implement efficient and robust ELT and ETL processes.
• Perform data profiling and data analysis against sources to define requirements as input for data models.
• Potentially manage unstructured, "Big Data" such as telematic, internet-of-things (IOT), drone, wearables, sensor, and social media, in a distributed ecosystem like Hadoop, should business use-cases require such sources.
• Operate across all phases of development, including but not limited to designing, coding, testing, debugging, documenting, installing, configuring, etc.
• Considers system capacity, resources, and performance when designing complex ELT and ETL processes
• Work collaboratively with team members and other departments.
• Have quality assurance responsibilities and limited after hours on-call support.
• Monitor, plan, document, conduct, and evaluate assignment status with project teams and management.
• Evaluate progress and results to recommend changes in procedures.
• Interact and communicate effectively with all business contacts, including group presentations and meeting facilitation.
• Responsible for project completion and user satisfaction on medium to large sized projects.
• May assist with the review and evaluation of personnel performance.
• Mentor junior associates and onboard contract resources.
• Delegate work to other team members and contractors when leading large complex projects.

What You'll Bring To The Company:

• Bachelor's degree in information systems or related field, or equivalent education and experience required.
• 7+ years of related work experience in similar or directly related functions, preferably in insurance or financial services.
• Demonstrate expert knowledge of relational databases such as Oracle, DB2, SQL Server, Teradata, and Snowflake.
• Demonstrate expert knowledge of ELT and ETL development. SSIS and Matillion programming experience a plus.
• Expert SQL querying skills.
• Experience with semi/unstructured data a plus.
• Experience with data modeling a plus.
• Ability to work independently under general supervision with considerable latitude for un-reviewed actions or decisions.
• Must possess excellent interpersonal and communications skills, excellent problem-solving skills, and the self-motivation to improve skills and abilities.
• Must demonstrate professionalism and preferably an understanding of the insurance business.

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.

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 Inclusive Culture 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.