Data Warehouse Engineer III

• 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.

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. Originally posted on Himalayas Data-Warehouse-Engineer, Data-Engineer, ETL-Developer, Database-Engineer, BI-Developer, Data-Warehouse-Developer, Enterprise-Data-Warehouse-Developer, Data-Warehouse-Specialist