Technical Data Analyst

Calico Energy

2d•$80,000 - $105,000•Onsite

About The Position

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.

Requirements

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

Nice To Haves

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

Responsibilities

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.