Data Warehouse Architect - Columbus, United States - Grange Insurance

Grange Insurance Columbus, United States

2 weeks ago

Description

** Data Warehouse Architect (remote opportunity)**

**Job Category****:** Data Management & Reporting **Requisition Number****:** DATAW003918 Showing 1 location **Job Details**

**Description**

**Summary:** This position is responsible for designing and implementing data warehouse architecture and data models.

**What Youll Be Doing:**

Develop data models and design ETL architecture for existing and new marts, ensuring consistency and alignment with industry best practices.

Demonstrate expertise in ETL architecture and data modeling, and provide thought leadership, guidance, and cross-training on same.

Work closely with ETL developers on integration solutions for the warehouse.

Work with Data Science, Research, IT, and business units to assess and incorporate new data sources into the warehouse.

Potentially introduce and 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.

Establish new and help manage existing data standards for the warehouse.

Act independently under general supervision using established software tools.

Consider equipment capacity, limitations, and operating time when designing data solutions.

Interpret requirements (written or oral) into logical and physical data models, and help design technical specifications for projects across a broad knowledge base.

Have full technical knowledge of all phases of applications systems analysis and programming, including but not limited to designing, coding, testing, debugging, documenting, installing, etc.

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 highly complex projects.

**What Youll Bring To The Company:**

Bachelors degree in Information Systems or related field, or equivalent education and experience required.

3+ years of related work experience in similar or directly-related functions, preferably in insurance or financial services.

Logical and physical (OLTP and OLAP) data modeling experience.

SQL expertise.

ETL architecture and design experience.

Experience using Erwin.

Experience in establishing Naming Conventions and Class Words.

Familiarity with metadata management and data lineage.

Expert knowledge of relational database management systems, preferably in SQL Server and Snowflake. Hadoop a plus.

Ability to work independently under general supervision with considerable latitude for un-reviewed actions or decisions.

Must have an in-depth knowledge of a groups applications programming system / platform and a general knowledge of all groups applications programming systems. Competent to work at the highest technical level of all phases of applications systems analysis and programming activities. SSIS and Matillion programming a plus.

Must possess excellent interpersonal and communications skills, excellent problem-solving skills, and the self-motivation to improve skills and abilities as generally acquired through three years of experience.

Must demonstrate leadership, professionalism, and preferably an understanding of the insurance business.

Grange Insurance Company, with $3 billion in assets and more than $1.3 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, life and business insurance protection. Life insurance offered by Grange Life Insurance and Kansas City Life Insurance. Grange Insurance Company and its affiliates serve policyholders in Georgia, Illinois, Indiana, Iowa, Kentucky, Michigan, Minnesota, Ohio, Pennsylvania, South Carolina, Tennessee, Virginia and Wisconsin.

**Who We Are:**

We are committed to an inclusive work environment where we welcome and value diversity and inclusion. We hire great talent from a wide variety of backgrounds, and our associates are our biggest strength. The diversity of our associates, their backgrounds, experiences, and individual differences are the foundation for our success. Our inclusive culture empowers all of us to Be One Team, Deliver Excellence, Communicate Openly, Do the Right Thing, and Solve Creatively for Tomorrow. We have active Associate Resource Groups and a Diversity and Inclusion Team, that focuses on professional development, networking, business value and community outreach; all 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 humans.

We welcome the unique contributions that you bring from education, opinions, culture, beliefs, race, color, religion, age, sex, national origin, handicap, disability, sexual orientation, gender stereotyping, gender identity or expression, genetic information, 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.*

**Qualifications**

**Skills**

**Behaviors**

**:**

**Motivations**

**:**

**Education**

**Experience**

**Licenses & Certifications**

Data Warehouse Architect

2 weeks ago

Grange Insurance Columbus, United States

** Data Warehouse Architect (remote opportunity)** · **Job Category****:** Data Management & Reporting · **Requisition Number****:** DATAW003918 · Showing 1 location · **Job Details** · **Description** · **Summary:** This position is responsible for designing and implementing ...
Sr. Data Architect, Data Warehouse

5 days ago

Columbus Region Columbus, United States

**Sr. Data Architect, Data Warehouse & MPP - Nationwide Opportunities** · Job ID: | Amazon Web Services, Inc. · **DESCRIPTION** · This role will specifically focus on large scale data warehousing and data warehouse modernization. The role is to help our customers and partners to ...
Cloud Data Solutions Architect

4 weeks ago

IT Associates Ohio, United States

Cloud Data solutions Architect - Azure · Length: months. · Hybrid 2-3 days in office in Ann Arbor, MI · Multi-Million Dollar E-commerce client · As a Cloud Data Solutions Architect focused on Data Solutions and Data Management, your primary responsibility will be to ensure build ...
Data Architect

2 weeks ago

Cloudinity Inc Ohio, United States

The Senior Database Architect is responsible for the analysis, design, development, and implementation of the data architecture in support of the agency mission. The Senior Database Architect will architect the analytical data systems including data warehouse(s), data lake(s), an ...
Database Architect

3 weeks ago

IntelliX Software Inc Columbus, United States

