The Oklahoman

Oklahoma Jobs & Oklahoma City Career Search

2 days old
2017-12-142018-01-12

Data Warehouse Analyst

Oklahoma City, OK
  • Job Code
    10085
Job Title: Data Warehouse Analyst
Company: Midfirst Bank
Jobid: 10085
Salary:
Job Type:
Location: Oklahoma City, OK 73101

Description:

Position Description:





The successful candidates will be responsible for gathering, analyzing, organizing and evaluating data to optimize return on assets and equity through producing reports through our Business Intelligence platform, WebFocus. This role will work with business units to identify and prioritize future reporting enhancements.

Responsibilities of the position include:

1) Acting as the primary contact regarding WebFocus functionality, training, project management, and vendor management
2) Designing, developing, documenting, and maintaining WebFocus reporting
3) Converting Crystal Reports and MS Office reporting to WebFocus
4) Designing and requesting SQL views and stored procedures to be created in order to improve the data warehouse and promote WebFocus adoption
5) Develop, maintain, and enforce data warehouse and WebFocus naming conventions
6) Analyzing, and evaluating business processes to create, improve, and automate reporting and controls
7) Creating, documenting, and communicating detailed reporting and process design outlines and enhancements
8) Managing multiple projects to completion and to the satisfaction of business operations
9) Communicating effectively with users and management, understanding their needs, and developing the correct solution
10) Working with business units to identify and prioritize a report development and enhancement pipeline

Advanced knowledge of the following systems, languages, and concepts preferred:

1) Business intelligence platforms: WebFocus, Microstrategy, SAP, Business Objects
2) SQL Server / relational databases
3) Crystal Reports
4) Microsoft Access / Microsoft Excel using Visual Basic for Applications (VBA)
5) HTML / CSS
6) VBScript / JavaScript
7) WebFocus / FOCUS
8) Business intelligence / data warehouse concepts















Position Requirements:





Excellent analytical, logical, and math skills are required. Candidates must also possess the ability to work both independently and collaboratively, an aptitude to manage multiple projects simultaneously, and a capacity to work in a deadline-driven environment. Other essential skills include a high technical aptitude, self-motivation, organization, attention to detail, inquisitiveness, and outstanding problem-solving abilities. This position requires a bachelor degree in Management Information Systems, Computer Science, Mathematics, or other related field is preferred. A GPA with a minimum of 3.0 is required or 3-5 years of commensurate experience. Must have working knowledge of Excel or WebFocus.







We are an Equal Opportunity Employer and do not discriminate against any employee or applicant for employment because of race, color, sex, age, national origin, religion, sexual orientation, gender identity, status as a veteran, and basis of disability or any other federal, state or local protected class.



Job ID:10085

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:

Data Warehouse Analyst

MidFirst Bank
Oklahoma City, OK

Share this job

Data Warehouse Analyst

MidFirst Bank
Oklahoma City, Ok

Separate email addresses with commas

Enter valid email address for sender.

Join us to start saving your Favorite Jobs!

Sign In Create Account
Powered ByCareerCast