Business Intelligence Developer

Houston, TX

Employment Type: Direct Category: Developer Job Number: 17979 Work Model: #LI-Hybrid Internal Reference: #LI-SM1

Job Description

SUMMARY: Our Downtown Houston Energy client is looking for an experienced Business Intelligence Developer to join their team.  In this role you will be responsible for designing and implementing BI solutions and oversee the organizations analytics solutions systems.   You will utilize your understanding of upstream and/or midstream oil and gas expertise to deliver technical solutions to the business.  This position will report to the IT Data Solutions Manager. 
RESPONSIBILITIES:
  • Provides hands on support with business stakeholders to encourage solution adoption and ensure project success
  • Design, develop, test, & deploy ETL solutions to move data from various source systems into data warehouse and/or analytics platforms
  • Develop dashboards, reports, key performance indicators (KPIs) and metrics utilizing SSRS, Power BI and other front-end reporting tools
  • Under direction of the IT Data Solutions Manager, develop business intelligence roadmaps to improve organizational maturity around analysis solutions & systems
  • Develop strategic enterprise-level BI solutions that drive improved decision-making, efficiency and performance
  • Partner with key stakeholders of various business units to establish a comprehensive understanding of underlying business processes, KPIs, reports and reporting cycle, and current and future needs
  • Proficiency in T-SQL, with the ability to understand, formulate and create efficient queries, views and stored procedures to prepare data for ETL, ad-hoc requests and presentation within the reporting tools
  • Maintain data warehousing processes including load management, scheduling, performance monitoring and tuning
  • Support, maintain and enhance documentation for new applications/solutions as well as legacy solutions
  • Interact regularly with managers, stakeholders, vendors, and other resources
  • Lead projects, including solution validation, project definition, and deliverable implementation
  • On call rotation


REQUIREMENTS:
  • Four-year degree in Computer Science or Computer Information Systems, or equivalent work experience
  • Minimum ten years’ in business intelligence solutions implementation and design roles
  • Minimum three years in a leadership or advisor role related to business intelligence
  • Minimum three years Oil and gas industry experience with a general understanding of oil and gas operations, terminology, and how information flows through the business
  • Strong T-SQL experience with understanding of data aggregation/manipulation through complex queries, views and stored procedures, including SSIS, SSAS, SSRS.
  • Industry knowledge of various business intelligence solutions, languages, & providers, including cloud service providers such as Microsoft Azure Data Factory & Power BI, Snowflake & Sigma, Amazon AWS/Glue & Redshift, etc.
  • Understanding of OLAP and Tabular model design for data warehouses
  • Strong ability to collaborate in a cross-functional team environment with users of diverse backgrounds and skill levels from the novice user to the expert programmer
  • Exceptional communication skills, both written and verbal

Preferred Qualifications:
  • Experience managing projects around the implementation of technology solutions/applications through to effective user adoption/change management procedures
  • Experience managing and/or working within certain oil & gas applications
    • Enertia
    • P2 ProCount
    • EMK3
    • Maestro
    • Enersight
  • Traditional development stack experience
Apply Online

Send an email reminder to:

Share This Job:

Related Jobs:

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