Integrity is seeking to lead and support the development of large-scale, complex data implementations within their Enterprise Data Warehouse (EDW) to drive innovation in the insurance industry.
Requirements
- advanced SQL, including query optimization and stored procedure development.
- enterprise data warehousing, data modeling, and analytics best practices.
- leading data engineering team with 5+ years of experience in technical project management within the EDW/BI space.
- Master Data Management (MDM) and Snowflake
- Microsoft Azure services, including Azure Data Factory (ADF), and Logic Apps
- ETL tools such as Talend, Nexla, Stitch, or Mito.
- data orchestration and scheduling tools such as Apache Airflow.
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
- Experience managing distributed teams (onsite, remote, and international)
- Strong analytical, problem-solving, and troubleshooting skills.
- Excellent communication and interpersonal abilities.
- Self-starter with a high level of initiative and drive.
- Bachelor’s degree in Computer Science, Data Engineering, Information Systems, or related field is required.
