Freelance and remote jobs in Pittsburgh, US

Create an in-arena / in-venue motion graphics package for a Pittsburgh-based team. The work will support the live game-day experience across venue displays and related presentation systems. Develop polished, high-energy motion assets aligned with the team’s visual identity. Experience designing for sports entertainment, arena environments, scoreboards, ribbon boards, and large-format LED displays is strongly preferred. Please share relevant sports, live-event, or venue-motion portfolio examples, along with your approach to creating assets that remain clear and impactful at large scale. The role will be hybrid. Read more

The UX Researcher supports foundational user research, synthesizes findings, and communicates insights to inform product and design decisions. This role collaborates with Product, Design, Engineering, Marketing, and Customer Success teams to identify user needs, evaluate product experiences, and help develop intuitive, accessible, and valuable solutions. Support the planning and execution of qualitative and quantitative research studies. Conduct interviews, usability tests, surveys, diary studies, and other research activities. Observe and document user behavior, feedback, and pain points. Analyze research data and synthesize findings into themes and actionable insights. Develop reports, presentations, journey maps, personas, and related research deliverables. Communicate findings and recommendations to cross-functional stakeholders. Partner with designers and product managers to incorporate user insights into product decisions. Maintain organized research documentation, participant records, and repositories. Support ethical, privacy-conscious, and accessible research practices. Stay informed about UX research methods, tools, and industry best practices. Requirements Based in the Pittsburgh, Pennsylvania area. Available for on-site work and research sessions. Able to troubleshoot basic hardware and technical issues involving devices, recording equipment, and testing setups. Able to walk long distances and stand for extended periods during on-site research sessions. Compensation Salary: $36–$50 per hour. Read more

Build and maintain scalable data pipelines and reusable datasets in a Databricks lakehouse environment to support reporting, visualization, machine learning and data-driven decision-making across finance, sales, supply chain, marketing and other business functions. Key responsibilities include: Develop and maintain scalable data pipelines and data products. Ingest, validate, clean and transform structured and unstructured data using Python, PySpark and SQL. Build data models and reporting datasets for Tableau and other analytics tools. Integrate existing data warehouses and reporting systems with modern cloud analytics platforms. Improve pipeline reliability, data quality and processing performance. Implement automated testing, monitoring, documentation and CI/CD practices. Collaborate with analysts, architects, developers and business stakeholders to deliver effective data solutions. Provide technical guidance, conduct code reviews and mentor other data engineers. Requirements At least 7 years of data engineering experience, including developing and supporting production data pipelines. Strong SQL skills and knowledge of data modelling, database design and data warehousing. Hands-on experience with Databricks, Apache Spark and cloud data platforms. Strong proficiency in Python and PySpark. Experience developing ETL/ELT pipelines and integrating data from multiple source systems. Experience creating reliable datasets for Tableau or comparable business intelligence tools. Familiarity with source control, automated testing and CI/CD practices. Ability to troubleshoot complex data issues and optimise pipeline performance. Strong communication and collaboration skills, with experience working with technical teams and business stakeholders. Preferred Experience and Qualifications Experience with Spotfire, Oracle, Informatica, R or data virtualisation. Databricks certification. Read more

Pinnacle Web Agency is hiring a Pittsburgh-area videographer for its creator brand, CowanFilm, a photography account with more than 15,000 Instagram followers that partners with camera and lifestyle brands on sponsored content. The videographer will film brand videos on a per-shoot basis. Work will be occasional initially, with opportunities for repeat bookings for the right person. Applicants should review the CowanFilm Instagram account at instagram.com/cowanfilm to determine whether the visual style is a good fit. Film short-form vertical videos for Instagram Reels and TikTok featuring branded products. Shoot product b-roll and lifestyle footage at locations around Pittsburgh. Follow brand briefs and shot lists while contributing original shot ideas. Deliver organized footage within 48 hours. Requirements A reel or portfolio showcasing short-form social media or product video. An eye for clean, natural-light, film-style footage that fits the CowanFilm aesthetic. Your own camera and basic audio equipment. Reliable transportation in the Pittsburgh area. Ability to meet brand deadlines. Preferred Qualifications Editing experience using CapCut, Adobe Premiere, or DaVinci Resolve. Experience creating sponsored or user-generated content (UGC). Compensation This is contract work paid on a per-shoot basis. Applicants should provide their per-shoot rate. How to Apply Send your reel or portfolio along with your per-shoot rate. Benefits Flexible schedule. Work Location In person in the Pittsburgh area. Read more