About the role
Job Title: Techno-Functional Business Analyst with DataStage & PL/SQL
Location: Dallas, TX
Work Arrangement: Hybrid
Employment Type: Contract
Contract Duration: 6+ months
Hourly Rate: $59.16/hr. on W2 OR $65.61/hr. on C2C
Domain: Technology | Enterprise Data Engineering & Analytics
Application Deadline: August 26, 2026
SKILLS REQUIRED
Primary (Must-Have):
✔️7 to 9 years of experience as a Techno-Functional Business Analyst on data-driven enterprise projects
✔️Hands-on technical proficiency with IBM InfoSphere DataStage ETL design and implementation
✔️Advanced expertise in Oracle PL/SQL, complex query writing, stored procedures, and performance tuning
✔️Proficiency with Unix shell scripting for data job execution and environment navigation
✔️End-to-end data mapping, transformation rules definition, gap analysis, and agile user story creation
Secondary (Good to Have):
✔️Design and execution of detailed test scenarios for data integration and downstream analytics
✔️Experience monitoring production ETL data jobs, identifying root causes, and resolving operational defects
✔️Creation of end-to-end process flow diagrams, data dictionaries, and traceability documentation
✔️Experience working within Agile/Scrum delivery frameworks in hybrid enterprise environments
✔️Strong stakeholder management, cross-functional collaboration, and technical communication skills\
POSITION OVERVIEW
✔️We are seeking a Senior Techno-Functional Business Analyst for a hybrid engagement based out of Dallas, TX.
✔️The role sits at the intersection of business analysis and enterprise data engineering, translating business needs into robust DataStage and PL/SQL solutions.
✔️The incumbent will collaborate with product owners, data engineers, and operational stakeholders to design scalable, high-performance data workflows.
✔️Candidates must possess 7 to 9 years of hands-on experience in Oracle PL/SQL, IBM InfoSphere DataStage, and Unix to validate and optimize database objects.
✔️This position requires driving data quality, gap analyses, automated workflows, and production support across complex enterprise data environments.
ROLES & RESPONSIBILITIES
✔️Analyze business requirements to define functional specifications, data mapping, and transformation rules for DataStage and Oracle PL/SQL implementation
✔️Collaborate with product owners and data engineers to refine user stories, acceptance criteria, and scalable data pipeline architectures
✔️Review and validate database objects (procedures, packages, scripts) and execute test scenarios for seamless ETL data integration
✔️Document end-to-end business workflows, data flows, and system interactions while conducting gap analyses to optimize business processes
✔️Monitor production data jobs, troubleshoot performance issues, and support smooth deployment releases in a hybrid team setting
BENEFITS
Medical | Dental | Vision | 401(k)
EEOC Compliance
We are an equal opportunity employer, and all qualified applicants will receive consideration for employment.
DISCLAIMER
AI Usage Policy: Pacer Group uses AI to assist in screening applications. Final hiring decisions are made by human recruiters based on qualifications and experience.
Millions of jobs, with real people getting hired every day
Questions, answered
Click "Apply with JobAssist" – we tailor your resume and application to this role and submit it for your approval.
Yes. This role at Pacer Group was screened before publishing – we confirmed the employer before listing it.
The employer didn't disclose a salary range for this listing. JobAssist shows pay whenever it's available.
This position can be done from anywhere, with no in-office requirement.
Yes – every application is tailored from your profile and this job's requirements, and you can review and edit before it's sent.