Business Intelligence Developer - Data Warehouse

Business Intelligence Developer – Data Warehouse

Design, develop, and maintain corporate data, enterprise data warehouse and business intelligence solutions and deliver timely, accurate and actionable data critical to business decision making process. Lead and collaborate in data management efforts, including operational data support, to provide data integrity, security and availability. Identify, analyze, develop, manipulate and report data and information to determine factors affecting company performance. Establish and maintain scalable, extensible and maintainable architecture for enterprise data warehouse and business intelligence system and summarize enterprise data into an intuitive analysis framework to understand current and future company performance. Design, develop, test and maintain ETL processes, reporting and dashboards to support strategic objectives and ensure enterprise data is appropriately captured and retained. Provide expertise to achieve system integration through database design, including data and dimensional modeling, logical and physical table design, complex queries, stored procedures and triggers, data transformation, aggregation and enterprise application integration. Analyze datasets, including extraction, manipulation, and analysis of complex datasets, and analyze data and information to assist with strategic decisions, balance portfolio risk, and optimize process efficiencies. Ensure all necessary data elements are available for model building and strategy analysis. Provide continuous improvement efforts to enhance data transformation, manipulation performance, and increased functionality and support to production information systems based on business needs. Research emerging technologies, trends and benchmark data to improve customer experience, architecture, processes and tools and support business unit analytical needs by researching and analyzing data from various sources and incorporating data into existing processes and systems. Develop and implement data warehouse and business intelligence standards and best practices. Collaborate and work with business units and business analysts to translate business needs into warehousing, analytics, reporting, and dash-boarding requirements. Educate business units and IT teams on analytics and reporting advantages and mentor, support and provide direction to teammates.

Minimum Requirements:

Bachelor’s degree or equivalent in Computer Science, MIS, Statistics or a closely related field with five (5) years of experience in data warehouse and/or business intelligence development, that includes experience in architecting large scale data warehouses, with providing users access to data by building reports and queries using various data querying tools, and with a variety of industry standards regarding Microsoft database development concepts, best practices, and procedures as well as proficiency in data manipulation and reporting tools (SSMS, TSQL, SSAS, SSIS, SSRS, Business Objects, Excel, SAS, PowerBI, PowerPivot) and Windows environment using Microsoft Office and SharePoint and with database and data warehouse development (replication, staging, ETL, stored procedures, partitioning, change data capture, triggers, scheduling tools, cubes and data marts) and database, dashboard and report development using Visual Studio, source control tools, Excel Services, PerformancePoint, PowerView, PowerBI and ER/Studio; basic analytical, data mining, data modeling and data management skills; and ability to utilize data to drive strategic business decisions. Send resumes to Caylee Messersmith, Farm Credit Services of America, 5015 S. 118th St, Omaha, NE 68137 or Caylee.messersmith@fcsamerica.com.