Data Warehouse Developer

Texas Windstorm Insurance Association (TWIA) is a not-for-profit, residual market insurer that serves the communities of the Texas coast by providing wind and hail coverage when other insurers will not. We are seeking talented Data Warehouse professionals to fill mid to senior level/lead roles within our information technology organization.

If you are a Data Warehouse professional looking for long-term, permanent employment please review the position description and apply below. Texas Windstorm Insurance Association is not able to sponsor visas currently.

POSITION SUMMARY: In this role, the candidate will work in Data Warehousing and Business Intelligence/Analytics space to design scalable, flexible, and resilient solutions to support TWIA/TFPA's continued growth and mission. Our BI systems aggregate information from numerous sources and provide management information to stakeholders throughout the company. As such, we frequently partner with various departments in TWIA/TFPA Property & Casualty Insurance companies to deliver accurate, actionable information to a diverse group of stakeholders.

ESSENTIAL FUNCTIONS: The following are the usual, basic and essential functions of the position. however, this job description does not preclude the performance of other duties by the incumbent. These functions are not to be construed as an exhaustive list of all responsibilities, duties, and skills required:

Primary Responsibilities:

Strategic:

• Develops recommendation 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.
• Participate in end-to-end architecture & data warehouse life cycle management activities & provides recommendations.
• Manage numerous requests concurrently and strategically, prioritizing when necessary.

Tactical:

• Develops, and implements the data architecture for a data warehouse, including high-performance ETL (Extract, Transform, and Load) tools and routines and the infrastructure.
• Recognize and leverage data sources both internally and externally to enhance the 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.
• Participates to ensure major architectural designs are consistent, maintainable, flexible and cost effective solutions.
• Leads retrospectives and defines opportunities for experiments and POC`s.
• Perform troubleshooting on all ETL processes and resolve issues effectively within IT service level agreements.
• Lead by example, engaging hands-on in complex data challenges and Information Management projects to derive deep insights from data.
• Implements business intelligence/data warehouse security and data load and implementation strategies.
• Lead small scale projects through all phases of System Development Life Cycle (SDLC)/ Agile process.

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-3+ 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.
• Enthusiasm in providing guidance to developers, quality assurance, and business analysts.
• Attention to detail with self-discipline, strong ownership and accountability and drive for results.

PREFERRED EDUCATION AND EXPERIENCE:

• Familiarity with agile methodology.
• Certifications in P&C and IT domains.
• Experience in financial or property and casualty insurance industry.
• Experience in JAVA programming, reverse engineer source code.