Job Summary
Synechron is seeking a Data Engineer – SAS ETL – LPA with 4–6 years of relevant experience in SAS ETL and Oracle Database development. The role will focus on designing, developing, enhancing, and supporting enterprise-scale data integration and ETL solutions. The successful candidate will use SAS, Oracle Database, SQL, and Control-M to deliver reliable data processes, support data quality, troubleshoot issues, and contribute to analytics and data delivery objectives.
Software Requirements
Required
SAS ETL: Hands-on experience developing, enhancing, maintaining, and supporting ETL processes using SAS.
Oracle Database: Mandatory hands-on experience with Oracle Database, including queries, stored procedures, data models, data validation, and performance tuning.
SQL: Strong experience writing and optimizing SQL queries for data extraction, transformation, validation, reconciliation, and analysis.
Control-M: Experience scheduling, monitoring, managing, and troubleshooting ETL jobs.
Data Warehousing Tools and Processes: Experience with data warehouse structures, ETL workflows, data integration, and data delivery practices.
Development and Support Tools: Experience using tools for technical documentation, issue tracking, job monitoring, and production support.
Preferred
Exposure to additional enterprise data integration, scheduling, or data quality tools.
Experience supporting analytics-focused data projects and large-scale data processing environments.
Familiarity with performance monitoring and optimization tools for SAS and Oracle environments.
Exposure to automated testing, deployment, or release management tools used in data engineering delivery.
Overall Responsibilities
Develop, enhance, maintain, and support ETL processes using SAS to meet approved business and technical requirements.
Design, develop, and optimize Oracle Database queries, stored procedures, data models, and related data processing components.
Analyze business requirements and translate them into scalable, maintainable, and technically accurate data integration solutions.
Perform data validation, reconciliation, troubleshooting, root-cause analysis, and performance tuning across ETL and database processes.
Schedule, monitor, and troubleshoot ETL jobs using Control-M to support reliable and timely data delivery.
Collaborate with business analysts, data teams, application teams, testing teams, and other stakeholders to clarify requirements and resolve delivery issues.
Apply data warehousing and ETL best practices to support data accuracy, completeness, consistency, maintainability, and operational stability.
Investigate production issues, document findings, coordinate resolutions, and support post-implementation validation.
Create and maintain technical documentation, data mappings, process specifications, job schedules, support procedures, and operational records.
Contribute to continuous improvement by reducing manual processing, improving job efficiency, reusing ETL components, and optimizing resource usage where applicable.
Deliver reliable data integration solutions that support enterprise-scale data delivery and analytics objectives.
Technical Skills (By Category)
Programming Languages
Essential
SAS programming for ETL development, data transformation, data validation, and processing.
Strong SQL skills for complex queries, joins, subqueries, aggregations, stored procedures, reconciliation, and data analysis.
Ability to interpret business rules and implement them through SAS ETL processes and Oracle Database components.
Preferred
Exposure to scripting or programming languages used for job monitoring, automation, data validation, or operational support.
Experience developing reusable utilities for ETL testing, reporting, or process monitoring.
Databases and Data Management
Essential
Mandatory hands-on experience with Oracle Database.
Experience designing and optimizing Oracle queries, stored procedures, data models, and data processing logic.
Understanding of data warehousing concepts, ETL architecture, staging processes, data marts, and target data structures.
Experience performing data validation, reconciliation, completeness checks, consistency checks, and data quality analysis.
Ability to analyze data lineage, source-to-target mappings, transformation rules, and downstream data dependencies.
Experience troubleshooting database and ETL performance issues.
Preferred
Exposure to additional relational databases or enterprise data platforms.
Experience with data profiling, metadata, data governance, data quality controls, or data lineage tools.
Experience supporting large-volume data processing and analytics environments.
Cloud Technologies
Essential
Ability to support ETL and database processes in the environments used by the assigned project.
Understanding of data integration, job scheduling, monitoring, and data delivery across enterprise environments.
Preferred
Exposure to cloud-based data platforms, databases, data warehouses, or ETL services.
Experience supporting hybrid data environments or cloud migration initiatives.
Frameworks and Libraries
Essential
SAS ETL development and processing capabilities.
Control-M job scheduling and monitoring capabilities.
Understanding of ETL design patterns, data transformation methods, error handling, restartability, dependency management, and batch processing.
Ability to develop maintainable and reusable ETL workflows.
Preferred
Exposure to data quality, testing, automation, or deployment frameworks used in enterprise data environments.
Familiarity with reusable ETL frameworks, job control standards, or process automation utilities.
Development Tools and Methodologies
Essential
4–6 years of relevant experience in SAS ETL and Oracle development.
Experience with requirements analysis, technical design, development, testing, deployment, monitoring, troubleshooting, and production support.
Experience scheduling and monitoring ETL jobs through Control-M.
Understanding of structured software development life cycle and ETL delivery practices.
Experience creating technical documentation, data mappings, job specifications, support procedures, and implementation records.
Ability to collaborate with cross-functional teams to deliver accurate and timely data solutions.
Preferred
Experience working in Agile, Scrum, or comparable iterative delivery environments.
Exposure to version control, release management, automated testing, continuous integration, or deployment practices.
Experience participating in code reviews, technical walkthroughs, sprint planning, defect resolution, and continuous improvement activities.
Security Protocols
Essential
Understanding of secure handling of enterprise data during ETL processing, database development, testing, and support.
Ability to follow access-control, data privacy, confidentiality, audit, and environment-specific data handling requirements.
Awareness of secure database access, credential management, logging, and controlled use of production and non-production data.
Ability to comply with Synechron’s applicable security, data governance, and operational standards.
Preferred
Experience supporting data solutions in regulated or controlled environments.
Exposure to data masking, encryption, role-based access, audit logging, and security validation practices.
Experience Requirements
4–6 years of relevant professional experience in SAS ETL and Oracle Database development.
Strong hands-on experience developing, enhancing, maintaining, and supporting SAS ETL processes.
Mandatory practical experience with Oracle Database, including SQL development, stored procedures, data models, validation, and performance tuning.
Experience using Control-M to schedule, monitor, troubleshoot, and manage ETL jobs.
Experience with data warehousing, ETL best practices, data integration, data validation, and data quality activities.
Demonstrated ability to analyze business requirements and translate them into technical data solutions.
Experience troubleshooting ETL and database issues and supporting reliable data delivery.
Experience collaborating with cross-functional teams, including business, development, testing, data, and support teams.
Experience in enterprise-scale data integration and analytics projects is preferred.
Candidates may qualify through equivalent professional experience in SAS development, ETL engineering, database development, or data integration roles where they can demonstrate comparable technical outcomes.
Day-to-Day Activities
Develop and maintain SAS ETL workflows, write and optimize Oracle SQL and stored procedures, and validate data against source-to-target requirements.
Schedule and monitor ETL jobs in Control-M, investigate failures, perform troubleshooting, and coordinate resolution of data or processing issues.
Participate in requirements discussions, technical reviews, testing activities, status meetings, and collaboration with cross-functional delivery teams.
Prepare technical documentation, data mappings, validation results, support records, and implementation deliverables while making technical decisions within approved standards.
Qualifications
Bachelor’s degree in Computer Science, Information Technology, Engineering, Data Management, or a related field; equivalent relevant professional experience may be considered.
4–6 years of professional experience in SAS ETL and Oracle Database development, with demonstrated enterprise data integration experience.
Relevant training in SAS ETL, Oracle Database, SQL, data warehousing, Control-M, data quality, and production support practices is preferred.
Certifications in SAS, Oracle Database, data engineering, data management, or related technologies are preferred but not required.
Commitment to continuous professional development through relevant technical training, product updates, data engineering practices, and evolving delivery standards.
Professional Competencies
Apply critical thinking and structured problem-solving to analyze requirements, investigate data issues, troubleshoot ETL failures, and identify root causes.
Collaborate effectively with business stakeholders, data teams, developers, testers, support teams, and other delivery participants.
Communicate technical findings, data quality results, risks, dependencies, progress, and resolution plans clearly and accurately.
Adapt to changing business requirements, data structures, ETL processes, technology environments, and delivery priorities.
Identify opportunities to improve ETL performance, data quality, automation, reusability, maintainability, and efficient use of processing resources.
Manage time and priorities across requirements analysis, development, validation, job monitoring, troubleshooting, documentation, and delivery commitments.
SYNECHRON’S DIVERSITY & INCLUSION STATEMENT
Diversity & Inclusion are fundamental to our culture, and Synechron is proud to be an equal opportunity workplace and is an affirmative action employer. Our Diversity, Equity, and Inclusion (DEI) initiative ‘Same Difference’ is committed to fostering an inclusive culture – promoting equality, diversity and an environment that is respectful to all. We strongly believe that a diverse workforce helps build stronger, successful businesses as a global company. We encourage applicants from across diverse backgrounds, race, ethnicities, religion, age, marital status, gender, sexual orientations, or disabilities to apply. We empower our global workforce by offering flexible workplace arrangements, mentoring, internal mobility, learning and development programs, and more.
All employment decisions at Synechron are based on business needs, job requirements and individual qualifications, without regard to the applicant’s gender, gender identity, sexual orientation, race, ethnicity, disabled or veteran status, or any other characteristic protected by law.
Candidate Application Notice
Skills Required
- 4–6 years of relevant professional experience in SAS ETL and Oracle Database development
- Hands-on experience developing, enhancing, maintaining, and supporting SAS ETL processes
- Practical experience with Oracle Database, including SQL, stored procedures, data models, data validation, and performance tuning
- Strong SQL experience with complex queries, joins, transformations, validation, reconciliation, and analysis
- Experience scheduling, monitoring, troubleshooting, and managing ETL jobs using Control-M
- Understanding of data warehousing, ETL architecture, staging processes, data marts, and target data structures
- Experience with data validation, reconciliation, data quality, data lineage, source-to-target mappings, and downstream dependencies
- Experience with requirements analysis, technical design, development, testing, deployment, monitoring, troubleshooting, and production support
- Experience creating technical documentation, data mappings, job specifications, support procedures, and implementation records
- Bachelor’s degree in Computer Science, Information Technology, Engineering, Data Management, or a related field; equivalent experience may be considered
- Exposure to additional enterprise data integration, scheduling, data quality, or cloud data tools
- Experience supporting analytics-focused, large-scale, or enterprise data processing environments
- Experience with Agile, Scrum, version control, release management, automated testing, continuous integration, or deployment practices
- Relevant training or certifications in SAS, Oracle Database, data engineering, or data management
Synechron Compensation & Benefits Highlights
The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about Synechron and has not been reviewed or approved by Synechron.
-
Fair & Transparent Compensation — Pay is frequently characterized as competitive, particularly relative to large service-consulting peers and in certain in-demand skill areas. Compensation sentiment appears strongest when staffing is stable on strong client engagements and for market-aligned roles in major hubs.
-
Healthcare Strength — Healthcare coverage is often portrayed as a strong point in the U.S., with broad coverage and relatively favorable out-of-pocket experiences. Core medical, dental, and vision options are consistently described as meeting or exceeding a baseline expectation for consulting roles.
-
Equity Value & Accessibility — Equity was made broadly accessible through a company-wide RSU grant tied to a major revenue milestone. This is positioned as a notable upside even if it is framed as a one-time recognition event rather than an ongoing program.
Synechron Insights
What We Do
At Synechron, we believe in the power of digital to transform businesses for the better. Our global consulting firm combines creativity and innovative technology to deliver industry-leading digital solutions. Synechron’s progressive technologies and optimization strategies span end-to-end Artificial Intelligence, Consulting, Digital, Cloud & DevOps, Data, and Software Engineering, servicing an array of noteworthy financial services and technology firms. Through research and development initiatives in our FinLabs we develop solutions for modernization, from Artificial Intelligence and Blockchain to Data Science models, Digital Underwriting, mobile-first applications and more. Over the last 20+ years, our company has been honored with multiple employer awards, recognizing our commitment to our talented teams. With top clients to boast about, Synechron has a global workforce of 14,700+, and has 48 offices in 19 countries within key global markets. For more information on the company, please visit our website: www.synechron.com.
