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 developing and maintaining data warehouse infrastructure using Redshift, BigQuery, and Snowflake, along with proficiency in Python and SQL for data processing and transformation. Strong experience in building data pipelines, supporting BI tools like Looker, and implementing data quality checks.
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
BrazeAcousticMoEngageSegmentJenkinsStitchFivetranKinesisGA4CRM
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
- Design data structures for real-time and near-real-time decision-making
- Support data needs of the MarTech stack, including Braze, Acoustic, MoEngage, and Segment
- Modify and maintain SQL and Python ELT processes loading data into warehouses
- Troubleshoot and maintain Airflow/Jenkins orchestration jobs
- Collaborate with DevOps and cloud management on underlying 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 efficient pipelines
- 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 from employment start date
- College tuition and education assistance programs
- Udemy Learning courses
- Ongoing learning and development opportunities
