Senior Data Engineer
Share
Job Location:
White Plains, NY - USA
Monthly Salary:
Not Disclosed
Posted on:
11 days ago
Vacancies:
1 Vacancy
Job Summary
Job Description
Senior Data Engineer
Job Summary
Seeking an experienced Data Engineer to support enterprise-level data initiatives within the insurance and financial services sector. This role focuses on designing and maintaining scalable data pipelines using Azure Data Factory (ADF) and SQL Server Integration Services (SSIS) while ensuring data accuracy performance and reliability across hybrid environments. Experience with AWS and Databricks is highly desirable as the organization continues to expand into multi-cloud and modern analytics platforms.
Key Responsibilities
- Design build and maintain end-to-end data pipelines and ETL processes using Azure Data Factory and SSIS.
- Develop and optimize complex SQL Server stored procedures queries and database schema designs for large-scale data processing.
- Integrate data from multiple sources (cloud and on-premises) to support reporting analytics and operational systems.
- Collaborate with analysts product teams and business stakeholders to define data requirements and deliver accurate efficient solutions.
- Implement and monitor data quality validation and performance-tuning processes.
- Troubleshoot and resolve production data issues ensuring reliability and minimal downtime.
- Support modernization initiatives by migrating or refactoring legacy workflows into cloud-based architectures.
- Maintain detailed documentation of data flows pipelines and integrations.
- Stay current on emerging data technologies and recommend enhancements to improve existing systems.
Qualifications / Requirements
- Bachelors degree in Computer Science Information Systems or a related field (or equivalent experience).
- Minimum of 7 years of hands-on experience in data engineering or related disciplines.
- Proven expertise with Azure Data Factory and SSIS for ETL/ELT pipeline development.
- Strong proficiency in SQL Server including stored procedures schema design and performance tuning.
- Solid understanding of data modeling relational databases and integration best practices.
- Experience within highly regulated industries such as insurance financial services or healthcare is a plus.
- Excellent analytical troubleshooting and communication skills.
Preferred Qualifications
- Experience with AWS data services (e.g. Redshift Glue S3) and/or Databricks.
- Familiarity with Python for scripting and pipeline automation.
- Knowledge of Power BI or Tableau for reporting and visualization.
- Exposure to version control (Git) and CI/CD pipelines for data operations.
Disclaimer: Please note that this job description may not cover all duties responsibilities or aspects of the role and it is subject to modification at the employers discretion.
#LI-MC1
Required Experience:
Senior IC
Key Skills
- Apache Hive
- S3
- Hadoop
- Redshift
- Spark
- AWS
- Apache Pig
- NoSQL
- Big Data
- Data Warehouse
- Kafka
- Scala
About Company
The Jonus Group #1 Career Coaching Employment Agency - Best Mock Interviews, Linkedin Profile Optimization, Social Media Job Seekers, Outplacement Services, Career Goal Coach.
