Key skills
PythonSQLData EngineeringData WarehousingAnalyticsSnowflakeBigQueryRedshiftAirflowdbtAWSAzureGlueGitHubGitLabBitbucketVersion ControlCRMProject ManagementCommunication
About this role
Wpromote is a fast-growing digital agency recognized as a Best Place to Work. As a Senior Data Engineer, you will play a crucial role in designing and optimizing data infrastructure while collaborating with cross-functional teams to ensure efficient data flow across various platforms.
Responsibilities:
- Developing data pipelines leveraging a variety of technologies including dbt and BigQuery
- Gathering requirements from non-technical stakeholders and building effective solutions
- Identifying areas of innovation that align with existing company and team objectives
- Managing multiple pipelines across Wpromote’s client portfolio
Requirements:
- Bachelor's degree in Computer Science, Information Technology, or a related field, or equivalent practical experience
- 4+ years of experience in data engineering or a related field
- Intermediate to advanced programming skills in Python
- Proficiency in SQL and experience with relational databases
- Strong knowledge of database and data warehousing design and management
- Strong experience with DBT (data build tool) and test-driven development practices
- Proficiency with at least 1 cloud database (e.g. BigQuery, Snowflake, Redshift, etc.)
- Excellent problem-solving skills, project management habits, and attention to detail
- Advanced level Excel and Google Sheets experience
- Familiarity with data orchestration tools (e.g. Airflow, Dagster, AWS Glue, Azure data factory, etc.)
- Strong business and marketing acumen including common marketing goals, KPIs, and tactics
- Excellent communication skills (verbal and written) to present effectively and to explain algorithms and insights to major non-technical stakeholders
- Experience leading and managing other Data Engineers
- Experience creating API calls to gather and store large datasets (batch or streaming)
- Familiarity with CRM data
- Familiarity with the command line interface
- Experience with data visualization and storytelling practices
- Ability to generate insights from data in the form of refined tabular and graphical reports, metrics, and ad-hoc analysis
- Familiarity with version control systems (e.g. GitHub, Bitbucket, GitLab)
- Experience within an Advertising Agency or similar client environment
- Working experience with digital media platforms (e.g. Facebook, Google Ads, The Trade Desk, etc.)
- Experience and/or certification in web analytics platforms (e.g. Google Analytics, Adobe Analytics, etc.)