North American Dental Group (NADG) · 10 hours ago
Data Warehouse Architect
Pittsburgh, PA
Full-time
Hybrid
Senior Level, Lead/Staff
8+ years expNorth American Dental Group (NADG) is the fastest growing dental services organization in the United States, consisting of a network of over 231 dental practices. They are seeking a Business Intelligence Architect to design and develop data models, ensure compliance with data security policies, and integrate data across various systems to support analytical reporting.
DentalHealth CareInsuranceMarketing
Hiring Manager
Karleigh McCord
Responsibilities
Design develops and revises conceptual, logical, and physical data models that conform to Data Architecture standards for the Digital Data Architecture
Determines database structural requirements by analyzing business operations, applications, and programming; reviewing objectives with business partners; evaluating current systems
Applies expertise and best practices to the development and revision of data architecture standards and conventions
Partners with infrastructure and cyber team to ensure compliance with data security and privacy policies and procedures
Partners business users to obtain requirements for enhancements and/or new analytic assets
Understands how data is used to support analytical and/or operational reporting including architectural dependencies, high-volume processing, and enterprise-level integration
Works with teams to integrate data across clinical, administrative, and financial source systems including the management of critical master data
Writes and/or reviews functional and technical specification documents
Responsible for maintaining integrity of database information
Provides off hours support of critical report production applications and ETL’s when necessary
Manages middleware interface programs and or applications that move data between systems using ETL functions
Develops custom code and scripts to support delivery and presentation of data warehouse
Create data flows and conceptual models defining the informational needs of solutions
Makes and champions technical recommendations for more efficient troubleshooting and issue resolution
Qualification
Required
8+ years in Data Modeling and Data Warehouse concepts, design and best practices
8+ years in Data Processing concepts, design and best practices, ETL, ELT
Proven ability to troubleshoot DW environment related issues, such as dependencies, keys
Proven ability to design, support DW and processing with large volumes of data and experience tuning ETL, reports and queries
Expertise with Microsoft SQL Server - SQL Server Integration Services (SSIS) or similar
Expertise in SQL programming
Experience in SQL Database administration
Proving experience in building and maintaining large, complex Data Warehouses
Strong ability to build consensus; ability to influence others
Experience working both independently and, in a team, oriented collaborative environment
Strong experience in current software engineering and solution delivery methodologies
Ability to communicate, both verbally and in writing, in a clear, concise and professional manner
Works effectively under pressure, can manage multiple priorities simultaneously and can work without direct supervision
Expert level in excel and MS Office Suite
Off hours support will be required
Preferred
Experience working with Power BI
Experience in the healthcare industry
BI Architect Experience
Company
North American Dental Group (NADG)
North American Dental Group is a premier dental group with a commitment to industry-leading service and care for EVERY PATIENT, EVERY VISIT.
1001-5000 employees
H1B Sponsorship
North American Dental Group (NADG) has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (1)
2024 (1)
2022 (2)
2021 (3)
Funding
Current Stage
Late StageTotal Funding
unknownKey Investors
ABRY Partners
2019-08-19Acquired
2015-08-10Private Equity
Leadership Team
Kenneth Cooper
CEO
Devitt Kramer
General Counsel and Secretary
Recent News
2025-11-10
2025-10-11
Company data provided by crunchbase