Data Engineer (1381)

Farm Credit East
Enfield, CT
United States
Job Description

Be part of a team focused on the success of our customers, the success of our communities, and the success of each other. Farm Credit East is the leading provider of loans and farm advisory services to farm, forest product, fishing, and other agricultural business owners across the northeast. We are One Team Working Together with a focus on our five pillars: Outstanding Customer and Employee Experience, Quality Growth, Operational Excellence, Commitment to our Communities, and Protecting Customer Information.


Position Summary

The Data Engineer is responsible for cleaning, managing, and sharing data that guides business decisions. Using ETL tools you will gather data from a variety of sources, checking for anomalies, automating processes, and generally making it easier for business stakeholders to generate valuable insights. This position will collaborate with internal and external organization to capture requirements, design, create, document, manage, and fulfill requests for on-going and/or ad-hoc reports, dashboards, and scorecards.


Duties and Responsibilities

  • Work with product stakeholders to implement, maintain, and enhance data models and solutions used to define and measure quality of data domains.

  • Design data models to meet requirements.

  • Perform ETL (Extract, Transform, and Load) on data to meet stakeholder specifications.

  • Design and develop data access methods, datasets, views etc.

  • Develops data modeling and is responsible for data acquisition, access analysis, archive, recovery, load design and implementation.

  • Coordinates new data developments to ensure consistency with existing warehouse structure.

  • Collaborates with internal customers to capture requirements, design, create, document, manage and fulfill requests for on-going and/or ad-hoc reports, dashboards, and scorecards.

  • Assists with the development, implementation, and maintenance of front-end presentation (dashboards), automated report solutions and other BI solutions to support tactical and strategic reporting needs of the organization.

  • Assists in identification of data integrity problems and recommends solutions.

  • Work collaboratively with key stakeholders both internally and externally, including but not limited to Senior Management, Business Unit Leaders, Knowledge Exchange, and Farm Credit Financial Partners (FPI).


Job Qualifications/Requirements

  • Bachelor’s Degree in Computer Science, Business, Finance, or other related field from an accredited University.

  • Experience with MSFT SQL Server

  • Proficient in Python, PySpark, Spark SQL

  • Microsoft Azure (Data Bricks, Data Factory, Logic Apps, Functions, etc.)

  • 2 plus years of experience in Finance related informatics, performance measurement, or analysis with strong relational database SQL skills.

  • 1 + years of experience using Microsoft Azure product to perform ETL

  • Familiar with Databricks Unity catalog

  • Salary range: $74,000- $125,000 commensurate with experience