IT Analyst - In office

Randstad

$80K — $95K *
Information Technology
5 - 7 years of experience
Job Overview by Ladders

Qualifications

  • University degree in computer science, software engineering, or a related field with an emphasis on programming.
  • 5+ years of related experience in technical support and system analysis.
  • 2+ years of SQL DBA/Developer experience in a Data Warehouse environment.
  • Strong SQL skills with knowledge in data integrity and performance efficiency.
  • Experience in client/server application development and database design methodology.

Responsibilities

  • Provide technical and end-user help desk support for web-based and digital systems.
  • Conduct systems analysis for business problems, interfacing with users and performing cost/benefit analysis.
  • Develop applications to meet business needs through collaboration with users.
  • Maintain and enhance SQL Server databases including query tuning and creating stored procedures.
  • Lead initiatives for continuous system improvements and collaborate across divisions.
  • Document software solutions and processes to aid in application migration and development.
  • Communicate project updates to stakeholders and participate in technology evaluations.

Benefits

  • Participation in continuous training and professional development opportunities.
  • Opportunity for exposure to new technologies and methodologies.
  • Support for a collaborative work environment across divisions.
  • Flexibility with after-hours support responsibilities.
Full Job Description
job details

Your responsibilities • Provide technical and end-user help desk support for web-based and digital systems. • Performs systems analysis of business problems with varying scope and complexity that includes requirements definition, interfacing with users and providing cost/benefit analysis ...
• Work with users to support and develop applications to meet the business needs • Maintain SQL Server databases. Utilizes SQL diagnostics involving fine tuning SQL queries and enhancing performance using SQL profiler and scripts. Create views, stored procedures, and UDFs as part of database development. • Lead continuous improvement initiatives to enhance system efficiencies within enterprise solutions, collaborating with divisions on localized systems. • Document application software solutions, metadata, and processes to support application migration, on-going development, and end-user issues. • Recommend modifications of IT systems to improve and simplify business systems • Communicate project status to key personnel including supervisor, project stakeholders, sponsors and project team members on a periodic basis. • Participates in new or alternative technology evaluation related to development tools, databases and methodologies. • Operational support & reliability: Troubleshoot production systems, perform structured root-cause analysis, implement corrective actions, and provide after-hours / on-call support as needed. Advantages Education, Experience and Skills • University degree in computer science, software engineering, or related field, with an emphasis on programming. • 5+ years of related experience • Knowledge in client/server application development, architecture, database-connectivity and database design methodology • 2 + years of SQL DBA/Developer experience in a Data Warehouse environment • Experience with data integrity, data retention, data analysis and data input/output processing and improving SQL code performance efficiency • Strong SQL, data-warehouse and stored procedure skills • Preference will be given to those applicants who have a working knowledge of C#, Visual Basic, ASP, JavaScript / VBScript, and T-SQL • Knowledge of Telerik Tools, Web Server Administration, Database Administration, SSIS and SSRS will be considered an asset • Experience using PowerBi will be considered an asset • Exposure to Agile development methodologies and MS DevOps will be considered an asset. • Knowledge of warehouse management and automation technology will be considered an asset • Project Management experience Responsibilities our responsibilities • Provide technical and end-user help desk support for web-based and digital systems. • Performs systems analysis of business problems with varying scope and complexity that includes requirements definition, interfacing with users and providing cost/benefit analysis • Work with users to support and develop applications to meet the business needs • Maintain SQL Server databases. Utilizes SQL diagnostics involving fine tuning SQL queries and enhancing performance using SQL profiler and scripts. Create views, stored procedures, and UDFs as part of database development. • Lead continuous improvement initiatives to enhance system efficiencies within enterprise solutions, collaborating with divisions on localized systems. • Document application software solutions, metadata, and processes to support application migration, on-going development, and end-user issues. • Recommend modifications of IT systems to improve and simplify business systems • Communicate project status to key personnel including supervisor, project stakeholders, sponsors and project team members on a periodic basis. • Participates in new or alternative technology evaluation related to development tools, databases and methodologies. • Operational support & reliability: Troubleshoot production systems, perform structured root-cause analysis, implement corrective actions, and provide after-hours / on-call support as needed. Qualifications Education, Experience and Skills • University degree in computer science, software engineering, or related field, with an emphasis on programming. • 5+ years of related experience • Knowledge in client/server application development, architecture, database-connectivity and database design methodology • 2 + years of SQL DBA/Developer experience in a Data Warehouse environment • Experience with data integrity, data retention, data analysis and data input/output processing and improving SQL code performance efficiency • Strong SQL, data-warehouse and stored procedure skills • Preference will be given to those applicants who have a working knowledge of C#, Visual Basic, ASP, JavaScript / VBScript, and T-SQL • Knowledge of Telerik Tools, Web Server Administration, Database Administration, SSIS and SSRS will be considered an asset • Experience using PowerBi will be considered an asset • Exposure to Agile development methodologies and MS DevOps will be considered an asset. • Knowledge of warehouse management and automation technology will be considered an asset • Project Management experience Summary Education, Experience and Skills • University degree in computer science, software engineering, or related field, with an emphasis on programming. • 5+ years of related experience • Knowledge in client/server application development, architecture, database-connectivity and database design methodology • 2 + years of SQL DBA/Developer experience in a Data Warehouse environment • Experience with data integrity, data retention, data analysis and data input/output processing and improving SQL code performance efficiency • Strong SQL, data-warehouse and stored procedure skills • Preference will be given to those applicants who have a working knowledge of C#, Visual Basic, ASP, JavaScript / VBScript, and T-SQL • Knowledge of Telerik Tools, Web Server Administration, Database Administration, SSIS and SSRS will be considered an asset • Experience using PowerBi will be considered an asset • Exposure to Agile development methodologies and MS DevOps will be considered an asset. • Knowledge of warehouse management and automation technology will be considered an asset • Project Management experience
show more

