Staff Reporting Programmer

Deliver and Operate United States


The Position:

Do you dream about creating a more sustainable future? At Uplight, we are motivating energy users and providers to accelerate the clean energy ecosystem. Working with over 80 of the world’s leading electric and gas utilities, Uplight provides an end-to-end customer energy experience. Uplight delivers personalized experiences that customers have now come to expect – improving satisfaction, increasing revenue, reducing the cost to serve, and contributing to carbon reduction goals. We are a certified B Corporation, which enables and commits us to put our values into action.

The Reporting team helps our clients succeed by providing them with on-going data reports and to inform business decisions, deliver energy savings, and achieve financial targets. We also contribute to the public sector by providing regulators, Attorneys General, and other government stakeholders with data that they rely on to make key decisions. We are a distributed team with three members in Seattle, one in Portland, two in Colorado, and one in Boston. We are seeking a disciplined Staff Reporting Programmer to help us achieve our ambitious goals for our business and for the planet. 

What you get to do: 

As the Staff Reporting Programmer, you will develop your experience in Uplight’s products and act as the technical team lead for the Reporting team across all product lines. You will provide the technical guidance and framework for the team to operate sustainably, scalably, and effectively, as well as represent the team when collaborating and communicating on technical topics with internal and external stakeholders. And you’ll work on a great team with excellent benefits. 

  • Investigate and explore our diverse products and data sets to lead decision making for standardizing and automating reporting capabilities with tooling and processes
  • Breakdown complex deliverables that can be turned into work products for the team 
  • Provide troubleshooting, system dependencies, and subsystem interaction
  • Conduct technical research and share this knowledge for the benefit of the larger team
  • Build out automation and tooling for recurring reports, including teaching and mentoring software engineering skills
  • Manage your own workload, with strong input into what lands on your plate and flexibility on where, when, and how you do your work
  • Drive architectural considerations for the team including technology adoption and application
  • Work closely with a broad range of stakeholders, such as Engineering, Product, Implementation, Account Managers, and finance and accounting experts

What you bring to Uplight:

  • 8+ years of personal, professional, and/or educational experience with one or more of our team's core tasks: accessing data, analyzing data, transforming data, packaging data into reports, and managing relationships with internal and external stakeholders.
  • Expert-level proficiency in three or more of the following:
    • Python - Writing and reviewing programs or scripts with Python (other languages a plus)
    • SQL (other structured query languages a plus)
    • Automated tooling for data transformation and delivery
  • Excellent scoping and planning skills, with experience working applying and instructing on best practices for project implementation
  • Motivated to streamline current and new processes to automate repeated steps and increase efficiency
  • Experience identifying and implementing PII risk mitigation strategies
  • Patient, communicative, team player who is detail-oriented and has outstanding interpersonal skills and ability to collaborate across multiple time-zones and communication platforms
  • A strong desire to lead and share your knowledge and skills through your work to grow the collective strength of the team
  • Compassion, empathy, self-awareness, and team spirit to support our clients and your fellow teammates
  • Passion for our mission and the stories we can tell with the data we provide

Bonus Points:

  • Experience with HEAP, Looker, Tableau, or other Business Intelligence tools
  • Experience in the utility industry or other heavily-regulated industries
  • Experience handling personally identifiable information (PII)
  • Experience managing direct reports or mentoring teammates
  • Experience working on remote teams
  • Experience working with APIs 
  • Application of industry security best practices
  • Experience working with large data sets 
  • BS in Computer Science / Engineering, or demonstrable industry experience
  • Experience with cloud infrastructure automation such as terraform,
  • cloudformation or similar
  • Experience with Google Cloud Platform or other cloud service provider
  • Serverless architecture, preferably Google Cloud Functions
  • You work on the command line confidently and are familiar with all the
  • You are a Git guru and revel in collaborative workflows.

What makes working at Uplight amazing:

In addition to all the standard medical and dental benefits, that kick in Day 1, we are:

  • Proud to be over 500+ purpose-driven individuals helping to create a more sustainable planet.
  • Committed to the environment, our employees, and our communities. 
  • Focused on career growth by following defined career ladders.
  • Committed to taking our work and mission seriously and….we love to laugh!

We also provide:

  • 401k Match
  • Medical, vision, and dental insurance 
  • Monthly wellness stipend 
  • Peer to peer recognition program 
  • Management by objectives bonus plan  
  • Innovative flexible time off policy
  • Exceptionally collaborative and cool office spaces 

Salary Range: $95,000 to $120,000 USD 

In accordance with the Colorado Equal Pay for Equal Work Act, the approximate annual base compensation range is listed above. The actual offer, reflecting the total compensation package and benefits, will be determined by a number of factors including the applicant's experience, knowledge, skills, and abilities, as well as internal equity among our team. 

Uplight provides equal employment opportunities to all employees and applicants and prohibits discrimination and harassment of any type without regard to race (including hair texture and hairstyles), color, religion (including head coverings), age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.