Data Warehouse III

AssuranceAmerica; Town of Texas (WI); On-site; USD 110,000 - 140,000; Full time

Job summary

AssuranceAmerica seeks a Data Warehouse Engineer III to advance analytics within IT. You will design, implement, and optimize the SQL Server data warehouse, ETL processes, and OLAP cubes.

Collaborate with business users, monitor production jobs, and adopt Azure/cloud technologies to modernize legacy systems and improve data insights.

Qualifications

• Requires a 4 year degree in a related technical area or equivalent experience
• 7+ years of experience as a SQL / Data Warehouse Developer in a SQL Server or equivalent environment
• Strong knowledge of SQL, performance-tuned procedures, and SSRS/SSAS

Responsibilities

• Assist with research, recommendations, and implementation of newer Azure/Cloud technologies to replace legacy data warehouse systems
• Develop ETL packages for translation and movement of data between vendor systems and the Data Warehouse
• Build, extend and maintain SSAS OLAP cubes
• Communicate with business representatives to extract requirements and review progress
• Monitor production jobs, fix failures, troubleshoot, and resolve issues
• Manage break/fix events and drive corrective actions
• Monitor and improve overall health of the data warehouse environment
• Communicate data warehouse issues, changes and outages to stakeholders
• Recommend standards, procedures, and policies for internal and customer groups
• Organize work schedule to ensure timely processing
• Identify opportunities to improve the Business
• Demonstrate proactive learning of new technologies

Skills

SQL

Data Warehouse

ETL

OLAP

SSAS

SSRS

Communication

Critical thinking

Team player

Insurance industry knowledge

Education

Bachelor's degree in a related technical area

Tools

SQL Server

SSAS

SSRS

ETL tooling

Job description

About The ROLE

Each day at AssuranceAmerica is different, but as a Data Warehouse Engineer III in Information Technology, you will:

• Assist with research, recommendations, and implementation of newer Azure / Cloud based technologies to replace legacy data warehouse systems and processes
• Develop ETL packages for translation and movement of data between vendor systems and the Data Warehouse.
• Build, extend and maintain SSAS OLAP cubes.
• Proactively communicate directly with business representatives to extract requirements and review work in progress.
• Assist in monitoring production jobs, correcting failures, troubleshooting and solving problems
• Manage break/fix events and drive solutions to correct and prevent recurring issues
• Monitor and improve overall health of the data warehouse environment
• Communicate data warehouse related issues, changes and outages to department manager and end-user community
• Recommend standards, procedures, and policies that help both the internal group as well as other operations and customer groups
• Organize work schedule to achieve timely processing of all responsibilities
• Identify opportunities to improve the Business
• Demonstrate a proactive and self-motivated approach to learning new technologies and techniques to enhance development skills.

About The ROLE

Each day at AssuranceAmerica is different, but as a Data Warehouse Engineer III in Information Technology, you will:

• Assist with research, recommendations, and implementation of newer Azure / Cloud based technologies to replace legacy data warehouse systems and processes
• Develop ETL packages for translation and movement of data between vendor systems and the Data Warehouse.
• Build, extend and maintain SSAS OLAP cubes.
• Proactively communicate directly with business representatives to extract requirements and review work in progress.
• Assist in monitoring production jobs, correcting failures, troubleshooting and solving problems
• Manage break/fix events and drive solutions to correct and prevent recurring issues
• Monitor and improve overall health of the data warehouse environment
• Communicate data warehouse related issues, changes and outages to department manager and end-user community
• Recommend standards, procedures, and policies that help both the internal group as well as other operations and customer groups
• Organize work schedule to achieve timely processing of all responsibilities
• Identify opportunities to improve the Business
• Demonstrate a proactive and self-motivated approach to learning new technologies and techniques to enhance development skills.

Job Qualifications

Formal Education & Certification

Requires a 4 year degree in a related technical area or equivalent experience

Knowledge & Experience

• 7+ years of experience as a SQL / Data Warehouse Developer in a SQL Server or equivalent environment
• Strong knowledge of and experience with SQL (candidates will be tested), creating performance tuned stored procedures and functions, SSRS (or equivalent)
• Experience with ETL development strongly preferred. Ability to design, develop, tune, and maintain OLAP cubes using Microsoft SSAS strongly preferred.

Skills & Competencies

• Ability to work in a fast-paced automated production environment.
• Auto insurance experience preferred.
• Good oral and written communications skills.
• Well-developed critical thinking skills.
• Works as a team player throughout the company.
• Must be professional and maintain an acceptable level of integrity and professionalism.