Data Engineer

Job description

Data Engineer (Databricks, SQL & Analytics)

Entra Solutions (A BSI Financial Services company)
Entra Solutions is a FinTech company specialized in technology-based financial solutions and services for the mortgage industry. We are a people-focused, growth-oriented, innovative company and we're looking for people like you to make a positive change and join our team today!

We are seeking a Data Engineer with strong expertise in Databricks and SQL programming, along with proven experience in analytics, reporting, and end-to-end data pipeline management. The ideal candidate will be comfortable working across our medallion architecture and supporting multiple data domains—from ingestion to governance to BI.

WHAT YOU WILL DO:

• Design, develop, and maintain ETL/ELT pipelines in Databricks (using PySpark, notebooks, and Delta Lake) following the Bronze-Silver-Gold medallion architecture.
• Write, optimize, and troubleshoot SQL queries, stored procedures, and transformations for large-scale datasets from multiple sources (SQL Server, Postgres, S3, Snowflake, SFTP).
• Transform and prepare data in Silver and Gold layers for analytics, dashboards, and downstream applications using dbt and native Databricks tools.
• Integrate data from operational systems into the enterprise warehouse.
• Collaborate with analytics teams to deliver curated datasets and enable reporting in Sigma or similar reporting tools for functional business groups.
• Support SLA-driven data feeds for operational systems, BI dashboards, and regulatory reporting.
• Monitor and optimize data pipelines for performance, scalability, and cost efficiency.
• Contribute to the architectural goal of building a centralized, scalable, and modular data environment with unified ETL orchestration and federated governance.

WHAT WE’RE LOOKING FOR:

• BE/BTech degree in Computer Science, Information Technology, or related field
• Mandatory:
  • 4–8 years of data engineering experience
  • Expert-level Databricks skills (Delta Lake, notebooks, clusters, jobs)
  • Advanced SQL programming, query optimization, and performance tuning

• Preferred / Good-to-Have:
  • Experience with Azure Data Services (Data Factory, Data Lake, Synapse)
  • Proficiency in Python or Scala for data processing in Databricks
  • Familiarity with dbt for transformation and orchestration
  • Exposure to BI/reporting tools like Sigma or Power BI
  • Understanding of data governance frameworks, metadata management, and data quality processes
  • Experience with real-time/streaming data (Spark Structured Streaming, Kafka)
  • Strong analytical and problem-solving skills, with attention to detail and data accuracy
  • Excellent communication and collaboration skills across technical and business teams

WHAT’S IN IT FOR YOU:

• Competitive Salary
• Full Benefits Package
• PTO
• Holiday Pay
• Career Growth Opportunities

EEO Statement

We are an equal employment opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, national origin, disability status, protected veteran status or any other characteristic protected by law.