Required Skills:
- Develop complex data extracts, applications, and ad-hoc queries as requested by using SQL or SSIS.
- Research, troubleshoot, and resolve data issues impacting extract delivery.
- Work within the project team to complete system analysis and application design.
- Work closely with Business Analysts to refine requirements and ensure data quality.
- Collaborate on the definition, development, and maintenance of standards and processes.
- Must be proficient with T-SQL, and development of stored procedures.
- Report writing and dashboard development experience, preferably with SSRS and Power BI.
- Drive continuous improvement and automation in BI solutions and processes.
- Work effectively with System Administrators, Project Manager(s), Developers and Management.
- Participate in a team development environment using the TFS source control system.
DESIRABLE SKILLS:
- Degree in Computer Science, business, or related discipline.
- 4 years of experience with T-SQL, including stored procedure development
- Knowledge of data integration, e.g., extract, transform, and load (ETL) process development/support.
- Able to develop and troubleshoot reports delivered with SSRS; requires good analytical skills.
- Experience with data access performance tuning, and database performance optimization.
- Application Development Lifecycle knowledge and experience.
- Data transport protocols, e.g., SFTP, XML, and JDXDML.
- Experience with Case Management data and/or Call Center data.
- Documentation of system support information.
- Basic understanding of networking principles.
- Ability to analyze system resource usage and constraints.
- Strong communication skills; ability to interact at all levels including management.
- Works independently and follows through on assignments.