Senior Programmer Analyst

Company

SafeAuto Insurance Company, Columbus, OH

Education

Bachelors Degree from 4 year institution, with emphasis in Information Technology, is preferred. Graduation from technical or junior college or partial university attendance, when combined with relevant course of instruction and/or relevant work experience in Information Technology is acceptable.

Experience
  • Senior Level SQL Development experience with career ambitions of becoming a data architect is required
  • Heavy work experience with the following is required:
    • Performing Data Analytics
    • Writing T-SQL scripts, SQL queries and ad-hoc reports
    • Developing and Deploying T-SQL stored procedures and functions
    • Writing C# programs
    • SSRS, SSIS, SSAS, SQL Server and Crystal Reports
  • Demonstrated accomplishment in advanced production level development work, including development and implementation of complex enterprise applications and components thereof, utilizing object oriented principles and component based architectures in a multiple tier environment, impacting multiple dependent systems.
  • Demonstrated proficiency at assessing, understanding and documenting the interactions between systems, impacts of various designs, and performance tradeoffs.
  • Fundamental knowledge of software design patterns and their application in various settings
  • Demonstrated knowledge of Safe Auto systems and environment from a technical perspective.
Description

Summary:

  • Leads development efforts and guides work of Programmer Analysts and Programmers. Provides support for design efforts of Systems Analysts and Application Architects
  • Assists in defining and documenting current state and goal state from an architectural/design perspective.

Responsibilities:

  • Serves as Development Lead for major Safe Auto development initiatives and primarily responsible for development of complex components and services.
  • Delegates to and mentors work of Programmers and Programmer Analysts on designated development projects.
  • Under the direction of Systems Analysts and/or Application Architects, documents current and goal state of all existing and proposed software applications, and changes to such applications, including the interactions and dependencies between applications, the infrastructure requirements for such systems, and the interfaces exposed by these applications.
  • Provides training and instruction to Programmer Analysts and Programmers in Safe Auto development practices and procedures, nature and scope of applications utilized, dependencies, interfaces and related topics.
  • Works with Systems Analysts and others in the design and preparation of Systems Requirements Documents, and related supporting documentation, and directs the work of Programmer Analysts and Programmers on such documents.
  • Under the guidance of Systems Analysts and/or Application Architects, analyzes system impacts of proposed development projects, provides proposed designs and documents all resulting changes/additions
  • Provides periodic backup development support for assigned projects;
  • Analyzes reported defects for design\architectural factors that may impact such defects, and recommend corrective structures and methodologies, subject to review by Systems Analysts and/or Application Architects
  • Assists in deriving designs for new development or changes of Graphical User Interface (GUI) elements and reporting artifacts.
  • Provides technical assistance by responding to inquiries regarding errors, problems, or questions with Safe Auto software applications. Provides third tier support.
  • Works with Systems Analysts and Application Architects in developing, revising and implementing coding standards, architectural frameworks and other processes governing application development activities.

Qualifications:

  • Senior Level SQL Development experience with career ambitions of becoming a data architect is required
  • Bachelors Degree from 4 year institution, with emphasis in Information Technology, is preferred. Graduation from technical or junior college or partial university attendance, when combined with relevant course of instruction and/or relevant work experience in Information Technology is acceptable.
  • Heavy work experience with the following is required:
    • Data Analytics
    • Writing T-SQL scripts, SQL queries and ad-hoc reports
    • Developing and Deploying T-SQL stored procedures and functions
    • Writing C# programs
    • SSRS, SSIS, SSAS, SQL Server and Crystal Reports
  • Demonstrated accomplishment in advanced production level development work, including development and implementation of complex enterprise applications and components thereof, utilizing object oriented principles and component based architectures in a multiple tier environment, impacting multiple dependent systems.
  • Demonstrated proficiency at assessing, understanding and documenting the interactions between systems, impacts of various designs, and performance tradeoffs.
  • Fundamental knowledge of software design patterns and their application in various settings
  • Demonstrated knowledge of Safe Auto systems and environment from a technical perspective.

Resumes may be submitted to  HR@safeauto.com  

Job URL
Zip Code 43219