Business Intelligence Specialist

Redaptive is an Energy-as-a-Service provider that fund and installs energy-saving and energy-generating equipment. Redaptive’s programs help many of the world’s most sophisticated organizations reduce energy waste, save money, lower their carbon emissions, and meet their sustainability goals across their entire real estate portfolios. With Redaptive, customers can overcome capital and contractual barriers to achieve energy-saving benefits quickly, all with real-time data powered by Redaptive’s proprietary Data Solutions metering platform. Redaptive was founded in 2015 and is headquartered in Denver, CO. Redaptive is backed by CarVal, ENGIE New Ventures, Linse Capital, CBRE, Evergy Ventures, Rabobank, CPP Investments, and Honeywell.

Our company culture is exciting, collaborative, and fast paced. We are passionate about changing the world and helping our customers to become more environmentally sustainable and profitable. We are looking for team members who are driven, passionate, and want to take on a diverse set of challenges to help grow a great company. Redaptive, Inc is an equal employment opportunity employer and all qualified applicants will receive consideration for employment. For more information, visit www.redaptive.com. 

Redaptive is looking for a self-motivated, passionate, and collaborative Business Intelligence Specialist to work closely with our growing team based in the US & India. The role will involve collaborating with multiple teams such as Finance, Marketing, Sales, Vendor management and Technology etc. to drive and deliver BI solutions. You would be responsible for owning and leading Business Intelligence projects end-to-end. This role is ideal for someone who has a strong foundation in data transformation and modeling, with hands-on coding experience in PySpark, Python, SQL and a working understanding of BI requirements. You’ll focus on building and optimizing silver and gold-layer data models in Databricks, preparing data to support dashboards and self-service analytics using tools like Tableau and the upcoming ThoughtSpot platform. We are looking for someone who thrives in an ambiguous, fast paced environment, can use great judgement to make decisions and display empathy and resilience. 

• Design, build, and maintain robust data models using PySpark & SparkSQL in Databricks, aligned to BI/reporting needs.

• Prepare silver and gold layer datasets, transforming raw inputs into clean, business-ready tables.

• Collaborate with business stakeholders to understand reporting requirements and translate them into optimized data structures.

• Support Tableau dashboards by ensuring the availability and quality of underlying data sources.

• Participate in the onboarding and adoption of new tools like ThoughtSpot, contributing to the evolution of our BI stack.

• Convert existing Tableau Prep data flows and logic into PySpark/Spark SQL workflows in Databricks to support scalable and maintainable data pipelines

• Write efficient, modular, and well-documented transformation code with a focus on maintainability and performance.

Time Spent Performing Duty

Creating Data Models and dashboards: 50%

Stakeholder management: 20%

Adhoc requests: 15%

Creating technical and functional documentation: 15%

• Ability to work with multiple competing priorities.

• Ability to gather requirements by interacting with multiple stakeholders across the organization.

• Experience in managing stakeholder expectations.

• 5–8 years of experience in a BI, analytics, or data transformation

• Strong experience with data modeling concepts, particularly for BI (e.g., dimensional modeling, star/snowflake schemas)

• Proficient in PySpark and Python for data manipulation, transformation, and business logic implementation.

• Solid SQL skills, especially in a distributed compute environment (e.g., Spark SQL).

• Experience working with Tableau or similar BI tools to support reporting workflows.

• Exposure to Tableau Prep, Alteryx, or similar transformation frameworks

• Familiarity with data quality, performance tuning, and validation best practices.

• Hands-on experience with Databricks and Delta Lake

• Familiarity with ThoughtSpot or other AI-driven analytics platforms.

• Understanding of CI/CD, Git-based version control, and collaborative development practices in data environments.

• At least 2 years’ experience in managing multiple projects and stakeholders.

• Strong experience in data manipulation and ETL process using SQL, Python or any equivalent ETL tool.

• 4 - 8 years of experience of extracting/analyzing data using SQL and Tableau Desktop or similar BI tools for sharing insights and self-serve reporting

• Experience in creating dashboards using tableau or similar BI tools

• Bachelor’s or master’s degree in computer science, data analytics or equivalent field 

This role does not involve any international travel.

• Equity plan participation
• Medical and Personal Accident Insurance
• Support on Hybrid working – Equipment & Relocation
• Flexible Time Off 
• Continuous Learning
• Annual bonus, subject to company and individual performance

The company is an Equal Opportunity Employer, drug free workplace, and complies with Labor Laws as applicable. All duties and responsibilities are essential functions and requirements and are subject to possible modification to reasonably accommodate individuals with disabilities. The requirements listed in this document are the minimum levels of knowledge, skills, or abilities.