Business Intelligence & Data Engineering

Job Details

MBH 7th Street Corporate Offices - Phoenix, AZ

Full Time

Bachelors Degree

Day

Health Care

Description

This is where you change your story…

At Meadows we understand that new directions to career advancing and improvement can be scary, but we are excited to offer you a possible new rewarding chapter with us! Come join us in transforming lives!

Who are we?

Meadows Behavioral Health is a leader in the behavioral health industry. We offer a range of specialized programs including residential, outpatient and virtual treatment. We provide care for drug and alcohol addiction, trauma, sexual addiction, behavioral health conditions, and co-occurring disorders. We offer state-of-the-art care including neurofeedback and other services. Our evidence-based approach is rooted in decades of clinical experience, with more than 45 years in the field. Our approach is different and success stories from our patients are the proof.

Who are you?

Are you compassionate, innovative and have a passion to make an impact? Are you looking to get your foot in the door with a company that will believe in your abilities and train you to advance? 75% of our current top-level executive staff are organic internal promotions from within.

We might be a perfect fit for you!

Position Summary:

The Data Engineer will play a crucial role in building, maintaining, and enhancing business intelligence solutions, focusing on data modeling, report building, and data analysis within cloud-based platforms, mainly Microsoft Azure. This role involves designing and optimizing data pipelines using Azure Data Factory, managing data lakes and data warehouses using Microsoft Azure Synapse, and creating meaningful reports and dashboards within Tableau. The Data Engineer will be responsible for designing, coding, and supporting functional intra-departmental data procedures and process flows, with additional focus on cross-departmental data integration procedures through ETL process builds. The Data Engineer will also be responsible for performing ad hoc SQL queries to extract data for analysis within the requesting department, ensuring the integrity and accessibility of critical business data to support decision-making. This role is not an analyst role and is majority focused on the technical "to-do" of making data available for the business in a form or fashion that the data can be analyzed. The Data Engineer needs to be comfortable building all aspects of the data pipeline from source through to storage, then presentation, rather than focusing on analysis of the impact of what the data means to the business.

Essential Job Functions:

Design, develop, and maintain ETL/ELT pipelines using Microsoft Azure Data Factory to move, transform, and load data from various sources into Azure Data Lakes and Azure Synapse. Primary focus on enhancement of data integration, normalization, and standardization for business intelligence and reporting.

Build, manage, and monitor data pipelines and ETL processes along with documentation and usage statistics/KPIs to improve processing performance, database capacity issues, data replication, and other distributed data issues.

Responsible for designing and building interactive dashboards, alerts, and reports on both a recurring and ad-hoc basis with our BI tools and platforms, primarily Tableau. Develops reports as needed against multiple types of data sources.

Design and implement data models for use in Tableau for reporting and dashboarding. Ensure data integrity, quality, and consistency in Tableau reports and dashboards.

Work closely with business stakeholders to understand their data needs and provide via ad hoc data extraction. Write and execute queries against the data warehouse or other sources in support of these ad hoc data requests and quick reporting needs. The sources include both SQL and No-SQL databases.

Implement security and access controls for databases and data pipelines to ensure compliance with security standards and protect sensitive data. Maintain proper documentation of data access, database schemas, and transformation logic for transparency and governance.

Collaborate with the Director of Infrastructure on cloud data architecture and integration strategies, ensuring that Azure Data Lakes and Azure Synapse are optimized for performance and scalability.

Creates and fosters a collaborative, friendly, and supportive environment for information technology users to interface their requirements and projects and troubleshoot their application and data-related problems.

Qualifications

Education, Skills, and Experience Requirements:

Bachelor's degree in computer science, data science, information technology, or related field, or equivalent education and experience.

Relevant certification in cloud platforms, data analytics, or business intelligence is a plus (i.e., Microsoft Certified: Azure Data Engineer Associate, Tableau Desktop Specialist).

At least 2 years of experience in data modeling and report building, specifically using Tableau for dashboard and report creation.

Direct experience with Microsoft Azure Data Factory, Azure Data Lakes, and Azure Synapse for building, maintaining, and optimizing data pipelines and data integration solutions.

Proficiency in SQL for querying relational and non-relational data sources, including experience with ad hoc queries for quick data extraction and reporting.

Experience in developing, maintaining, and enhancing ETL/ELT processes for data transformation and loading in cloud-based environments.

Strong understanding of data warehousing concepts, data modeling techniques, and best practices for cloud data architecture.

Proficiency in scripting languages like Python or R is preferred, particularly for data manipulation and analysis.

Experience with other AI/ML-based analytics tools or other reporting platforms is a plus, but not required. Examples include Crystal Reports, PowerBI, Salesforce CRM Reporting, IBM Cognos, etc.