Associate Technical Product Manager

Overview:

The Associate Technical Product Manager will assist overseeing day-to-day data operations, translate business needs into technical deliverables, and develop lightweight tools to reduce manual work. This role is embedded in a hands-on, pragmatic environment at a growing legal tech startup. This role is a great fit for someone looking for their first Technical Product Management role. 

Position Description:

The Associate Technical Product Manager is responsible for maintaining healthy database performance, building automation scripts, setting up and supporting ELT processes, and creating internal tools and dashboards that streamline workflows. The position requires strong SQL and Python skills, clear communication, and the ability to work independently in a fast-paced environment.

Workforce Opportunity Services (WOS) is a leading 501(c)(3) nonprofit dedicated to developing the skills of high-potential individuals who may not have access to career opportunities. Through strategic partnerships, WOS connects motivated talent with organizations seeking to expand their workforce with skilled professionals.

Utilizing a scientifically based model derived from research conducted at Columbia University, we recruit, educate, train, and place high-potential talent with leading organizations around the world.

• Maintain PostgreSQL performance, write and review queries, and triage database issues.

• Build Python scripts for validating, cleaning, and moving data on schedule.

• Stand up and maintain simple ELT pipelines using Airbyte, dbt, or similar tools.

• Develop internal tools and dashboards to reduce manual work and support the team.

• Translate business requirements into clear tickets and documentation for both engineers and non-technical stakeholders.

• Integrate AI helpers into workflows to save time and reduce errors.

• Improve reliability and cost-efficiency of the AWS footprint, using Git and Docker for repeatable processes.

• Respond to ad hoc data questions with quick analysis and summaries.

• Troubleshoot production issues across databases, scripts, and jobs.

• Write and maintain concise, up-to-date documentation.

• Facilitate communication between engineering, the Founder, and customers where technical context is needed.

30-60-90 Day Outcomes

• 30 Days: Map data flows and critical jobs, document current state, and resolve top bottlenecks. Reduce manual data work.

• 60 Days: Ship a stable ELT path for key sources with tests and alerts. Replace at least one manual spreadsheet or ad hoc process with an internal tool.

• 90 Days: Establish weekly health metrics for pipelines and database performance. Propose next two quarters of data improvements with effort and impact estimates.

Candidate Profile:

• Authorized to work in the United States
• High School Diploma or Equivalent with IT experience
• Available to work Full-time

Qualifications/Skills:

• 1–3 years in a technical role (data engineering, data analytics, devops, or a similar role)

• Strong SQL with PostgreSQL, including indexing and query tuning.

• Proficiency in Python for automation and data manipulation.

• Experience with ELT tools such as Airbyte and dbt.

• Clear written and verbal communication skills.

• Ability to learn new tools quickly and work independently.

Nice to Have:

• Familiarity with AWS, Git, and Docker.

• Experience in startups or fast-paced environments.

• Exposure to project management practices.

Job Type:

• Full Time

Salary:

• Qualified candidates will receive an email with the pay range.

Location:

• Pittsburgh, PA
  • Hybrid

• Low Cost Individual Health Insurance
• Paid Vacation
• Paid Company Holidays
• Education Assistance/Reimbursement (Toward first degree - Bachelors/Associates)
• Individual Mentor 
• 401k Retirement Savings

Our vision is to empower early-career professionals to achieve long-lasting professional success and financial independence while supporting companies in building workplaces that reflect and engage with the communities they serve. We are in the business of creating dynamic partnerships that transform lives.