Job Url: https://www.remoterocketship.com/company/morrisdickson/jobs/solutions-data-architect-united-states-remote Job Description: Morris & Dickson Co., LLC Website LinkedIn All Job Openings Morris & Dickson Co. , LLC is the largest independent full-line pharmaceutical distributor in the United States, focused on reliable, next-day delivery of pharmaceutical and healthcare products. With a diverse inventory of over 30,000 SKUs, the company services health systems, independent pharmacies, specialty pharmacies, and alternate care facilities across 27 states. Established in 1841, Morris & Dickson is known for its exceptional personal service, transparent pricing, and commitment to elevating patient care in the healthcare supply chain. 501 - 1000 employees Founded 1841 βš•οΈ Healthcare Insurance πŸ’Š Pharmaceuticals 🀝 B2B Solutions Data Architect 10 hours ago πŸ‡ΊπŸ‡Έ United States – Remote ⏰ Full Time 🟑 Mid-level 🟠 Senior 🚰 Data Engineer AWS Azure Cloud Docker ETL Flask JavaScript Kubernetes Python React Selenium Spark SQL Svelte Tableau Tensorflow Terraform Unity Vue.js Apply Now Receive Emails with Similar Jobs Report problem πŸ“‹ Description β€’ 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. β€’ 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. β€’ 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. β€’ 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. β€’ 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. β€’ 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. πŸ–οΈ 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