Time Type:

Full time

This is an in-office position.

Department:

650 Management Services

Job Summary:

The role of this Developer is to use T-SQL (SQL Server) to write stored procedures, functions, and queries that allow for the development and design of reports at a corporate, market, branch, and individual levels across the enterprise using SSRS tools. This includes development/design of new reports as well as maintaining existing reports due to continuing requirement and data changes from the business owners. In this role, the Developer will ensure that all change initiatives are effectively delivered into the relevant business and IT areas by means of a carefully developed and coordinated change management plans.

Job Description:

ESSENTIAL JOB FUNCTIONS

The statements on this job description are intended to describe the general nature of level of work being performed by incumbents.  They are not an exhaustive list of all responsibilities, duties, and skills required by all incumbents.

• Develop new SSRS reports and/or modify existing reports based on business needs

• Develop new SSIS packages or modify existing packages as business requirements change

• Plan, provision, and execute updates and upgrades to the SQL environments in coordination with other groups as necessary

• Design, develop, test, and implement programs and scripts to satisfy validated customer requests and/or improve system reliability and/or efficiency

• Respond to field/department notifications of errors in a time sensitive manner

• Identify bottlenecks and bugs, and devise solutions to mitigate and address these issues

• Help maintain code quality, organization, and automated processes

• Displays acceptable Leadership core competencies, and is committed to continued development of strengths and gaps, in the following categories:

  • Individual Work Characteristics

  • Decision-Making

  • Planning and Organizing

  • Leadership Styles

  • Interpersonal skills

  • Communication skills

• Meet professional obligations through efficient work habits such as, meeting deadlines, honoring schedules, coordinating resources and meetings in an effective and timely manner, and demonstrate respect for others

• Other duties as assigned

SKILLS

• Strong knowledge of SQL queries, SSIS and SSRS

• Strong understanding of object-oriented programming

• Skill for writing reusable libraries

• Familiar with various design and architectural patterns

• Understanding of fundamental design principles for building a scalable application

• Experience creating database schemas that represent and support business processes

• Experience implementing automated testing platforms and unit tests

• Strong interpersonal and customer service skills

• Excellent communicator – both verbal and written

• Strong conceptual, analytical, and judgement abilities

• Experience with HR and/or Financials is a plus

EDUCATION & KNOWLEDGE

• Bachelor’s degree in Information Technology, Computer Science, or a related field, or 4 years of equivalent experience

• 5 years of experience in information technology, including strong knowledge in T-SQL queries, SSRS, and SSIS