Business Intelligence Analyst Developer

Customized Energy Solutions (CES), a privately-held company, is a leading service provider of market intelligence and operational support services to companies participating in the retail and wholesale electric and natural gas markets. Utilizing deep know-how developed since the inception of the deregulated energy markets, CES provides accurate & timely analysis on regulatory changes, market opportunities, and operational efficiencies for electricity and natural gas commodities.

We started our India operations as Customized Energy Solutions India Pvt. Ltd in 2010. We work with commercial and industrial customers to help reduce their energy costs through better utilization of the energy markets and emerging technologies. We have helped bring innovative energy services such as demand response to India. We are pioneering in exploring integration of latest technologies such as energy storage, microgrids as well as smart grid maturity model to Indian consumers.

Join a rapidly growing company in an exciting and dynamic work environment. As one of the top 100 fastest growing companies in the Philadelphia region, Customized Energy Solutions offers an opportunity for significant professional growth. Our team of associates at CES is highly motivated, innovative, and passionate about providing excellent Services to our clients. Our main office is in Philadelphia, with satellite offices in various U.S. states, Canada, India, Japan and in India.

• Gather, analyze, and compile data needed to identify trends and patterns, generate insights and inform sound business decisions.


• Understand business requirements to set functional specifications for reporting applications


• Create or assist the team in creating new visualizations in Power BI to replace and/or enhance current visualization


• Create new dashboards in Power BI


• Apply in-depth knowledge and experience with Power BI stacks (Power Pivot, SSIS, SSRS, and SSAS) to create data sets in Power BI to replace exiting enterprise data sources


• Design, develop, and deploy Power BI scripts and perform efficient detailed analysis


• Performing data analysis, data modeling, inferring data trends, communicating to stakeholders


• Perform DAX queries and functions in Power


• Work on other ad hoc projects as required

• Bachelor or master’s degree in computer science or information system, along with work experience in a related field


• 5+ years of experience in data preparation, data gateway, and data warehousing projects


• 5+ years of experience working with Microsoft BI Stack: Power Pivot, SSIS, SSRS, and SSAS


• 3-4 years of experience with a self-service tool such as Power BI or Tableau


• Ability to work in large, complex development BI projects environments


• Understanding of JavaScript, CSS, SQL, and other JavaScript libraries


• Proven and extensive experience in


• BI tools and BI systems (Power BI and QlikView required, Tableau, SAP etc. beneficial) - implementing Row-level Security (RLS) in Power BI, writing DAX expressions, and developing custom BI products with scripting and programming languages such as R, Python, etc.


• 3rd party tools used in conjunction with Power BI for better visualization and data strategy


• Building highly interactive and data rich financial dashboards and charts


• Data Modeling, DAX, and SQL


• Tabular cubes experience

Customized Energy Solutions offers competitive salary commensurate with experience. Benefits include comprehensive health Insurance, disability insurance, gym membership, Employee Provident Fund Scheme and Gratuity Scheme.