Job Title:           Data & Reports Analyst   

Department:     Information Services

Status:               Regular Full-time, Exempt

Location:           Nashville, TN International Headquarters

Purpose and Scope

The Data & Reports Analyst role is to design, develop and maintain reporting capabilities for various reporting structures across TGI. This role is also designated to gather business requirements from users in order to develop architectural concepts and accurate functional requirements for each initiative.  The role is expected to manage systems to be able to reliably produce multiple defined reports of high accuracy on a defined schedule, to produce ad-hoc reports as needed, and to provide recommendations for technology and structural improvements in existing systems and processes.

Essential Job Functions

Strategy & Planning

Design, develop and manage current reporting activities and processes.
In conjunction with data owners and lines of business, develop models, procedures, and protocols for reporting in concert with TGI goals.
Design, develop, and deploy required reporting in response to business user needs.
Assist in the development of data management policies and procedures.
Research, review, and analyze effectiveness, accuracy and efficiency of existing report procedures and develop strategies for enhancing or further leveraging processes.
Develop routines and procedures for end-users to facilitate best practices use of reporting tools and applications.
Communicate reporting changes, enhancements, and modifications to management and business owners.

Operational Management

Manage, monitor, and maintain existing data warehouse and reporting infrastructure using Azure SQL databases, NetSuite ERP, and Celigo integration.
Develop a working knowledge of TGI operations and processes, and how the various enterprise operations, membership and financial systems function and interact to support TGI’s mission.
Design and develop new reporting infrastructure as needed as systems and processes change or new needs are recognized.
Perform daily monitoring of overnight processing, observing any abnormal behavior and promptly take action to apply corrections to processing routines or contact data managers for remediation.
Serve as a resource to investigate inquiries raised by reporting users regarding the accuracy and validity of reported data.
Provide expertise for and execution of key processes for establishment of fiscal year Camp and Country-level ministry goals to support monthly reporting.
Provide expertise for and execution of key processes for fiscal year-end reporting.
Manage, monitor, and maintain existing TGI mailing list processes for US Mail and Email, maintain external vendor interfaces, and maintain compliance with US Postal Service regulations.
Create prototype reporting models, specifications, diagrams, and charts to provide direction to application developers.
Understand and follow existing data management practices, and work to define best practices for data & reports architecture, data mining/analysis services across the organization.
Follow appropriate safeguards when implementing technical changes to production systems.
Coordinate and perform appropriate testing, including peer and end-user reviews, for modified and new processes.

Working Relationships

Reports To:      Sr. Manager, IT Project Services                                               

People Management Responsibility:    None   

Works Closely With:    TGI I.T. staff, other TGI staff and outside vendors

Essential Knowledge, Skills, and Training & Development

Non-physical

Follow and provide verbal and written instructions

Ability to use PC and widely used software applications, especially Microsoft Office applications

Ability to learn new software applications as necessary

Ability to provide analytical skills

Ability to communicate effectively with TGI Staff and Membership

                        Physical

Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

While performing the duties of this job, the employee is required to stand, walk, sit, talk, and hear. Specific vision abilities required by the job include close vision.

Able to be fully capable working in a remote environment and using collaboration software such as MS Teams or Zoom.

Mission Critical Competencies

SHARED VALUES

Integrity
Excellence
Open Communication
Stewardship

CORE COMPETENCIES

Actively learns, demonstrates, and fosters the organizations’ culture in all actions and words.  Takes personal initiative and is a positive example for others to emulate.
Ability to understand the fundamental business drivers and communicate the state of business and provide strategic recommendations to management.
Proven ability to keep a big picture perspective while dealing with very detailed information.
Foster Open Communications and Approachability
Positive and Constructive Attitude
Business Acumen
Process Management
Decision Quality
Problem Solving
Perspective
Ability to challenge the status quo

Work Environment and Time Requirements

Climate-controlled office environment when required to be in office

Nominal 8-hour workday

Variations in work volume sometimes require extended working hours

Occasional travel required as necessary

Minimum Qualifications

Bachelor’s degree in Information Technology and 3-5 years of Information Technology and relevant Business-related work experience
Minimum of 3 years working extensively with an RDBMS system such as MS SQL Server or Oracle for both database management and server-based application development using Transact SQL or PL/SQL procedural languages.

Advanced database developer experience with MS SQL or Oracle (particularly with complex queries, stored procedures, and index management), and with MS SQL Management Studio (or equivalent).

Working knowledge of operations management and/or financial management.

Working knowledge of financial and accounting principles and systems.
PC experience, with advanced proficiency in MS Excel, working knowledge with MS Word, PowerPoint, FTP clients, and remote desktop management
Successful completion of a drug and background screen

Proven experience with data analysis, report writing and technical requirements analysis, business process modeling/mapping, and data modeling.
Proven experience with reporting tools, software, and other related applications.
Experience with the NetSuite platform or similar ERP system is required.
Success in applying data technology and reports development efforts to achieve business objectives and revenue goals.
Ability to handle and manage multiple complex tasks concurrently

This Job Description is for general purposes and guidelines only and should not be considered all-inclusive.  Neither does the receipt of this job description constitute an employment contract.  Furthermore, it should be known that this list of job requirements is subject to change without written notice.

[January 2025 – Data & Reports Analyst]