The Role
Designs, develops, tests, and maintains SAS and SQL ETL workflows and data pipelines. Extracts and transforms data from multiple sources, performs validation and reconciliation, develops complex queries, monitors batch jobs, troubleshoots production issues, conducts root-cause analysis, and maintains technical documentation. Collaborates with analysts, developers, QA teams, and stakeholders while participating in Agile/Scrum ceremonies.
Summary Generated by Built In
Data Specialist
Job requirements
- Develop and maintain ETL workflows and data pipelines using SAS and SQL.
- Design, develop, and optimize SAS programs, SAS macros, SAS procedures, and stored processes.
- Extract data from various sources including Oracle, SQL Server, DB2, flat files, CSV, Excel, and APIs.
- Perform data cleansing, transformation, validation, aggregation, and reconciliation.
- Develop complex SQL queries, joins, subqueries, views, and stored procedures.
- Work with SAS Base, SAS Macro, SAS SQL, and SAS Enterprise Guide.
- Build and maintain batch processing and scheduled ETL jobs.
- Perform data mapping and source-to-target analysis based on business requirements.
- Implement data quality checks and investigate data discrepancies.
- Optimize SAS programs and SQL queries for performance and scalability.
- Perform unit testing, integration testing, regression testing, and production validation.
- Monitor daily ETL jobs and troubleshoot job failures, data issues, and performance problems.
- Analyze production incidents and perform root-cause analysis (RCA).
- Maintain technical documentation, data mapping documents, ETL specifications, and operational procedures.
- Work closely with Business Analysts, Data Analysts, Developers, QA teams, and business stakeholders.
- Participate in Agile/Scrum ceremonies, sprint planning, backlog refinement, daily stand-ups, reviews, and retrospectives
Role Summary We are looking for an experienced ETL/SAS Engineer responsible for designing, developing, testing, and maintaining data integration and ETL processes using SAS and SQL. The role involves extracting data from multiple sources, transforming and validating the data, and loading it into data warehouses and downstream applications. Key Responsibilities
Skills Required
- Experience designing, developing, testing, and maintaining ETL and data integration processes
- SAS programming experience, including SAS Base, SAS Macro, SAS SQL, SAS procedures, stored processes, and SAS Enterprise Guide
- SQL experience, including complex queries, joins, subqueries, views, and stored procedures
- Experience extracting and integrating data from Oracle, SQL Server, DB2, flat files, CSV, Excel, and APIs
- Experience with data cleansing, transformation, validation, aggregation, reconciliation, and data quality checks
- Experience building and maintaining batch processing and scheduled ETL jobs
- Experience with unit, integration, regression, and production validation testing
- Experience monitoring ETL jobs and troubleshooting job failures, data issues, and performance problems
- Experience performing production incident analysis and root-cause analysis
- Experience creating data mapping documents, ETL specifications, technical documentation, and operational procedures
- Experience collaborating with Business Analysts, Data Analysts, Developers, QA teams, and business stakeholders
- Participation in Agile/Scrum ceremonies
Brillio Compensation & Benefits Highlights
The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about Brillio and has not been reviewed or approved by Brillio.
-
Healthcare Strength — Healthcare is considered comprehensive, including medical coverage for employees and dependents alongside life, disability, and accidental death protections. Feedback suggests these protections are a core strength of the package.
-
Leave & Time Off Breadth — Time-off options include paid leave and parental leave, with flexible or ‘flexible PTO’ approaches cited in some contexts. Feedback suggests this breadth helps support work-life balance when team norms permit usage.
-
Wellbeing & Lifestyle Benefits — Wellbeing offerings span counseling, financial-management sessions, fitness programs, and travel insurance, plus region-specific extras like discounted IT hardware and work-from-home essentials. Feedback suggests these add-ons enhance perceived value beyond core insurance.
Brillio Insights
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
Brillio is the leader in global digital business transformation, applying technology with a human touch. We help businesses define internal and external transformation objectives, and translate those objectives into actionable market strategies using proprietary technologies. With 2600+ experts and 13 offices worldwide, Brillio is the ideal partner for enterprises that want to quickly increase their core business productivity, and achieve a competitive edge, with the latest digital solutions.
