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

Switchboard is seeking an Associate Data Engineer on behalf of our client, Open Technology Solutions. We are looking for a SQL, data warehouse, and data lake specialist who builds, supports, and optimizes the data pipelines that enable reporting, analytics, and business operations. You'll research, design, implement, and document best practices for data infrastructure—playing a crucial role in expanding the organization's use of data as a strategic asset. If you're passionate about turning raw data into reliable workflows and strategic insights, we want to hear from you.

About Open Technology Solutions

Open Technology Solutions (OTS) is a technology consortium empowering credit unions and community financial institutions to compete and thrive. They provide shared technology infrastructure and innovative solutions that help member institutions deliver exceptional service to their communities. With a people-first culture built on collaboration and technical excellence, OTS combines the stability of serving the financial sector with the innovation of a forward-thinking technology organization.

As a Data Engineer at Open Technology Solutions, you will:

• Build, support, and optimize data pipelines using tools like FiveTran, dbt, and Python to move data to/from Snowflake, SaaS API’s, on-prem databases (Oracle, SQL Server), and other data stores.
• Support the design, modification, and implementation of data structures in Snowflake to support data ingestion, integration, and analytics.
• Curate and transform data into appropriate structures for analytics and data science purposes using SQL, Python, SnowSQL, and transformation tools such as dbt.
• Design and implement processes to automate monitoring and alerting on source data quality, data ingestion and transformation processes, and the overall health of our data infrastructure.
• Create and produce technical documentation for data products, designs, and lineage.
• Research, recommend, and implement new methods and tools to support/optimize data pipelines and processes for data ingestion, data storage, data transformation, data quality, and automation.

Requirements

• 2-3 years of relevant data warehouse, business intelligence, and date engineering experience.
• Experience with data pipeline design and automation.
• Intermediate SQL knowledge and experience coding in Python.
• Experience with databases like Oracle, SQL Server, and Snowflake.
• Experience with advanced ETL/ELT tools administration (code deployment, security, setup and configuration).
• Experience with enterprise ETL/ELT tools like Fivetran, dbt, Matillion or other similar ETL/ELT tools.
• Experience with BI platforms (Power BI, Qlik) preferred.

Benefits

Location: Hybrid (3 days per week in our Englewood, CO office)

Compensation: $96K - $125K salary + bonus

Benefits:

• Comprehensive medical, dental, and vision insurance (starting first full month)
• 401(k) with company matching
• 11 paid holidays + PTO
• Student loan paydown program (up to $10,000 lifetime benefit)
• Tuition reimbursement (up to $5,250 annually)
• Service anniversary bonuses
• Company-paid life insurance, short-term and long-term disability
• Wellness reimbursement and additional unique perks