Data Architect

Data Architect

10+ years of experience in designing and developing Databricks. Design and develop scalable ETL/ELT pipelines using Databricks including Delta Lake, Auto Loader, and DLT. Develop batch, streaming, and CDC ingestion pipelines to enable efficient and near real-time data processing. Prior experience with data migration from various data sources like Redshift, DB2, Oracle, Mysql, PLSSql into databricks Implement ingestion patterns using Auto Loader with checkpointing and schema evolution for structured and semi-structured data Develop and maintain reusable DBX functions for data transformation, data quality checks, and validation logic, ensuring consistent implementation across DLT and notebook-based pipelines. Leverage Unity Catalog to establish secure data governance, enabling controlled access, lineage tracking, and management of External Locations and Volumes across workspaces. Partner with cross-functional teams to enable secure data sharing using Delta Sharing across internal domains and external partners. Integrate Power BI/Tableau/Looker with Databricks using optimized connectors (ODBC/JDBC) and Unity Catalog security controls Implement Medallion architecture (Bronze, Silver, Gold layers). Develop incremental and CDC-based ingestion pipelines Design and implement real-time streaming pipelines using Kafka and Structured Streaming. Optimize Spark jobs, SQL queries, and streaming pipelines. Strong SQL and data modeling skills. Experience with cloud platforms and distributed systems. Build, package, and deploy Databricks data pipelines using Databricks Asset Bundles (DAB), with automated CI/CD processes managed through GitHub or GitLab. Diverse Lynx LLC is an Equal Employment Opportunity employer. All qualified applicants will receive due consideration for employment without any discrimination. All applicants will be evaluated solely on the basis of their ability, competence and their proven capability to perform the functions outlined in the corresponding role. We promote and support a diverse workforce across all levels in the company.