Senior Analytics Engineer

Arcadia; United States; Remote; USD 150,000 - 200,000; Full time

Job summary

Arcadia seeks a Senior Analytics Engineer to create organized data sets for analytics. You'll collaborate closely with various teams, using SQL and dbt to enhance data management practices. This role offers a chance to innovate within a remote-first culture while significantly influencing our data strategy.

Benefits

Flexible PTO

Weekly 'flex time'

Comprehensive health benefits

Paid parental leave

15 annual company-wide holidays

Professional development days off

Qualifications

• 4+ years as an Analytics Engineer or equivalent role.
• 6+ years cumulative experience in the data space.
• Expert-level understanding of conceptual data modeling.

Responsibilities

• Transform, test, deploy, and document data for analysis.
• Collaborate with engineers and product managers for data structures.
• Build scalable ELT pipelines with data engineers.

Skills

Data modeling

SQL

Python

Data pipeline construction

Collaboration

Education

Graduate degree in math, statistics, engineering, computer science

Tools

Snowflake

dbt

Job description

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!

What we’re looking for

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

What you’ll do

• 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

What will help you succeed

Must-haves

• 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

Nice-to-haves

• 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 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

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.

Thank you

Create a Job Alert

Interested in building your career at Arcadia? Get future opportunities sent straight to your email.

Apply for this job

*

indicates a required field

First Name *

Last Name *

Preferred First Name

Email *

Phone

Location (City) *

Resume/CV *

Enter manually

Accepted file types: pdf, doc, docx, txt, rtf

Enter manually

Accepted file types: pdf, doc, docx, txt, rtf

Are you legally eligible to work in the U.S.? * Select...

Will you now or in the future require visa sponsorship for employment at Arcadia? * Select...

Do you currently live in the U.S.? * Select...

If Yes, what state do you currently live in? * Select...

What city do you currently live in? *

What is your zip code? *

What are your pronouns? (optional)

Arcadia Self-Identification Questions

For government reporting purposes, we ask candidates to respond to the below self-identification survey. Whatever your decision, it will not be considered in the hiring process or thereafter. Any information that you do provide will be recorded and maintained in a confidential file.

As set forth in Arcadia’s Equal Employment Opportunity policy, we do not discriminate on the basis of any protected group status under any applicable law.

---

If you believe you belong to any of the categories of protected veterans listed below, please indicate by making the appropriate selection. As a government contractor subject to the Vietnam Era Veterans Readjustment Assistance Act (VEVRAA), we request this information in order to measure the effectiveness of the outreach and positive recruitment efforts we undertake pursuant to VEVRAA. Classification of protected categories is as follows:

A "disabled veteran" is one of the following: a veteran of the U.S. military, ground, naval or air service who is entitled to compensation (or who but for the receipt of military retired pay would be entitled to compensation) under laws administered by the Secretary of Veterans Affairs; or a person who was discharged or released from active duty because of a service-connected disability.

A "recently separated veteran" means any veteran during the three-year period beginning on the date of such veteran's discharge or release from active duty in the U.S. military, ground, naval, or air service.

An "active duty wartime or campaign badge veteran" means a veteran who served on active duty in the U.S. military, ground, naval or air service during a war, or in a campaign or expedition for which a campaign badge has been authorized under the laws administered by the Department of Defense.

An "Armed forces service medal veteran" means a veteran who, while serving on active duty in the U.S. military, ground, naval or air service, participated in a United States military operation for which an Armed Forces service medal was awarded pursuant to Executive Order 12985.

---

Voluntary Self-Identification of Disability

Why are you being asked to complete this form?

We are required to measure our progress toward having at least 7% of our workforce be individuals with disabilities. To do this, we must ask applicants and employees if they have a disability or have ever had a disability. Because a person may become disabled at any time, we ask all of our employees to update their information at least every five years.

Identifying yourself as an individual with a disability is voluntary, and we hope that you will choose to do so. Your answer will be maintained confidentially and not be seen by selecting officials or anyone else involved in making personnel decisions. Completing the form will not negatively impact you in any way, regardless of whether you have self-identified in the past. For more information about this form or the equal employment obligations of federal contractors under Section 503 of the Rehabilitation Act, visit the U.S. Department of Labor’s Office of Federal Contract Compliance Programs (OFCCP) website atwww.dol.gov/ofccp .

How do you know if you have a disability?

You are considered to have a disability if you have a physical or mental impairment or medical condition that substantially limits a major life activity, or if you have a history or record of such an impairment or medical condition.

Disabilities include, but are not limited to:

• Autism
• Autoimmune disorder, for example, lupus, fibromyalgia, rheumatoid arthritis, or HIV/AIDS
• Blind or low vision
• Cancer
• Cardiovascular or heart disease
• Celiac disease
• Cerebral palsy
• Deaf or hard of hearing
• Depression or anxiety
• Diabetes
• Epilepsy
• Gastrointestinal disorders, for example, Crohn's Disease, or irritable bowel syndrome
• Missing limbs or partially missing limbs
• Nervous system condition for example, migraine headaches, Parkinson’s disease, or Multiple sclerosis (MS)
• Psychiatric condition, for example, bipolar disorder, schizophrenia, PTSD, or major depression

Gender or Gender Identity * Select...

Please identify your race and/or ethnicity. Please check all that apply: * Select...