Business Intelligence (BI) Developer

Job Title:

Business Intelligence (BI)

Developer Location:

Kansas City, Missouri About the Role ESS Companies, Inc. is seeking a Business Intelligence (BI) Developer to join our Reporting and Analytics team and play a key role in building and scaling our enterprise data platform. In this role, you will design, develop, and maintain robust data models and reporting solutions that transform complex financial and operational data into reliable, high-performance datasets. You will focus on creating scalable, efficient data structures that support analytics and reporting across multiple business units across the companies . A core responsibility of this position is helping consolidate data from multiple companies into a unified data environment. This includes developing standardized data models, optimizing data workflows, and ensuring data integrity and performance across systems. As ESS continues to grow, this role offers a strong opportunity to shape and implement best practices for data architecture, modeling, and BI development. You will also play a key role in structuring and modeling data in a way that enables future advanced analytics and AI-driven initiatives, ensuring the organization is well-positioned to leverage emerging technologies. The ideal candidate is someone who enjoys hands-on development, solving complex data challenges, and building systems that are both scalable and maintainable. This role reports directly to the Manager of Reporting and Analytics. Key Responsibilities Design, develop, and maintain BI solutions (reports, dashboards, data models) T ransform data from various sources Optimize database queries and improve data performance Collaborate with stakeholders to gather and define reporting requirements Ensure data accuracy, consistency, and integrity Develop and maintain documentation for data processes and systems Troubleshoot and resolve data-related issues Stay current with BI tools, trends, and best practices Required Qualifications Bachelor's degree in Computer Science , Information Systems, Data Analytics, or related field 3 + years of experience in BI development or data analytics Strong proficiency in SQL Experience with BI tools such as Power BI, Tableau, or Looker Knowledge of data warehousing concepts and ETL processes Strong analytical and problem-solving skills Excellent communication and collaboration abilities Preferred Qualifications Experience with cloud platforms (e.g., AWS, Azure, or Google Cloud) Familiarity with Python, R, or other scripting languages Experience with data modeling and database design Knowledge of big data technologies Understanding of business processes and KPIs Proficiency with dbt and Google Bigquery Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor's legal duty to furnish information. 41 CFR 60-1.35(c)