SQL Developer

Assist in gathering reporting requirements and building data warehouse.

Convert existing reports that are on Reports (Older platform) to the SSRS reports.

Design layout of SSRS reports and determine the best way to present data to end users.

Develop SSRS reports and dashboards using Microsoft Reporting Services platform (SSRS), Microsoft SQL, MS Excel, Pivot tables and other intuitive graphical add-ons.

Ensure accuracy and integrity of the data and applications through analysis, coding, writing clear documentation and problem resolution.

Analyze data content and ensure validity of the data structures in support of the ETL and BI needs.

Prepare required documentation For System Support and End User.

Understand concepts associated with Financing, Inventory, and Analytics to support the Core Business through reports.

Provide technical support for SSRS business applications.

Collaborate with Senior Data Analyst, Principal Data Warehouse Architect and project teams on matters concerning Technology.

Define, document, analyze, and recommend processes, procedures and solutions to moderately complex reporting system problems.

Provide support as needed/requested utilizing various technologies.

Define, develop, document and maintain SSIS/SSRS packages, packages configuration and logging

Define, develop, document and maintain procedural and SQL programs

Assist in the development, execution and documentation of system and integration test plans.

Optimize SSIS/SSRS code performance and Perform ETL, reporting, SQL tuning.

Provide input into standards and best practices for code development.

The role requires the candidate to understand complex large-scale data models and the underlying business processes and produce reports in various formats.

Develop and design reports with SSRS and ETL processes using SSIS.

Basic understanding of Retail, finance and accounting systems.

Good interpersonal skills with the ability to respect others at all times and communicate appropriately with persons possessing a different level of technology aptitude and experience.

Ability to facilitate and effectively participate in change

Strong T/SQL experience including writing of Stored Procedures.

Knowledge of standards and best practices used in conjunction with developing reports and dashboards using SSRS.

Required Bachelor’s Degree in Computer Science or related field.