Apply on Employer Site

RxFunction, Inc. · 1 month ago

Enterprise Data Architect

Eden Prairie, MN

Full-time

Hybrid

Senior Level, Lead/Staff

10+ years exp

RxFunction, Inc. is a leader in medical device innovation, seeking an Enterprise Data Architect to design and manage enterprise-wide data architecture. This role involves leading the development of data models, ensuring compliance, and enabling data-driven decision-making through a robust BI environment.

Health CareInformation ServicesInformation TechnologyMedical DeviceService Industry

Responsibilities

Define and implement an enterprise-wide data architecture strategy that integrates ERP, CRM, Billing, FileMaker, AWS S3, and other systems

Design and maintain logical and physical data models, including relational and dimensional models for reporting and analytics

Lead database design sessions, translating business requirements into system designs for complex projects

Develop and manage ETL/ELT pipelines to ensure clean, standardized, and optimized data flows

Establish and enforce data governance, master data management (MDM), and security standards

Ensure all data handling aligns with HIPAA, FDA, and healthcare compliance requirements

Define corporate standards for data format, quality, and lifecycle management

Build and manage a centralized data warehouse to support enterprise reporting

Enable enterprise-wide Power BI dashboards, reports, and analytics models

Define reporting standards and best practices across departments

Support ad hoc queries, reporting needs, and advanced analytics requests from business leaders

Ensure reporting environments are optimized for both transactional (OLTP) and decision support (OLAP) systems

Collaborate with IT, Finance, Operations, Manufacturing, and Patient Services to align architecture with organizational goals

Lead large, complex data projects, including project work plans, resource utilization, and milestone tracking

Mentor junior IT staff, business analysts, and consultants on best practices in data modeling, integration, and reporting

Serve as a subject matter expert for BI architecture and data integration strategy

Architect and oversee integrations between Microsoft Dynamics 365 Business Central (ERP), Dynamics CRM, Billing, FileMaker, AWS S3, SQL Server, and Power BI

Coordinate database performance monitoring and tuning, including optimization and indexing schemes

Research and recommend emerging technologies that enhance RxFunction’s data ecosystem

Qualification

Data architectureDimensional modelingData warehouse designETL/ELT developmentPower BISQL ServerAWS S3Communication skillsLeadership skillsProblem-solving skills