ActsSocial

For the best experienceDownload the Mobile App

ActsSocial

For the best experienceDownload the Mobile App

Director, ERP Data Architecture

Location
Remote/Work From Home
Type
Full Time
Status
Inactive
Job Published
07-01-2025

Description

- - Director of ERP Data Architecture
    
    Job Summary
    
    About RedSail Technologies:
    
    At RedSail, we’re transforming pharmacy and healthcare software through innovation and a commitment to data-driven decision making. We are building a next-generation data platform powered by Microsoft Fabric to unify ERP, operational, and customer data across all lines of business. We are seeking a hands-on Director of Data Architecture to lead this strategic initiative and drive impact across our go-to-market and internal teams.
    
    Role Overview
    
    We are looking for a technically strong and strategically minded Director of Data Architecture to lead RedSail’s ERP data architecture and analytics practice. This role will be the cornerstone for integrating and enabling data-driven insights across Marketing, Sales, Implementation, Customer Support, Finance, and other departments.
    
    You will own the architecture, design, and implementation of modern data solutions on Microsoft Fabric, while also driving stakeholder engagement and cross-functional alignment.
    
    Key Duties
    
    Architect and operationalize Microsoft Fabric solutions (including OneLake, Lakehouse’s, Data Factory, and Power BI) to support real-time and historical analytics for ERP data.
    Define and enforce data governance, security, quality, and documentation standards across all ERP-related datasets.
    Design, build, and maintain semantic models in Power BI that support self-service reporting across departments such as Sales, Marketing, Support, and Finance.
    Lead the integration of ERP and CRM data sources (e.g., Dynamics 365, Bespoke CRMs, etc.) into the centralized Fabric Lakehouse environment.
    Define and manage a data product framework aligned with business domains, including ownership, SLAs, quality rules, and access policies.
    Partner with executive leadership to establish KPIs and reporting strategies aligned with company goals and business unit metrics.
    Build and enforce standards for data ingestion, transformation, and distribution pipelines, ensuring security, scalability, and observability.
    Serve as the bridge between business users and data engineering teams, translating functional requirements into technical data solutions.
    Drive enablement and adoption of Fabric tools across analysts, developers, and business users through training and documentation.
    Conduct hands-on solution design and code reviews, contributing to complex ETL pipelines and Lakehouse optimizations.
    Guide the modernization of legacy reporting solutions by consolidating siloed systems into a unified Microsoft Fabric environment.
    Establish and track a data architecture roadmap with milestones for delivery, refactoring, automation, and Fabric feature adoption.
    Collaborate with Finance and other key RedSail Departments to ensure data accuracy, reconciliation, and auditability within their datasets.
    Work with Implementation and Support leadership to deliver analytics on deployment timelines, ticket resolution, customer satisfaction, and other operational KPIs.
    Champion data quality management practices, implementing monitoring and alerting for critical data flows.
    Migrate our existing Microsoft SQL Server DB’s into Fabric.
    Stay abreast of Microsoft Fabric roadmap updates and emerging best practices, incorporating innovations into the data strategy.
    
    Education/Training
    
    Bachelor's Degree or 4 plus years in a Microsoft Data Architect role.
    
    Required Work Experience/Skills
    
    Proven experience in ERP data integration and architecture, preferably supporting GTM, implementation, support, and finance teams.
    Hands-on expertise with Microsoft Fabric, including:
    OneLake, Lakehouse, Data Factory pipelines
    Delta Lake, Power BI Direct Lake mode
    Strong experience with data modeling, especially for customer lifecycle, pipeline, and financial data structures.
    Familiarity with data governance tools (e.g., Microsoft Purview) and security standards (RBAC, data classification, etc.).
    Demonstrated success in stakeholder engagement across multiple business units.
    Comfortable leading architecture while writing code, configuring Fabric components, and supporting technical delivery.
    Experience migrating Microsoft SQL Server DB’s and SSIS jobs into Fabric
    
    Preferred Work Experience/Skills
    
    Experience in healthcare industry.
    Experience with Power Platform (Power Apps, Power Automate) is a plus.
    Certifications: Dynamics 365 certifications are highly valued.
    Prior experience with Snowflake and Dremio.
    
    Discretionary Judgment
    
    Uses independent judgment and discretion based upon the employee’s experience in the position and knowledge of the products, equipment, and services
    Uses good judgement and possesses ethical work values
    
    Physical Demands, Working Conditions, and General Employment Guidelines
    
    Moderate or high levels of stress may be experienced in the performance of the job
    Position is performed in a general office environment, home office, or approved remote workspace where physical work includes, but is not limited to, sitting, standing, reaching, kneeling, bending, and lifting to 25 lbs.
    
    Equipment
    
    Daily use of the Microsoft Teams (phone), computer, printer, and other routine office equipment
  - Must have internet access
  Safety to Self and Others
  
  Little responsibility for safety of others. The job is performed in an office setting where there are no hazardous materials or equipment
Working Conditions/Hazards

Position is performed in an open office environment or approved remote work location