We are seeking an experienced Lead Data Engineer with strong expertise in Databricks, PySpark, Python, SQL, and modern cloud-based data platforms. The ideal candidate will have a combination of approximately 70% data engineering and 30% analytical responsibilities.
This role involves designing and maintaining scalable data pipelines, optimizing large-scale data processing environments, and supporting financial analytics and data science initiatives.
The successful candidate will bring hands-on experience with financial or payroll data, lakehouse architecture, data governance, and analytical workflows. The individual will collaborate with data scientists, economists, and business stakeholders to deliver reliable data solutions supporting financial research and business intelligence.
Design, develop, and maintain scalable ETL/ELT pipelines for payroll, financial, and macroeconomic datasets.
Build and support Databricks-based data platforms using PySpark and Delta Lake.
Develop data models and data marts for analytics, reporting, and machine learning use cases.
Optimize data processing performance across billions of records and multi-terabyte environments.
Ensure data quality, consistency, lineage, governance, and observability.
Translate business requirements into scalable and maintainable technical solutions.
Perform exploratory data analysis, data profiling, and anomaly detection.
Collaborate with data scientists to implement analytical logic using scalable PySpark solutions.
Develop validation dashboards and notebooks to verify data quality and pipeline outputs.
Support feature engineering, time-series analysis, and complex data aggregations.
Utilize Python, pandas, and NumPy for ad hoc analytical tasks.
Investigate unusual data patterns and validate analytical results.
Work with Databricks, Delta Lake, Unity Catalog, and lakehouse architecture.
Participate in architecture discussions involving medallion architecture, catalog design, and data mesh concepts.
Implement CI/CD pipelines using Bitbucket Pipelines, Jenkins, and Databricks Asset Bundles.
Manage data governance, access controls, and schema design through Unity Catalog.
Maintain security, compliance, and data management standards.
Utilize AI-assisted coding tools such as GitHub Copilot, Amazon Q, Kiro, or equivalent.
Review AI-generated code for accuracy, performance, scalability, and maintainability.
Incorporate AI-assisted development practices into engineering workflows.
Bachelor's or Master's degree in Computer Science, Data Engineering, Information Systems, Statistics, Finance, Economics, or a related field.
5+ years of experience in Data Engineering or Data Platform Development.
Strong hands-on experience with Databricks, PySpark, Python, and SQL.
Experience with financial services or payroll data, including compensation, deductions, and pay-period logic.
Expertise in large-scale data processing, including billions of records, multi-terabyte datasets, and time-series data.
Strong knowledge of Delta Lake, Unity Catalog, Databricks Workflows, and data optimization.
Experience with ETL/ELT development, data modeling, and data quality frameworks.
Proficiency in pandas and NumPy for exploratory data analysis.
Experience with CI/CD tools such as Jenkins, Bitbucket Pipelines, or equivalent.
Understanding of statistical concepts, data distributions, correlations, and feature engineering.
Experience participating in technical architecture and design decisions.
Familiarity with AI-assisted development tools.
Experience with financial markets, macroeconomic, or capital markets datasets.
Knowledge of lakehouse architecture, medallion architecture, and data mesh concepts.
Experience with Kafka or Spark Structured Streaming.
Exposure to Census data, TIGER datasets, and FIPS codes.
Infrastructure-as-code experience with Terraform or CDK.
Databricks Associate or Professional certification.
Experience migrating legacy data platforms to Databricks.
Exposure to machine learning and AI-driven analytics.
Experience with Power BI, Tableau, or Databricks Dashboards.
Scala programming experience is a plus.
