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.