Data Warehouse Developer

Data Warehouse Developer at Texas Windstorm Insurance Association

Join a team where your work truly makes an impact. In this role, you’ll leverage your expertise in Data Warehousing and Business Intelligence to design scalable, flexible, and resilient data solutions that support the continued growth and mission of TWIA/TFPA. You’ll play a key role in transforming data from multiple sources into meaningful insights, powering critical decision-making across the organization. Working closely with teams throughout our Property & Casualty insurance business, you’ll help deliver accurate, actionable intelligence to a wide range of stakeholders—turning complex data into real business value. If you’re passionate about building data-driven solutions and collaborating across the enterprise, this is an opportunity to make a lasting impact.

Candidates selected for the Data Warehouse Developer position with TWIA/TFPA will be placed at a level that aligns with their demonstrated skills, competencies, and professional experience.

Primary Responsibilities:

Strategic:

• Develops recommendations and conducts analysis in support of department and business line strategic efforts.
• Confers with client, technical staff, and team members to plan, design, develop, implement, and enhance applications, scripts, procedures, and metadata for relational databases.
• Champions enterprise data management best practices & provides recommendations for data architecture structure and standards.
• Participates in end-to-end architecture & data warehouse life cycle management activities & provides recommendations.
• Manages numerous requests concurrently and strategically, prioritizing when necessary.

Tactical:

• Designs, develops, and implements the data architecture for a data warehouse, including high-performance ETL (Extract, Transform, and Load) tools and routines and the infrastructure.
• Recognizes and leverages data sources both internally and externally to enhance analysis capabilities.
• Reverse engineers data specifications from source systems through data discovery, analysis, and other techniques.
• Develops and maintains Data Models, including Enterprise Data Dictionary.
• Establishes methods and procedures for tracking data quality, completeness, redundancy, and improvement.
• Participates with application and infrastructure design architects to provide guidance for development and releases.
• Influences technology direction and/or adjustments to incorporate into business plans.
• Influences the selection of hardware and software product standards and the design of standard configurations; makes significant contributions to market-centric technology roadmaps and architectural principles and frameworks.
• Reviews and ensures major architectural designs are consistent, maintainable, flexible, and cost-effective solutions.
• Leads retrospectives and defines opportunities for experiments and POCs.
• Performs troubleshooting on all ETL processes and resolves issues effectively within IT service level agreements.
• Leads by example, engaging hands-on in complex data challenges and Information Management projects to derive deep insights from data.
• Oversees business intelligence/data warehouse security and data load and implementation strategies.
• Leads enterprise projects through all phases of System Development Life Cycle (SDLC)/ Agile process.
• Performs other duties as assigned.

Required Skills:

• Four-year college degree, preferably in CS, engineering, or other technical field, or equivalent experience.
• 7-12 years of directly relevant experience in Data Warehouse/Business Intelligence.
• 3-8 years of hands-on experience in building ETL, reporting, and Data Visualization solutions using tools (Ex: SAP Data Services, Informatica, Data Stage, Microsoft SSIS packages, QlikView, Tableau etc.).
• 1-5 years of work experience in Guidewire Data Management tools.
• Experience in building conceptual, logical, and physical data modeling; dimensional modeling preferred.
• Significant experience in software development processes and best practices.
• Understanding of business operations - preferably property and casualty insurance.
• Clear, effective verbal and written communication skills, including the ability to actively listen, problem-solve, and communicate with both technical and business users.
• Demonstrated experience working both as an individual contributor and as part of a team.
• Experience in providing guidance to junior developers, quality assurance, and business analysts.
• Attention to detail with self-discipline, strong ownership and accountability, and drive for results.

Preferred Skills:

• Familiarity with agile methodology.
• Certifications in P&C and IT domains.
• Experience in building Master Data Management & Data Governance desired.
• Experience in JAVA programming, reverse engineer source code.

Why work with TWIA?

The Association offers a comprehensive and competitive benefits package designed to support both your professional success and personal well-being. A key highlight of our offering is a fully remote work environment, allowing you to contribute from home with no relocation required.

In addition to our benefits, Texas Windstorm Insurance Association fosters a collaborative and mission-driven work environment where employees are valued, supported, and encouraged to grow. Our teams work closely across departments, promoting transparency, innovation, and a shared commitment to serving our policyholders and communities.

Employees also enjoy:

• Comprehensive medical, dental, vision, group life, AD&D, and dependent life insurance coverage
• Flexible Spending Accounts (FSA) and Health Savings Accounts (HSA)
• A 401(k) retirement plan with employer matching contributions up to 6%, in addition to a pension plan
• Performance-based incentives, ongoing training and professional development, and certification support
• Generous paid time off, including vacation, sick leave, paid holidays, and personal days
• Flexible scheduling to support work-life balance

Key skills/competency

• Data Warehousing
• Business Intelligence
• ETL Development
• Data Modeling
• SQL
• Data Visualization
• Data Architecture
• System Development Life Cycle (SDLC)
• Agile Methodologies
• Property and Casualty Insurance