Jobs at Pivotal Solutions

Design, develop, tune, and maintain large-scale OLTP database systems and data pipelines. Build PL/SQL, T-SQL, C, and shell-scripted solutions; provide Oracle and SQL Server DBA services, ensure efficient ETL and data warehouse delivery, support SDLC and automation, and create documentation. Hybrid role requiring Pittsburgh-area residence or relocation.

Manage and secure the organization's IT systems and ERP (financials, supply chain, manufacturing, HR). Provide technical support, troubleshoot hardware/software/network issues, perform server monitoring and backups, implement security/CMMC controls, evaluate technologies, manage ERP implementations and training, negotiate with vendors, and perform cost/benefit analyses and special IT projects.

Build and maintain data views, ETL processes, and advanced reports. Monitor data integrity, document data dictionaries, support power users, enable visualizations, and assist Information Services with integrations and ticketed support.

Manage lifecycle of on-prem and cloud infrastructure including servers, Microsoft SQL databases, AD, DNS, SAN, backups, monitoring, and cloud accounts. Deploy, maintain, automate (PowerShell, Ansible, Terraform), support production/test environments, document systems, and assist with acquisitions and disaster recovery. Provide on-call support.

Design, develop and implement custom solutions on Infor M3 and Infor ION. Gather requirements, troubleshoot and resolve issues, provide maintenance and support, and assist with testing, deployment and documentation of system updates.

Maintain and support 100+ on-premise virtualized Microsoft SQL Server instances; install, configure, patch, upgrade and migrate databases; manage security, backups, jobs, performance tuning, capacity planning, and DR. Automate builds and tasks, develop queries/stored procedures/reports/ETLs, troubleshoot performance and participate in agile team development and on-call rotation.

Ensure GAAP-compliant transaction reporting; support month-end close and annual audit (including drafting financial statements and notes); analyze expense variances; prepare journal entries and cost accounting; assist with forecasting, budgeting, and customer billing.

Design and build responsive, accessible, high-performance web interfaces. Collaborate with designers and back-end developers, write clean code, test/debug for cross-browser compatibility, and meet project deadlines.

Design, develop, and deliver cloud-native full-stack banking applications. Partner with UX, Cloud, QA, and InfoSec; implement secure, testable microservice-based solutions; mentor developers and accelerate prototype-to-production cycles using Agile practices.

Develop cloud-hosted monitoring and control platform features for large-scale solar and storage. Participate in weekly sprints, refactor and optimize edge performance and security, provide product feedback, and document features and configurations for support teams.

Owner of multiple third-party and in-house applications; leads data warehouse operations, translates business requirements into technical designs, develops and tests solutions, troubleshoots issues, evaluates products, mentors junior staff, and collaborates with vendors across project lifecycles.

Design, build, and maintain web pages and web applications end-to-end. Coordinate with other development teams (D365 CRM, D365 Finance & Ops, Azure, mobile, MFA). Enhance and support multiple systems including Client Portal, Payroll Processing, SharePoint, Data Factory, and Integration Services. Gather and document requirements, participate in usability testing, optimize code for performance and reliability, and troubleshoot issues while collaborating with stakeholders.

Manage and improve multi-tier IT infrastructure across AWS and Azure, networks, servers, and core services. Administer Office 365, scripting with PowerShell, oversee MSPs and vendors, handle security incidents and outages, support conferencing and core business platforms, ensure GxP/SOX compliance, and own budgeting, strategy, and infrastructure delivery processes.

Lead and support the firm's on-premise and cloud Linux/Unix infrastructure including HPC, filesystems, networking, security, and end-user systems. Maintain services (Apache, Docker, uWSGI, Gitolite, SSH), automate deployments (Ansible), script in Bash/Python, manage vendor relationships, and support business continuity and production report applications.

Support Assistant Controller and Controller by performing reconciliations, transaction verification, general ledger preparation, payroll processing, expense reporting, sales/use tax returns, bank and P-card reconciliations, inventory analysis, and monthly balance sheet reporting.

Lead and mentor an IT team to design, implement, and maintain infrastructure and applications. Manage IT operations, budgets, vendor relationships, systems analysis, and cross-functional partnerships while ensuring compliance with quality, ISO, and medical device requirements.

Lead and manage all laboratory services, ensuring high-quality diagnostics, regulatory compliance, quality assurance, staff development, budget oversight, cross-department collaboration, and laboratory safety.

Work with business units to document and map process and data flows, identify gaps, and recommend process or technology improvements. Create diagrams of process and integration flows, perform gap analyses, and collaborate cross-functionally to optimize operations.

Design, develop, train, and evaluate state-of-the-art generative AI models (GANs, VAEs, Transformers) and large-scale recommender systems (GNN embeddings). Optimize model performance and scalability, integrate solutions with cross-functional teams, provide technical leadership, and mentor junior engineers to drive AI-driven media buying decisions.

Lead daily supply chain operations including shipment planning, tendering, consolidation, freight audit/payment into SAP, network optimization, UAT for Oracle TMS, contract support, KPI tracking, logistics analysis, process improvement, and management of third-party logistics performance and parcel accounts.