Senior Data Engineer

Data Engineer

Smithfield, Rhode Island- preferred location - gets first consideration

Data is moving in 2 ways in this group

1. Oracle (or other RDBMS) to Oracle

2. Oracle to Snowflake

• Candidates must have advanced levels of Oracle and be able to read Oracle SQL/PLSQL.
• Need to know RDBMS database, modeling, ETL and SQL concepts
• Expertise in Oracle is a must to read logic, schema, stored procedures
• AWS data engineering services, is a must (batch, EMR, S3, glue, lambda, etc
• Snowflake is a nice to have but will be first considered
• Informatica is a must (need ETL concepts
• Unix/Python for scripting is a must
• Spark is a nice to have

The Role

This is a Data engineer position for a development Chapter in ET. Looking for a hardworking, highly motivated Lead Engineer with strong expertise in analyzing existing solutions, designing new solutions and helping team members in building robust and scalable solutions using the best software design & development practices.

In this role, you will be responsible for the leading, engineering & developing quality software components and applications for brokerage products. You will build, modernize, and maintain Core & Common tools and Data Solutions. You will also apply and adopt variety of cloud-native technologies for the products. In addition to building software, you will have an opportunity to help define and implement development practices, standards and strategies.

This position can be located in Merrimack NH, Smithfield RI or Westlake TX

The Expertise and Skills You

• BringDesign, develop, and maintain data pipelines and ETL processes using Oracle, Snowflake, and Aws batch, Python.
• Responsible for System analysis including analyzing system requirements, identifying system specifications.
• Implement and manage data integration solutions to ensure seamless data flow across systems.Develop and optimize Unix shell scripts for automation and data processing tasks.
• Utilize AWS Batch for scheduling and executing ETL pipelines and batch processing jobs.
• Implement CI/CD pipelines using tools like Jenkins, Git, and Artifactory to automate deployment and integration processes.
• Collaborate with cross-functional teams to understand data requirements and deliver solutions that meet business needs.
• Ensure data quality, integrity, and security across all data platforms.
• Troubleshoot and resolve data-related issues in a timely manner.
• Document data engineering processes and maintain comprehensive technical documentation.
• Strong experience with Oracle databases and Snowflake data warehousing.
• Proficiency in Unix and shell scripting.
• Hands-on experience with AWS Data Engineering services including AWS Batch, S3, EMR, EC2 Expertise in Informatica for data integration and ETL processes.
• Solid understanding of data modeling and data architecture principles.
• Strong SQL skills for data querying and manipulation.
• Familiarity with CI/CD tools such as Jenkins, Git, and Artifactory.
• Knowledge of data governance and data quality best practices.
• Knowledge of Python for data processing and automation.Experience with big data technologies (e.g., Hadoop, Spark).
• Solid understanding of data warehousing concepts and ETL processes.
• Excellent analytical and problem-solving skills.Ability to work independently and as part of a team in a fast-paced environment.
• Strong communication and collaboration skills.
• Ability to translate business requirements into data-driven solutions.
• Strong communication skills to convey data insights to non-technical stakeholders
• Ability to analyze large datasets to identify trends and insights.
• Proficiency preferred in developing and maintaining dashboards and reports using data visualization tools (e.g., Tableau, Power BI).

The Value You Deliver

Excellent problem-solving and analyticalskills.

Strong communication skills to effectively collaborate with technical and non-technical stakeholders.

Ability to work independently and as part of a team.

• Detail-oriented with a focus on delivering high-quality work.
• Adaptability to work in a fast-paced and dynamic environment.
• Collaborative mindset with a willingness to share knowledge and mentor team members.
• Ability to work effectively in cross-functional teams and contribute to team success.

Open to feedback and continuous improvement.