Business Intelligence & Data Analyst

Description

Business Intelligence & Data Analyst

Posting Date:December 11, 2024

Job Posting Number:            2024-054

Pay Grade:                             6

Department:ICT, AMI Technical Services

Location:Keystone Heights

Classification:                        Non-Exempt

Notes:This is a current position

Clay Electric Cooperative, Inc. does not sponsor employment visas.

If you require reasonable accommodation for any part of the application or hiring process due to a disability, please submit your request by emailing [email protected] or by calling 352-473-8000, EXT 8264 or 8270.  Please be advised that this assistance is available for individuals who require accommodation due to disability.

Classification Summary:

Individuals in this position will be responsible for development, database administration, data retrieval and analysis within the organization.  A significant portion of time is spent building internal customer relationships, developing queries, reports, and scripts that meet the business needs of the Cooperative, as well as, assisting in the administration of Clay Electric’s broad datasets.

Work requires broad information technology skills and specialization in at least two of the following areas:  business intelligence, database management, development of applications and interfaces.

Work is performed under the general direction of the assigned ICT Supervisor or Manager who reviews work performed based on the Essential Job Functions.

Essential Job Functions

(Note:  These job functions are intended only as illustrations of the various types of work performed in positions allocated to this class.  The omission of specific statements of duties does not exclude them from the position if the work is similar, related, or a logical assignment to the position. All employees are expected to demonstrate cooperation in working with others, deal effectively with members and practice safety consciousness.)

1. Query Development, Design, and Tuning. Develops database queries in multiple languages used at the Cooperative that includes analyzing queries to ensure optimum performance. 
2. Business Intelligence (BI) Reporting. Works with internal customers to define their reporting requirements, determines the best reporting method to meet those requirements, develops the reporting solution and provides support of that solution over time. 
3. Interface Development. Develops integrations between various data sources and applications used by the Cooperative. 
4. Database Administration. Ensures the Cooperative’s databases are properly secured, managed and maintained for on premises and cloud solutions. 
5. Solution Development. Implements custom solutions, applications and automations as needed for the success of the Cooperative. 
6. Solution Support. Provides support of the Cooperative’s BI, database and application solutions as needed.  
7. Communications. Serves as a liaison between users, administrators, technical experts and vendors as necessary.  Able to distinguish between and communicate with a user, application, database, or system level event or action. 
8. Technical Documentation. Writes documentation and technical procedures for applications such as, but not limited to, interfaces, reports, forms, and workflows. 
9. Safety. Practices safe work habits in the performance of all job duties and is familiar with and follows those portions of the Cooperative Safety Manual that pertain to the position. 
10. Other Essential Duties.  Each employee is responsible to perform other duties as required to benefit the Cooperative and its members, includes responding to and/or assisting in emergency situations.

Minimum Training and Experience:

This position requires a Bachelor’s degree from a regionally accredited college or university with a major in Science, Technology, Engineering, Mathematics, Business or a related field, plus one (1) year of business intelligence, database administration or applications development experience.

Substitution:

Related experience may substitute for the required education on a year-for-year basis.

This position requires certification as a Microsoft Associate or a related certification to be obtained within twelve (12) months from date of employment.

Individuals in this position must maintain a valid State of Florida driver's license.

Knowledge, Skills and Abilities:

Skilled in the use of Microsoft Productivity Applications (Word, Excel, Access, Visio, etc.)

Skilled in common query languages, such as T-SQL, PL-SQL, PostgreSQL, etc.

Skilled in generating reports using standard Business Intelligence (BI) reporting tools, such as Crystal Reports, SSRS, Power BI etc.

Ability to generate ETL (Extract, Transform, Load) packages and processes using standard ETL tools, resources, and best practices such as SSIS, Azure Data Factory, Azure Synapse Pipelines.

Ability to develop scripting and automation tasks, using tools such as Power Platform, PowerShell, Windows Batch Files, Python, Bash etc.

Ability to develop applications using Low/No-Code platforms or traditional programming languages such as Microsoft Power Apps, C# .NET, and Python.

Working knowledge of database monitoring and management tools such as SentryOne, Activity Monitor, SQL Trace, SQL Server Logs, etc.

Working knowledge of applications interfaces such as SOAP Web Services, Rest API, JSON, XML, CSV, etc.

Working knowledge of the administration of database technologies such as Oracle, Microsoft SQL Server, and PostgreSQL.

Working knowledge of database structure and design, such as relation, non-relational, OLAP, etc.

Working knowledge of data protection and privacy best practices.

Ability to communicate technical information to users.

Ability to work independently as well as within a team.

Ability to work with internal and external partners to communicate project status, activities and achievements.

Ability to prioritize multiple requests or projects that may have competing priorities and complex dependencies.

This position requires working outside of normal business hours to meet deadlines and respond after hours on a rotation basis to respond to critical issues.

Clay Electric Cooperative, Inc. is an Equal Opportunity employer.  All applicants for employment shall be considered on the basis of merit, without regard to race, color, sex, age, religion, national origin, physical or mental handicap or disability, where otherwise qualified, or marital or veteran status.  Clay Electric Cooperative, Inc. treats all employees equally without discrimination in rates of pay and other opportunities for advancement.

Clay Electric Cooperative, Inc. has a drug-free workplace policy.

Clay Electric Cooperative, Inc. participates in E-Verify.  E-Verify electronically compares information entered on the Employment Eligibility Verification, Form I-9, with records contained in Social Security Administration and Department of Homeland Security (DHS) databases.  This helps employers verify the identity and employment eligibility of newly hired employees.

JOB ANALYSIS FORM

for

BI AND DATA ANALYST

This form is used to determine the essential function and physical requirements of each

job class for recruitment purposes to comply with the American With Disabilities Act.

Tools, Equipment, Vehicles, or Machinery Used:

Telephone, personal computer, printers, copiers, projectors, television, carts, vehicles

Work Conditions:

Communication Requirements:

Physical Requirements of the Job:

Note: - In terms of an 8-hour workday, "Occasionally" equals 1% to 33% of the time, "Frequently" means 34% to 66% of the time, and "Continuously" means 67% to 100% of the time.

Definitions:

1. Simple Grasping- Apply pressure to an object with the fingers and palm.
2. Pushing-Using upper extremities to press against something with steady force in order to thrust forward, downward or outward.
3. Pulling-Using upper extremities to exert force in order to draw, drag, haul or tug objects in a sustained motion.
4. Fingering-Picking, pinching, typing or otherwise working primarily with fingers rather than with the whole hand or arm as in handling.

The physical demands and work environment described here are representative of those an employee encounters or must be met by an employee to successfully perform the essential functions of this job.  Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.  Some requirements may exclude individuals that cannot be reasonably accommodated or who pose a direct threat or significant risk to the health and safety of themselves or other employees.