Role Summary
As a SQL Developer you will work as part of a team that receives detailed and high-level requirements & specifications from our client for implementation. Working with Clients and other technical team members you will analyze, design, develop, optimize, test, and document SQL based queries and procedures to meet our clients’ needs. You passion for data will enable you to move quickly and develop meaningful and performant solutions to tough client questions. This position does not have any direct reports.
Major Areas of Responsibility
Review and interpret ongoing business requirements
Research required data
Build queries that provide short- or long-term answers to business questions.
Design and implement technical enhancements of Data Warehouse, Business Intelligence, or Big Data solutions as required
Develop, implement, and optimize stored procedures and functions using appropriate database syntax and approach (Teradata USP, PL/SQL, SAS DI, SAS Enterprise Guide)
Analyze existing SQL queries for performance improvements
Develop procedures and scripts for data migration
Enforce standards and discipline in the documentation and structured development
Build appropriate and useful deliverables
Conduct unit tests and assist in test preparations to ensure data integrity, data quality and program quality
Required Education and Experience:
Diploma or Bachelors degree in computer science or related field
3-5 years’ experience in Data Analysis or related filed.
3-5 years’ experience a SQL Developer or similar role
SAS programming (DATA step), SQL programming (i.e., use of SQL pass-through or PROC SQL).
Excellent understanding of SQL Programming and entity relationships
Experience with Teradata Stored Procedures (BTEQ), PL/SQL and other utilities
Experience with Scheduling, SQL, UNIX Script, RDMS and Data Warehousing
Understanding of data warehouse/big data architectures and entity relationships
Ability to learn new interfaces between database and ETL tools
Ability to solve technical problem / processes and understand complex details
SAS Data Integrator experience an asset
Visualization software (MicroStrategy/Tableau) an asset.
Why Join Project X:
Project X Ltd drives success by focusing on building teams of incredibly talented, fun, dedicated people. We reward hard work and forward thinking with recognition and a fun company culture. We offer the following incentives:
Competitive Salary
Health and Dental benefits package
Additional Health and Wellness Benefit – (i.e., bikes, fitness classes, health / fitness club memberships)
Opportunities to advance your career
Employee Referral Bonus
In our commitment to promote fair and equitable treatment of all employees and applicants, Project X Ltd. provides equal employment opportunities for all individuals regardless of age, sex, disability, race, ethnic origin, citizenship, creed, sexual orientation, marital status or any other ground as described in the Ontario Human Rights Code. In addition, accommodation will be provided during the hiring process.
Project X is an equal opportunity employer and welcomes and encourages applications from people with disabilities. Accommodations are available on request for candidates taking part in all aspects of the selection process.
Due to the current COVID 19 Pandemic:
Interviews are conducted online
Project X Ltd. staff are currently working from home
Powered by JazzHR
Click here to apply as an internal applicant. Req ID: 172141 Company: Nova Scotia Health Location: Eastern Zone, St. Martha’s...
Apply For This JobWhat you’ll do The Customs Compliance Auditor exists to ensure CTC’s compliance to all regulations and legislation of Customs Border...
Apply For This JobDescription : Qualifications requises : Baccalauréat en éducation, en psychoéducation ou formation jugée suffisante jumelée avec 2 ans d’expérience dans...
Apply For This JobStaff – Non Union Job Category M&P – AAPS Job Profile AAPS Salaried – Student Management, Level C Job Title...
Apply For This JobJob Seekers can review the Job Applicant Privacy Policy by clicking HERE. Summary Ryder is seeking a motivated individual to...
Apply For This JobCompany Description WHO ARE WE? We’ve been serving Canadian clients for over 75 years. The companies that began independently and...
Apply For This Job