Business Intelligence Data Warehouse Developer
Omaha, NE, US, 68137-2210
AgCountry Farm Credit Services (AgCountry), Farm Credit Services of America (FCSAmerica) and Frontier Farm Credit are financial cooperatives that operate under shared management across eight states. While each association is owned by its local farmers and ranchers, they collaborate by pooling resources, expertise, and talent to provide affordable credit, crop insurance, and financial services.
Our associations are united by a common mission and commitment to serving rural America and supporting each other, which drives the success of the farmers, ranchers, and agribusiness we serve. We take pride in being a great place to work, and this enthusiasm is reflected in the relationships our team members foster with one another and with our customers.
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 help translate business requirements into the appropriate 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 with 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
- Strong computer literacy and proficiency in data manipulation and reporting tools with demonstrated and highly skilled knowledge of Snowflake, SSAS, and PowerBI.
- High-level proficiency with database and data warehouse development including replication, staging, ETL, stored procedures, partitioning, change data capture, scheduling tools, cubes, and data marts.
- Experience with software as a service data platform such as Snowflake and semantic layers such as SSAS.
- High-level proficiency with database, dashboard and report development using Visual Studio, source control tools, Excel Services, PowerBI or Tableau and data modeling tools.
- Experience in providing sound technical advice to leadership and other staff in the subject field(s) related to this position.
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 serving rural communities and agriculture in Iowa, Nebraska, South Dakota, and Wyoming. Frontier Farm Credit has six offices serving eastern Kansas. Together, we support nearly 82,000 producers and agribusinesses, meeting the needs of today’s agricultural industry with our combined 2600+ employees providing lending, risk management, technology, commodity marketing, and customer and employee education.
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.