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
Description PeaceHealth is seeking a Hospital Engineer Lead for a Full Time, 1.00 FTE, Variable position. The general salary range...
Apply For This JobCompany Description The spirit of Dior is reflected in each of the House’s products and in the care taken at...
Apply For This JobWe are looking for summer camp voice/singing teacher to teach kids singing and perpare summer performance, we really need one...
Apply For This JobReports To Director, Street Sales Location Winnipeg Type Salaried Closing Date September 8, 2023 Company Overview Sysco connects the world...
Apply For This JobDo you have a TAE40116 or TAE40110 Certificate IV in Training and Assessment? Sessional opportunity available in Pakenham; a more...
Apply For This JobThe following temporary position is open for applications: EDUCATION ASSISTANT – SPECIAL EDUCATION (Student Specific 1) CUPE Competition No. 5456...
Apply For This Job