Business Intelligence Developer

Kodiak Gas Services•The Woodlands, TX

8d•Onsite

About The Position

Kodiak Gas Services is seeking a Business Intelligence Developer to join their team. This role is responsible for data modeling, BI, Data Warehousing, and IoT solutions. The developer will perform technical troubleshooting, code debugging, and problem-solving for custom-built data warehousing solutions. They will also assist in implementing effective business analytics practices to drive improved decision-making, efficiency, and performance. This role requires strong communication skills to interact with non-technical business users to determine reporting requirements and to communicate regularly with technical staff to ensure database integrity, security, and performance. The developer will identify, communicate, and resolve data quality and reconciliation issues, perform independent audits, and develop/enforce standards for data storage and retrieval. Collaboration with institutional staff to resolve data discrepancies and maintain an inventory of data, systems, and storage is also key. The role involves processing data extracts, building partnerships through information sharing, and ensuring optimal service to internal and external partners. Additional duties as assigned and protection of confidential information are also part of the role.

Requirements

Bachelor’s degree required in relevant field
Demonstrated attention to detail on ensuring the accuracy and efficiency of the data warehouse and the individual work units
Possesses strong oral and written communication skills, clearly and accurately communicating complex and/or technical information to both technical and nontechnical audiences
Self-motivated; able to work within a project-based environment
Seven years of experience in business performance reporting, data analysis and proactive insights
MS SQL Server, Integration Services and Reporting Services required
Strong TSQL scripting abilities and understanding of complex stored procedures, views, data aggregation/manipulation through table joins/queries, database design, normalization, and de-normalization techniques
Demonstrated experience in data extraction and manipulation, ETL techniques required
Must be able to meet deadlines, juggle multiple projects and work independently.
Aptitude in telling the story behind the data and translating analysis into insights and recommendations
Ability to teach and mentor other employees, providing an opportunity for development and growth
Excellent planning, and organizational skills
Strong analytical skills and business problem-solving skills.

Nice To Haves

IoT Experience
AI / ML Experience highly desired

Responsibilities

Data Modeling BI, Data Warehousing and IoT solutions
Performs technical troubleshooting, code debugging, and problem solving for custom built data warehousing solutions
Assists in implementing effective business analytics practices that drive improved decision making, efficiency and performance
Communicate with nontechnical business users to determine specific business requirements for reports and business intelligence solutions
Communicates regularly with technical, applications and operational staff to ensure database integrity, security and optimized performance at the application and database level
Identifies, communicates, and resolves data quality and data reconciliation issues
Participates in and supports all planning and problem resolution
Performs independent audits and reviews and validates databases to ensure data integrity
Develops and enforces standards and procedures for the storage and retrieval of institutional data
Works collaboratively with institutional staff and reporting officials to resolve data discrepancies and/or to clarify reporting procedures
Maintains an accurate and comprehensive inventory of data, data systems, and data storage
Processes data extracts using data retrieval and management tools
Builds effective partnerships with coworkers throughout the Company by freely sharing appropriate information and providing assistance when needed
Ensures optimum service to all internal and external partners in response to all requests for service and information
Assists with other duties as assigned
Protects confidential information