PLC Programmer

American Cybersystems, Inc.; Pittsburgh (Allegheny County); On-site; USD 69,000 - 74,000; Full time

Benefits offered by this job

Medical & pharmacy coverage

Dental/vision insurance

401(k)

HSA and FSA

Life Insurance

Sick time

EAP

Job summary

Innova Solutions is hiring a PLC Programmer to design, implement, and optimize Oracle PL/SQL solutions and ODI-based ETL workflows in Pittsburgh. You will bridge MES, financial systems, and enterprise reporting to enable data-driven decisions.

The role emphasizes automating reporting with Excel Macros/VBA and collaborating with analytics teams using Oracle Analytics Cloud, Power BI, and Tableau to deliver actionable insights.

Qualifications

• Bachelor’s degree in computer science, IT, or related discipline.
• Strong Oracle Database Development with advanced PL/SQL.
• Hands-on ODI ETL development experience.
• Excel Macros/VBA for automating reporting.
• Strong debugging and problem-solving skills.
• Excellent cross-functional collaboration.

Responsibilities

• Design, develop, and optimize Oracle PL/SQL programs, packages, procedures, and objects.
• Create scalable database solutions supporting mission-critical apps.
• Develop ETL solutions with ODI and integrate MES/Fin systems.
• Automate processes with Excel Macros and VBA for reporting.
• Collaborate with analytics teams using Oracle Analytics Cloud/Power BI/Tableau.
• Troubleshoot, debug, and ensure data integrity across systems.

Skills

Oracle PL/SQL

ETL Development

Excel Macros/VBA

Data Integration

BI Reporting

Education

Bachelor’s degree in Computer Science, Information Technology, or related discipline

Tools

Oracle Data Integrator (ODI)

Oracle Analytics Cloud

Power BI

Tableau

SQL Performance Tuning

Job description

A client of Innova Solutions is immediately hiring for a PLC Programmer Position type: Full-time, contract Duration: 18 months Location: Pittsburgh Pennsylvania 15203

About the Role

We’re looking for a PLC Programmer who thrives on solving complex data challenges, streamlining integrations, and turning business needs into scalable technical solutions. In this role, you’ll be at the heart of our data ecosystem, designing robust Oracle database applications, developing ETL pipelines, and enabling data‑driven decision‑making through modern BI platforms. You’ll collaborate closely with business stakeholders and technology teams to bridge Manufacturing Execution Systems (MES), Financial Systems, and enterprise reporting environments.

What You’ll Do

Build & Optimize Enterprise Data Solutions

• Design, develop, and optimize advanced Oracle PL/SQL programs, packages, procedures, and database objects.
• Create scalable database solutions that support mission‑critical business applications.
• Ensure database performance, reliability, and data integrity across enterprise systems.

Power Data Movement & Integration

• Develop and maintain robust ETL solutions using Oracle Data Integrator (ODI).
• Seamlessly integrate data between Manufacturing Execution Systems (MES), Financial Systems, and enterprise applications.
• Support data transformation, cleansing, and synchronization initiatives.

Drive Automation & Reporting Excellence

• Design and maintain Excel Macros and VBA‑based solutions to automate business processes and enhance reporting capabilities.
• Partner with stakeholders to streamline data preparation and reporting workflows.

Enable Business Insights

• Collaborate with analytics teams to support reporting and visualization initiatives using Oracle Analytics Cloud, Power BI, and Tableau.
• Deliver data structures and solutions that empower informed business decisions.

Solve Complex Challenges

• Troubleshoot, debug, and resolve application and database issues with a focus on operational stability.
• Conduct code reviews, testing, and documentation to ensure high‑quality development standards.
• Translate business requirements into practical, maintainable technical implementations.

Required Qualifications

• Bachelor’s degree in computer science, Information Technology, or a related discipline.
• Strong experience in Oracle Database Development with advanced PL/SQL expertise.
• Hands‑on experience building ETL workflows using Oracle Data Integrator (ODI).
• Proficiency in developing and managing Excel Macros/VBA solutions.
• Exceptional troubleshooting, debugging, and problem‑solving skills.
• Ability to interpret complex business requirements and convert them into scalable technical solutions.
• Strong communication skills with the ability to collaborate effectively across business and technical teams.
• Self‑driven mindset with a passion for continuous improvement and innovation.

