Executive Service

BUSINESS INTELLIGENCE ANALYST

Information Technology Services Division

Nashville, TN

Closing Date: 02/22/2024

This position requires a criminal background check. Therefore, you will be required to provide information about your criminal history in order to be considered for this position.

The Administrative Office of the Courts is seeking a Business Intelligence (BI) Analyst. This role is to strategically design and implement BI software and systems, including integration with databases and data warehouses. This includes selecting, blueprinting, gathering requirements, designing, and participating in rolling out BI solutions to end users. The Business Intelligence Analyst is also responsible for ensuring high levels of BI availability through support functions and in-depth testing.

Essential Duties and Responsibilities:

• Assess and cultivate long-term strategic goals for BI development in conjunction with end users, managers, clients, and other stakeholders.
• Conduct research and make recommendations on BI products, services, and standards in support of procurement and development efforts.
• Evaluate and select database/data warehouse components, including hardware, relational database management systems, ETL software, metadata management tools, and database design solutions.
• Direct, organize, and lead projects in the implementation and use of new BI software tools and systems.
• Lead the integration efforts for merging BI platforms with enterprise systems and applications.
• Work with developers to design, code, test, and document all new or modified BI systems, applications, and programs.
• Develop the semantic layer, metadata, reports, and report definitions.
• Develop graphs and portal interfaces.
• Assist in the design of databases and data warehouses to ensure interoperability with BI solutions.
• Analyze user requirements and, based on findings, design functional specifications for BI front-end applications.
• Produce ETL design guidelines to ensure a manageable ETL infrastructure for the BI system.
• Work with ITSD resources to ensure that data entry, retrieval, change, and delete functions meet business requirements for project completion.
• Conduct job duties and responsibilities according to the organization's business systems development methodology and/or its Systems Development Life Cycle (SDLC) methodology.
• Design and deliver end-user training and training materials; provide technical support as necessary.
• Troubleshoot BI tools, systems, and software; performance-tune these applications as necessary.

Qualifications:

Education:

Graduation from an accredited college or university with a bachelor's degree including, at least, six quarter hours in statistics, mathematics, and/or computer science and experience equivalent to two years of full-time professional work experience.

Experience:

• Minimum of 2 years direct work experience.
• Comprehensive data warehouse analysis and design experience, with full knowledge of data warehouse methodologies and data modeling.
• Experience with tier-one applications, databases, and data warehouses, such as Oracle 9i, MS SQL Server, Crystal, SAP, SCM, and so on.
• Expertise with data visualization products, e.g. Power BI, Tableau.
• Demonstrated ability with MS Windows, UNIX, AIX, operating systems.
• Demonstrated ability with industry best practice ETL tools.
• Strong ability to analyze user requirements and build front-end BI applications according to specifications.
• Strong understanding of relational database structures, theories, principles, and practices.
• Full project management and development life cycle experience.
• Experience with database design applications
• Experience with data processing flowcharting techniques.
• Strong understanding of the organization's goals and objectives.
• Good knowledge of applicable data privacy practices and laws.

Pursuant to the State of Tennessee's Workplace Discrimination and Harassment policy, the State is firmly committed to the principle of fair and equal employment opportunities for its citizens and strives to protect the rights and opportunities of all people to seek, obtain, and hold employment without being subjected to illegal discrimination and harassment in the workplace. It is the State's policy to provide an environment free of discrimination and harassment of an individual because of that person's race, color, national origin, age (40 and over), sex, pregnancy, religion, creed, disability, veteran's status or any other category protected by state and/or federal civil rights laws.