Data Warehouse Engineer III
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
-
Assist with research, recommendations, and implementation of newer Azure / Cloud based technologies to replace legacy data warehouse systems and processes including: SQL Server on Azure Cloud, Azure DevOps, Microsoft Fabric, Data Warehouse, Lakehouse and Onelake, Azure Data Factory
-
Develop ETL packages or pipelines 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, Engineer, Architect in a SQL Server or equivalent relational database environment.
-
Strong knowledge of and experience with SQL (candidates will be tested).
-
Must be able to create and optimize stored procedures, functions, and/or pipelines for ETL development.
-
Experience with SSRS (or equivalent reporting tools).
-
Ability to design, develop, tune, and maintain OLAP cubes using Microsoft SSAS is strongly preferred. Experience with Azure Cloud and Microsoft Fabric is preferred.
-
Understanding data modeling, dimensional warehouse design, and the Kimball method is a plus.
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.