Data Developer

Our IT department is currently seeking an experienced Data Developer to build data pipelines that provide peace of mind for people by equipping them to make data-informed business decisions.

Be Ready To:

• develop reliable, reusable, automated and streamlined ETL cod
• analyze and organize raw data from multiple sources to produce requested or required data elements
• design table structures and ETL to build performant data solutions that are scalable in a fast growing data ecosystem
• create reconciliation procedures and data checks to ensure data quality
• build in automated audit, balancing and controls
• provide production support, including on-call rotation and technical assistance to end-user and IT staff
• lead user requirements gathering and documentation designs
• proactively conduct data investigations and assist business partners with complex data analysis and ad-hoc queries
• lead application and technical architecture analysis, design and implementation, and ensure BI product fulfills requirements
• lead efforts with data management and database specialists to troubleshoot and report issues
• design new reporting applications to ensure reporting requests can be supported by the underlying data source
• adhere to all metadata management and data quality standards by leading quality management reviews
• understand configuration dependencies and interrelationships between data warehouse and business intelligence tools and designs; troubleshoot in the area with this knowledge
• proactively identify, build and maintain relationships with business process owners and colleagues
• identify changes in scope or work effort that could result in budgetary overrun or missing of delivery date, design and implement contingency
• demonstrate expert problem solving capabilities
• mentor development team members in design and development of BI solutions

Be Equipped With:

• proven experience in designing and implementing ETL processes (preferred tools: IBM's DataStage, SQL, SAS, Python, Unix)
• proven experience distilling business requirements into data warehouse design artifacts such as a Facts Qualifier Matrix (FQM), source to target maps and star/snowflake schema data models
• preferred five or more years experience with SQL, Data Modeling and Dimensional Modeling
• experience with cloud data technologies/platforms (Azure/Snowflake preferred)
• understanding of enterprise technical landscape (property and casualty insurance background a plus)
• knowledge of developing BI dashboards and reports (preferred tools: IBM's Cognos, Microsoft's Power BI), including data quality scorecards and data lineage
• experience with agile teams
• strong team working skills, an analytical nature, self-motivated and excellent written and oral communication skills
• ability to comprehend complex technical and logical concepts and adapt quickly to changes
• ability to maintain own workflow and meet deadlines while managing parallel project deliverables with minimal direction
• ability to create effective visual models to enable collective understanding of processes, data flow, user interaction and others as needed
• prior reporting application support experience
• track record of successfully architecting small, medium and enterprise-scale solutions

preferred three or more years of business requirements experience