Description
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 AssuranceAmerica team.
For more than 25 years, AssuranceAmerica 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.
Associate Data Warehouse Engineer
AssuranceAmerica is seeking an Associate 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 the ROLE
Requirements
About YOU• Detail-oriented
• Thrives in a fast-paced environment
• Creative, driven and motivated problem solver
• Well-developed critical thinking skills
• Enjoys working with data
• Can communicate complex concepts and procedures to others
• Ability to form strong relationships and work collaboratively
• Propensity to learn new technologies
• Good oral and written communications skills
Required
• Requires a 4-year degree in computer science or a related technical area.
• 1-3 years of experience as a SQL / Data Warehouse Developer in a SQL Server environment.
• Experience with T-SQL (candidates will be tested)
Preferred
• Experience creating stored procedures and functions
• Experience developing SSRS reports
• Experience with ETL development
• Experience with Azure (Managed Instances, SQL Databases)
• Auto insurance experience
Physical Requirements
• Prolonged periods sitting at a desk and working on a computer
• Must be able to lift 15 pounds at times
• May be required to work on-call, evenings or weekends
Benefits
About US• We are direct, results-driven, and dedicated to the success of our business and each other
• We are a diverse group of thinkers and doers
• We offer many opportunities to grow in your professional skills and career
• We fight homelessness by directing 5% of our earnings from each policy we sell to organizations that help those in need. We call it our Generous Policy.
WHAT WE OFFER
• AssuranceAmerica provides these benefits to Associates:
o 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.
o 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 TeladocTM, Pet Insurance and Health Advocate.
• Additional Benefits:
o 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 Plan. AssuranceAmerica will match 100% of the first 4% of an Associate's contributions.
o Engagement Events. We make time for fun activities that strengthen Associate relationships in all our locations.
o Annual Learning Credit: Want to learn something new? Well reimburse you for approved educational assistance, up to $5,250 annually.
• Time Off:
o Paid Time Off (PTO), Parental Leave Pay, Volunteer Time Off (VTO), Bereavement Pay, Military Leave Pay, and Jury Duty Pay.
This job description indicates the essential responsibilities of the job. The duties described are not to be interpreted as being all-inclusive to any specific associate. Management reserves the right to add to, modify, or change the work assignments of the position as business needs dictate. Reasonable accommodation may be made to enable individuals with disabilities to perform the essential functions of the job. This job description does not represent a contract of employment. Employment with AssuranceAmerica is at-will. The at-will relationship can be terminated at any time, with or without reason or notice by either the employer or the associate.
Reasonable accommodation may be made to enable individuals with disabilities to perform the essential functions.
AssuranceAmerica is an Equal Opportunity Employer