Your responsibilities • Provide technical and end-user help desk support for web-based and digital systems. • Performs systems analysis of business problems with varying scope and complexity that includes requirements definition, interfacing with users and providing cost/benefit analysis • Work with users to support and develop applications to meet the business needs • Maintain SQL Server databases. Utilizes SQL diagnostics involving fine tuning SQL queries and enhancing performance using SQL profiler and scripts. Create views, stored procedures, and UDFs as part of database development. • Lead continuous improvement initiatives to enhance system efficiencies within enterprise solutions, collaborating with divisions on localized systems. • Document application software solutions, metadata, and processes to support application migration, on-going development, and end-user issues. • Recommend modifications of IT systems to improve and simplify business systems • Communicate project status to key personnel including supervisor, project stakeholders, sponsors and project team members on a periodic basis. ...
• Participates in new or alternative technology evaluation related to development tools, databases and methodologies. • Operational support & reliability: Troubleshoot production systems, perform structured root-cause analysis, implement corrective actions, and provide after-hours / on-call support as needed. Advantages Education, Experience and Skills • University degree in computer science, software engineering, or related field, with an emphasis on programming. • 5+ years of related experience • Knowledge in client/server application development, architecture, database-connectivity and database design methodology • 2 + years of SQL DBA/Developer experience in a Data Warehouse environment • Experience with data integrity, data retention, data analysis and data input/output processing and improving SQL code performance efficiency • Strong SQL, data-warehouse and stored procedure skills • Preference will be given to those applicants who have a working knowledge of C#, Visual Basic, ASP, JavaScript / VBScript, and T-SQL • Knowledge of Telerik Tools, Web Server Administration, Database Administration, SSIS and SSRS will be considered an asset • Experience using PowerBi will be considered an asset • Exposure to Agile development methodologies and MS DevOps will be considered an asset. • Knowledge of warehouse management and automation technology will be considered an asset • Project Management experience Responsibilities our responsibilities • Provide technical and end-user help desk support for web-based and digital systems. • Performs systems analysis of business problems with varying scope and complexity that includes requirements definition, interfacing with users and providing cost/benefit analysis • Work with users to support and develop applications to meet the business needs • Maintain SQL Server databases. Utilizes SQL diagnostics involving fine tuning SQL queries and enhancing performance using SQL profiler and scripts. Create views, stored procedures, and UDFs as part of database development. • Lead continuous improvement initiatives to enhance system efficiencies within enterprise solutions, collaborating with divisions on localized systems. • Document application software solutions, metadata, and processes to support application migration, on-going development, and end-user issues. • Recommend modifications of IT systems to improve and simplify business systems • Communicate project status to key personnel including supervisor, project stakeholders, sponsors and project team members on a periodic basis. • Participates in new or alternative technology evaluation related to development tools, databases and methodologies. • Operational support & reliability: Troubleshoot production systems, perform structured root-cause analysis, implement corrective actions, and provide after-hours / on-call support as needed. Qualifications Education, Experience and Skills • University degree in computer science, software engineering, or related field, with an emphasis on programming. • 5+ years of related experience • Knowledge in client/server application development, architecture, database-connectivity and database design methodology • 2 + years of SQL DBA/Developer experience in a Data Warehouse environment • Experience with data integrity, data retention, data analysis and data input/output processing and improving SQL code performance efficiency • Strong SQL, data-warehouse and stored procedure skills • Preference will be given to those applicants who have a working knowledge of C#, Visual Basic, ASP, JavaScript / VBScript, and T-SQL • Knowledge of Telerik Tools, Web Server Administration, Database Administration, SSIS and SSRS will be considered an asset • Experience using PowerBi will be considered an asset • Exposure to Agile development methodologies and MS DevOps will be considered an asset. • Knowledge of warehouse management and automation technology will be considered an asset • Project Management experience Summary Education, Experience and Skills • University degree in computer science, software engineering, or related field, with an emphasis on programming. • 5+ years of related experience • Knowledge in client/server application development, architecture, database-connectivity and database design methodology • 2 + years of SQL DBA/Developer experience in a Data Warehouse environment • Experience with data integrity, data retention, data analysis and data input/output processing and improving SQL code performance efficiency • Strong SQL, data-warehouse and stored procedure skills • Preference will be given to those applicants who have a working knowledge of C#, Visual Basic, ASP, JavaScript / VBScript, and T-SQL • Knowledge of Telerik Tools, Web Server Administration, Database Administration, SSIS and SSRS will be considered an asset • Experience using PowerBi will be considered an asset • Exposure to Agile development methodologies and MS DevOps will be considered an asset. • Knowledge of warehouse management and automation technology will be considered an asset • Project Management experience

Similar Jobs

  • Tata Technologies
    Senior Database Developer
    $95K — $115K *
    Tata Technologies
    Auburn Hills, MI 48326 (Oakland County)
  • Database Developer
    $88K — $105K *
    Prestige Engineering L.L.C
    Auburn Hills, MI 48326 (Oakland County)
  • Software Engineer
    $92K — $160K *
    Community Financial System, Inc.
    Buffalo, NY 14221 (Erie County)
  • Software Engineer
    $92K — $160K *
    Community Financial System, Inc.
    Syracuse, NY 13210 (Onondaga County)
  • Software Engineer
    $92K — $160K *
    Community Financial System, Inc.
    Rochester, NY 14609 (Monroe County)
  • Programmer Analyst
    $80K — $105K *
    Defence Construction Canada
    Ottawa, ON K1G 3J6

More Jobs at Randstad

More Information Technology Jobs

Find similar IT Analyst - In office jobs: