Manager – Business Intelligence Architecture

Job not on LinkedIn

November 20

Apply Now

Receive Emails with Similar Jobs

Ultradent Products, Inc.

WebsiteLinkedInAll Job Openings

Healthcare Insurance • Pharmaceuticals

Ultradent Products, Inc. is a company specializing in dental products and equipment. They offer a comprehensive range of products for dental professionals, including teeth whitening systems, restorative materials, endodontic products, orthodontics, surgical supplies, and various dental equipment such as LED curing lights and diode lasers. Ultradent focuses on providing high-quality solutions to enhance dental procedures and patient care. Their offerings are used in preventative and hygiene care, direct and indirect restoration, and tissue management among others.

1001 - 5000 employees

Founded 1978

⚕️ Healthcare Insurance

💊 Pharmaceuticals

📋 Description

• General & Core Engineering Thought leadership in technology innovation and transformation. • Maintaining applications ensuring high availability, performance and user experience. • Creates and maintains optimal data pipeline architecture on Azure platform. • Ensures that system designs adhere to solution architecture design and are traceable to functional as well as non-functional requirements. • Designs relational and non-relational data stores on Azure. • Builds analytical tools to provide actionable insights from key business performance metrics. • Leverages Azure Data Factory and Databricks to assemble large, complex data sets that meet end user and business requirements. • Designs new solutions and services to improve overall user experience. • Identifies, designs, and implements internal process improvements such as automating manual processes and optimizing data delivery. • Defines system design standards to improve and sustain standardization. • Expertise in Azure DevOps concepts and implementations, including git, CI/CD pipelines, IaC, docker containers, and Work Items. • Assists Manager-Data Administration in leading coordination with other staff to ensure data handling meets organizational objectives for data quality, business process management, and risk management. • Provides technical mentoring to other team members for best practices on data engineering and cloud technologies. • Designs and Governs Data Models: Defines and enforces logical and physical data models for both the Azure Data Lake and the Azure Synapse Analytics data warehouse. • Leads the effort to standardize data definitions, metadata management, and data lineage across the Azure platform to ensure consistency and quality. • Develops and maintains the multi-layered Data Lake architecture (e.g., Raw, Bronze, Silver, Gold zones) to optimize for ingestion, transformation, and consumption of data by both BI and AI initiatives. • Designs and implements real-time and batch data ingestion strategies, ensuring low latency and high reliability for critical business data. • Establishes and monitors data quality checks and validation rules within data pipelines to maintain a high level of trust in the datasets used for reporting and machine learning models. • Implements schema evolution strategies to manage changes in source data and prevent pipeline breaks. • Develops, trains, and deploys machine learning models using Azure Machine Learning (AML) / Azure AI Studio or equivalent platforms. • Builds end-to-end MLOps pipelines (e.g., model registration, automated retraining, deployment via Azure Kubernetes Service/Managed Endpoints) using Azure DevOps and AML. • Hands-on experience implementing data and AI workflow automation using n8n, Microsoft Power Automate, or equivalent tools to connect Azure services, databases, and enterprise applications. • Architects and implements low-code/no-code AI workflow automation using n8n or equivalent tools (e.g., Power Automate, Zapier, Apache Airflow).

🎯 Requirements

• BA / BS preferred; equivalent work experience will be considered. • Minimum of 7 years of successful, results-oriented experience in a diverse range of business and IT functions is ideal. • Hands on experience with Azure Data Lake, Azure Data Factory, SQL Data Warehouse Azure Blob, Azure Storage Explorer. • Hands on experience with Delta tables and implementing delta logic on data lakes and warehouse. • Hands on experience with implementing multi layered data lake architecture. • Hands on experience with implementing data warehouse architecture. • Hands on experience in creating Data Factory pipelines for on-cloud ETL processing; copy activity, custom Azure development etc. • PowerBi experience a plus.

🏖️ Benefits

• Medical/Dental & Other Insurances (eligible the first of month after 60 days) • Health Savings Account with employer contribution • 401K Plan with employer matching contribution • Employee access to discounted Ultradent products • Excellent Paid Time Off (PTO) and Medical Time Off (MTO) account to support medical and military events • Five days paid between Christmas and New Years • Education Assistance • Onsite Fitness Center