FREE ACCESS
5,000–10,000 jobs/day
See all jobs on Scoutfield
Search thousands of fresh jobs every day.
Discover
- Fresh listings
- Fast filters
- No subscription required
Create a free account and start exploring right away.
Core Competencies
Role fitCore Competencies
Use this summary to align your resume positioning with the role.
Expertise in data warehouse infrastructure management across Redshift, BigQuery, and Snowflake, with strong proficiency in SQL and Python for data transformation and pipeline development. Ability to support analytics products and maintain data quality through automated checks and documentation.
Highest-signal resume keywords
Python DevelopmentSQL ProficiencyData Warehouse ManagementAirflow OrchestrationDbt Data Transformation
ATS Keywords
Tailor your resumeApplicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard Skills
SQLPythonData ModelingData Pipeline DevelopmentReal-Time Data IngestionData Quality ChecksAgile DevelopmentData AnalysisETL ProcessesData Documentation
Tools & Technologies
RedshiftBigQuerySnowflakeAirflowLookerTableauBrazeAcousticMoEngageSegment
Industry Keywords
MarTechBusiness IntelligenceData EngineeringCloud PlatformsCI/CDStatisticsA/B TestingData Quality FrameworksAnalytics ProductsData-Driven Decisions
Tech Stack
Tools & technologiesAirflowAmazon RedshiftAWSBigQueryCloudJenkinsPythonSQLTableau
About the role
Key responsibilities & impact- Own and maintain data warehouse infrastructure across Redshift, BigQuery, and Snowflake
- Build and maintain real-time, batch, and streaming data pipelines supporting analytics products and data-driven decisions
- Design data structures for real-time and near-real-time decision-making
- Support MarTech data needs, 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 and coordinate with DevOps and cloud management on infrastructure
- Fulfill ad-hoc data extract requests and other data engineering duties
- Provide ad-hoc SQL and analysis support to business stakeholders
- Maintain and update Looker Explores and dashboards as warehouse structures change
- Partner with Data Analysts on reporting requirements, pipelines, and derived tables
- Develop, test, and maintain dbt models transforming raw data into analytics-ready datasets
- Unify GA4, CRM, and other data sources into a consolidated warehouse structure
- Build reusable data models supporting marketing funnels, segmentation, and campaign analytics
- Implement automated data quality checks and validation rules
- Document data models and business logic
Requirements
What you’ll need- 4+ years of experience developing in Python
- 4+ years of experience in SQL, including Redshift, Snowflake, and BigQuery
- 2+ years working on AWS or an equivalent cloud platform
- 2+ years working 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 have: experience with Segment, Braze, Acoustic, or MoEngage data integrations
- Nice to have: familiarity with LookML and Looker semantic layer concepts
- Nice to have: experience with Google Analytics (GA4) as a data source
- Nice to have: knowledge of data quality frameworks and CI/CD for data pipelines
- Nice to have: exposure to statistics, experimentation (A/B testing), or basic ML concepts
- No visa sponsorship
Benefits
Comp & perks- Medical, dental, vision and FSA benefits for eligible full-time regular employees and dependents
- Healthcare and Dependent Care reimbursement programs
- Employee Assistance Program (EAP)
- Optum Care 24-hour confidential medical counseling services
- Ten paid holidays per calendar year
- 15 days of PTO in the first 12 months of continuous service
- 22 days of PTO in subsequent years
- Pro-rated PTO for eligible part-time employees
- 401(k) Plan eligibility effective with employment start date
- College tuition and education assistance programs
- Udemy Learning courses
- Ongoing learning and development opportunities
- Global team collaboration and opportunity to work with innovative technology
- Equal opportunity and inclusive work environment
