Senior Analytics Engineer

Arcadia; United States; Remote; USD 131,000 - 235,000; Full time

Benefits offered by this job

Remote first

Flexible PTO

17 annual holidays

Sick leave

Bereavement leave

Volunteer days off

Professional development days off

Parental leave

Cost coverage for medical/dental/vison

Job summary

Arcadia is seeking a Senior Analytics Engineer to create clean, curated data sets and analytics pipelines in a Snowflake-based lakehouse. You will lead data modeling efforts, collaborate with engineers and product managers, and drive data-driven decision making across the business.

You’ll work primarily with SQL and dbt Core, leveraging Argo or Prefect for orchestration. Remote-friendly role for US-based candidates, with strong preference for major cities in the US.

Qualifications

• 4+ years as an Analytics Engineer or equivalent role; experience with dbt is strongly preferred.
• 6+ years in the data space (data engineering, data science, analytics, or similar).
• Expert-level understanding of conceptual data modeling and data mart design.
• Strong knowledge of SQL and Python; data structures and database design.

Responsibilities

• Transform, test, deploy, and document data for analysis.
• Collaborate with engineers, PMs, and stakeholders to design data structures.
• Build robust, scalable ELT pipelines with data engineers.

Skills

dbt

SQL

Python

Snowflake

Data modeling

Data pipelines

Mentorship

Communication

Scheduling flexibility

Problem solving

Education

Graduate degree in math/statistics/engineering/CS

Tools

dbt Core

Argo

Prefect

Job description

Who We Are

Arcadia is the technology company empowering energy innovators and consumers to fight the climate crisis. Our software and APIs are revolutionizing an industry held back by outdated systems and institutions by creating unprecedented access to the data and clean energy needed to make a decarbonized energy grid possible.

In 2014, Arcadia set out on its mission to break the fossil fuel monopoly and since then we have been knocking down the institutional barriers to unlock decarbonisation. To date, we have connected hundreds of thousands of consumers and small businesses with high-quality clean energy options. Fast forward to today, and now, we’re thinking even bigger. We have launched Arc, an industry-defining SaaS platform that empowers developers and energy innovators to deliver their own custom, personalized energy experiences, accelerating the transformation of the industry from an analog energy system into a digitized information network.

Tackling one of the world’s biggest 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 electron, 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. Strong preference for candidates who reside in Washington DC, New York, Boston, Atlanta, or Denver.

#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

Benefits:

• "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 exempt employees can take each year
• 17 annual company-wide holidays including a week long "summer break"
• 10 days sick leave
• Up to 4 weeks bereavement leave
• 2 volunteer days off
• 2 professional development days off
• 12 weeks paid parental leave for all parents
• 80-95% employer cost coverage for medical, dental, and vision benefits for employees and dependents

Eliminating carbon footprints, eliminating carbon copies.

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. Please note that we are unable to offer visa sponsorship for this position at this time

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.

Target Annual Compensation Range for this role will be $131,250 to $235,000. 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

Job posting details for Senior Analytics Engineer at Arcadia in United States. Compensation / salary range: $131,250 to $235,000. ClimateTechList gathers 16,000+ job openings from over 767 climate tech companies and updates them daily.