Senior Analytics Engineer

Arcadia is the global utility data and energy solutions platform. With our leading data platform, AI-powered analytics, industry expertise, and expansive partner network, we deliver solutions for every stage of the enterprise energy management lifecycle across carbon, cost, and reliability. 

Arcadia’s Enterprise Energy Management Solutions are built on a foundational data platform that has been developed for over a decade and scaled across millions of customer facilities.  We transform fragmented data and siloed processes into coordinated, enterprise-wide action with comprehensive solutions including:

• Utility Bill Management:  Lower utility costs and streamline bill management with automated bill payment, proactive error identification, optimized tariff structures, and budgeting & forecasting.
• Energy Procurement Advisory: Source clean energy through a comprehensive evaluation of supply options - including traditional retail options and onsite and offsite resources — to effectively manage risks, reduce costs, and achieve corporate sustainability goals.
• Sustainability Reporting:  Achieve compliance goals and track carbon emissions with standardized energy data and seamless integration with leading sustainability platforms.

Tackling an enterprise client’s most critical energy challenges requires out-of-the-box thinking & diverse perspectives. We’re building a team of individuals from different backgrounds, industries, & educational experiences. If you share our passion for ushering in the era of the clean, cost-effective electrons, we look forward to learning what you would uniquely bring to Arcadia!

We are seeking a Senior Analytics Engineer to create clean, curated, and organized data sets used across Arcadia. The role will be hands-on and collaborative, building data assets that enable analysis and drive daily business decisions. You’ll bring an engineer’s rigor and a seasoned data modeler’s expertise to our thorniest data modeling problems, helping to lead our efforts to organize, rationalize, and produce enriched data products on our data.  

Our data lake is hosted on Snowflake and that’s also where we are building our curated data layer–we call it the Unified Data Model–and produce analytics pipelines for our derived data products–our Solutions business. You’ll work primarily with SQL in dbt; we use dbt Core, orchestrated in Argo and, in some instances, Prefect.

This is an excellent opportunity for someone who relishes the chance to engage with cutting-edge technology, influence the development of a world-class data ecosystem, and work in a fast-paced environment on a high-performing team. As the senior-most individual contributor on our Data and Analytics Engineering team, you’ll work with our Director of Data and Analytics Engineering to define and drive our data strategy and best practices.

Arcadia is open to fully remote candidates who are based in the US and employees have access to co-working spaces.

#LI-REMOTE

• Transform, test, deploy, and document data to deliver clean and trustworthy data for analysis to end-users
• Collaborate with subject matter experts, engineers, and product managers to identify the most elegant and effective data structures to understand our constantly growing and evolving business
• Help bring engineering best practices (reliability, modularity, test coverage, documentation) to our DAG and to our Data team generally
• Collaborate with data engineers to build robust, tested, scalable ELT pipelines.
• On a daily basis, this role will perform:
• Data modeling: model raw data into clean, tested, and reusable datasets to represent our key business data concepts.  Define the rules and requirements for the formats and attributes of data
• Data transformation: build our data lakehouse by transforming raw data into meaningful, useful data elements through joining, filtering, and aggregating source dataData documentation: create and maintain data documentation including data definitions and understandable data descriptions to enable broad-scale understanding of the use of data
• Employ software engineering best practices to write code and coach analysts and data scientists to do the same

• 4+ years as an Analytics Engineer or equivalent role; experience with dbt is strongly preferred 
• 6+ years, cumulatively, in the data space (data engineering, data science, analytics, or similar)
• Expert-level understanding of conceptual data modeling and data mart design
• An understanding of data structures and/or database design plus deep experience with SQL and Python
• Experience building data pipelines and database management including Snowflake or similar
• Ability to bring a customer-oriented and empathetic approach to understanding how data is used to drive the business
• Experience in technical leadership or mentorship
• Strong communication and collaboration skills
• Any schedule requirements (ie East coast time) to maximize overlap with team members in India
• Proven ability to solve complex problems in a dynamic and evolving environment

• Graduate degree in math, statistics, engineering, computer science, or related technical field
• Experience in predictive modeling and statistical analysis
• Experience with BI platforms
• Experience working in global, distributed teams
• Experience in the energy sector

• "Remote first" culture - work anywhere in the US as long as you have a reliable internet connection
• Flexible PTO - no accrued hours and no limit on the number of vacation days employees can take each year
• 15 annual company-wide holidays including a week-long "summer break"
• 10 days of sick leave
• Up to 4 weeks of bereavement leave
• 2 volunteer days off
• 2 professional development days off
• 12 weeks of paid parental leave for all parents
• Weekly "flex time" - no internal meetings on Tuesdays and Friday afternoons
• 80-95% employer cost coverage for medical, dental, and vision benefits for employees and dependents
• A supportive engineering culture that values diversity, empathy, teamwork, trust, and efficiency

Here at Arcadia, we cultivate diversity, celebrate individuality, and believe unique perspectives are key to our collective success in creating a clean energy future. Arcadia is committed to equal employment opportunities regardless of race, color, religion, gender, sexual orientation, gender identity or expression, national origin, age, disability, genetic information, protected veteran status, or any status protected by applicable federal, state, or local law. 

We will ensure that individuals with disabilities are provided reasonable accommodation to participate in the job application or interview process, to perform essential job functions, and to receive other benefits and privileges of employment. Please contact us to request accommodation.

The Target Annual Compensation Range for this role will be $150,000-$175,000- $200,000 based on experience and the candidate’s location. There will also be a competitive benefits and equity component to the package. The exact compensation at which this job is filled will be determined by the skills, experience, and location of the qualified candidate.