Job Title: Database Architect · Duration: 3 Months + 12 Months Extension · Remote – Columbus, OH (Local Prefer) · Must be require First and Last day onsite at Columbus, OH · The Senior Database Architect is responsible for the analysis, design, development, and implementation ...
IT Architect

2 weeks ago

MIDWEST MOTOR SUPPLY CO Columbus, United States

Kimball Midwest, a national distributor of maintenance, repair, and operation products, is searching for an IT Architect on our WMS team for our Columbus, OH location. As a Kimball Midwest associate, you will experience why we have been recognized as one of the Top Workplaces in ...
D365 Architect

1 week ago

Vertex Solutions Columbus, United States

We have a client looking to hire THREE (3) IT ARCHITECTS These roles are FTE and local to Columbus, OH only for the time being. W2 Candidates only please · Role 1: D365 Architect · Responsibilities: · Architectural Design: Lead the architectural design and implementation of s ...
Data Architect

2 weeks ago

Vaco Los Angeles Columbus, United States

Data Architect | ETL | Data Warehouse | Azure | Columbus OH in Columbus, OH at Vaco **Location:** · **Experience:** · At least 5 year(s) **Job Description** · **JOB SUMMARY:** · Vaco Technology is currently seeking a Data Architect for a direct hire opportunity in Columbus, O ...
Data Architect

2 weeks ago

Cloudinity Inc Columbus, United States

The Senior Database Architect is responsible for the analysis, design, development, and implementation of the data architecture in support of the agency mission. The Senior Database Architect will architect the analytical data systems including data warehouse(s), data lake(s), an ...
s is hiring for a Senior Data Arcitect

3 weeks ago

vTech Solution Columbus, United States

Job Description · Job DescriptionThe Senior Database Architect is responsible for the analysis, design, development, and implementation of the data architecture in support of the agency mission. · The Senior Database Architect will architect the analytical data systems including ...
Data Architect

2 weeks ago

Diversified Systems, Inc. Columbus, United States

Data ArchitectRemote (Onsite First day) · Description: · DSI is searching for aSenior Database Architect who will be responsible for the analysis, design, development, and implementation of the data architecture in support of the agency mission. The Senior Database Architect wi ...
Data Architect

3 weeks ago

Hallmark Global Technologies Ltd Columbus, United States

Title: Data Architect · Location: Onsite/Columbus, Ohio · Duration:6 months · Description: · Possesses extensive knowledge of one or more database systems and is capable of hands-on work in all phases of database design and management. · 3 years of experience working with Micros ...
Solution Architect( Oracle Fusion

6 days ago

Apexon Ohio, United States

Job Description: Solution Architect( Oracle Fusion & Python Snowflake) · Location: Remote (Cleveland, OH) · (Candidate must be willing to travel monthly or as needed) · Industries: Consumer & Retail, Industrial Manufacturing · Key Skills and Requirements: · Expertise in Oracle Fu ...
Data Solution Architect

2 weeks ago

Rose International Columbus, United States

Date Posted: 05/15/2024 · Hiring Organization: Rose International · Position Number: 464160 · Job Title: Data Solution Architect · Job Location: Columbus, OH, USA, 43215 · Work Model: Hybrid · Employment Type: Temporary · Estimated Duration (In months): 13 · Min Hourly Rate($): 6 ...
Director Distribution Operations

1 day ago

People Architects Ohio, United States

People Architects is excited to partner with our Stark County based client as we recruit for our Director Distribution Operations. Our client is a dynamic and rapidly growing D2C tech-enabled consumer products company that is building a global growth platform, acquiring and evolv ...
Sr. Solution Architect

2 weeks ago

ShiftCode Analytics Columbus, United States

Title: Sr. Solution Architect · Location: Columbus, OH hybrid position (local preferred) · Duration: 12 Months+ · Visa: USC, GC, GC-EAD · Interview: Phone/Zoom · Qualifications: · 7+ Years (preferably 10+ total years experience in Information Technology) in role with: · D ...
Senior Data Architect

3 weeks ago

HNB - 6785 Columbus, United States

The Huntington National Bank · Senior Data Architect · (7 Easton Oval, Columbus, OH 43219) · Remote · Job Description: · Lead and develop technical solution architectures to meet business requirements with focus on data pipeline orchestration, cloud data solutions and advanced an ...
GCP Data Architect

1 week ago

Group Nine LLC Columbus, United States

Title : GCP Data Architect · Location : Dublin or Columbus, OH[Hybrid] · Type : 12+ month Contract · Job Description: · Data Architect · The primary role of the Data Architect is to support and expand the Data & Analytics platforms that process, store, organize the data crit ...
Data Modeler

1 week ago

Vaco Technology Columbus, United States

· Data Modeler/Architect · 6 month contact · Westerville, OH (hybrid) · Requirements · * Experience data modeling based on a certain set of data attributes · * Experience data modeling for data warehousing with a star schema / snowflake schema (dimensional modeling) · * Experien ...
Data Modeler

2 weeks ago

Virtual Columbus, United States

Data Modeler/Architect · 6 month contact · Westerville, OH (hybrid) · Requirements · • Experience data modeling based on a certain set of data attributes · • Experience data modeling for data warehousing with a star schema / snowflake schema (dimensional modeling) · • Experience ...