Senior Software Engineer II (Data Pipelines)

The Role The Senior IT Engineer will serve as a key technical anchor on the IT team, owning the systems and platforms that power Wpromote's day-to-day operations. Reporting to the Director of IT, this role is built for a senior individual contributor who can take strategic direction, drive technical execution end-to-end, and make sound systems decisions with minimal oversight. The ideal candidate brings deep expertise in Apple/Mac environments, Google Workspace, MDM, and modern identity platforms, and is energized by both hands-on engineering and partnering across the team to elevate IT as a whole. This role is onsite at our El Segundo office, with an expected in-office presence of 2 days per week, providing critical on-site support and serving as a senior point of escalation across the function. 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: -Unlimited PTO -Extended Holiday break (Winter) -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 $110,000 - $130,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). *While there is some remote flexibility, this role has an expected in-office presence of 2 days per week at our El Segundo office to support team needs **This position is not eligible for immigration sponsorship Important Notice: Beware of Job Scams Wpromote 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-SD #LI-Remote

You Will Be

• Acting as a technical leader and Subject Matter Expert (SME) in data pipeline automation and workflow orchestration.
• Designing, implementing, and maintaining complex, reliable, data solutions with a focus on automation using Airflow, dbt, and Google Cloud data products.
• Managing a large portfolio of dbt models, leveraging macros and DRY patterns.
• Advocating for test-driven development and assisting QA in developing a robust and reliable process for continuous integration and delivery.
• Monitoring, troubleshooting, and optimizing the performance of data pipelines and workflows.
• Architecting solutions and reusable patterns that scale with business needs.
• Providing implementation, configuration, and deployment documentation.
• Proactively addressing issues and problems, generating and implementing innovative solutions.
• Participating in all agile ceremonies, including daily standups and regular sprint planning.
• Mentoring other engineers and fostering a culture of technical excellence.
• Staying up-to-date with the latest industry trends and technologies to drive continuous improvement and innovation in data engineering practices.
• Ensuring data security, governance, and compliance with relevant standards and privacy restrictions.

You Must Have

• Minimum 7+ years of experience in software development, with extensive experience in Python, SQL, and data pipelines.

• Expertise in building and automating ETL/ELT pipelines using Airflow and DAG-based workflow management software. Airbyte for data ingestion is a plus, but not required.

• Deep experience managing dbt models using macros and dbt tests.

• Mastery of Python or comparable scripting language, API integrations, and software architecture.

• Deep experience with databases like PostgreSQL and BigQuery, including query optimization for performance and cost.

• Good understanding of business intelligence tools like Looker or comparable alternatives.

• Experience with Google Cloud Platform, Kubernetes, and managing infrastructure as code using Terraform.

• Proficiency with advanced data formats (Parquet, Avro, Hive, JSONL) and data integration techniques.

• Experience with monitoring and logging tools (e.g., Prometheus, Grafana) is a plus.

• Familiarity with version control systems and CI/CD tools like GitHub Actions.

• Strong command of agile methodologies, continuous integration, and test-driven development.

• Exceptional problem-solving skills and technical leadership.

• Ability to influence and guide cross-functional teams and projects.