Job Posting
The primary role of this position is to evaluate and review database information to ensure high levels of data quality, analyze and produce required queries/reports in response to business user needs, and interface with business users to research and correct data inaccuracies.
Education Requirements:
A Bachelor’s degree in Computer Science, Information Technology or the equivalent knowledge is preferred.
Experience:
A minimum of two years of progressively responsible experience in the area of Information Technology is required. Candidates not possessing a degree must have a minimum of four years of relevant information technology experience. Requires a working knowledge of Microsoft SQL programming language, relational database design and structure, Business Intelligence practices, and System Development Life Cycle.
Summary of Duties and Responsibilities:
The incumbent will assist with the monitoring of the quality of data stored in TRS databases, work with users to rectify inaccuracies of production data, provide appropriate reports to users and management and provide assistance with all Freedom of Information Act (FOIA) requests. In addition, the incumbent is required to support the application development programming staff by providing technical assistance in effective and efficient data utilization techniques and will be responsible for researching and interpreting technical documentation, suggesting recommendations that support organizational needs.
Knowledge/Skills/Abilities:
The incumbent must possess good organizational skills, the ability to work effectively with others and communicate complex information at a high level. A thorough knowledge of Windows servers/operating systems, client/server computing, MS SQL Server 2014/2016, database concepts, structures and SQL language is required.
Selection Criteria
ANALYTICAL SKILLS
Analyzes information and reviews problems thoroughly; determines the nature and relationship of situations.
COMMUNICATION SKILLS
Demonstrates effective oral and written communication skills. This includes the ability to organize ideas and speak effectively in public situations, to small groups or one-on-one as well as the ability to demonstrate good listening skills including the ability to receive, attend to, interpret and respond to verbal messages and non-verbal cues when conversing with others. In addition, the position requires the ability to compose and edit specified documents in a clear, concise and well-structured manner.
JOB KNOWLEDGE AND EXPERIENCE
Ability to interpret programming logic from documented requirements. Has completed specified amount of time previously performing essential duties of the job and/or has completed specified degrees, coursework or training programs to perform the job. Possesses a body of information or level of understanding necessary to complete assigned responsibilities.
ORGANIZATIONAL SKILLS
Organizes work tasks in an efficient manner; able to complete assignments on time and accurately by prioritizing tasks and monitoring their completion.
PROBLEM SOLVING
The ability to define a problem; define several solutions (if necessary); and implement the solution which resolves the problem in the most effective and timely manner.
TECHNICAL SKILLS
The ability to identify technical limitations on existing systems and define essential technical enhancements and acquisitions to assure the efficiency of TRS systems in the future.
Job Posting
Purpose:
Under the supervision of the Database Manager, the Data Analyst is responsible for evaluating and reviewing database information to ensure high levels of data quality, analyzing and producing required queries/reports in response to business user needs, and interfacing with business users to research and correct data inaccuracies. This position is accountable for maintaining an effective working relationship, and open communication with the Database Manager, other members of the database team, and the TRS user community as a whole.
Nature and Scope:
The major function of this position is to assist with the monitoring of the quality of the data stored in TRS databases, work with users to rectify inaccuracies of production data, provide appropriate reports to users and management, and provide assistance with all Freedom of Information Act (FOIA) requests. The incumbent is required to support the application development programming staff by providing technical assistance in effective and efficient data utilization techniques. This position will also be charged with researching and interpreting technical documentation, suggesting recommendations that support organizational needs and communicating complex information at a high level.
The incumbent must possess good organizational skills, the ability to work and communicate effectively with others, and have a thorough knowledge of windows servers/operating systems, client/server computing, MS SQL Server 2014/2016, database concepts, structures and SQL language is required. The incumbent must have working knowledge of Agile principles and Scrum method.
The greatest challenge of this position is to evaluate, review and report on data ensuring high levels of data quality. Another challenge of this position is to organize and prioritize job responsibilities while coping with multiple demands, which may be the result of mandatory deadlines.
Principal Accountabilities:
- Ensure the stability and reliability of data quality via ongoing data review and analysis.
- Interpreting data, analyzing results using statistical techniques and providing ongoing reports.
- Provide guidance and training to the programming staff for effective and efficient use of database tools and resources.
- Study advanced techniques and reference materials, which are pertinent to the job; attend classes/seminars covering such topics as data cleansing and data archival.
- Monitor database system details within the database, including stored procedures and execution times, and suggest efficiency improvements.
- Analyze SQL coding techniques, developer feedback, and performance issues, and suggest recommendations to the Application Development Manager.
- Assist the Database Manager, Database Administrator and Senior Database Administrator in developing long-term goals for production databases in conjunction with user and IT management staff to ensure effective protection and integrity of data assets.
- Conduct research and make recommendations on database products and services in support of procurement and development efforts.
- Assist with the resolution of technical programming and system software issues with outside vendors.
- Perform test deployment tasks.
- Assist with database monitoring and maintenance procedures in the absence of the Database Administrator.
- Assist with the maintenance of a data dictionary.
- Assist with the maintenance of a data archival system.
- Assist with Database design for ongoing development efforts.
- Experience with SQL Server Reporting Services is desired for this position.
- Candidates with experience in Power BI will be preferred for this opportunity.
- Perform other duties as required or assigned.