Data Architect Job at Farm Credit East
Description/Job Summary
Farm Credit East is the leading provider of loans and financial accounting services to farmers, foresters, fishermen, and agricultural business owners across the northeast. The Farm Credit cooperative has been around for over 100 years and has grown into a program with $10 billion in loan volume and $20 million in financial services revenue generated annually. When you pursue a career with Farm Credit East, you can positively impact the families and businesses that drive the Northeast economy. We offer a hybrid workplace after six months.
As a Data Architect , you will be a member of the Data team within the Association’s Risk Management and Technology groups. The Data Architect is responsible for developing SQL Server reporting databases, data marts, and access methods to suport the analystcs and reporting function at Farm Credit East. This position will collaborate with internal and external stakeholders to capture requirements, design, create, document, manage and fulfill requests for on-going and/or ad-hoc reports, dashboards, scorecards, and analytics.
Duties and Responsibilities
Reverse engineer legacy data marts using industry standard modeling tools.
Design data models to meet business requirements for analytics and reporting
Document requirements for new databases by collaborations with business unit leaders
Project oversight for the introduction of new data sources as requested by business units
Oversight of projects to synchronize data between applications
Oversight of changes to data within core systems
Design and collaborate on data flow ETL logic for data movement
Design and develop data access methods, datasets, views etc. using industry standard tools.
Coordinate with other team members to understand legacy systems and effectively communicate downstream impacts to changes in data schema
Develop data access methods to support request management, reporting, and project needs.
Develop data modeling and collaborate with business units on data acquisitions, access analysis, archive, recovery, load design and implementation.
Coordinate new data developments to ensure consistency with existing warehouse structure.
Assist 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 recommend 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
Knowledge of MSFT Azure (Data Bricks, Data Factory, and Power BI)
Expertise in a modelling and design tool is a must, such as, Erwin, Power Designer, etc.
3 plus years of experience in Finance related informatics, performance measurement, or analysis with strong relational database SQL skills.
2 plus years of experience in designing and developing performance measurement data marts and automated reporting systems.
Experience within a financial institution and knowledge of data needs and structures is a plus.
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, age, marital status, 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 .
Please Note :
chrismaxcer.com is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, chrismaxcer.com provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, Site.com is the ideal place to find your next job.
Farm Credit East is the leading provider of loans and financial accounting services to farmers, foresters, fishermen, and agricultural business owners across the northeast. The Farm Credit cooperative has been around for over 100 years and has grown into a program with $10 billion in loan volume and $20 million in financial services revenue generated annually. When you pursue a career with Farm Credit East, you can positively impact the families and businesses that drive the Northeast economy. We offer a hybrid workplace after six months.
As a Data Architect , you will be a member of the Data team within the Association’s Risk Management and Technology groups. The Data Architect is responsible for developing SQL Server reporting databases, data marts, and access methods to suport the analystcs and reporting function at Farm Credit East. This position will collaborate with internal and external stakeholders to capture requirements, design, create, document, manage and fulfill requests for on-going and/or ad-hoc reports, dashboards, scorecards, and analytics.
Duties and Responsibilities
Reverse engineer legacy data marts using industry standard modeling tools.
Design data models to meet business requirements for analytics and reporting
Document requirements for new databases by collaborations with business unit leaders
Project oversight for the introduction of new data sources as requested by business units
Oversight of projects to synchronize data between applications
Oversight of changes to data within core systems
Design and collaborate on data flow ETL logic for data movement
Design and develop data access methods, datasets, views etc. using industry standard tools.
Coordinate with other team members to understand legacy systems and effectively communicate downstream impacts to changes in data schema
Develop data access methods to support request management, reporting, and project needs.
Develop data modeling and collaborate with business units on data acquisitions, access analysis, archive, recovery, load design and implementation.
Coordinate new data developments to ensure consistency with existing warehouse structure.
Assist 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 recommend 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
Knowledge of MSFT Azure (Data Bricks, Data Factory, and Power BI)
Expertise in a modelling and design tool is a must, such as, Erwin, Power Designer, etc.
3 plus years of experience in Finance related informatics, performance measurement, or analysis with strong relational database SQL skills.
2 plus years of experience in designing and developing performance measurement data marts and automated reporting systems.
Experience within a financial institution and knowledge of data needs and structures is a plus.
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, age, marital status, 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 .
Please Note :
chrismaxcer.com is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, chrismaxcer.com provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, Site.com is the ideal place to find your next job.