DATA WAREHOUSE III

<p><b><u>About the ROLE</u></b></p><p></p><p>Each day at AssuranceAmerica is different, but as a Data Warehouse Engineer III in Information Technology, you will:</p><ul><li><p>Assist with research, recommendations, and implementation of newer Azure / Cloud based technologies to replace legacy data warehouse systems and processes</p></li><li><p>Develop ETL packages for translation and movement of data between vendor systems and the Data Warehouse.   </p></li><li><p>Build, extend and maintain SSAS OLAP cubes.</p></li><li><p>Proactively communicate directly with business representatives to extract requirements and review work in progress.</p></li><li><p>Assist in monitoring production jobs, correcting failures, troubleshooting and solving problems</p></li><li><p>Manage break/fix events and drive solutions to correct and prevent recurring issues</p></li><li><p>Monitor and improve overall health of the data warehouse environment</p></li><li><p>Communicate data warehouse related issues, changes and outages to department manager and end-user community</p></li><li><p>Recommend standards, procedures, and policies that help both the internal group as well as other operations and customer groups</p></li><li><p>Organize work schedule to achieve timely processing of all responsibilities</p></li><li><p>Identify opportunities to improve the Business</p></li><li><p>Demonstrate a proactive and self-motivated approach to learning new technologies and techniques to enhance development skills.</p></li></ul><p></p><p><b>Job Qualifications</b></p><p><b>Formal Education &amp; Certification</b></p><p><span>Requires a 4 year degree in a related technical area or  equivalent experience</span></p><p></p><p><b>Knowledge &amp; Experience</b></p><ul><li><p><span>7&#43; years of experience as a SQL / Data Warehouse Developer in a SQL Server or equivalent environment</span></p></li><li><p><span>Strong knowledge of and experience with SQL (candidates will be tested), creating performance tuned stored procedures and functions, SSRS (or equivalent)</span></p></li><li><p><span>Experience with ETL development strongly preferred. Ability to design, develop, tune, and maintain OLAP cubes using Microsoft SSAS strongly preferred.  </span></p></li></ul><p></p><p><b>Skills &amp; Competencies</b></p><ul><li><p><span>Ability to work in a fast-paced automated production environment.  </span></p></li><li><p><span>Auto insurance experience preferred.  </span></p></li><li><p><span>Good oral and written communications skills.  </span></p></li><li><p><span>Well-developed critical thinking skills.  </span></p></li><li><p><span>Works as a team player throughout the company.  </span></p></li><li><p><span>Must be professional and maintain an acceptable level of integrity and professionalism.</span></p></li></ul><p></p>