Description
The SQL Developer will be responsible for developing applications and integrations using the Microsoft SQL Server platform. This will include vendor exports, data warehousing tasks and other data related tasks.Responsibilities:
- Maintain and enhance the existing data warehouse, ETL Imports and exports
- Develop vendor and client exports that meet provided specifications
- Perform quality checks on reports and exports to ensure exceptional quality
- Monitor job and transfer queues to ensure they are functioning as expected
- Work closely with the ETL Lead and Business Analysts to understand business requirements, providing knowledge and solutions on Data Warehousing, ensuring delivery of business needs in a timely manner.
- Lead and guide the ETL developers in data movement as well as staging and archiving strategies, source-target mappings, ETL development, SQL tunings and optimization, testing and implementation
- Provide reviews of deliverables and identify gaps/areas for improvement
- Provide detailed technical specifications and ETL documentations required in each phase of the SDLC
- Identify opportunities to optimize the ETL environment, implement monitoring, quality and validation processes to ensure data accuracy and integrity
- Provide business users the data required for metrics and analysis
- Develop new SSIS/SSRS packages to meet business needs
- Migrate existing Access reports to SSIS/SSRS
- Create and maintain documentation for all projects
- Provide background to assist in the development of data models
- Designs, develops, and implements cubes, scorecards, and dashboards
SKILLS:
- (5) Years of SQL Development and Reports Development Experience
- (5) Years of SSRS and SSIS Experience
- (3) Plus Years of SSAS Experience
- (3) Plus Years Data Warehouse life cycle experience including data analysis, data modelling & design using dimensional modelling approach
- (3) Plus Years of SQL Server 2008 Experience.
- (7) Years of Data Analysis and Reports Development experience
- Excellent Communication and Interpersonal Skills
- Excellent technical and project management skills
- .NET development experience
- T-SQL (Transact SQL) Stored Procedures and Triggers
- Ideal candidate will have a strong understanding of SSAS and dimensional modelling, work well with a .NET development team that leverages this data and create solutions that present data through SharePoint Dashboards and KPI's, Excel Services and PowerPivot. Microsoft SQL Server 2008 Server Side development including (SSIS, SSRS, SSMS, SSAS).
- The ideal candidate should possess some database administrative experience
- The ideal SQL Server Side developer should possess payroll or accounting experience
- The ideal candidate should possess some experience working with Access applications and strong Excel skills