Integrity is seeking to improve its data engineering capabilities to drive innovation in the insurance industry
Requirements
- Skilled in advanced SQL, including query optimization and stored procedure development
- Knowledge of enterprise data warehousing, data modeling, and analytics best practices
- Good working knowledge of Microsoft Azure services, including Azure Data Factory (ADF), Logic Apps, and Power BI
- Experienced in ETL tools such as Talend, Nexla, Stitch, or Mito
- Knowledge of data orchestration and scheduling tools such as Apache Airflow
- Strong analytical, problem-solving, and troubleshooting skills
- Certification in Azure and PowerBI are preferred
Responsibilities
- Lead the analysis, design, and implementation of data solutions within the Enterprise Data Warehouse (EDW)
- Collaborate with business and cross-functional teams to gather and analyze requirements, perform impact analysis, and define solution approaches
- Design, develop, implement and maintain data solutions, including ETL pipelines using Azure Data Factory, Talend, Nexla and Snowflake
- Perform data modeling and performance tuning for Enterprise Data Lake/Warehouse systems and ensure data quality and accuracy
- Develop Power BI dashboards and Freeform SQL reports to support data-driven decision-making
- Write efficient T-SQL, DDL/DML scripts, and develop stored procedures, functions, and complex Snowflake procedures
- Support Agile development lifecycle, including sprint planning, user story estimation, daily scrums, testing and retrospective meetings
Other
- A bachelor’s degree in Computer Science, Data Engineering, Information Systems, or related field is required
- 7+ years of experience in data engineering or a related field
- Excellent communication, leadership, and interpersonal abilities
- Self-starter with a high level of initiative and drive
- Certification on any AI tool and solutions are preferred
