About Us:

American Integrity Insurance, a premier writer of homeowners insurance, has more than 280,000 customers and is exclusively represented by more than 1,000 independent agents who specialize in this complex and ever-evolving market. We offer sound and comprehensive home and dwelling insurance to families throughout the Southeast. Comprised of more than 300 insurance professionals, most of whom work in our Tampa-area headquarters, we have been recognized as a Top Place to Work in Tampa by the Tampa Bay Times and a Best Places to Work in Insurance by Business Insurance magazine for the past ten years. We have also rated among the Top Workplaces in the USA by USA Today for the past four years.

A Day in the Life:

Who Says Insurance Cant Be Fun? From company picnics to charity events, no one can ever say American Integrity Insurance doesnt understand the importance of having fun, helping others and giving back. Our company culture is priceless, and we hold true to our six core values: integrity, commitment, teamwork, humility, passion and fun. As a team working to provide home insurance solutions to our policyholders, together we aim to achieve greater heights each day and celebrate each other's accomplishments along the way. It is our mission to continue providing reliable, customer-centric homeowners insurance and paying claims in a timely manner when our customers suffer a loss and to do so with Integrity.

Learn more about American Integrity Insurance and our job opportunities at https://careers.americanintegrityinsurance.com.

Title: Senior SQL Developer

The Senior SQL Developer will help transform our team into a best-in-class business intelligence unit. He/she will develop and maintain data warehouse, integrate and automate data flows and work with a diverse data sets. The Senior SQL Developer will also develop and drive data management and governance strategies by working directly with all levels of management, lines of business and technology to ensure alignment and dedication to the overall strategic objectives of the organization, in coordination with business intelligence strategies that support business processes and business process improvement initiatives.

Design and develop flexible data solutions to meet ever-changing company needs.
Support the processes to identify, capture and store data in data warehouse structure.
Collaborate with business and technology stakeholders.
Design, Maintain, and Enhance Data Models to support business initiatives.

Design and develop integration/connections to various external and internal data sources.
Design and implement ETL procedures from both internal and outside sources while ensuring data quality.

Support implemented BI solutions and Analytics by monitoring performance, tuning queries, and troubleshooting database issues while upholding high standards of data integrity.

Perform project planning and resource allocation to meet project milestones.
Open, track, and resolve issues with vendors.
Standardize, organize, and document BI processes.
Expertise in ETL and writing stored procedures
Drive and participate in all stages of the development life cycle, from concept to planning, to developing, to testing/debugging, to delivery.

Work within an Agile environment to plan and deliver incremental projects in defined sprints.

Education :

Required: Bachelors Degree in Computer Science or similar.

Experience :

Minimum of 5 years experience in database development & architecture experience
Minimum of five (5) to ten (10) with SSIS projects
Experience in developing a semantic data layer for easy access of business users.
Experience creating logical models and translating into physical database structure. Both existing and proposed.
Strong knowledge and experience with T-SQL, SSIS, SSAS on SQL server, OLAP/PLTP, RDBMS design, dimensional modeling, SQL server, ETL and BI tools.
Demonstrated experience in business intelligence and data warehousing principles, approaches, technologies, and architectures.
Experience with one or more data visualization tools. (Tableau,etc.)
Experience with Cloud platforms and databases (Azure,AWS)
Scripting skills in Powershell
Scripting skills in Python

Good analytical & problem-solving skills and interest in learning and applying new technologies.

Other Skills:

Understanding of data warehouse and relational database concepts such as Kimball and Inmon.
Demonstrated ability to solve problems of diverse scope and working in complex environments.
Proficient in data modeling tools.
Advanced SQL optimization and skills required.
Ability to work in cross functional teams and communicate with colleagues in both business and technical terms.
Performance tuning experience.

Working Conditions: Normal business office environment. Must be able to remain in a stationary position for periods of time while constantly operating a computer and or other office productivity machinery such as a calculator or telephone. The person in this position needs to occasionally move about inside the office to access file cabinets, office machinery or communicate with coworkers. #LI-Onsite

Travel : As required.

ADA : The above statements cover what are generally believed to be the principal and essential functions of this job. Specific circumstances may allow or require some people assigned to the job to perform a somewhat different combination of job duties.

American Integrity Insurance Group is an Equal Opportunity Employer.