Senior Data Engineer

Tillster • Las Vegas, NV

4d • $120,000 - $140,000

About The Position

The Data Science and Analytics team at Tillster is seeking a motivated Senior Data Engineer to build and maintain real-time data pipelines and support the company’s data accessibility, analytical efficiency, and data products. The position is primarily focused on data engineering, with additional responsibility for analytics support and contributing to the dbt-based data modeling layer.

The role includes owning data warehouse infrastructure across Redshift, BigQuery, and Snowflake; developing batch, streaming, and real-time pipelines; supporting marketing technology data needs; and maintaining SQL and Python ELT processes and orchestration jobs. The engineer will work with business stakeholders and Data Analysts on ad-hoc analysis, reporting requirements, Looker content, and analytics-ready data structures.

The position also involves developing and maintaining dbt models, consolidating data sources such as GA4 and CRM, creating reusable models for marketing analytics, implementing basic data quality checks, and documenting data models and business logic.

Requirements

• At least 4 years of experience developing in Python.
• At least 4 years of experience with SQL, including Redshift, Snowflake, or BigQuery.
• At least 2 years of experience working on AWS or an equivalent cloud platform.
• At least 2 years of experience with Airflow or comparable orchestration tools.
• Working knowledge of dbt for data transformation and modeling.
• Hands-on experience supporting BI tools such as Looker or Tableau.
• Experience with real-time ingestion tools such as Snowpipe, Stitch, Fivetran, or Kinesis.
• Experience working in an Agile development environment.

Nice To Haves

• Experience with Segment, Braze, Acoustic, or MoEngage data integrations.
• Familiarity with LookML and Looker semantic layer concepts.
• Experience with Google Analytics (GA4) as a data source.
• Knowledge of data quality frameworks, including dbt tests and schema tests, and CI/CD for data pipelines.
• Exposure to statistics, experimentation such as A/B testing, or basic ML concepts.

Responsibilities

• Own and maintain data warehouse infrastructure across Redshift, BigQuery, and Snowflake.
• Build and maintain real-time, batch, and streaming data pipelines that support analytics products and data-driven decisions across marketing, product, engineering, sales/account management, finance, and operations.
• Design data structures that provide appropriate data and formats for real-time and near-real-time decision-making.
• Support the data needs of the MarTech stack, including Braze, Acoustic, MoEngage, and Segment.
• Modify and maintain SQL and Python ELT processes loading data into Redshift and other warehouses.
• Troubleshoot and maintain Airflow/Jenkins orchestration jobs, working with DevOps and cloud management on underlying infrastructure.
• Fulfill ad-hoc data extract requests and perform other data engineering duties as required.
• Provide ad-hoc SQL and analysis support to business stakeholders when requests exceed the Data Analyst team's capacity.
• Maintain and update Looker Explores and dashboards to ensure consistent, accurate data as warehouse structures change.
• Partner with Data Analysts to understand reporting requirements and ensure pipelines and derived tables meet their needs efficiently.
• Develop, test, and maintain dbt models that transform raw data into clean, analytics-ready datasets.
• Contribute to unifying GA4, CRM, and other data sources in a consolidated warehouse structure.
• Build modular, reusable data models for marketing funnels, segmentation, and campaign analytics.
• Implement basic automated data quality checks and validation rules in owned pipelines.
• Document data models and business logic.

Benefits

• Medical, dental, vision, and FSA benefits for eligible full-time, regular employees and their dependents.
• Healthcare and Dependent Care reimbursement programs.
• Employee Assistance Program (EAP) and Optum Care 24-hour confidential medical counseling services.
• Ten paid holidays per calendar year.
• PTO: 15 days during the first 12 months of continuous service and 22 days in subsequent years for full-time, regular employees; eligible part-time employees receive prorated PTO.
• Eligibility to participate in the 401(k) Plan starting on the employment start date.
• College tuition and education assistance programs.
• Udemy Learning courses and ongoing learning and development opportunities.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Education Level: No Education Listed