Business Intelligence (BI) Developer

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

Do you have experience in SQL?, Do you have a Bachelor's degree?, * 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