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 building and maintaining data warehouse infrastructure using Redshift, BigQuery, and Snowflake, along with proficiency in SQL and Python for data processing and transformation. Strong experience in developing data pipelines and supporting BI tools like Looker for analytics and reporting.
Highest-signal resume keywords
Python DevelopmentSQL ProficiencyData Warehouse ManagementAirflow OrchestrationDbt Data Modeling
ATS Keywords
Tailor your resumeApplicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard Skills
PythonSQLRedshiftBigQuerySnowflakeAirflowDbtLookerReal-Time Data IngestionAgile Development
Tools & Technologies
BrazeAcousticMoEngageSegmentJenkinsFivetranKinesisStitchGA4CRM
Industry Keywords
Data WarehouseData PipelineBusiness IntelligenceData Quality ChecksData Structures
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 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 and collaborate with DevOps and cloud management on infrastructure
- Fulfill ad-hoc data extract requests
- Provide ad-hoc SQL and analysis support to business stakeholders
- Maintain and update Looker Explores and dashboards
- Partner with Data Analysts on reporting requirements and pipeline efficiency
- Develop, test, and maintain dbt models
- Unify GA4, CRM, and other data sources into a consolidated warehouse structure
- Build reusable data models for 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 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
- No visa sponsorship
Benefits
Comp & perks- Medical, dental, vision and FSA benefits for 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
- 401(k) Plan eligibility effective with employment start date
- College tuition and education assistance programs
- Udemy Learning courses
- Ongoing learning and development opportunities
