JOIN THE ASSURANCE AMERICA 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.

Data Warehouse Architect/Manager

AssuranceAmerica is seeking an experienced Manager / Architect of Data Warehouse Engineering 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. You will play a pivotal role in delivering scalable, high-performing data solutions that empower Product, Underwriting, Claims, Actuarial, Finance/Accounting, Sales and other business functions with reliable data sources. Your leadership will help drive modernization efforts, leveraging cloud technologies to enhance data-driven decision-making in a highly regulated, data-intensive industry.

About The ROLE

Each day at AssuranceAmerica is different, but as Data Warehouse Architect/Manager in IT you will:

• Lead the design, development, and optimization of data warehouse solutions that support core P&C insurance functions such as Product, Underwriting, Claims, Actuarial, Customer Service, Finance/Accounting, Sales, regulatory reporting, and customer analytics.
• Manage and mentor a team of data warehouse engineers, fostering continuous improvement, technical excellence, and collaboration.
• Architect robust, secure, and scalable data pipelines and models using tools / platforms such as Microsoft Fabric, Microsoft Azure Synapse, SQL Server, Azure Data Factory, and Power BI.
• Partner with departmental teams to understand data requirements and translate them into effective actionable data solutions.
• Oversee ETL/ELT processes to integrate data from third-party data sources.
• Drive adoption of modern data architecture (cloud, data lakehouse, real-time data integration) to improve agility and performance.
• Ensure compliance with regulatory requirements (e.g., state reporting, NAIC guidelines, data privacy laws) in all data warehouse processes.
• Establish and maintain documentation, metadata management, data quality, and governance frameworks.
• Evaluate emerging tools and technologies to continually improve data warehousing capabilities.
• Manage project delivery timelines, budgets, and resource planning across multiple concurrent initiatives.
  
  

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 associates at all levels
• Ability to form strong relationships and work collaboratively
• Propensity to learn new technologies
• Strong oral and written communications skills
  
  

Required

• Minimum 10 years of experience in data warehouse engineering, including experience as an Architect, with a track record of delivering solutions in data-intensive industries (insurance strongly preferred).
• Minimum 5 years of experience managing data warehouse engineering teams.
• Proven expertise with Microsoft cloud / data technologies, including:
• Azure SQL Database / SQL Server / Azure Managed Instance
• Azure Data Factory
• SSIS, SSRS, SSAS
• Power BI
• Demonstrated experience with enterprise-scale data modeling, ETL/ELT design, performance tuning, and data governance.
• Experience working with structured, unstructured, and semi-structured data.
• Excellent leadership, communication, and stakeholder engagement skills.
• Ability to balance technical depth with strategic leadership to align data solutions with business goals.
  

Preferred

• Prior experience delivering data solutions for underwriting, claims analytics, actuarial modeling, or regulatory reporting in a P&C insurance environment.
• Familiarity with data governance tools (e.g., Microsoft Purview) and data privacy regulations relevant to insurance data.
• Industry certifications in Microsoft Azure or related technologies.
• Exposure to big data and advanced analytics technologies (e.g., Databricks, Spark) within the Microsoft stack.
• Experience with Microsoft Fabric
  
  

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 or long hours in case of network malfunction.
  
  

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:
• Premium healthcare plans: All full-time Associates and part-time Associates working a regular schedule of 30 hours, or more, are eligible for day one 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.
• Additional Benefits:
• 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. A ssuranceAmerica will match 100% of the first 4% of an Associate’s contributions.
• Engagement Events. We make time for fun activities that strengthen Associate relationships in all our locations.
• Annual Learning Credit: Want to learn something new? We'll reimburse you for approved educational assistance.
• Time Off:
• Paid Time Off (PTO), Parental Leave Pay, Volunteer Time Off (VTO), Bereavement Pay, Military Leave Pay, and Jury Duty Pay.
  
  

YOU’RE INVITED TO APPLY

We believe the right fit is more important than a checklist. If you have most of what we’re looking for in this role and our culture and mission speak to you, contact us. We want to hear from you!