Senior Data Engineer

Job description
Data Engineer (Databricks, SQL & Analytics)

BSI Financial Services company is a FinTech company specializing 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.

About BSI Financial
Founded in 1986, we provide financial services that support our vision of enabling sustainable home ownership by practicing core values that embody doing what is right; emphasizing problem solving; delivering on expectations and winning with humility. Our clients include lenders and investors who make home financing possible. BSI Financial was ranked multiple times in the SMU Dallas 100 list of the fastest growing
companies in North Texas and was twice named to the Inc. 5000 list of the fastest growing U.S. companies.