14 hours

Business Intelligence Developer

Omaha, NE
  • Job Code
    385
  • Jobs Rated
    61st
JobTitle: Business Intelligence Developer
Job ID: 385
Salary Range: 80510.0- 152250.0
Job Category: Information Technology
Grade Level: 24C, 25C
Employment type: Full-Time
Relocation Available: No
Closing Date: Jan 20, 2019
Location: Omaha
Team: Bus Intel and Data Mgmt

Position Description:

POSITION SUMMARY:

Design, develop, and maintain the corporate data, enterprise data warehouse and business intelligence solutions within Farm Credit Services of America. Deliver timely, accurate and actionable data critical to the business decision-making process. Facilitate the identification, analysis, development, manipulation and reporting of company data and information to gain knowledge of the factors that affect overall company performance. Provide continuous improvement efforts to enhance data transformation and manipulation performance while providing increased functionality and support to production information systems based on the business needs. 

EMPLOYEES SUPERVISED:

None

DUTIES AND RESPONSIBILITIES:

Essential functions of the position include, but are not limited to:

Levels 24 & 25:

  1. Work in a highly collaborative team environment following the Agile methodology to assist other department personnel 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 collaborate in the data management efforts including operational data support to provide a high level of data integrity, security and availability for internal and external customers. 
  2. Establish and maintain a scalable, extensible and maintainable architecture for the enterprise data warehouse and business intelligence system.  Summarize enterprise data into an intuitive analysis framework for understanding the current and future performance of the company.  Provide the design, development, testing and maintenance of ETL processes, reporting and dashboards to support Association strategic objectives. 
  3. Collaborate with Risk Management and other business unit leaders for various projects involving enterprise data. Ensure the appropriate capture and retention of enterprise data. Work with Business Analysts to translate various business needs into warehousing, analytics, reporting, and dash-boarding requirements. Educate other business units and Information Technology teams about the analytics and reporting advantages available to them through Business Intelligence.
  4. 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. Level 25: Develop and implement data warehouse and business intelligence standards and best practices. Mentor, support and provide direction to lesser experienced teammates.
  5. Level 25 Support the analytical needs of business units by researching and analyzing data from various sources, and incorporate data into existing processes and systems as needed by using expert level understanding of how data, technology and credit processes work together to serve our customers.
  6. Conduct analysis on datasets, including efficient extraction, manipulation, and analysis of complex datasets. Analyze data and information in innovative ways 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.
  7. Research emerging technologies, trends and benchmark data to make recommendations to improve customer experience, architecture, processes and tools. 

Additional functions of the position may include:

  1. Performs other related duties as assigned.

JOB SPECIFICATIONS:

Bachelor’s degree in Computer Science, MIS, Statistics, Finance or equivalent training and experience required.

Level 24: Ideal candidate will have a minimum of two years of experience in data warehouse and/or business intelligence development, or comparable IT field.

Duties require: 

  • Strong computer literacy and proficiency in data manipulation and reporting tools which may include: SSMS, TSQL, SSIS, SSRS, Business Objects, Crystal Reports, Excel, SAS
  • Ability to work effectively in a collaborative team environment and effectively demonstrate team building attitude and skills
  • Basic knowledge of database design and data warehouse development including replication, staging, ETL, stored procedures, triggers, scheduling tools and data marts
  • Familiar with a variety of industry standards regarding Microsoft database development concepts, best practices, and procedures
  • Basic analytical, data mining, data modeling and data management skills, and ability to utilize data to drive strategic business decisions
  • Proficient in the latest Windows environment using the most recent versions of Microsoft Office and SharePoint
  • Database and report development experience with Visual Studio, Excel Services, PerformancePoint, PowerView and ER/Studio a plus
  • Ability to provide sound technical advice to leadership and other staff in the subject field(s) related to this position
  • Willing to be flexible and perform a variety of roles such as analyst, tester, and mentor
  • Experienced with providing users access to data by building reports and queries using various data querying tools
  • Strong collaboration, interpersonal, relationship and project management skills
  • Ability to analyze, evaluate, and develop solutions to complex problems
  • Excellent presentation and writing skills
  • Ability to interpret policy, programs, and regulations

Level 25: Ideal candidate will have a minimum of five years of experience in data warehouse and/or business intelligence development, or comparable IT field. Experience in architecting large scale data warehouse. Microsoft MCDBA certification, CBIP or other data warehouse certification, MBA or Master Degree in related field is preferred.

