Data Warehouse Analyst Position Available In Suffolk, Massachusetts

Data Warehouse Analyst Ampion Inc.

Boston, MA Job Details Estimated:

$81.2K – $107K a year 8 hours ago Benefits Disability insurance Health insurance Dental insurance Vision insurance Life insurance Qualifications Jira Information Systems Mid-level SQL Bachelor’s degree PostgreSQL 2 years Communication skills Analytics Full Job Description Renewable Energy Everywhere, For Everyone We’re a fast-growing market leader working toward a world powered by renewable energy. Distributed Energy Resources, like solar and wind farms, are central to this vision—offering clean, affordable power with massive social and economic impact. Building this industry takes grit and precision. That’s where Ampion comes in: our platform connects consumers and clean energy providers, enabling affordable green energy while helping the industry scale. As a Data Warehouse Analyst, you’ll help ensure the quality and reliability of our data. You’ll dig into stakeholder expectations, identify and communicate data issues, build monitoring tests, and create views that power insights across the company. You’ll work with a skilled team of data engineers, analysts, and PMs to support stakeholders through our custom Data Insights portal.

Core Responsibilities:

We’re looking for a Data Analyst to champion data integrity in BigQuery and develop robust data models and reports for diverse business needs. The role includes but may extend beyond: Discovery & documentation of high-impact data quality gaps, & creating SQL models to address those gaps. Monitor for, triage, & respond to data quality issues; work with data stewards across the business to drive resolution on quality issues. Educate & support data warehouse stakeholders, & expand our training & education frameworks for users across the company. Collaborating with the team’s PM to manage delivery and resolve issues.

Essential Attributes:

Requirements are flexible for the right candidate – we’re looking for someone with curiosity about both technology and business, with an eagerness to understand the context & impact of their efforts. 2+ years hands-on technical experience with data storage and analytics systems. Comfort with GCP products, DBT, airflow, JIRA, datahub, postgreSQL. Bachelor’s Degree, preferential towards information systems and business analytics. Must be able to thrive in an ambiguous environment – where change is the only constant. Communication skills – ability to communicate cross-functionally and across management levels in formal and informal settings. Social justice is at the center of Ampion’s mission to bring renewable energy everywhere, to everyone. We are committed to a diverse and vibrant workforce. If you lack a specific credential for this position but believe that your strengths will propel our mission, we would love to hear from you. Equal Opportunity Ampion is an Equal Opportunity Employer and does not discriminate on the basis 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 seek to be an inclusive community and actively encourage applications from candidates of all backgrounds and identities.