Position Summary

The Business Intelligence (BI) Developer works collaboratively with end users to develop reporting systems that provide accessible information for decision-making. The Business Intelligence Developer supports development and implementation of analytical reporting tools, data analysis and analytic services for the entire company, with an emphasis on IoT data analysis. This position is responsible for collection, aggregation, analysis and presentation of decision support tools. Collaborates with all departments, including Finance, IT, Operations, and Supply Chain, to identify and maximize opportunities to utilize data to improve business outcomes, business processes, promote the strategic use of information, and enable the workforce to use data analysis and interpretation as a competitive tool.

Essential Duties & 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

Education, Experience and Training

• 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.
• IoT Experience
• AI / ML Experience highly desired

Physical Demands

• Requires an employee to frequently type and use computer and other office equipment such as a copier, printer, calendar, telephone, etc.
• May be required to sit for long periods of time

Kodiak Gas Services is an Equal Employment Opportunity Employer: All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, veteran status.

#administrative