Associate Data Engineer

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.

• →

  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.

• 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