SQL BI Consultant

19 May 2024

Vacancy expired!

11-15 years of experience. Subject Matter Expert in Backend Development. SQL Server Developer with proven professional experience in the design, development, delivery and enhancement of SQL queries, reports, procedures & functions. Senior Backend SQL Server Developer with proven professional experience in the design, development, delivery and enhancement of SQL queries, reports, procedures, functions and other necessary backend development and administration including database backups and recoveries The Application Support Division I is looking for a Senior Backend SQL Server Developer whose primary responsibilities include design, development, delivery and enhancement of SQL queries, reports, procedures, functions and other necessary backend development and administration including backup, restoring and monitoring. Candidate will be responsible for the implementation and management of business aligned IT services. Ensuring the application platform is of high quality, defects free and adheres to industry standards for development, testing and deployment methodologies. Must have experience with SQL Server Management Studio, Code Editor for authoring Transact-SQL, MDX, DMX, XML/A, Reporting Services, Analysis Services etc. Hands on experience with any of the following is favourable: .NET, VB Script/JavaScript, BPEL, PHP and WebLogic.

The successful candidates will demonstrate the following knowledge, skills, characteristics, experiences and/or abilities:
  • Capable of design, develop and deploy applications that support users on the client assessments & case and program management applications especially with TCA, SNAP E&T Assessment etc. applications.
  • Provides mentorship and technical advice to a team of Application/Reports/Query developers.
  • Provides strategic advice to the lead, management and customers of the OIS.
  • Capable of implementing programming standards that support a secure and defect free application.
  • Interacts daily with government clients in order to meet the technical requirements for new initiatives.
  • Works with Quality Assurance / Quality Control teams to insure the application remains secure and defect free.
  • Evaluates, designs, and implements accepted programming standards as they relate to the TCA and SNAP E&T application and infrastructure.
  • Defines and documents processes to be used by all application developers on the team.
  • Plans, researches, and recommends new equipment, software tools, and related technologies.
  • Uses monitoring and performance analysis tools to troubleshoot and isolate application performance issues.
  • Management of Database environments, backups, restores and other administration tasks
  • Updates system and process documentation, produces user guides, ER diagrams, and SOPs as needed - Including Visio Network design drawings.

Skill
  • Proven experience in IT field with focus on the technical reporting, system setup, data analysis and analytics.
  • Proven experience in the setting up and configuration of MS SQL Server infrastructure.
  • Proven experience in creating and deploying reporting/dashboard solutions using Reporting Services of MS SQL Server together with good problem solving
  • Candidate should have worked on any of the leading Reporting tools like SSRS, Business Objects, MicroStrategy Cognos, Tableau, and / or Qlikview.
  • Candidate should strong ETL experience in Data Warehouse / Business Intelligence platforms (experiences with ETL Tools like SSIS/Informatica/ Data Sta
  • Knowledge and experience with front-end (e.g., Cognos)/back-end programming languages (e.g., Structured Query Language (SQL)Knowledge )
  • Proven experience in design, implement and managing complex databases including administration tasks.
  • 11-15 yrs. conveying technical and functional concepts for a specific technical specialty
  • 11-15 yrs. preparing complex technical documentation
  • Bachelor’s degree in IT or related field or equivalent experience