Senior Data Engineer
Whitehouse Station, NJ, United States
We are looking for an experienced and motivated Senior Data Engineer to join our dynamic team. In this role, you will participate in the delivery of key projects in support of North America Data Delivery team with focus on MDM projects. You will be responsible for leading ETL development projects, coordinating with cross-functional teams to ensure project success, and creating and maintaining data integration solutions to meet business requirements. The ideal candidate will have experience with ETL development solutions such as Informatics MDM, Azure Data Factory, Snowflake, Informatica/IICS and be able to identify and resolve data quality issues, performance bottlenecks, and other ETL-related problems.
In this role, you will:
- Lead ETL development projects and coordinate with cross-functional teams to ensure project success
- Create and maintain data integration solutions to meet business requirements
- Identify and resolve data quality issues, performance bottlenecks, and other ETL-related problems
- Design and develop scalable ETL workflows and data pipelines using ETL tools such as Informatica/IICS
- Ensure compliance with data governance and security policies
- Develop and maintain documentation such as technical design documents, data lineage, and ETL runbooks
- Evaluate modern technologies and tools, and recommend solutions to improve ETL processes and performance
- Contribute to the architecture, design, and development of data warehousing and business intelligence solutions
- Understands data mapping and data modeling methodologies including normal form, star, and snowflake to reduce data redundancy and improve data integrity.
- Participate in analysis, design, and ETL development as part of Agile development methodologies and provide status updates to the management
- Maintains knowledge on current and emerging developments/trends for assigned area(s) of responsibility, assesses the impact, and collaborates with Scrum Team and Leadership to incorporate current trends and developments in current and future solutions
- Bachelor’s degree or equivalent work experience (4 years of experience in lieu of Bachelors)
- At least 5+ years of Strong understanding of ETL development concepts and tools such as ETL development solutions (e.g., Informatica MDM, Azure Data Factory, Snowflake, Informatica/IICS)
- Experience with Data Warehousing and Business Intelligence concepts and technologies
- Strong knowledge of SQL and advanced programming languages such as Python and Java
- Demonstrated critical thinking skills and the ability to identify and resolve data quality issues, performance bottlenecks, and other ETL-related problems
- Experience with Agile methodologies and project-management skills
- Excellent communication and interpersonal skills
- Ability to mentor and provide technical guidance to junior ETL developers
- Experience with cloud based environment required.
- 2+ years of experience in scheduling jobs using Autosys (or comparable distributed scheduler)
- 3+ years of experience writing Unix/Linux or Windows Scripts in tools such as PERL, Shell script, Python, etc.
- 3+ years of experience in creating complex technical specifications from business requirements/specifications
At Chubb, we are committed to equal employment opportunity and compliance with all laws and regulations pertaining to it. Our policy is to provide employment, training, compensation, promotion, and other conditions or opportunities of employment, without regard to race, color, religious creed, sex, gender, gender identity, gender expression, sexual orientation, marital status, national origin, ancestry, mental and physical disability, medical condition, genetic information, military and veteran status, age, and pregnancy or any other characteristic protected by law. Performance and qualifications are the only basis upon which we hire, assign, promote, compensate, develop and retain employees. Chubb prohibits all unlawful discrimination, harassment and retaliation against any individual who reports discrimination or harassment.
* Salary range is an estimate based on our AI, ML, Data Science Salary Index 💰
Tags: Agile Architecture Azure Business Intelligence Data governance Data pipelines Data quality Data Warehousing ETL Informatica Java Linux Perl Pipelines Python Scrum Security Snowflake SQL
Perks/benefits: Insurance
More jobs like this
Explore more career opportunities
Find even more open roles below ordered by popularity of job title or skills/products/technologies used.