Source Meridian is a development software company that works to solve the industry’s most challenging problems in healthcare practices. We are laser focused on specific technologies in the healthcare and life science industries: Healthcare technology, artificial intelligence, and healthcare interoperability.
About the role
We're looking for a Data Architect to lead the design and evolution of the data platform for our client. This is a hands-on architecture role: you'll own the target-state design across ingestion, transformation, storage, and consumption on Databricks and AWS, and you'll stay close enough to the code to prototype, review, and unblock the engineering team. You'll act as the technical counterpart to the client's data and engineering stakeholders — translating business needs into architecture decisions, defending trade-offs, and setting the standards the rest of the data team builds against. Success looks like a platform that is well-governed, cost-aware, and trusted by the business.
What You'll do
- Define and document the target data architecture (medallion/lakehouse layers, data models, contracts, integration patterns) and drive it from design to production.
- Lead architecture and design reviews for pipelines built by the data engineering team; set coding, testing, and deployment standards.
- Own data governance: Unity Catalog structure, access model, lineage, data quality rules, and PII handling.
- Design and optimize ingestion and transformation pipelines (batch and streaming) on Databricks/Spark over AWS sources.
- Partner directly with client stakeholders — engineering, analytics, and business — to gather requirements, present options, and get architectural decisions approved.
- Guide cost and performance optimization (cluster/warehouse sizing, storage layout, partitioning, workload isolation).
- Mentor senior and mid-level data engineers, and provide technical input into hiring and team growth.
- Contribute to roadmap planning and estimate effort for new data initiatives
Required Qualifications
7+ years in data engineering/data platform work, with at least 2–3 years in an architect or lead role.
Databricks in production: Delta Lake, Unity Catalog, workflows/jobs, SQL warehouses, performance tuning.
Strong Apache Spark (PySpark and Spark SQL) — able to reason about execution plans, shuffles, and optimization.
AWS data services: S3, IAM, Glue, Lambda, networking fundamentals.
Advanced SQL and dimensional/data modeling (star schema, slowly changing dimensions, data vault a plus).
Design and operation of production ELT/ETL pipelines, orchestration, CI/CD, and infrastructure-as-code.
Data governance and security practice: access control, lineage, cataloging, data quality frameworks, PII/compliance handling.
Demonstrated ability to produce architecture artifacts (diagrams, decision records, standards) and defend them with stakeholders.
Nice to have
- SQL Server experience (high priority) — T-SQL, SSMS, SSIS, stored procedure logic, and experience migrating or integrating SQL Server workloads into a lakehouse.
- Experience with legacy-to-modern data platform migrations.
- BI tooling exposure (Power BI, Tableau) and semantic layer design.
- Streaming/CDC experience (Structured Streaming, Kafka, Debezium, Lakeflow/DLT).
- FinOps or cloud cost optimization experience.
- Prior experience in a consultancy or client-facing delivery model.
✔ Permanent contract
✔ High-impact projects in the healthcare industry
✔ Learning and continuous growth environment 🚀
✔ Competitive salary based on experience 💰
✔ Collaborative and international team
📍 Apply only if you reside in Ecuador 📍
At Source Meridian, you’ll be part of a high-impact tech-health company, building products that truly make a difference.
If you meet the profile — or know someone who might be interested — apply now!
We’d love to meet you 💬
Skills Required
- 7+ years of experience in data engineering or data platform work
- 2–3 years of experience in an architect or lead role
- Production experience with Databricks, including Delta Lake, Unity Catalog, workflows/jobs, SQL warehouses, and performance tuning
- Strong Apache Spark skills, including PySpark and Spark SQL, execution plans, shuffles, and optimization
- Experience with AWS data services, including S3, IAM, Glue, Lambda, and networking fundamentals
- Advanced SQL and dimensional/data modeling, including star schemas and slowly changing dimensions
- Experience designing and operating production ELT/ETL pipelines, orchestration, CI/CD, and infrastructure as code
- Experience with data governance and security, including access control, lineage, cataloging, data quality frameworks, and PII/compliance handling
- Ability to produce architecture artifacts and defend architecture decisions with stakeholders
- SQL Server experience, including T-SQL, SSMS, SSIS, stored procedure logic, and lakehouse migration or integration
- Experience with legacy-to-modern data platform migrations
- BI tooling exposure, including Power BI or Tableau, and semantic layer design
- Streaming or CDC experience with Structured Streaming, Kafka, Debezium, Lakeflow, or Delta Live Tables
- FinOps or cloud cost optimization experience
- Consultancy or client-facing delivery experience
What We Do
As a software development company, our mission is to provide our people with interesting projects to learn and grow, and to provide our clients with the best possible experience in software solutions for their needs. Every Rocketeer has unique skills and knowledge, and together we form a highly skilled crew that is always ready to take on new challenges and overcome them successfully. Source Meridian is a home without structures nor labels, since this journey is destined for success based on humanity, freedom, development, and growth 🔥🔥🔥 Right now, we're on the hunt for talent: 💻 Senior Front Developer/React 💻 Mide Site Reliability Engineer 💻 Senior Data Engineer 💻 Mid Fullstack/Angular/Python Some of the awesome benefits and perks we offer: 🚀Healthcare plan 🚀Workout bonus 🚀Bonus for building your home office 🚀English lessons 🚀Bonus for learning platform 🚀Internet & foodie cart bonus 🚀Streaming subscription 🚀Flexible schedule 🚀Collective vacations at the end of the year If you are passionate about technology and want to work with a team of talented professionals, please do reach out here 👉🏻 https://sourcemeridian.com/join-us/#joinus We look forward to hearing from you!
