Enterprise Data Architect

Location: Eden Prairie, MN (Hybrid)

Department: IT / Operations

Employment Type: Full-time

Overview

RxFunction, a leader in medical device innovation, is seeking an Enterprise Data & Integration Architect to design, implement, and manage an enterprise-wide data architecture that supports our ERP, CRM, Billing Systems, FileMaker, AWS S3, SQL, and future data warehouse initiatives.

This role will not only build seamless interconnections across systems but also lead the design of relational and dimensional data models, establish reporting and analytics standards, and ensure data integrity, compliance, and scalability. The Architect will play a pivotal role in enabling data-driven decision-making by developing a robust BI environment (with Power BI as our primary platform) and mentoring IT and business staff.

Key Responsibilities

Data Architecture & Modeling

• 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.

Data Governance & Compliance

• 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.

Reporting & Business Intelligence

• 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.

Leadership & Collaboration

• 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.

Systems Integration & Performance

• 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.

Qualifications

• Bachelor’s degree in Computer Science, Information Systems, Data Engineering, or related field.
• 10 years of business/technology experience with at least 5 years implementing enterprise data management solutions.
• Proven expertise in data architecture, dimensional modeling, and data warehouse design.
• Hands-on experience with ERP (Dynamics 365 Business Central), CRM (Dynamics CRM), Billing systems, FileMaker, and AWS S3.
• Strong knowledge of SQL Server, Azure SQL, Dataverse, and Power Platform
• Proficiency with BI tools, especially Power BI or Tableau is a plus.
• Experience with ETL/ELT development and integration frameworks.
• Familiarity with Big Data platforms (Snowflake, Redshift, Hadoop) a plus.
• Strong understanding of data governance, compliance (HIPAA/FDA), and security best practices.
• Excellent problem-solving, communication, and leadership skills.
• Ability to manage complex, multi-disciplinary projects and deliver results on time and within budget.