Job#: 3042348

Job Description:

SAS/SQL Developer

Overview: 

Seeking a SAS/SQL Developers to build and support data transformation and reporting processes using SAS and SQL. This role is responsible for enhancing data processing, business logic application, reporting, and analytics capabilities across multiple teams. You will:

• Support data development and reporting initiatives.
• Combines backend data development with reporting and visualization responsibilities.
• Team is migrating reporting solutions from SSRS to Power BI and responsible for building out net new Power BI reports and dashboards. Ideal consultant would also have experience in Power BI, but the focus of the role is around data processing and transformation, business logic implementation.

This role is 6 month contract but candidates may apply to FTE roles at the bank or additional contracts as there is a lot of opportunity within the bank.

This role is hybrid onsite 2-3 days/week (Thursday, every other Friday, third day flexible)

Key Responsibilities:

• Develop and maintain SAS programs and scripts.
• Create data transformation processes that apply business logic to source data.
• Extract, manipulate, and validate data from enterprise data sources.
• Build data processing workflows involving transaction, sales, and portfolio datasets.
• Write and maintain PROC SQL and SAS Data Step code.
• Support production data processes and scheduled jobs.
• Apply business rules and calculations to support tracking and performance metrics.
• Troubleshoot and maintain existing SAS programs and processes.

Additional Responsibilities

• Support frontend reporting and dashboard development.
• Conduct ad hoc data analysis and reporting requests - requires core querying skills in SQL (JOINs, GROUP BY, Aggregations)
• Work with SSRS and/or Power BI reporting solutions.
• Translate transformed data into reporting-ready datasets.

Required Skills (Must-Haves)

• 3–5+ years of hands-on SAS development experience (more senior for Ruby's team, Vera is open to candidates with less experience)
• Strong understanding of:
  • SAS Data Steps
  • PROC SQL
  • Core SAS programming techniques
  • Conditional logic and data manipulation
• Ability to read, understand, troubleshoot, and modify existing SAS code.
• Experience performing data transformations and data integration work.
• Ability to apply business logic to raw source data.
• Experience working with production data environments.
• Strong analytical and problem-solving skills.
• Ability to understand complex business rules.
• Practical approach to solving technical problems without overengineering solutions.
• Ability to quickly understand existing processes and code bases.

SQL Skills

• Solid SQL querying skills.
• Experience writing joins, aggregations, and data manipulation queries.
• Comfortable performing ad hoc analysis against enterprise databases.

Nice-to-Haves:

• Power BI development experience
• SSRS reporting experience
• SAS Enterprise Guide experience (they are using Enterprise Guide, but open to candidates with other SAS applications)
• Experience with Netezza databases (primary data source)
• Experience supporting scheduled batch processes.
• Familiarity with cron job scheduling.

Tech Stack / Core Technologies

• SAS
• PROC SQL
• SAS Data Steps
• SQL
• Netezza
• SAS Enterprise Guide
• SAS-based SQL processing
• Power BI
• SSRS
• Cron jobs (scheduling/automation)

Location: Toronto, ON

Engagement Type: Contract

EEO Employer

Everforth Apex Systems is an Equal Employment Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, sexual orientation, gender identity, national origin, disability, protected veteran status, or any other characteristic protected by law. Everforth Apex Systems will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law. If you have visited our website in search of information on employment opportunities or to apply for a position, and you require an accommodation in using our website for a search or application, please contact our Employee Services Department at [email protected] or 844-463-6178.

Everforth Apex is a world-class IT services company that serves thousands of clients across the globe. When you join Everforth Apex, you become part of a team that values innovation, collaboration, and continuous learning. We offer quality career resources, training, certifications, development opportunities, and a comprehensive benefits package. Our commitment to excellence is reflected in many awards, including ClearlyRateds Best of Staffing® in Talent Satisfaction in the United States and Great Place to Work® in the United Kingdom and Mexico.

Everforth Apex Benefits Overview: In terms of professional development, Everforth Apex hosts an on-demand training program, provides access to certification prep and a library of technical and leadership courses/books/seminars once you have 6+ months of tenure, and certification discounts and other perks to associations that include CompTIA and IIBA.