** 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-management Data Science Problem-solving Researcher naming-conventions Matillion Microsoft SQL Server snowflake-cloud-data-platform Writing reports and proposals Communication SQL Server Integration Services (SSIS) Professionalism Information technology (IT) erwin SQL ETL Leadership Hadoop data-lineage