Data Architect

Job Description

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.

---