About Calico Energy

Founded in 2010, Calico Energy provides trusted technical products and services for utilities and their partners. Working across the energy sector, we have solved some of the industry’s most complex energy data aggregation and usage system problems. Today, we continue to pursue big challenges, providing strategic and technical solutions to market needs. Utilibridge™, our whole building benchmarking application, is an industry-leading solution that addresses one of the sector’s largest opportunities for reducing energy consumption nationwide.

We are building a team of authentic, imaginative, self-starting professionals who can help us achieve our mission and contribute to a culture of transparency and trust. No matter the department or role, we are looking for team members who understand how to balance meeting customer needs with creating processes, systems and products that adapt to scale.

We are self-aware, accountable, and we’ve got grit. We thrive on clear, proactive, inclusive communication. We’re resourceful, strategic, and always evolving. And we care about the planet, each other, and ourselves. If you connect with these values, we are eager to hear from you.

Calico offers competitive compensation and benefits including employee equity, bonus potential, insurance plans with employer cost sharing at 100% of employee and 50% of dependent costs, a 401k plan, paid holidays and an unlimited paid time off plan.   

We are committed to equal employment opportunity regardless of race, color, ancestry, religion, sex, national origin, sexual orientation, age, citizenship, marital status, disability, gender, gender identity or expression, or veteran status. We are proud to be an equal opportunity workplace.

About the role

Technical Data Analyst | Full-Time, Salaried | $80k-$105k | Eligible for Benefits

Calico is a growing company looking for a Technical Data Analyst to support our Utilibridge™ application. This position will require expertise on the data processes, tools and formats that underpin our flagship software product and close collaboration with our engineering, product and support teams. We are specifically looking for someone excited to deepen their data and domain skills across an analysis-to-engineering spectrum. This position is responsible for data analysis, integration support, and related internal and external deliverables. This role will report to our Interim Head of Engineering.

Please note that this hiring process will include a synchronous assessment of technical skills.

What you'll do

• Serve as a subject matter expert and primary technical resource for new client data integrations by contributing to requirements scoping, data mapping, architecture planning, technical implementation, QA / validation. Work closely with Product Management and Engineering leads to execute new Utilibridge implementations and data integration projects effectively.
• Work closely with the Utilibridge Product Support team to resolve user data issues through troubleshooting, root cause investigation, escalation to client source data points of contact, and confirmation of data repair. Communicate clear status and next steps with internal and external stakeholders.
• Collaborate with software engineers on execution, maintenance and improvement of data pipelines, taking responsibility over time for some standard, recurring processes. Contribute to roadmap-driven revisions to the same.

Qualifications

Required Qualifications: 

• 3+ years working with enterprise software enabled by data integrations or commensurate skill level
• Experience with data analysis, flows, formats, mapping, and standards
• Advanced proficiency in spreadsheets, including complex formulas, tables, data validation, and tools for combining and transforming data
• Demonstrated experience cleaning, reconciling, and quality-checking datasets from multiple sources and troubleshooting discrepancies
• Proficiency in SQL, including writing and troubleshooting queries that join, filter, aggregate, and validate data across multiple tables
• Demonstrated ability to translate business questions into analysis, investigate data-quality issues, and reconcile results against source data
• Experience documenting analyses for both internal and external audiences
• Experience working with software development teams
• Strong relationship building and communication skills, both written and oral
• Research and information synthesis skills
• The emotional intelligence to balance your ambition and drive with self-awareness and empathy
• The experience and confidence to work independently

Preferred Qualifications: 

• Experience with utility data and the energy industry
• Experience with T-SQL and Microsoft SQL Server / Azure SQL
• Familiarity with ETL/ELT concepts, data pipelines, pipeline orchestration, and batch processing
• Experience working with sensitive data, such as PII, PCI, or HIPAA-regulated data
• Experience with command-line tools and scripting, such as Bash or PowerShell
• Experience with interactive data-analysis environments, such as JupyterLab or Jupyter Notebook
• Experience with modern data formats and analytical tools, such as Parquet and DuckDB
• Experience with data lakes or similar large-scale data storage environments
• Familiarity with containerized environments such as Docker or Kubernetes
• Familiarity with programming and version-control workflows