Senior Data Engineer

The Role
As a Senior Data Engineer, you will be pivotal in designing, building, and optimizing our data infrastructure. You'll work closely with cross-functional teams to ensure seamless data flow and integration across various MarTech and AdTech platforms powering Polaris, Wpromote’s proprietary tech platform. Have a seat at the table from day one, with the ability to influence strategy and the technical roadmap, and join an organization with opportunities for professional advancement and development. Most importantly, you will have the challenge of building with cutting-edge technologies and innovative projects.
The System: 
At Wpromote, we're developing something special called Polaris - a modern data and marketing intelligence platform that gives our clients a serious edge over their competition. Polaris enables and empowers our marketing teams to work together seamlessly, using a comprehensive marketing data foundation with apps that deliver new insights and performance gains for our clients. Polaris also gives Wpromote an operational edge - doubling as our company CRM and integrated source of truth for operations data, making our lives easier and our decisions smarter.
At Wpromote, we believe that great work is only possible with great people. Our goal is to build a better, more inclusive work environment and support our people at every stage of their careers by prioritizing a strong work-life balance through our policies and benefits listed below. As a Best Place to Work according to both Ad Age and Glassdoor and Adweek’s Fastest Growing Digital Agency, we are moving fast to expand our teams and bring new experts into the fold to keep pushing the boundaries of what’s possible in marketing.
We offer:-Half-day Fridays year round-Unlimited PTO-Extended Holiday break (Winter)-Flexible schedules-Work from anywhere options*-100% paid parental leave-401(k) matching-Medical, Dental, Vision, Life, Pet Insurance-Sponsored life insurance-Short Term Disability insurance  and additional voluntary insurance-Annual Class Pass Credits and more! The anticipated annual salary for this role will range from $95,000 - $125,000, based on a variety of factors unique to each candidate, including skill set, years and depth of experience, education and certifications, competitive benchmarks, scope of responsibility, market dynamics, geographic location, and the respective state’s salary threshold for exempt employees. At Wpromote, pay ranges are subject to change and are based on specific market medians for similar jobs according to third-party salary benchmark surveys. Individual pay within that range can vary due to skills, experience, and available budget.  The total compensation package for this role will include benefits (listed above).
*This position may be performed remotely in most states within the US, with some exclusions**While this role offers the flexibility to work remotely, we have office hubs in Los Angeles, Chicago, and New York, where you can join in on learning and development opportunities, fun events, take advantage of a space to work, and collaborate in person!***This position is not eligible for immigration sponsorship
Important Notice: Beware of Job ScamsWpromote recruiting communications will only be sent through our official channels via wpromote.com email addresses. If you see a posting elsewhere that is not reflected on Wpromote.com/careers, it may be a fraudulent posting. We do not require payment or fees during the hiring process nor do we request sensitive information, such as Social Security numbers or payment details. Please safeguard yourself against possible scams and contact us if you encounter any suspicious activity.
#LI-JJ#LI-Remote

You Will Be

• 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

You Must Have

• 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
• 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.)
• Proficiency with at least 1 programming language (e.g. Python, JavaScript, R, AppScript, etc.), preferably JavaScript or Python
• 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

Nice to Have

• Experience leading and managing other Data EngineersIntermediate to advanced programming skills in Python
• 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.)

Wpromote is committed to bringing together individuals from different backgrounds and perspectives, providing employees with a safe and welcoming environment free of discrimination and harassment. We strive to create a diverse & inclusive environment where everyone can thrive, feel a sense of belonging, and do impactful work together. As an equal opportunity employer, we prohibit any unlawful discrimination against a job applicant on the basis of their race, color, religion, gender, gender identity, gender expression, sexual orientation, national origin, family or parental status, disability*, age, veteran status, or any other status protected by the laws or regulations in the locations where we operate. We respect the laws enforced by the EEOC and are dedicated to going above and beyond in fostering diversity across our workplace.
Applicants with disabilities may be entitled to reasonable accommodation under the terms of the Americans with Disabilities Act and certain state or local laws. A reasonable accommodation is a change in the way things are normally done which will ensure an equal employment opportunity without imposing undue hardship on Wpromote.
This employer participates in E-Verify and will provide the federal government with your Form I-9 information to confirm that you are authorized to work in the U.S. If E-Verify cannot confirm that you are authorized to work, this employer is required to give you written instructions and an opportunity to contact Department of Homeland Security (DHS) or Social Security Administration (SSA) so you can begin to resolve the issue before the employer can take any action against you, including terminating your employment. Employers can only use E-Verify once you have accepted a job offer and completed the Form I-9. For more information on E Verify, or if you believe that your employer has violated its E-Verify responsibilities, please contact DHS.