Data Engineer
Date: Dec 1, 2023
Location: Enfield, CT, US, 06082
Company: Farm Credit East
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
Farm Credit East is an Equal Opportunity Employer. As an Equal Opportunity Employer, we do not discriminate on the basis of race, color, religion, national origin, sex, sexual orientation, gender identity or expression, age, marital status, parental status, political affiliation, disability status, protected veteran status, genetic information or any other status protected by federal, state or local law. It is our goal to make employment decisions that further the principle of equal employment opportunity by utilizing objective standards based upon an individual's qualifications for a specific job opening. In compliance with the Americans with Disabilities Act (“ADA”), if you have a disability and would like a reasonable accommodation in order to apply for a position with Farm Credit East, please call 1-800-562-2235 or e-mail FarmCreditCareers@farmcrediteast.com.
Nearest Major Market: Hartford