The company is looking to fill a position for a SQL Reports Developer to assist with report development.
Requirements
- Outstanding SQL programming skills, with ability to write advanced queries, read data models, and understand dimensional table relationships
- Strong Microsoft Excel skills. Experience with VBA’s and Macros, Pivot tables and Pivot Reporting highly desirable.
- Excellent with SQL Server 2008R2/2012/2014, including writing T-SQL, with ability to write stored procedures, CTE’s, user defined functions & SQL queries
- Ability to develop dynamically parameterized, drill down, matrix, and chart SSRS reports
- Excellent analytical and troubleshooting skills and ability to trace report performance issues to root cause.
- Strong experience using SSRS report manager and report viewer
- Strong discipline in full life cycle development
Responsibilities
- Develop dynamically parameterized, drill down, matrix, and chart SSRS reports
- Write advanced SQL queries, read data models, and understand dimensional table relationships
- Write T-SQL, including stored procedures, CTEs, user-defined functions & SQL queries
- Work on ETL tools – SSIS preferred
- Development using Microsoft .NET framework preferred
- Trace report performance issues to root cause
- Utilize SSRS report manager and report viewer
Other
- 3+ years’ experience working in report development
- 2+ years’ experience working on ETL tools – SSIS preferred.
- At least 2-year experience of development using Microsoft .NET framework preferred
- Strong verbal and written communication skills
- Good understanding of Project Management Methodology.
