Integrity is seeking a Senior Data Engineer to lead and support the development of large-scale, complex data implementations within the insurance industry, aiming to build, enhance, and maintain a scalable data ecosystem.
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.
- Certification in Azure and PowerBI are preferred.
- Certification on any AI tool and solutions are preferred.
Responsibilities
- Lead the analysis, design, and implementation of data solutions within the Enterprise Data Warehouse (EDW).
- 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.
- Conduct testing and validation, including unit testing, integrated testing, UAT support, and production incident resolution.
Other
- Collaborate with business and cross-functional teams to gather and analyze requirements, perform impact analysis, and define solution approaches.
- Prepare and maintain project documentation, such as design specs, release plans, flowcharts, and presentation materials; participate in code reviews and mentor team members.
- Strong analytical, problem-solving, and troubleshooting skills.
- Excellent communication, leadership, and interpersonal abilities.
- Self-starter with a high level of initiative and drive.
