Business Intelligence Data Warehouse Developer

Business Intelligence Data Warehouse Developer

Join to apply for the Business Intelligence Data Warehouse Developer role at Farm Credit Services of America

Job Summary

We are seeking a Business Intelligence Data Warehouse Developer who will lead the architecture, technical design, evaluation and administration of existing and proposed data warehouse and business intelligence systems by providing system expertise including domain knowledge.

Design, develop, and maintain the corporate data, cloud data warehouse and business intelligence solutions within the Associations. Monitor existing cloud data warehouses and perform system enhancements to ensure optimal performance to meet business requirements. Lead continuous improvement efforts by enhancing performance, providing increased functionality, and supporting business intelligence systems based on current and future business needs. Foster collaboration with business analysts, developers and product owners to ensure they are working towards the same vision and goals. Provide technical leadership, mentoring, and support to project team members.

Essential Duties & Responsibilities

• Meet with business teams to understand future business needs and translate business requirements into data models that integrate with the cloud data warehouse. Work collaboratively with business and technology stakeholders to establish, communicate, and maintain the cloud data warehouse architecture. Architect and assist in the design and development of ETL standards, policies, procedures, and metadata to ensure accuracy, consistency, integrity, and optimization of the information in the cloud data warehouse.
• Promote a highly collaborative team environment following the Agile methodology to assist developers in the successful accomplishment of strategic and divisional objectives. Take the necessary steps to ensure our customers' needs are met to the maximum extent possible in an accurate and timely manner. Lead and perform coding efforts to provide a high level of data integrity, security, and availability for internal and external customers. Mentor, support and provide direction to less experienced teammates.
• Analyze future data warehouse requirements and develop long-term strategies for data warehousing and business intelligence usage while maintaining an effective and consolidated environment. Apply knowledge of Snowflake data warehouses to maintain consistent peak performance and proper secure access. Communicate proposed changes and promote collaboration while providing guidance and contributing to the development of business intelligence projects. Facilitate the architecture of discussions and communications with the team to ensure the team understands the goals and objectives of each development stream and how they affect the system as a whole.
• Provide support on production systems and collaborate to define and correct defects. Identify and effectively resolve data warehouse performance concerns, capacity requirements, environment migrations, and other data warehouse enhancement opportunities. Work with business analysts and developers to develop adequate testing procedures for data warehouse enhancements and data corrections. Provide expertise regarding data movement and management tools to administer and maintain data confidentiality, integrity, and availability in all database environments.
• Maintain accepted best practices and standards regarding the development, security, and utilization of all business intelligence systems.

Education Requirements

Bachelor's degree in Computer Science, MIS, Finance or Statistics preferred.

Years of Experience

6+ years of experience in data warehouse and / or business intelligence development, or comparable IT field.

Certification and Technical Requirements

About Us

AgCountry has 45 offices, is based in Fargo, North Dakota and serves portions of North Dakota, Minnesota, and Wisconsin; FCSAmerica is based in Omaha, NE and has 42 local offices; Frontier Farm Credit has six offices serving eastern Kansas. Together, we support nearly 82,000 producers and agribusinesses, meeting the needs of todays agricultural industry with our combined 2600+ employees providing lending, risk management, technology, commodity marketing, and customer and employee education.

Equal Employment Opportunity Statement

AgCountry Farm Credit Services, ACA, Farm Credit Services of America, ACA, and Frontier Farm Credit, ACA are Equal Employment Opportunity employers, and they comply with all applicable federal, state, and local fair employment practices laws.

#J-18808-Ljbffr