Preferred Qualifications

• Experience working with Oracle Analytics Cloud, Power BI, Tableau, or other BI platforms.
• Exposure to Manufacturing Execution Systems (MES) and Financial Systems integration projects.
• Knowledge of Oracle database administration and SQL performance tuning techniques.
• Familiarity with Agile development practices and methodologies.
• Experience with additional ETL frameworks, data integration technologies, or programming languages.

Pay Range and Benefits

Pay Range*: $50.00 - $53.84 per hour
*Pay range offered to a successful candidate will be based on several factors, including the candidate’s education, work experience, work location, specific job duties, certifications, etc.

• Medical & pharmacy coverage
• Dental/vision insurance
• 401(k)
• Health saving account (HSA) and Flexible spending account (FSA)
• Life Insurance
• Pet Insurance
• Short term and Long term Disability
• Accident & Critical illness coverage
• Pre-paid legal & ID theft protection
• Sick time
• and other types of paid leaves (as required by law)
• Employee Assistance Program (EAP)

About Innova Solutions

Founded in 1998 and headquartered in Atlanta, Georgia, Innova Solutions employs approximately 50,000 professionals worldwide and reports an annual revenue approaching $3 Billion. Through our global delivery centers across North America, Asia, and Europe, we deliver strategic technology and business transformation solutions to our clients, enabling them to operate as leaders within their fields.

Recent Recognitions

Named One of America’s Best Employers for New Grads by Forbes (2024) Named One of the Best Companies to Work for by U.S. News & World Report (Private Companies List, 2024‑2025) One of the Largest IT Staffing Firms in the US – Ranked #3 by Staffing Industry Analysts (SIA, 2024) One of the Largest Staffing Firms in the US – Ranked #13 by Staffing Industry Analysts (SIA, 2024; includes Innova Solutions, Volt, & HireGenics) Named One of the Top Ten Private Companies in Atlanta by the Atlanta Business Chronicle (2023) One of the Largest Certified Minority Business Enterprises (MBEs) in the United States (NMSDC, 2024) AWS Advanced Tier Services Partner with 100+ certifications

Contact

Website: https://www.innovasolutions.com/ Innova Solutions offers a referral bonus for qualified Ambassadors who refer eligible referrals. Submit referrals at https://innovasolutions.workllama.com/atsuser/anonreferafriend and earn $250-$1,000 per referral.
Innova Solutions is an Equal Opportunity Employer and prohibits any kind of unlawful discrimination and harassment.
Innova Solutions is committed to the principle of equal employment opportunity for all employees and to providing employees with a work environment free of discrimination and harassment on the basis of race, color, religion or belief, national origin, citizenship, social or ethnic origin, sex, age, physical or mental disability, veteran status, marital status, domestic partner status, sexual orientation or any other status protected by the statutes, rules, and regulations in the locations where it operates.
If you are an individual with a disability and need a reasonable accommodation to assist with your job search or application for employment, please contact us at [e-mail] or (770) 493‑5588. Please indicate the specifics of the assistance needed.
Innova Solutions encourages all interested and qualified candidates to apply for employment opportunities.
Innova Solutions (HireGenics/Volt) does not discriminate against applicants based on citizenship status, immigration status, or national origin, in accordance with 8 U.S.C. § 1324b. The company will consider for employment qualified applicants with arrest and conviction records in a manner that complies with the SanFrancisco Fair Chance Ordinance, the LosAngeles Fair Chance Initiative for Hiring Ordinance, and other applicable laws.
By applying for this job, you agree to receive calls, AI‑generated calls, text messages, or emails from Innova Solutions and its affiliates, and contracted partners. Frequency varies for text messages. Message and data rates may apply. Carriers are not liable for delayed or undelivered messages. You can reply STOP to cancel and HELP for help. You can access our privacy policy at Privacy Policy - innovasolutions.