Senior Data Engineer
United StatesFull-TimeSeniorSoftware Engineering
Who we are:
- 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!
Our core data stack makes heavy use of Snowflake, dbt, and Fivetran for ingestion, all orchestrated within our broader AWS-based ecosystem. You’ll work primarily with SQL in dbt to build our curated data layer–we call it the Unified Data Model–and produce analytics pipelines for our derived data products–our Solutions business. We use dbt Core, orchestrated in Argo or Prefect.
- Design, build and maintain the tooling that the wider Data team (and Arcadia as a whole) uses to interact with our data platform, including CI/CD pipelines for our data lakehouse, and unit/integration/validation testing frameworks for our data pipelines.
Optimize and tune data pipelines for improved performance, scalability, and reliability, and proactively monitor pipelines to address any issues or bottlenecks.
- 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
- Transform, test, deploy, and document data to deliver clean and trustworthy data for analysis to end-users
- 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 and observable ELT pipelines.
- Identify and implement best practices for data ingestion, transformation, and storage to ensure data integrity and accuracy.
- 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 data
- Data 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
- 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 data
- Data 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 a Senior Data Engineer or Software Engineer building production data infrastructure. dbt experience is highly desirable
- 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
- Proficiency in SQL and strong Python skills, especially in the context of data orchestration.
- Deep experience building data pipelines and database management including Snowflake or similar, along with familiarity with data integration patterns and ELT/ETL processes.
- Experience with orchestration tools like Prefect, Airflow, or Argo.
- Proven ability to establish and enforce AI-related engineering best practices (e.g., security, responsible code review, and prompt discipline) within data pipelines and codebase contributions, ensuring data integrity, architectural stability, and the safe use of AI-assisted tools.
- 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
- The ability to work East Coast business hours 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
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
- 12 annual company-wide holidays
- 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
- 75-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.
- 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 by emailing careers@arcadia.com prior to completing your application.
- Target Annual Compensation Range for this role will be $131,250 to $235,000. There will also be a competitive benefits and equity (bonus if applicable) 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. Please note that we are unable to offer visa sponsorship for this position at this time.
Data Privacy & California Residents: You voluntarily provide personal information (such as your resume, contact details, and assessment responses) when submitting an application. We may use this to evaluate your candidacy and derive inferences from this data to match your profile with open roles. For California Residents: This collection is consistent with the CCPA. You have the right to request access to or deletion of your data by contacting careers@arcadia.com
- Thank you
