Business Intelligence Developer Jobs

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:

• Support, maintain and enhance documentation for new applications/solutions as well as legacy solutions
• Under direction of the IT Data Solutions Manager, develop business intelligence roadmaps to improve organizational maturity around analysis solutions & systems
• 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
• 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
• On call rotation
• 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
• Maintain data warehousing processes including load management, scheduling, performance monitoring and tuning
• Lead projects, including solution validation, project definition, and deliverable implementation
• Develop strategic enterprise-level BI solutions that drive improved decision-making, efficiency and performance
• Interact regularly with managers, stakeholders, vendors, and other resources

REQUIREMENTS:

• Four-year degree in Computer Science or Computer Information Systems, or equivalent work experience
• 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.
• Minimum three years in a leadership or advisor role related to business intelligence
• 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
• Understanding of OLAP and Tabular model design for data warehouses
• 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.
• Minimum ten years’ in business intelligence solutions implementation and design roles
• Exceptional communication skills, both written and verbal

Preferred Qualifications:

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