Enterprise Data Architect

Eden Prairie, MN - USA

Monthly Salary: USD 140000 - 160000

Posted on: 20 days ago

Vacancies: 1 Vacancy

Job Summary

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 RxFunctions data ecosystem.

Qualifications

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

Enterprise Data ArchitectLocation: Eden Prairie MN (Hybrid)Department: IT / OperationsEmployment Type: Full-timeOverviewRxFunction a leader in medical device innovation is seeking an Enterprise Data & Integration Architect to design implement and manage an enterprise-wide data architecture that supp...