Integrity, an omnichannel Insurtech company, is seeking a Lead Data Engineer to build, enhance, and maintain a scalable data ecosystem to support their large-scale, complex data implementations and 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.
- Experienced in Master Data Management (MDM) and Snowflake
- Good working knowledge of Microsoft Azure services, including Azure Data Factory (ADF), and Logic Apps
- Experienced in ETL tools such as Talend, Nexla, Stitch, or Mito.
- Knowledge of data orchestration and scheduling tools such as Apache Airflow.
- Certification in Azure, Snowflake and any ETL tools are preferred.
Responsibilities
- Lead the analysis, design, and implementation of data solutions within the Enterprise Data Warehouse (EDW).
- Design, build, and maintain ETL pipelines using Azure Data Factory, Logic Apps, and other modern data tools.
- Conduct Data mapping, Data Collection, Data profiling and Data storage plans to support project/product needs.
- Write efficient T-SQL, DDL/DML scripts, and develop stored procedures, functions, and complex Snowflake procedures.
- Manage the development and maintenance of robust Snowflake and SQL scripts for data extraction and transformation.
- Ensure high-quality, scalable data integration solutions across platforms and business functions.
- Define and execute test strategies, scenarios, and test data for all development deliverables.
Other
- Experienced in leading data engineering team with 5+ years of experience in technical project management within the EDW/BI space.
- Experience successfully leading project-based team.
- Strong analytical, problem-solving, and troubleshooting skills.
- Excellent communication and interpersonal abilities.
- Self-starter with a high level of initiative and drive.
