Texas Windstorm Insurance Association · 3 weeks ago
Sr. Data Warehouse Developer
Texas Windstorm Insurance Association (TWIA) is a not-for-profit insurer serving the Texas coast by providing wind and hail coverage. They are seeking a Sr. Data Warehouse Developer to design scalable and resilient solutions in the Data Warehousing and Business Intelligence space to support the organization’s growth.
Responsibilities
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
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 developments 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 POCs
Perform troubleshooting on all ETL processes and resolve issues effectively within IT service level agreement
Leads 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
Leads small scale projects through all phases of System Development Life Cycle (SDLC)/ Agile processes
Qualification
Required
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
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
Company
Texas Windstorm Insurance Association
We at Texas Windstorm Insurance Association (TWIA) recognize the great responsibility that comes with providing insurance that plays an essential role in the lives of many Texans.