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
- 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
About the Company: Expert In Recruitment Solutions
Apply To This Job