Switchboard Hiring ยท 1 month ago
Associate Data Engineer
Denver, CO
Full-time
Hybrid
Entry, Mid Level
$96K/yr - $125K/yr
2+ years expSwitchboard is seeking an Associate Data Engineer on behalf of Open Technology Solutions. The role involves building, supporting, and optimizing data pipelines to enhance reporting, analytics, and business operations, while also documenting best practices for data infrastructure.
Human Resources
No H1B
Responsibilities
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
Qualification
Required
2-3 years of relevant data warehouse, business intelligence, and data 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
Preferred
Experience with BI platforms (Power BI, Qlik)
Benefits
Comprehensive medical, dental, and vision insurance (starting first full month)
401(k) with company matching
Open 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
Company
Switchboard Hiring
Switchboard Hiring gives growing teams the best of both worlds: the insider judgment of an internal talent leader with the reach and firepower of a top agency, all in one embedded senior recruiter.
2-10 employees
Funding
Current Stage
Early StageCompany data provided by crunchbase