Data Engineer

Data Engineer contractor role designing, building, and maintaining data pipelines and infrastructure for payment analytics, reporting, and business intelligence products.

• Contract type: 1099 contract (opportunity to transition to full-time W2)
• Location: Omaha, NE (remote during 1099 phase)

Responsibilities

• Design, build, and maintain scalable ETL/ELT pipelines to ingest, transform, and deliver data from internal systems and third-party payment sources
• Build and optimize data models and warehouse structures in BigQuery to support analytics, reporting, and product needs
• Develop and maintain data pipeline orchestration using tools such as Cloud Composer (Airflow) or Dataflow
• Maintain data quality, integrity, and consistency using validation, testing, and monitoring
• Migrate rules-driven transformation logic from Excel spreadsheets into versioned SQL tables to enable historical reloads and reproducible processing based on rules in effect at a given point in time
• Collaborate with a multidisciplinary team including Data Engineers, Back-End Software Engineers, Product Managers, and Data Scientists
• Implement data security and access controls aligned with PCI DSS and internal governance standards for sensitive payment and merchant data
• Work with product and analytics teams to translate requirements into reliable, well-documented datasets
• Optimize pipeline performance and cost efficiency across Google Cloud Platform data services
• Tackle difficult problems and deliver results on schedule
• Handle ad hoc business requests by converting ambiguous questions into reliable datasets, analyses, and data products, while continuously improving ingestion and transformation for speed, scalability, and cost efficiency

Requirements

• 3+ years of recent hands-on experience in data engineering or a related backend engineering role
• Bachelor’s degree in Computer Science or a related field
• Strong SQL skills plus experience with data modeling for analytics workloads
• Proficiency in Python for data pipeline development
• Strong hands-on experience with Google Cloud Platform, especially BigQuery and related data services
• Experience with workflow orchestration tools such as Cloud Composer, Apache Airflow, or Dataflow
• Strong understanding of OLAP, data warehousing, and analytics-oriented modeling concepts including partitioning, clustering, and performance tuning
• Experience with structured and semi-structured data: JSON, CSV, Parquet
• Proven ability to complete projects on time; described as a flawless executor rather than a procrastinator
• Experience across all phases of the software development life cycle, best practices, and Agile Software Development

Technologies

• Python, SQL
• BigQuery, Google Cloud Platform
• Cloud Composer, Airflow, Dataflow
• dbt, Looker Studio, Tableau
• Excel, JSON, CSV, Parquet
• PCI DSS

Benefits

• Free Fridays: 1 Friday per month to be taken as PTO
• Unlimited PTO
• Casual work environment
• Health Insurance and Dental Insurance
• Simple IRA Match
• Life Insurance premiums 100% paid by TSG

About the Job

• This is a 1099 contract position with the opportunity to transition to full-time W2 employment.
• Please provide resume when applying.

• 1099 phase terms, including scope, duration, and payment terms, are defined in a separate Independent Contractor Agreement.
• During the 1099 contract phase, the role can be performed remotely from anywhere in the United States.
• Upon transition to W2 employment, the role is onsite in Omaha, NE.

Compensation and Benefits

• 1099 contract phase: compensation structured as a contract rate agreed upon in the Independent Contractor Agreement
• TSG provides equipment needed to perform the work
• As an independent contractor, the contractor is responsible for tax withholding and insurance
• No TSG employee benefits package during the 1099 phase
• W2 employment phase: competitive compensation and benefits including Free Fridays, Unlimited PTO, Health Insurance, Dental Insurance, Simple IRA Match, and life insurance premiums 100% paid by TSG

Background Checks, Access, and Security Controls

• Contract-to-hire employees, in both 1099 and W2 phases, are subject to the same background check, access control, and security control requirements
• Includes background checks required for employment and compliance with TSG PCI DSS and data security policies
• No difference in vetting or security standards between the two phases

Working Conditions

• 1099 contract phase: work location and schedule agreed upon between contractor and TSG in the Independent Contractor Agreement
• W2 employment phase: standard office environment, Monday through Friday, with some scheduling flexibility
• Business casual attire and off-street free parking in Omaha