Data Architect - Precision Medicine Team

Roles & Responsibilities:

• Architect scalable enterprise analytics solutions using Databricks, Power BI, and other modern data tools.
• Leverage data virtualization, ETL, and semantic layers to balance need for unification, performance, and data transformation with goal to reduce data proliferation
• Support development planning by breaking down features into work that aligns with the architectural direction runway
• Participate hands-on in pilots and proofs-of-concept for new patterns
• Create robust documentation of architectural direction, patterns, and standards
• Present and train engineers and cross-team collaborators on architecture strategy and patterns
• Collaborate with data engineers to build and optimize ETL pipelines, ensuring efficient data ingestion and processing from multiple sources.
• Design robust data models, and processing layers, that support both analytical processing and operational reporting needs.
• Develop and implement best practices for data governance, security, and compliance within Databricks and Power BI environments.
• Ensure the integration of data systems with other enterprise applications, creating seamless data flows across platforms.
• Provide thought leadership and strategic guidance on data architecture, advanced analytics, and data mastering best practices.
• Develop and maintain Power BI solutions, ensuring data models and reports are optimized for performance and scalability.
• Serve as a subject matter expert on Power BI and Databricks, providing technical leadership and mentoring to other teams.
• Collaborate with stakeholders to define data requirements, architecture specifications, and project goals.
• Continuously evaluate and adopt new technologies and methodologies to enhance the architecture and performance of data solutions.

Basic Qualifications and Experience:

• Masters degree with 6 to 8 years of experience in data management and data solution architecture
• Bachelors degree with 8 to 10 years of experience in in data management and data solution architecture
• Diploma and 10 to 12 years of experience in in data management and data solution architecture

Functional Skills:

Must-Have Skills:

• Minimum of 3 years of hands-on experience with BI solutions (Preferable Power BI or Business Objects) including report development, dashboard creation, and optimization.
• Minimum of 7 years of hands-on experience building Change-data-capture (CDC) ETL pipelines, data warehouse design and build, and enterprise-level data management.
• Hands-on experience with Databricks, including data engineering, optimization, and analytics workloads.
• Deep understanding of Power BI, including model design, DAX, and Power Query.
• Proven experience designing and implementing data mastering solutions and data governance frameworks.
• Expertise in cloud platforms (AWS), data lakes, and data warehouses.
• Strong knowledge of ETL processes, data pipelines, and integration technologies.
• Strong communication and collaboration skills to work with cross-functional teams and senior leadership.
• Ability to assess business needs and design solutions that align with organizational goals.
• Exceptional hands-on capabilities with data profiling, data transformation, data mastering
• Success in mentoring and training team members

Good-to-Have Skills:

• Experience in developing differentiated and deliverable solutions
• Experience with human data, ideally human healthcare data
• Familiarity with laboratory testing, patient data from clinical care, HL7, FHIR, and/or clinical trial data management

Professional Certifications (please mention if the certification is preferred or mandatory for the role):

• ITIL Foundation or other relevant certifications (preferred)
• SAFe Agile Practitioner (6.0)
• Microsoft Certified: Data Analyst Associate (Power BI) or related certification.
• Databricks Certified Professional or similar certification.

Soft Skills:

• Excellent analytical and troubleshooting skills
• Deep intellectual curiosity
• Highest degree of initiative and self-motivation
• Strong verbal and written communication skills, including presentation to varied audiences of complex technical/business topics
• Confidence technical leader
• Ability to work effectively with global, virtual teams, specifically including leveraging of tools and artifacts to assure clear and efficient collaboration across time zones
• Ability to manage multiple priorities successfully
• Team-oriented, with a focus on achieving team goals
• Strong problem solving, analytical skills;
• Ability to learn quickly and retain and synthesize complex information from diverse sources.