Wpromote Logo

Wpromote

Senior Software Engineer II (Data Pipelines)

Posted 5 Days Ago
Remote
Hiring Remotely in United States
155K-180K Annually
Senior level
Remote
Hiring Remotely in United States
155K-180K Annually
Senior level
Leads the design, automation, optimization, and maintenance of scalable data pipelines using Airflow, dbt, Python, SQL, and Google Cloud technologies. Manages dbt models, develops reusable architecture patterns, monitors pipeline performance, supports CI/CD and testing, and ensures data security and governance. The role also provides technical leadership, mentors engineers, collaborates cross-functionally, documents implementations, and drives continuous improvement across data engineering practices.
The summary above was generated by AI
The Role

As a Senior Engineer, you will play a crucial role in the development, optimization, and automation of our data pipelines. You will lead complex data projects, architect technical initiatives, and ensure the scalability and performance of our data solutions. Your role will involve strategic planning, collaboration with senior management, and mentoring other engineers. You will be responsible for pushing the delivery speed and quality of our data ELT, leading the implementation of innovative tooling and architecture patterns, and fostering a culture of data engineering excellence.

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.

 
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 $155,000 - $180,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 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.

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.

Wpromote Chicago, Illinois, USA Office

Chicago, United States

Similar Jobs

Afterpay Logo
Afterpay

Business Development Lead, AI Commercialization

14 Minutes Ago
Remote or Hybrid
164K-297K Annually
Expert/Leader
164K-297K Annually
Expert/Leader
Fintech • Payments • Software • Financial Services
Lead commercialization of emerging AI products by securing enterprise customers and strategic partners, structuring pilots, and converting them into scaled relationships. Own engagements from prospecting and negotiation through launch and optimization, while partnering with Product and Engineering to shape product strategy, pricing, implementation, and go-to-market models.
Top Skills: AICloud InfrastructureData InfrastructureDeveloper Platforms
Afterpay Logo
Afterpay

Director, AI Commercialization

14 Minutes Ago
Remote or Hybrid
240K-359K Annually
Expert/Leader
240K-359K Annually
Expert/Leader
Fintech • Payments • Software • Financial Services
Own commercialization of Block’s emerging AI products from early pilots through scaled enterprise adoption. Develop market strategy, positioning, pricing, partnerships, and routes to market; personally secure lighthouse enterprise customers and strategic partners; design pilots that convert to production relationships; establish repeatable GTM, sales, implementation, and expansion processes; and build the commercial organization as product-market fit develops. Partner closely with Product and Engineering while shaping an emerging AI business.
Top Skills: AICloud InfrastructureData InfrastructureDeveloper Platforms
Nisos Logo
Nisos

Intelligence Analyst

An Hour Ago
Remote
United States
Entry level
Entry level
Artificial Intelligence • Security • Business Intelligence • Consulting • Cybersecurity
Conduct open-source intelligence investigations and produce actionable analysis for clients across geopolitical, cybersecurity, executive protection, due diligence, and threat-monitoring issues. Collect and analyze structured and unstructured data, research investigative tools and datasets, assess online footprints, create executive-ready deliverables, and brief clients on findings and mitigation options. The role is fully remote and requires collaboration across a distributed intelligence team.
Top Skills: Google WorkspacemacOSMonday.ComOsint Investigative Tools

What you need to know about the Chicago Tech Scene

With vibrant neighborhoods, great food and more affordable housing than either coast, Chicago might be the most liveable major tech hub. It is the birthplace of modern commodities and futures trading, a national hub for logistics and commerce, and home to the American Medical Association and the American Bar Association. This diverse blend of industry influences has helped Chicago emerge as a major player in verticals like fintech, biotechnology, legal tech, e-commerce and logistics technology. It’s also a major hiring center for tech companies on both coasts.

Key Facts About Chicago Tech

  • Number of Tech Workers: 245,800; 5.2% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: McDonald’s, John Deere, Boeing, Morningstar
  • Key Industries: Artificial intelligence, biotechnology, fintech, software, logistics technology
  • Funding Landscape: $2.5 billion in venture capital funding in 2024 (Pitchbook)
  • Notable Investors: Pritzker Group Venture Capital, Arch Venture Partners, MATH Venture Partners, Jump Capital, Hyde Park Venture Partners
  • Research Centers and Universities: Northwestern University, University of Chicago, University of Illinois Urbana-Champaign, Illinois Institute of Technology, Argonne National Laboratory, Fermi National Accelerator Laboratory

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account