BI Analyst

Tulsa, OK 74103-3000

Posted: 09/04/2019 Employment Type: Direct Hire Job Category: IT Job Number: 5409

BI Analyst

JOB SUMMARY: Incumbent is responsible for performing tasks related to the expansion and optimization of data architecture to empower business units with ready access to data required for business planning and decision-making.

ESSENTIAL DUTIES AND RESPONSIBILITIES:  The following represents the majority of the duties performed by the position, but is not meant to be all-inclusive nor prevent other duties from being assigned when necessary:
  • Collaborate with IT Software Developers and Data Architects, as well as business unit Data Analysts, Engineering Techs, and Oil and Gas Engineers on transformational company data initiatives and process improvements, ensuring an optimal and consistent data delivery architecture throughout the company
  • Design and implement scalable Extract/Transform/Load (ETL) processes using SQL Server Integration Services (SSIS) and other methods and tools as required
  • Develop and tune SQL code in multiple data platforms (SQL Server, Vertica, Oracle, Virtualized Data environment, MDM environment)
  • Develop and support enhancements to existing company Data Warehouse (SSIS, SSAS, SQL)
  • Manage code using Git code repository in Visual Studio Team Services (VSTS)
  • Gather operational data requirements with team members and business stakeholders, assessing the validity and business-sense of data warehousing models for end-user consumption
  • Train and educate business users on existing and new data solutions
  • Review team code for quality, accuracy and adherence to standards
  • Maintain data documentation (Data Dictionary, graphical data models)
  • Communicate data changes and enhancements to the organization
  • Other tasks as assigned

SKILLS AND EXPERIENCE:
  • 4-year degree in Management Information Systems, Computer Information Systems, Computer Science or related field highly preferred; Combination of education and experience may be considered in lieu of degree
  • Experience with relational databases (SQL) required
  • Knowledge of SQL Server Reporting Services (SSRS), and SQL Server Analysis Services (SSAS) cubes
  • Experience in SQL Server Integration Services (SSIS) and other advanced business intelligence concepts related to data extraction, transformation, loading, scheduling, etc.
  • Familiarity with Kimball approach for data mart development, multi-dimensional database structures, e.g. Star Schemas preferred
  • Experience with time-series data (SCADA or IoT)
  • Familiarity with Microsoft Excel' s data analysis capabilities
  • Upstream oil and gas IT experience preferred
  • Established proficiency with Microsoft Office Suite (Excel, Word, Power Point)
  • Strong interpersonal, problem solving, verbal and written communications skills required
  • Must be detail-oriented and able to multi-task with attention to accuracy
  • Must be team player able to adapt to a changing and fast paced work environment
Apply Online

Send an email reminder to:

Share This Job:

Related Jobs:

Login to save this search and get notified of similar positions.