Duties require:

  • Strong computer literacy and proficiency in data manipulation and reporting tools with demonstrated highly skilled knowledge of SSMS, TSQL, SSAS, SSIS, SSRS, Excel and PowerPivot
  • Ability to work effectively in a collaborative team environment and effectively demonstrate team building attitude and skills
  • High level of proficiency with database and data warehouse development including replication, staging, ETL, stored procedures, partitioning, change data capture, triggers, scheduling tools, cubes and data marts
  • Experience with a variety of industry standards regarding Microsoft database development concepts, best practices, and procedures
  • Strong analytical, data mining, data modeling and data management skills, and ability to utilize data to drive strategic business decisions
  • Proficient in the latest Windows environment using the most recent versions of Microsoft Office and SharePoint
  • Database and report development experience with Visual Studio, Excel Services, PerformancePoint, PowerView and ER/Studio.
  • Experience providing sound technical advice to leadership and other staff in the subject field(s) related to this position
  • Demonstrated ability to be flexible and perform a variety of roles such as analyst, tester, and mentor
  • Advanced experience with providing users access to data by building reports and queries using various data querying tools
  • Strong collaboration, interpersonal, relationship and project management skills
  • Leadership and judgment to analyze, evaluate, and develop solutions to complex problems
  • Ability to interpret policy, programs, and regulations
  • Excellent oral, written and presentation skills

INTERNAL/EXTERNAL CONTACTS:

Levels 24 and 25: All levels of Association staff, internal legal counsel, external vendors, state and federal agencies, FCA, FCC, other Farm Credit Associations and Banks, and commercial lenders. 

MENTAL AND PHYSICAL REQUIREMENTS:

  • Proficient in Windows environment using Microsoft Word, Excel, and Internet Explorer.
  • Operate a computer and related peripheral equipment proficiently and performs repetitive motions on computer for extended periods of time. This also includes reading the screen and keying/typing information.        
  • Ability to complete work in an acceptable timeframe and manage a variety of detailed tasks and responsibilities simultaneously and with accuracy to meet deadlines, goals and objectives and satisfy internal and external customer needs related to the job.
  • Ability to lift or move equipment up to 50 pounds from one location to another.
  • Ability to move about the office with occasional reaching and bending.
  • Ability to operate the telephone and respond to calls and in-person inquiries.
  • Ability to reason, judge, compare, calculate, evaluate and critique such information as written materials, numerical data, responses to customer needs and/or other work related activities.
  • Ability to speak and make presentations to individuals or groups on technical subjects related to this role.
  • Ability to successfully interact with and represent the organization to staff, officers, board members, customers, industry specialists, and the public at all levels.
  • Ability to travel by auto or commercial transportation to carry out essential responsibilities of the job.
  • Ability to understand and explain various subject matter and consult on concepts, programs, terminology and methods.
  • Ability to use a keyboard/calculator/computer. This involves reading the screen and keying/typing information.
  • Ability to use and understand various computer software related to carrying out essential responsibilities of the position.
  • Ability to work effectively in a team environment and effectively demonstrate team building attitude and skills.

Requirements of the job include the ability to do the work, with or without reasonable accommodations. It is the Association's policy to make reasonable accommodations for individuals with disabilities. Leadership retains the right to add, subtract or change duties of the position at any time. 

This document does not create an employment contract, implied or otherwise, other than \"at will\" employment relationship. 

We are an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability status, protected veteran status, or any other characteristic protected by law.

 

","

Industry

  • Banking / Finance

Jobs Rated Reports for Computer Programmer

Posted: 2019-01-17 Expires: 2019-02-16
Sponsored by:
Farm Credit Services of America Logo
Sponsored by:
Bank of America Logo

Featured Jobs[ View All ]

Featured Employers

Before you go...

Our free job seeker tools include alerts for new jobs, saving your favorites, optimized job matching, and more! Just enter your email below.

Share this job:

Business Intelligence Developer

Farm Credit Services of America
Omaha, NE

Join us to start saving your Favorite Jobs!

Sign In Create Account
Computer Programmer
61st2018 - Computer Programmer
Overall Rating: 61/220
Median Salary: $82,240

Work Environment
Good
50/220
Stress
Very Low
17/220
Growth
Very Poor
211/220
Powered ByCareerCast