Data Engineer

TerraFirma; Tumwater (WA); On-site; USD 90,000 - 130,000; Full time

Benefits offered by this job

Competitive Pay

Paid Holidays & PTO

Disability Insurance (Short & Long)

401(k) Retirement Plan

Life Insurance

AD&D Insurance

Wellness Programs

Job summary

TerraFirma is seeking a data-focused professional to own TerraFirma's data ecosystem. You will manage data quality, ingestion into the data lake, and transformation pipelines, while delivering actionable Power BI reports to leadership.

You will work with the Full Stack Developer and business stakeholders to ensure trusted data and clear storytelling. The role requires 3+ years in data roles, strong SQL, Python, and Power BI expertise, plus experience with Azure Data Factory, Synapse, and data

Qualifications

• 3+ years in a data-focused role with ownership of data quality and reporting
• Strong SQL with complex joins, window functions, and performance tuning
• Power BI proficiency with report/dashboard delivery and DAX
• Python for data work: scripting and automation
• Ability to explain data discrepancies to senior leaders
• Experience with data lake concepts and transformation pipelines
• Experience with REST APIs and JSON data sources

Responsibilities

• Own data quality and integrity across connected systems
• Build and maintain validation frameworks to catch bad data
• Document data standards, naming conventions, and transformation rules
• Be the go-to person when numbers don’t match
• Ingest data into the data lake from multiple sources
• Design and maintain pipelines for clean, report-ready data
• Collaborate on integration design linking pipelines to application logic
• Monitor pipeline health and resolve failures
• Build and maintain Power BI reports and dashboards
• Translate business questions into data models and visuals
• Own the reporting layer and fix stale or confusing reports
• Surface insights proactively
• Contribute to TerraFirma's data lake design
• Document data sources, schemas, transformation logic, and lineage
• Support long-term data strategy with IT leadership

Skills

Strong communication

SQL proficiency

Python for data work

Power BI proficiency

Data modeling

Problem solving

Tools

Power BI

Azure Data Factory

Azure Synapse

Blob Storage

REST APIs

Git

Power Query / M

JSON

Job description

In this role, you will own data at TerraFirma. Not a slice of it. Not the reporting piece. All of it: where it comes from, what shape it is in, where it lives, and whether it can be trusted. You are the person who makes data actionable for the business.

You will work closely with our Full Stack Developer on pipeline and integration work, and directly with business stakeholders to understand what they need to make decisions. You will spend a significant portion of your time cleaning, validating, and transforming data so that when a report goes in front of a leader, the numbers are right and the story is clear. If you are the kind of person who gets bothered by a broken data feed, who cannot leave a messy schema alone, and who gets satisfaction from turning chaos into something someone can actually use: this role is for you.

Key Responsibilities

Data Quality and Integrity

• Identifying, investigating, and resolving data quality issues across all connected systems
• Building and maintaining validation frameworks so bad data gets caught before it reaches reports
• Establishing and documenting data standards, naming conventions, and transformation rules
• Being the person stakeholders call when the numbers do not match

Data Lake and Pipeline Work

• Managing data ingestion into the data lake from multiple source systems
• Designing and maintaining transformation pipelines that produce clean, structured, report-ready data
• Collaborating with the Full Stack Developer on integration design where pipelines connect to application logic
• Monitoring pipeline health, catching failures early, and keeping things running

Reporting and Analytics

• Building and maintaining Power BI reports and dashboards that get used, not shelved
• Working directly with stakeholders to translate business questions into data models and visualizations
• Owning the reporting layer: if a report is wrong, stale, or confusing, that is your problem to fix
• Surfacing insights proactively, not just waiting to be asked

Data Architecture and Documentation

• Contributing to the ongoing design of TerraFirma's data lake architecture
• Documenting data sources, schemas, transformation logic, and lineage so the team is not dependent on tribal knowledge
• Partnering with IT leadership on the long-term data strategy for the organization

Experience and Education Requirements

• 3+ years working in a data-focused role with real ownership of data quality and reporting
• Demonstrated ability to take messy, inconsistent source data and produce something clean and trustworthy
• Strong SQL: not just SELECT statements, but complex joins, window functions, and performance tuning
• Power BI proficiency: you have built reports that people actually use to make decisions
• Python for data work: scripting, transformation, automation
• Clear communicator: you can explain a data discrepancy to a finance leader without making it a technical lecture
• Power BI: advanced report and dashboard development, DAX, data modeling, and row-level security
• Azure: Data Factory, Blob Storage, Synapse, or equivalent pipeline and lake tooling
• Microsoft 365 and Dynamics 365 / Business Central as primary data source systems
• SQL: strong query skills, stored procedures, schema design, and optimization

Beyond Microsoft, we expect:

• ETL/ELT design: you understand the difference, know when to use each, and can build both
• Data lake concepts: partitioning, schema-on-read vs schema-on-write, medallion architecture or equivalent
• Git and version control: your pipelines and transformation logic live in source control, not just in a tool UI
• Power Query / M: for lighter transformations and report-layer data shaping
• Experience with REST APIs and JSON: you will be pulling data from systems that expose APIs, not just databases

This job description is intended to describe the general nature and level of work performed by employees in this position. It is not intended to be an exhaustive list of all duties, responsibilities, or qualifications. Management reserves the right to modify, add, or remove duties as necessary.

CORE VALUES: AT TERRAFIRMA, OUR VALUES ARE IMPORTANT, WE DON'T JUST TALK ABOUT THEM, WE LIVE THEM. WE ARE LOOKING FOR PEOPLE WHO SHARE OUR VALUES OF FAMILY, INTEGRITY, RESILIENCE, AND MASTERY.

What We Offer:

As a family-oriented company, we provide industry-leading perks and benefits, including:

• Competitive Pay
• Paid Holidays & PTO
• Short and Long-Term Disability
• 401(k) Retirement Plan
• Life Insurance
• AD&D Insurance
• Wellness Programs

High school graduate or equivalent required. Applicants must be 21 years or older, as this position involves operating a company vehicle. We are a drug-free workplace. We are committed to equal employment opportunity (regardless of race, color, ancestry, religion, sex, national origin, sexual orientation, age, citizenship, marital status, disability, gender identity or Veteran status). We also consider qualified applicants regardless of criminal histories, consistent with legal requirements.