CGI Technologies and Solutions, Inc. SQL Server Developer in Pittsburgh, Pennsylvania

SQL Server Developer

CGI-experience the commitment

Find similar career opportunities

Category:Information Technology

City:Pittsburgh, Pennsylvania, United States

Position ID:J0916-2077

Employment Type:Full Time

Meet our professionals

CGI: An employer of choice offering a global health and wellness program

Position Description:

CGI Federal, a wholly owned subsidiary of CGI and a leader in providing clinical auditing and IT consulting services to federal government agencies throughout the US, has openings in Cleveland, OH for experienced SQL Server Developers. Overall, these roles will work with a Scrum Development Team to create, test and export SSIS/DTS packages for various projects and data warehouses. Specific responsibilities will include the following:

  • Investigate and analyze data for various projects and report results in Excel spreadsheets or

other formats

  • Create and test stored procedures and triggers with T-SQL

  • Create T-SQL scripts to perform complex queries and complex data manipulations

  • Ensure data integrity and data quality among the database environments

  • Design and develop ETL/DTS/SSIS and RDL packages

  • Perform data research and analysis on data and processes used to generate various letters

  • Implement fine-tuned SQL to maximize performance

To be considered for these challenging and rewarding roles, applicants should have a majority of the following skills, knowledge and abilities:

  • At least four years of SQL Server development experience in a fast-paced, collaborative IT

work environment

  • Fluent in either T-SQL, RDL, or ANSI-SQL scripting languages

  • Demonstrated experience writing complex stored procedures

  • Proven experience troubleshooting and solving complex databases schemas/warehouses

  • Proven experience using ETL/DTS for data integration and SSIS

  • Experience with performance tuning stored procedures and T-SQL involving SQL Server

2005/2008/2012, experience using TFS

  • Knowledge of Microsoft Visual Studio 2013/2015, familiar with Health Care data

and processes

  • Prefer bachelor degree in CS, IS or STEM discipline

What you can expect from us:

At CGI, we’re a team of builders. We call our employees members because all who join CGI are building their own company - one that has grown to 65,000 professionals located in 40 countries. Founded in 1976, CGI is a leading IT and business process services firm committed to helping clients succeed. We have the global resources, expertise, stability and dedicated professionals needed to achieve results for our clients - and for our members. Come grow with us. Learn more at

This is a great opportunity to join a winning team. CGI offers a competitive compensation package with opportunities for growth and professional development. Benefits for full-time, permanent members start on the first day of employment and include a paid time-off program and profit participation and stock purchase plans.

We wish to thank all applicants for their interest and effort in applying for this position, however, only candidates selected for interviews will be contacted.

No unsolicited agency referrals please.

All CGI offers of employment in the U.S. are contingent upon the ability to successfully complete a background investigation. Background investigation components can vary depending upon specific assignment, or upon any US government security clearance if required. Qualified applicants will receive consideration for employment without regard to their race, color, religion, sex, gender Identity, sexual orientation, national origin, age, disability, veteran status, pregnancy, or other status protected by law. CGI will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with CGI’s legal duty to furnish information.

Have you been referred by a CGI Member for this position?* Yes No

CGI member’s email ( *

First Name

Last Name

I agree to allow CGI to contact the CGI member who referred me to obtain additional information about my application and to confirm my referral. *

* This field is required.

Are you interested in this job?

In the US, CGI is committed to a policy of equal employment opportunity. We recruit, employ, train, compensate, and promote without regard to race, ancestry, color, sex, religion, creed, age, national origin, citizenship status, disability, medical condition, military and veteran status, marital status, sexual orientation or perceived sexual orientation, gender, gender identity and gender expression, familial status, political affiliation, genetic information, or any other legally protected status or characteristics.

CGI is committed to the principles of equal employment opportunity and to compliance with US laws and regulations. Click here at to access our US EEO/Affirmative action policy.

Applicants have rights under Federal Employment Laws:

  1. EPPA at

  2. FMLA at

  3. Consolidated EEO Is The Law at

If you need an accommodation in order to complete the application process, click here at .

We make it easy to translate military experience and skills! Click here at to be directed to our site that is dedicated to veterans and transitioning service members.