Data Warehouse III
About this role
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.
Company at a glance
At AssuranceAmerica, our mission is to make quality insurance accessible and affordable for everyone. We provide personal auto, renters, commercial auto, and motor club to customers across 14 states through our network of over 9,500 independent agents. We believe everyone deserves a fair rate, which is why we do not use credit scores to determine pricing—just straightforward coverage at prices that fit your budget.
Through The Generous Policy™, we direct 5% of our profits to high-impact nonprofits addressing homelessness and education in the communities where we live and work. For over 25 years, we've been committed to helping drivers and renters get the coverage they need at prices they can afford.
Tired of cold applications?
Sign up with Clera and we'll reach out the moment a role actually fits you — no more spraying applications into the void.
Know someone who'd be great for this?