BI Developer - Data Warehouse

Farm Credit Services   Omaha, NE   Full-time     Information Services / Technology (IT)
Posted on September 10, 2023

BI Developer –
Data Warehouse

Design, develop, and maintain data warehouse and business intelligence solutions. Deliver data for decision making. Lead and collaborate in data management and support. Provide data integrity, security and availability. Identify, analyze, develop, manipulate and report data affecting company performance. Establish and maintain scalable and extensible architecture for enterprise data warehouse and BI system. Summarize enterprise data in intuitive analysis framework. Design, develop, test and maintain ETL processes, reporting and dashboards to support strategic objectives and capture and retain enterprise data. Provide expertise for system integration via database design (data and dimensional modeling, logical and physical table design, complex queries, stored procedures and triggers, data transformation, aggregation and enterprise application integration). Analyze complex datasets (extraction, manipulation) and data and info for strategic decisions, balance portfolio risk, and optimal process efficiencies. Ensure necessary data elements available for model building and strategy analysis. Enhance data transformation, manipulation performance, and functionality. Support to production info systems. Research emerging tech, trends and benchmark data to improve customer experience, architecture, processes and tools and support analytical needs and incorporate into existing processes and systems. Develop and implement data warehouse and BI standards and best practices. Collaborate with business units and BAs to translate business needs into warehousing, analytics, reporting, and dash-boarding requirements. Provide education on analytics and reporting advantages and mentor, support and provide direction.

Minimum Requirements: Bach degree or equiv in CS, MIS, Statistics or closely related field with 5 yrs of exp in data warehouse and/or business intelligence dev, including exp in architecting large scale data warehouses, providing users access to data, building reports and queries using various data querying tools, and with industry standards regarding MS database development concepts, best practices, and procedures; proficiency in data manipulation and reporting tools (SSMS, TSQL, SSAS, SSIS, SSRS, Business Objects, Excel, SAS, PowerPivot), Windows environment using MS Office and SharePoint, 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 dev using Visual Studio, source control tools, Excel Services, PerformancePoint, PowerView, PowerBI and ER/Studio; basic analytical, data mining, data modeling and data management skills; ability to utilize data for strategic business decisions. Send resumes to C. Messersmith, Farm Credit, 5015 S 118th St, Omaha, NE 68137 or