Data Solution Architect

Our organization is seeking an experienced Data Architect to play a crucial role in designing and implementing scalable enterprise analytics solutions. This position requires a deep understanding of modern data tools, including Databricks, Power BI, and cloud platforms.

The successful candidate will be responsible for architecting data virtualization, ETL, and semantic layers that balance unification, performance, and data transformation while reducing data proliferation. Additionally, they will support development planning by breaking down features into work aligned with the architectural direction runway.

This role also involves participating in pilots and proofs-of-concept for new patterns, creating robust documentation of architectural direction, patterns, and standards, presenting and training engineers and cross-team collaborators on architecture strategy and patterns, collaborating with data engineers to build and optimize ETL pipelines, ensuring efficient data ingestion and processing from multiple sources.

The Data Architect will design robust data models and processing layers that support both analytical processing and operational reporting needs. They will also develop and implement best practices for data governance, security, and compliance within Databricks and Power BI environments, ensuring seamless data flows across platforms.

We are looking for a subject matter expert who can provide thought leadership and strategic guidance on data architecture, advanced analytics, and data mastering best practices. The ideal candidate will have hands-on experience with BI solutions, including report development, dashboard creation, and optimization, as well as expertise in cloud platforms, data lakes, and data warehouses.

Key Responsibilities:

• Design and implement scalable enterprise analytics solutions using modern data tools.
• Architect data virtualization, ETL, and semantic layers that balance unification, performance, and data transformation.
• Support development planning by breaking down features into work aligned with the architectural direction runway.
• Participate in pilots and proofs-of-concept for new patterns.
• Create robust documentation of architectural direction, patterns, and standards.
• Presentation and training of engineers and cross-team collaborators on architecture strategy and patterns.
• Collaboration with data engineers to build and optimize ETL pipelines.
• 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.
• Ensure seamless data flows across platforms.

Requirements:

• 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 data management and data solution architecture.
• Diploma and 10 to 12 years of experience in data management and data solution architecture.

Functional Skills:

• Minimum of 3 years of hands-on experience with BI solutions.
• 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, data lakes, and data warehouses.
• Strong knowledge of ETL processes, data pipelines, and integration technologies.

Good-to-Have Skills:

• Experience in developing differentiated and deliverable solutions.
• Experience with human data, ideally human healthcare data.

Professional Certifications:

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

Soft Skills:

• Excellent analytical and troubleshooting skills.
• Deep intellectual curiosity.
• Highest degree of initiative and self-motivation.
• Strong verbal and written communication skills.
• Confidence technical leader.
• Ability to work effectively with global, virtual teams.
• Ability to manage multiple priorities successfully.