Database Report Specialist

Job Description

• Senior Reports/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.

• 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 favorable: .NET, VB Script/JavaScript, BPEL, PHP and WebLogic.

The successful candidates will demonstrate the following knowledge, skills, characteristics, experiences and/or abilities:

• Delivers enterprise, Web-enabled reporting functionality and create reports that draw content from a variety of data sources, publish reports in various formats, and centrally manage security and subscriptions.

• Compliment/Capable of design, develop and deploy applications that support users on the case and program management especially with CATCH application.

• Provides mentorship and technical advice to a team of Application/Reports/Query developers.

• Provides strategic advice to the lead, management and customers

• Capable of implementing programming standards that support a secure and defect free application.

• Interacts daily with 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.

• 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.

• Updates system and process documentation, produces user guides, ER diagrams, and SOPs as needed - Including Visio Network design drawings.

• Provides all activities related to the administration of computerized databases.

• Designs, creates, and maintains databases in a client/server environment.

• Conducts quality control and auditing of databases in a client/server environment to ensure accurate and appropriate use of data.

• Advises users on access to various client/server databases.

• Designs, implements, and maintains complex databases with respect to Job Control Language (JCL), access methods, access time, device allocation, validation checks, organization, protection and security, documentation, and statistical methods.

• Applies knowledge and experience with database technologies, development methodologies, and front-end (e.g., Cognos)/back-end programming languages (e.g., Structured Query Language (SQL).

• Performs database programming and supports systems design.

• Includes maintenance of database dictionaries, overall monitoring of standards and procedures, file design and storage, and integration of systems through database design.

Skills:

• 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

• SQL and Transact SQL

• Candidate should have worked on any of the leading Reporting tools like SSRS and Tableau

• Candidate should strong ETL experience in Data Warehouse

• Procedural Language knowledge (Joins/Cursors/Triggers)

• Data warehousing concepts and schema description

• Business Intelligence platforms (experiences with ETL Tools like Informatica/SSIS/Data Stag)

• Other Reporting Tools Business Objects, MicroStrategy Cognos, and / or Qlikview.

Qualifications

• Bachelor’s degree in Information Technology or related field or equivalent experience

Additional Information

All your information will be kept confidential according to EEO guidelines.