Analytics Engineer III

Who we are

Arcadia is the tech company empowering energy innovators and consumers to combat the climate crisis. Our software and APIs are revolutionizing an industry restrained by outdated systems and institutions by forging unparalleled access to the data and clean energy essential to enable a decarbonized energy grid.

Started in 2014, Arcadia embarked on its mission to disrupt the fossil fuel monopoly, and since then, we have been eliminating the institutional barriers to facilitate decarbonization. So far, we have connected hundreds of thousands of consumers and small businesses with top-notch clean energy alternatives. Progressing to the present, we now aspire to even greater feats. We have unveiled Arc, an industry-shaping SaaS platform that enables developers and energy innovators to deliver their own tailored, personalized energy experiences. This accelerates the transformation of the industry from a traditional energy system into a digitized information network.

Addressing one of the world's most significant challenges necessitates innovative thinking and diverse viewpoints. We are assembling a team of individuals from diverse backgrounds, industries, and educational experiences. If you share our passion for ushering in the age of clean electricity, we are interested in learning what unique qualities you would bring to Arcadia! Visit .

Main headquarters: Washington, DC

$1.5 billion value; $380 million funding received to date

What we’re looking for

We are seeking an Analytics Engineer III to create pristine, curated, organized data sets utilized by our Data Analysts, Operations teams, and other Arcadians. The role is hands-on and collaborative, constructing data assets that facilitate analysis and guide daily business decisions. You’ll bring an engineer’s rigor and an experienced data modeler’s expertise to tackle our most complex data modeling problems, collaborating with the rest of the Analytics Engineering team to organize and rationalize our data.

Our data lake is situated on Snowflake, and that's where we construct our curated data layer—we call it the Lakehouse. You'll primarily work with SQL in dbt; we use dbt Core, coordinated in Prefect.

This presents an extraordinary opportunity for someone who savors the opportunity to interact with cutting-edge technology, impacting the development of a world-class data ecosystem and operating in a fast-paced environment on a tight-knit team with high morale. You'll work with a globally dispersed team, based primarily in Chennai, India, but involving key contributors throughout the United States.

What you’ll do

• Transform, test, deploy, and document data to deliver clean and reliable data for analysis to end-users.
• Cooperate with data scientists, data analysts, and business analysts to identify the most elegant and effective data structures for understanding our continually growing and evolving business.
• Assist in implementing engineering best practices (reliability, modularity, test coverage, documentation) into our DAG and our Data team in general.
• Collaborate with data engineers to construct robust, tested, scalable ELT pipelines.
• On a daily basis…
  • Data modeling: Shape 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: Structure our data lakehouse by transforming raw data into significant, useful data elements through joining, filtering, and aggregating source data.
  • Data documentation: Create and maintain data documentation including data definitions and understandable data descriptions to enable widespread understanding and use of data.
  • Utilize engineering best practices to write code and enhance our codebase.

What will help you succeed

Must-haves

• 2+ years as an Analytics Engineer or similar role (we recognize that titles aren’t everything!). Experience with dbt is strongly preferred.
• 4+ years, accumulative, in the data field (data engineering, data science, analytics, or similar)
• Comprehensive understanding of conceptual data modeling and data mart design.
• Comprehension of data structures and/or database design along with extensive experience with SQL and Python
• Experience in constructing data pipelines and database management, including Snowflake or similar
• Ability to adopt a customer-focused and empathic approach to understanding how data is used to propel the business
• Strong communication abilities

Nice-to-haves

• Degree in mathematics, statistics, engineering, computer science, or a related technical field
• Experience in predictive modeling and statistical analysis
• Experience with BI platforms
• Experience in working within global, distributed teams
• Experience in the energy sector

Benefits:

• Market-competitive compensation
• We are developing a hybrid model with a remote-first policy
• Aside from a fixed base salary, potential candidates are eligible for the following benefits
  • Flexible Leave Policy
  • Office situated in the city center, available for any necessary visits
  • Medical Insurance (plus 5 family members)
  • Annual performance cycle
  • Quarterly team engagement activities, rewards & recognitions
  • Training & Development programs to promote professional growth

Eradicating carbon footprints, eliminating carbon copies.

Here at Arcadia, we cultivate diversity, celebrate individuality, and believe different perspectives are key to our collective success in fostering 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 federal, state, or local law. While unable to consider candidates that will require visa sponsorship, we encourage applications from all candidates eligible to work in India.

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