Associate Data Engineer

DESCRIPTION

Switchboard is seeking an Associate Data Engineer on behalf of our client, Open Technology Solutions (OTS). This is an early-career role for someone with a year or two of hands-on SQL and data work who wants to grow into a full data engineer. You'll join a five-person data engineering team where you'll build SQL ingestion processes, create dbt models, document how things work, and learn the architecture behind a modern Snowflake data stack. If you've written real code in a BI, analytics, or developer role and you're ready to make the jump into data engineering, we want to hear from you.

About Open Technology Solutions
Open Technology Solutions (OTS) is a CUSO (Credit Union Service Organization) providing shared technology services to credit union partners. Built on a cooperative model, OTS delivers enterprise-grade IT infrastructure, support, and innovation to its partner organizations, allowing them to compete at a higher level while keeping costs in check. OTS operates with the values of a credit union at its core: member-focused, collaborative, and committed to long-term relationships over short-term wins.

RESPONSIBILITIES

- Build, support, and optimize data pipelines using tools like Fivetran, dbt, and Python to move data between Snowflake, SaaS APIs, on-prem databases (Oracle, SQL Server), and other data stores.

- Write and run SQL for data ingestion and transformation, and build dbt models that turn raw data into analytics-ready structures.

- Support the design and implementation of data structures in Snowflake.

- Help automate monitoring and alerting on data quality, pipeline health, and overall data infrastructure.

- Create and maintain technical documentation for data products, processes, and lineage.

- Research and recommend new tools and methods to improve how data is ingested, stored, and transformed.

- Participate in scheduled weekend and after-hours maintenance windows and downtime testing as needed.

QUALIFICATIONS

- 1–2+ years of hands-on experience in data engineering, business intelligence, data analytics, or software development

- Real, hands-on SQL coding experience. You've written and run queries in production, not just read about them

- Exposure to Python and databases such as Snowflake, Oracle, or SQL Server

- Familiarity with ETL/ELT tools like dbt, Fivetran, or Matillion is a plus

- Experience with BI platforms (Power BI, Qlik, Tableau, or similar) is a plus

- Resourceful problem solver. You try to find the answer yourself first, and you know when to use your team

- Clear communicator who's comfortable talking through your work and asking questions

- Team-minded. You coordinate your work so teammates aren't left scrambling to review it at 9 p.m.

- You see documentation as part of the job, not an afterthought

- Flexible and willing to pitch in on occasional weekend or after-hours work

COMPENSATION AND DETAILS

- Compensation: $100,000–$120,000 base + 10% annual bonus target

- Benefits: Medical, dental, and vision; 401(k) with fully vested match; PTO and holiday pay; FSA; life, short-term, and long-term disability; student loan paydown program; tuition reimbursement

- Location: Englewood, CO. Hybrid, typically Tuesday–Thursday in office (Wednesdays required)

- Schedule: Full-time, exempt, with occasional weekend and after-hours work for scheduled maintenance

Sponsorship not available. Position only available to those with legal authorization to work in the United States.