Data Solutions Engineer
Company Overview
Imagen Dental Partners is a community of the best players in the game. We surround the industry’s top dental experts with deep business expertise, resulting in the highest performing practices in the nation. We are the home for the exceptional, technology driven dentist. We strive for excellence in all that we do, supporting high achievers who embrace innovation. Founded by highly experienced industry experts we are expanding our footprint at tremendous speed. As a fast-growing startup, we look for people hungry for growth, who get things done, and are energized by a high-intensity environment.
Culture
We’re building a culture at Imagen where ‘A’ players can do their best work. Developing powerful leaders and world class culture that generate revolutionary results. That’s why our top priority is creating an environment in which talented people excel, collaborate, and do the most influential work of their careers. We value new ideas, fresh perspectives, and unique voices. Every. Day. We lead. We forge our own path in the marketplace. No one’s been where we’re going. And that’s just how we like it. We strive to make the lives of everyone associated with our partner practices better. To bring a smile to every face. We create community — and inspire that community to become a movement.
Mission
We are pioneering our own path to become Dentistry’s top player. We trust amazing people to do amazing things. Let’s grow together.
Position
We are seeking to hire an experienced Data Solutions Engineer to join our team. If you're a passionate, detail-oriented self-starter that finds delight in delivering innovative data solutions to consumers, Imagen is a great place to get ahead!
Responsibilities
- Develop and maintain high quality data pipelines from source ingestion to access layer, leveraging modern technologies and tools
- Translate business user requirements into technical solutions that drive data access, reporting, analytics, and/or AI
- Automate environment monitoring to assure timely and accurate data content
- Create, maintain, and update technical documentation
- Maintain and support data analytics platforms and warehouses
- Communicate key insights and findings to product teams and leadership
- Make data-driven decisions, think systematically about ROI and resolve complexity to drive results
- Develops solutions to complex problems which require the regular use of ingenuity and innovation
- Ensures solutions are consistent with organization objectives
Key Metrics
- Successful delivery of data solutions that drive annual company priorities and outcomes, according to timeline and requirements
- Data platform availability and accessibility according to SLAs
Experience
- Bachelor's degree or higher in Computer Science or related field
- 6+ years of experience as a Data Engineer or similar role
- Skilled in the following: Azure, Snowflake, Matillion/ADF, DBT, Data Modeling, DAX, API connectivity
- Proficiency in Data Warehouse / Business Intelligence environment with involvement in design, development, implementation, troubleshooting, and support of ETL/ELT process using Azure ADF/ Matillion
- Proven ability in developing Data warehousing, Operational Data Store (ODS), and Data Mart on Snowflake platform
- Excellent programming skills in writing Complex Stored Procedures, Queries, Views, User Defined Functions, Cursors, and Common Table Expressions using SQL
- Proven ability in Performance Tuning and Query Optimization by Indexing, Partitioning, and Denormalization
- An advanced level of SQL programming for data analysis is required
- Experience working in an Agile environment, preferred, including conceptualization, design, development, testing, selection, deployment, and post-implementation support
- Familiarity with various BI technologies and data governance principles
- Familiarity working in a fast-paced environment, with clear measurable outcomes
- Strong communication and collaboration skills
- Strong troubleshooting, problem solving and conceptualization skills