IT Data Architect

Michigan Farm Bureau; Lansing (MI); Híbrido; USD 100.000 - 122.000; Jornada completa

Ventajas ofrecidas por este puesto de trabajo

Full benefits package

Descripción de la vacante

Michigan Farm Bureau in Lansing, MI is seeking an experienced Data Architect to lead advanced database design and data integration initiatives. You will partner with division leadership to set strategic data goals and oversee production database environments using SQL Server and T-SQL.

Responsibilities include modeling at all levels, migrations, maintenance, and performance optimization, plus translating complex data problems into clear business language for stakeholders.

Formación

• Strong understanding of data concepts and ability to translate business needs into data solutions.
• Excellent verbal and written communication for technical and non-technical stakeholders.
• Willingness to pursue continuing job-related training in technology or insurance.

Responsabilidades

• Provide advanced technical support for data architecture and database management.
• Develop long-term strategic goals for production databases with division leadership.
• Design, build and maintain conceptual, logical and physical database models.
• Lead migrations, integrations, maintenance, and production monitoring processes.

Conocimientos

Communication skills

Problem solving

Team collaboration

Educación

Bachelor’s degree in computer science or related field

Herramientas

Microsoft SQL Server

T-SQL

Descripción del empleo

To provide advanced technical support in the research, analysis and application of systems technology, including data architecture, integration capabilities and database management. To provide technical and data leadership to development, production support and business teams. To maintain awareness of current and future technologies, and have responsibility for guiding the organization in how to use current and future technologies to advance business initiatives.

Assess and develop long-term strategic goals for production databases in conjunction with division leadership and data owners. Design database solutions to satisfy business and technical requirements.

Design, build and maintain conceptual, logical and physical database models. Be responsible for the planning and design of database conversions, migrations, integrations, maintenance, optimization, and production monitoring processes.

Have the ability to conceive and portray the data picture in easy to understand language. Be well versed in data technologies, including data warehouse, big data, advanced analytics, data visualization, and data virtualization. Be able to work with structured and unstructured data.

Required
Bachelor’s degree in computer science or related field required, or equivalent experience may be considered.

Minimum eight years database administration or data architecture experience required.
Hands‑on experience with current versions of Microsoft SQL Server, T‑SQL, and writing relational and multi-dimensional queries required.

Ability to understand complex business problems and apply data solutions required.
Knowledge and use of computer database concepts and administration, hardware, operating systems, system software, program language(s) and tools, and testing techniques and tools required.
Ability to communicate verbally and in written form in a clear and concise manner required.
Willingness to pursue continuing job related training and education in technology or insurance required.
Completion of 7 Habits of Highly Successful People course required.

Preferred
Prior experience at an insurance company or on projects for an insurance company preferred.

Designations in AINS, FLMI and/or AIDM preferred.
Designation in MCSE: Data Platform preferred.

Note: If a candidate is not selected, an Associate Data Architect position may be considered on the level of experience and qualifications.This is a Hybrid position working both Remotely from the State of Michigan, and On‑site at the Farm Bureau Center located in Lansing, Michigan.
Farm Bureau offers a full benefit package including medical, dental, vision, and 401K.
PM19

Work Type

Hybrid

Standard Hours

8:00am-4:30pm

Position Type

Full‑time

111,180

Location(s)

Lansing , Michigan 48917

The Michigan Farm Bureau Family of Companies is an equal opportunity employer. The Company will not discriminate against applicants or employees on the basis of race, color, religion, national origin, age, sex, pregnancy (including childbirth or related medical condition), disability, genetic information, sexual orientation, gender identity, military status, citizenship, or any other class protected by applicable law. In accordance with Michigan's Persons with Disabilities Civil Rights Act, the companies listed above advise you as follows: If you believe that any of the above‑listed companies has failed to accommodate you as a disabled individual, you may allege a violation against that company for failing to so accommodate you, but only if you have notified that company in writing of your need for accommodation within 182 days after the date on which you knew, or reasonably should have known, that an accommodation was needed by you to perform the job which you hold or seek.