Data Warehouse Engineer

## Data Warehouse Engineer IApply:
ATLANTA, GA:
Full time:
Posted Today:
JR100462
** JOIN THE ASSURANCEAMERICA TEAM
** Do you want to be part of an organization where you are valued, and your ideas and opinions have an impact?
* Join the Assurance America team.
* For more than 25 years, Assurance America has provided superior property and casualty insurance products through contracted independent agents and directly to customers.

Our team succeeds through diversity of thought, experiences, skills, and backgrounds.
** SUMMARY
* * Assurance America is seeking a Data Warehouse Engineer to join our growing ranks as we continue to transform the way technology impacts the insurance business. You will work with a small team of experienced IT professionals and interface directly with stakeholders to understand their challenges and develop solutions. Your daily contributions will have direct, positive impacts on our employees, agents, and customers.
** About YOU*
* · Detailed oriented
· Thrives in a fast-paced environment
· Creative, driven and motivated problem solver
· Strong analytical skills
· Can communicate complex concepts and procedures to others
· Ability to form strong relationships and work collaboratively
· Propensity to learn new programming languages and technologies
** About the ROLE
** Each day at Assurance America is different, but as a Data Warehouse Engineer I in Information Technology, you will:o    Respond to user needs for ad hoc queries using T-SQL, and institutional reports using SSRS, Power BI and/or refreshable Excel Pivot tables.o    Create ETL objects and processes (via SSIS, Python, or other) for translation and movement of data between vendor systems and the Data Warehouse.
o    Proactively communicate directly with business representatives to extract requirements and review work in progress.o    Assist in monitoring production jobs, correcting failures, troubleshooting and solving problemso    Manage break/fix events and drive solutions to correct and prevent recurring issueso    Communicate data warehouse related issues, changes and outages to department manager and end-user communityo    Recommend standards, procedures, and policies that help both the internal group as well as other operations and customer groupso    Organize work schedule to achieve timely processing of all responsibilitieso    Identify opportunities to improve business processes or business outcomes.o    

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.
** Knowledge & Experience
** 2+ years of experience as a SQL / Data Warehouse Developer in a SQL Server environment or equivalent (SQL and Azure experience is preferred).  Good knowledge of and experience with T-SQL, creating stored procedures and functions, and reporting such as experience with SSRS. Experience completing and deploying ETL development required.  

Experience with Microsoft Fabric a plus.
** Skills & Competencies
** o    Ability to work in a fast-paced automated production environment.o    Auto insurance experience preferred.o    Good oral and written communications skills.o    Well-developed critical thinking skills.o    Works as a team player throughout the company.o    Must be professional and maintain an acceptable level of integrity and professionalism.
** About US
*** We are direct, results-driven, and dedicated to the success of our business and each other
* We cover the cost of health-related benefits for our Associates
* We are a diverse group of thinkers and doers
* We offer many opportunities to grow in your professional skills and career
* We fight…