Solutions Data Architect

About Us

Morris & Dickson Co. is a leading pharmaceutical distribution company serving independent pharmacies with dedication, integrity, and a customer-first approach. With over 180 years of experience, we're known for our commitment to service, reliability, and innovation. We foster a supportive, dynamic workplace where employees are encouraged to thrive professionally and personally. Joining Morris & Dickson means joining a team dedicated to making a difference in healthcare.

Role Overview

We are seeking a highly skilled Solutions Data Architect to join our team. This role blends expertise with big data solutions, advanced analytics, web development, and testing. As an integral part of our organization, you will design robust data architectures, build scalable pipelines, create intuitive web interfaces, build advanced Power BI dashboards, and ensure rigorous quality standards through standardized testing practices. This role will help shape how Morris & Dickson utilizes data while collaborating across multiple stakeholder groups to build scalable solutions. This role reports to the VP, Data & Analytics.

Responsibilities

• Data Architecture and Engineering:
• • Design and implement scalable system architecture and automated CI/CD solutions.
  • Design and implement end-to-end data solutions using Databricks and Spark. Follow best practices and provide detailed communication to the team and company.
  • Develop scalable and optimized ETL pipelines for structured and unstructured data.
  • Ability to create fact / dimension tables for use in data marts and star schemas.
  • Collaborate with stakeholders to define data requirements, models, analytic discoveries, and dashboards.
  • Design and implement IaC solutions utilizing terraform or OpenTofu.
  • Build AI/ML projects with MlFlow, Scikit learn, and tensorflow.
  • Responsible for optimization of Databricks Data and monitoring.
• Collaboration:
• • Communicate complex technical concepts effectively to executive teams and non-technical stakeholders.
  • Act as a trusted advisor, provide recommendations that align with organizational objectives.
  • Translate business goals into actionable data solutions while designing robust architecture.
  • Work closely with business stakeholders to streamline data that allows the Data & Analytics team to deliver a single source of truth.
  • Provide training and documentation for implemented solutions.
• Data Visualization and Storytelling:
• • Design, develop, and maintain Power BI dashboards and interactive reports to meet business needs.
  • Create scalable and efficient data models within Power BI, ensuring optimal performance.
  • Develop custom DAX calculations and measures to enhance analytics capabilities.
  • Simplify complex datasets into star schemas with clear narratives that enable data-driven decision-making.
  • Incorporate user feedback to enhance visualization functionality and usability.
• Data Management:
• • Implement data governance and security measures to protect sensitive information by utilizing tools such as Unity Catalog.
  • Gather, clean, and integrate data from multiple sources, ensuring data accuracy and integrity with the end goal to build out data dictionaries and semantic layers for use by all stakeholders.
  • Collaborate with data engineers to define ETL workflows and maintain data pipelines.
  • Utilize Databricks tooling such as Unity Catalog and FiveTran to provide Data Management for each department within Morris & Dickson.
  • Implement and manage row-level security and other access controls in Power BI.
• Web Development:
• • Develop and maintain responsive web applications to enhance data visualization and user experience.
  • Integrate backend data solutions with dynamic web platforms.
  • Utilize modern frameworks and programming languages like Python, JavaScript, and HTML/CSS.
• Testing and Quality Assurance:
• • Conduct unit testing, integration testing, and performance testing for data solutions and web applications.
  • Troubleshoot and debug system issues effectively.
  • Ensure code reliability, scalability, and adherence to quality standards.

Requirements

• Expertise in Databricks/Spark or similar data engineering tools.
• Proven experience in data architecture design and developing scalable pipelines utilizing tools such as Autoloader and DABs.
• Proficiency in web development frameworks such as FastAPI, Flask, React, Svelte, or Vue.js.
• Solid understanding of software testing methodologies and tools such as Selenium, Pytest, Great Expectations, database constraints, and Postman.
• Strong programming skills in Python, SQL, and JavaScript.
• Experience with cloud platforms (Azure, AWS, Google Cloud).
• Knowledge of data visualization tools like Power BI or Tableau.
• Exceptional communication skills with the ability to engage effectively with leadership.

Preferred Qualifications

• 5+years in data pipeline development (Databricks, cloud platforms, or web development frameworks).
• Knowledge of containerization tools like Docker and orchestration platforms like Kubernetes.
• Familiarity with CI/CD pipelines for automated testing and deployment.
• Hands-on experience in machine learning pipelines and API development.
• Experience in the pharmaceutical or healthcare industry is a plus.

Comprehensive Benefits

• Medical, Dental, and Vision Insurance
• HRA, HSA, and FSA reimbursement accounts
• Basic & Voluntary Life Insurance
• Short & Long-term Disability Insurance
• Paid Time Off
• Paid Holidays
• Fitness Program Reimbursement
• Employee Assistance Program
• 401K Savings Plan with a company match

Why You'll Love Working with Us

• First and foremost, great people. We pride ourselves on being a family-owned company with a vision.
• Opportunity to work on cutting-edge projects combining big data and modern web technologies.
• Collaborative environment with cross-functional teams.
• Commitment to professional growth and development.