Data Engineer - Operations Technology

About Mindful Support Services  We are a business-to-business support service for independent mental healthcare businesses, which helps providers service a growing client base. We provide administrative and organizational services to simplify the processes of lead-generation, marketing, billing, and collecting payments from patients and insurers. Our teams currently support over 2,000 independent mental health providers, who serve over 25,000 clients per week across 15 locations throughout 5 states, as well as virtually via Telehealth.   We have built the Mindful Therapy Group brand from the ground up with years of dedication to solving the complex processes of the mental healthcare landscape in innovative ways, creating a platform geared toward growth, and working to meet our mission of creating improved access to high quality mental healthcare.     About the Role  The Data Engineer – Custom Data Solutions will serve as a technical generalist and problem-solver across multiple departments and business units. Reporting to the Lead Technical Project Manager, this role will support the Operations Team and other internal stakeholders to investigate business challenges designing and delivering custom-built solutions that support operational success. You will develop tools to optimize workflows, integrate systems, and manage our data pipelines. This role will work with both internal and vendor-supported initiatives—all while establishing and maintaining clear documentation and process standards. This is a full-time, in-person role based out of our Mountlake Terrace Headquarters with travel to other Mindful Support Services locations as needed. Responsibilities Write and maintain clean, efficient code in SQL.  Lead development efforts including creating custom scripts, working with new APIs, automating workflows, and designing secure and efficient data pipelines.  Build and maintain stored procedures and custom queries to support reporting and operational workflows.  Utilize Azure tools for cloud-based development and solution deployment.  Scope and plan technical initiatives, estimating time, effort, and required resources. Establish and maintain detailed, standardized documentation for all custom-built tools and workflows.  Propose improvements to existing systems and processes, driving innovation across the business.  Knowledge of data modeling, warehousing, and governance.  Create and maintain ETL processes to extract, transform, and load data from various sources into data warehouses or databases.  Write and optimize SQL queries for data manipulation, reporting, and analysis.  Requirements Qualifications  Bachelor’s degree in Computer science, Information Systems, OR equivalent experience in a related field.  4+ years of experience as a data engineer, data analyst, solution engineer, software developer, application developer, or similar role.  Strong working knowledge of SQL, Power BI, Logic apps, Webhooks, JavaScript, T-SQL, SQL Server, and PowerShell.  Knowledge of Dev-Ops processes (including CI/CD) and Infrastructure as code. Solid understanding of data structures, database design principles, and ETL/data pipeline development.  Experience developing and maintaining custom applications and backend logic (e.g., stored procedures, automation tools, SQL databases).  Familiarity with Azure tools and services (e.g., Logic Apps, Azure Functions, Data Factory).  Ability to design and implement ETL processes to extract, transform, and load data from various sources into SQL Server databases. Strong analytical and proactive problem-solving skills is essential, especially in relation to mapping and understanding business process, and working with APIs with differing syntax.  Understanding and experience with Python, JavaScript and PowerShell.  Effective communicator with the ability to tailor technical information for different audiences. Additional Skills Database Design Performance Tuning Data Warehousing SSIS / ADF Data Integration Data Security and Data Masking Work Environment  This is an in-person position based at our Mountlake Terrace Headquarters. The role requires occasional travel to other Mindful Support Services office locations, including out-of-state trips when necessary. Off-site travel may also be needed to support projects, equipment setup, or vendor coordination.  The responsibilities listed above are not exhaustive. Duties and responsibilities may evolve over time with or without formal notice.  Benefits Compensation and Benefits: 75% employer covered Health, Dental & Vision benefits plan 401(k) savings plan with employer matching upon eligibility 8 paid holidays 15 PTO days accrued annually Professional and career development opportunities Compensation evaluated with opportunities for advancement It is a conflict of interest to simultaneously be an employee of Mindful Support Services and a client of Mindful Therapy Group. Job Type: Full-time Pay: $80,000 - $95,000 per year