Senior Data Engineer

Bitful Consulting; Elm (PA); On-site; USD 120,000 - 180,000; Full time

Job summary

Bitful Consulting is seeking an experienced Data Engineer to design and maintain scalable data pipelines across finance, sales, and operations. You will work in a Databricks lakehouse environment, ingesting data with PySpark and Python, and building datasets for Tableau and Spotfire.

Strong SQL, data modeling and warehouse design are essential, along with cloud platform experience and CI/CD practices. You will mentor teammates and collaborate with business stakeholders to deliver robust data

Qualifications

• 7+ years of experience in data engineering and production pipelines.
• Strong SQL, data modeling and data warehousing fundamentals.
• Experience with Databricks, PySpark, Python and Spark in cloud environments.

Responsibilities

• Build and maintain scalable data pipelines and datasets for reporting and analytics.
• Ingest, validate, clean, and transform data from multiple sources using Python and PySpark.
• Develop data models and datasets for Tableau and Spotfire.
• Integrate data warehouses with modern cloud analytics platforms.
• Improve pipeline reliability, data quality and performance.
• Implement automated testing, monitoring, and CI/CD practices.
• Collaborate with analysts and stakeholders to deliver practical data solutions.
• Provide technical guidance and review code.

Skills

SQL

Python

PySpark

Databricks

Spark

Data modeling

ETL/ELT

CI/CD

Tableau

Spotfire

Data warehousing

Cloud platforms

Communication

Tools

Tableau

Spotfire

Oracle

Informatica

R

Data virtualization

Source control

CI/CD tools

Job description

• You’ll build and maintain data pipelines and datasets that support reporting, visualization, machine learning and data-driven decision making across finance, sales, supply chain, marketing and other business functions.
• Your responsibilities will include:
  • Developing and maintaining scalable data pipelines and reusable datasets within a Databricks lakehouse environment
  • Ingesting, validating, cleaning and transforming structured and unstructured data from multiple sources using Python, PySpark and SQL
  • Building data models and reporting datasets that support Tableau and established analytics tools such as Spotfire
  • Integrating established data warehouse and reporting systems with modern cloud analytics platforms
  • Improving pipeline reliability, data quality and processing performance
  • Implementing automated testing, monitoring, documentation and CI/CD practices
  • Partnering with analysts, architects, developers and business stakeholders to deliver practical data solutions
  • Providing technical guidance, reviewing code and mentoring other data engineer

Requirements

• 7+ years of experience in data engineering, including building and supporting production data pipelines
• Strong SQL skills and a solid understanding of data modeling, database design and data warehousing
• Hands-on experience with Databricks, Apache Spark and cloud data platforms
• Strong proficiency in Python and PySpark
• Experience developing ETL/ELT pipelines and integrating data from multiple source systems
• Experience preparing reliable datasets for Tableau or comparable business intelligence tools
• Familiarity with source control, automated testing and CI/CD practices
• Ability to troubleshoot complex data issues and optimize pipeline performance
• Strong communication skills and experience collaborating with technical teams and business stakeholders
• Experience with Spotfire, Oracle, Informatica, R or data virtualization preferred
• Databricks certification preferred