Data Warehouse Engineer I

AssuranceAmerica • Atlanta, GA

1d

About The Position

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

Requirements

• Requires a 4-year degree in a related technical area.
• 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.

Nice To Haves

• Microsoft Fabric a plus.
• Auto insurance experience preferred.
• 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
• Ability to work in a fast-paced automated production environment.
• 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.

Responsibilities

• Respond to user needs for ad hoc queries using T-SQL, and institutional reports using SSRS, Power BI and/or refreshable Excel Pivot tables.
• Create ETL objects and processes (via SSIS, Python, or other) for translation and movement of data between vendor systems and the Data Warehouse.
• 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.
• 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 business processes or business outcomes.
• Demonstrate a proactive and self-motivated approach to learning new technologies and techniques to enhance development skills.

Benefits

• Premium healthcare plans: All full-time Associates and part-time Associates working a regular schedule of 30 hours, or more, are eligible for benefits including Medical, Dental, Vision, Voluntary Life, Flexible Spending Accounts, and a Health Savings Account.
• Employer Paid Benefits: We enroll all eligible Associates in Group Life and AD&D Insurance, Short- and Long-Term Disability Plans, Employee Assistance Program, Travel Assist, and the Benefit Resource Card which includes Teladoc™, Pet Insurance and Health Advocate.
• 401(k) Employer Match: We want to help you prepare for the future, now. All full-time and part-time Associates over age 21 are eligible to participate in the 401(k) Savings with company matching.
• Engagement Events.
• Annual Learning Credit: Want to learn something new? We'll reimburse you for approved educational assistance up to HR guideline limits.
• Time Off: Paid Time Off (PTO), Parental Leave Pay, Volunteer Time Off (VTO), Bereavement Pay, Military Leave Pay, and Jury Duty Pay as well as company holidays.

What This Job Offers

• Job Type: Full-time
• Career Level: Entry Level