Job summary
Job post source
This job is directly from AssuranceAmerica
Job overview
The Data Warehouse Architect/Manager at AssuranceAmerica leads the design and management of data warehouse solutions to support core insurance functions, driving modernization and data-driven decision-making.
Responsibilities and impact
The role involves leading data warehouse design, managing a team, architecting data pipelines using Microsoft Azure tools, partnering with departments for data solutions, overseeing ETL/ELT processes, ensuring regulatory compliance, and managing project delivery.
Experience and skills
Requires minimum 10 years in data warehouse engineering with architect experience, 5 years managing teams, expertise in Microsoft Azure data technologies, enterprise-scale data modeling, ETL/ELT design, and strong leadership and communication skills; insurance industry experience preferred.
Work environment and culture
AssuranceAmerica values diversity, impact of ideas, and collaboration in a fast-paced environment where employees are motivated problem solvers and continuous learners.
Company information
AssuranceAmerica is a property and casualty insurance company with over 25 years of experience, providing products through agents and direct customers, focusing on technology transformation in insurance.
Team overview
The candidate will join a small team of experienced IT professionals working closely with stakeholders across business functions.
Unique job features
The role offers the opportunity to work with modern cloud data technologies like Microsoft Fabric and Azure Synapse, focusing on scalable, secure data solutions in a regulated insurance industry.
Company overview
AssuranceAmerica Corp is a provider of affordable auto insurance primarily targeting the non-standard market, which includes drivers who may have difficulty obtaining insurance from standard carriers due to factors like driving history or credit score. The company generates revenue through underwriting insurance policies and collecting premiums, as well as through investment income from its portfolio. Founded in 1998, AssuranceAmerica has grown by focusing on underserved markets and leveraging technology to streamline operations and improve customer service.
How to land this job
Tailor your resume to emphasize extensive experience in data warehouse architecture and management, particularly highlighting leadership roles and successful delivery of data solutions in insurance or similarly regulated industries.
Focus on showcasing expertise with Microsoft Azure technologies such as Azure SQL Database, Azure Data Factory, SSIS, SSRS, SSAS, and Power BI, as well as your skills in cloud data modernization and governance frameworks.
Apply through multiple channels including AssuranceAmerica’s official corporate careers page and LinkedIn to maximize your application’s visibility and ensure it reaches the right hiring managers.
Connect with current AssuranceAmerica IT or data warehouse team members on LinkedIn, using ice breakers like commenting on recent company initiatives around cloud modernization or asking about their experiences working on data solutions for P&C insurance.
Optimize your resume for ATS by incorporating keywords from the job description such as 'data warehouse architect,' 'Azure Data Factory,' 'ETL/ELT,' 'data governance,' 'Power BI,' and 'cloud data modernization' to ensure it passes automated screenings.
Leverage Jennie Johnson's Power Apply feature to automate tailored resume creation, identify the best application portals, and discover relevant LinkedIn connections, allowing you to focus your energy on preparing for interviews and networking.
Jennie Johnson works for you!
Here’s what we do to make sure you’re successful:
Targeted Resume Revamp:
We expertly craft your resume to navigate Applicant Tracking Systems (ATS) and showcase your qualifications, making you stand out as a top-tier candidate.
Job Description Dissection:
Unpack the job posting with expert analysis, ensuring your application hits every key requirement.
Bespoke Cover Letter:
Capture the attention of hiring managers with a personalized cover letter that highlights how your skills align perfectly with the job's needs.
Interview Mastery:
Prepare for interviews like a pro with likely questions, strategic answers, and insightful questions for you to ask, setting you apart as an informed candidate.
Direct Application Insights:
Receive tailored advice on the best places to apply, ensuring your applications are seen by the right employers.
Skills and Gaps Assessment:
Identify and close critical skills gaps to position yourself as the best-fit candidate for your ideal job.
Personalized Email Pitch:
Make a memorable first impression with an email template crafted to engage potential employers and initiate meaningful conversations.
In-depth Research Guide:
Leverage comprehensive research tools to gather effective insights on companies, industry trends, and role-specific challenges.
Detailed Company Analysis:
Gain in-depth understanding of your prospective employer, giving you the edge in applications and interviews.
Strategic Candidate Overview:
Understand your unique value and why companies would want to interview you, highlighting your background and positioning.