Data Warehouse Architect/Manager Position Available In Fulton, Georgia

Data Warehouse Architect/Manager AssuranceAmerica – 3.3

Atlanta, GA Job Details Full-time Estimated:

$114K – $147K a year 3 hours ago Qualifications Performance tuning Power BI Data modeling Management Underwriting 5 years Big data Spark Regulatory reporting Microsoft SQL Server SSRS Data governance

SQL ETL SSIS

Senior level Leadership Communication skills Data warehouse Analytics Full Job 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. 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 highlyregulated, data-intensive industry. 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 1 0 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.