HireFT
Browse JobsHow it worksPricingSuccess Stories
    Back to jobs
    AS

    AssuranceAmerica

    Insurance

    Data Warehouse Engineer III

    US TX Remote, United StatesFull-time7+ yrs experiencePosted 3mo ago
    All AssuranceAmerica jobs

    Job description

    About the ROLE

    Each day at AssuranceAmerica is different, but as a Data Warehouse Engineer III in Information Technology, you will:

    • Assist with research, recommendations, and implementation of newer Azure / Cloud based technologies to replace legacy data warehouse systems and processes

    • Assist with research, recommendations, and implementation of newer Azure / Cloud based technologies to replace legacy data warehouse systems and processes including: SQL Server on Azure Cloud, Azure DevOps, Microsoft Fabric, Data Warehouse, Lakehouse and Onelake, Azure Data Factory

    • Develop ETL packages or pipelines for translation and movement of data between vendor systems and the Data Warehouse.

    • Build, extend and maintain SSAS OLAP cubes.

    • Proactively communicate directly with business representatives to extract requirements and review work in progress.

    • Assist in monitoring production jobs, correcting failures, troubleshooting and solving problems

    • Manage break/fix events and drive solutions to correct and prevent recurring issues

    • Monitor and improve overall health of the data warehouse environment

    • Communicate data warehouse related issues, changes and outages to department manager and end-user community

    • Recommend standards, procedures, and policies that help both the internal group as well as other operations and customer groups

    • Organize work schedule to achieve timely processing of all responsibilities

    • Identify opportunities to improve the Business

    • Demonstrate a proactive and self-motivated approach to learning new technologies and techniques to enhance development skills.

    Job Qualifications

    Formal Education & Certification

    Requires a 4 year degree in a related technical area or equivalent experience

    Knowledge & Experience

    • 7+ years of experience as a SQL / Data Warehouse Developer, Engineer, Architect in a SQL Server or equivalent relational database environment.

    • Strong knowledge of and experience with SQL (candidates will be tested).

    • Must be able to create and optimize stored procedures, functions, and/or pipelines for ETL development.

    • Experience with SSRS (or equivalent reporting tools).

    • Ability to design, develop, tune, and maintain OLAP cubes using Microsoft SSAS is strongly preferred. Experience with Azure Cloud and Microsoft Fabric is preferred.

    • Understanding data modeling, dimensional warehouse design, and the Kimball method is a plus.

    Skills & Competencies

    • Ability to work in a fast-paced automated production environment. 

    • Auto insurance experience preferred. 

    • Good oral and written communications skills. 

    • Well-developed critical thinking skills. 

    • Works as a team player throughout the company. 

    • Must be professional and maintain an acceptable level of integrity and professionalism.

    Job details are sourced from the employer's original posting.

    Open job posting
    AS

    About the company

    AssuranceAmerica

    AssuranceAmerica is a leader in the non-standard auto insurance space.

    View all AssuranceAmerica jobs
    Industry
    Insurance
    Open roles
    75

    Interested in this role?

    Apply with HireFT

    Free to start — no card required.

    Your fit

    How well do you match?

    Sign in to see how your résumé lines up with this role.