5+ years of experience in ETL and data integration using SAS and SQL.
Proficient in data extraction from various sources including Oracle, SQL Server, and APIs.
Strong understanding of data cleansing, transformation, and validation processes.
Experience with complex SQL queries, joins, and stored procedures.
Familiarity with Agile/Scrum methodologies and team collaboration.
Responsibilities
Develop and maintain ETL workflows and data pipelines using SAS and SQL.
Design and optimize SAS programs and macros for data processing.
Extract and transform data from multiple sources into data warehouses.
Implement data quality checks and troubleshoot discrepancies.
Monitor and optimize daily ETL jobs for performance and reliability.
Collaborate with cross-functional teams to gather business requirements.
Document technical specifications and operational procedures.
Benefits
Opportunity to work with cutting-edge data technologies.
Collaborative team environment with Agile practices.
Professional development and training opportunities.
Flexible work arrangements to support work-life balance.
Full Job Description
Data Specialist Job requirements
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
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
About Brillio
Brillio is a technology consulting and technology services company focused on the implementation of digital technologies.
Brillio Careers
There has never been a more opportune time to join Brillio—the forefront of innovation and digital transformation.
Opportunities Await
Brillio offers a plethora of job opportunities aimed at harnessing the potential of professionals eager to drive change. With a focus on technology and consulting, Brillio is not just a company; it's a vibrant ecosystem conducive to growth and professional development.
Transform Your Career
Embark on a journey of growth and leadership at Brillio. This is where industry expertise meets digital innovation to transform businesses and industries. Brillio stands out in the marketplace, providing a unique blend of technology solutions and strategic insights.
Join a Diverse and Inclusive Team
Brillio is committed to diversity and inclusion, ensuring a wide range of perspectives that fuel innovation and creative solutions. The team at Brillio, enriched with diverse skills and backgrounds, collaborates to deliver excellence and drive success.
Internship Programs and Employment
Kickstart your career with Brillio's internship programs, designed to offer hands-on experience and a gateway to full-time employment. Brillio is dedicated to nurturing young talent, providing them with the necessary tools and guidance to excel.
Innovate and Lead
At Brillio, every team member is an innovator and leader. The company fosters a culture of continuous learning and improvement, encouraging each individual to push boundaries and contribute to groundbreaking projects.
Networking and Professional Development
Networking at Brillio opens doors to influential connections, mentorship, and collaborative opportunities. Brillio supports career advancement through professional development, offering training in leadership, diversity, and specific job skills.
Benefits and Culture
Brillio is known for its dynamic culture and the comprehensive benefits it offers. Team members enjoy a supportive environment that values their well-being and professional growth.
Explore Job Positions
Brillio is hiring! Explore the various positions available that match your skills and interests. Brillio seeks passionate, curious, and solution-driven professionals ready to make an impact.
Prepare for Your Interview
Brillio helps candidates succeed by providing resources on how to effectively prepare your resume and ace the interview process. Stand out as a prospective employee by demonstrating your knowledge and enthusiasm for Brillio's mission.
Stay Connected with Brillio Careers
Keep up to date with career tips, industry insights, and the latest job openings at Brillio. Personalize your job search and stay informed about new and exciting opportunities within the company.
APPLY TO BRILLIO JOBS
Read Careers Blog
Stay ahead in your career with insights from Brillio's experts. Discover articles and advice tailored to advancing your career and enhancing your professional journey.
Job Alert Emails
Subscribe to receive customized job alerts and the latest news from Brillio. Discover the rewarding career opportunities that await and how Brillio can be the key to your professional future.
