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.)
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.
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:
Work is Performed: | Indoors | Outdoors | Both |
| X |
|
|
Exposure To: | Cold | Heat | Wet/Humid | Noise/Vibration | Hazards | Dust | Fumes |
|
|
|
|
|
|
|
|
Communication Requirements:
Hearing: | Yes | No |
Ability to receive detailed information through oral communication. | X |
|
Ability to make fine discriminations in sound, such as when making fine adjustments on machine parts. |
| X |
Talking: | Yes | No |
Ability to express or exchange ideas by means of the spoken word. | X |
|
Ability to convey detailed or important spoken instructions to other workers. | X |
|
Ability to speak loudly, such as when speaking over loud machinery. |
| X |
No speaking is required. |
| X |
Visual Requirements: | Yes | No |
Field of vision requires the normal ability, such as working with figures, on computer terminals or reading. | X |
|
Field of vision requires the ability to see small or detailed items, such as working on machines. | X |
|
Field of vision requires the ability to operate equipment, such as trucks, forklifts, cranes. |
| X |
Repetitive Motions: | Yes | No |
Substantial movements (motions) of the wrists, hands and/or fingers, such as keyboarding or handwriting. | X |
|
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.
Employee Must Lift & Carry: | Never | Occasionally | Frequently | Continuously |
Up to 5 lbs |
|
| X |
|
6 to 10 lbs |
| X |
|
|
11 to 20 lbs |
| X |
|
|
21 to 25 lbs |
| X |
|
|
26 to 50 lbs |
| X |
|
|
51 to 100 lbs | X |
|
|
|
Employee is Required To: | Never | Occasionally | Frequently | Continuously |
Bend |
| X |
|
|
Squat |
| X |
|
|
Crawl | X |
|
|
|
Climb | X |
|
|
|
Reach Above Shoulder Level |
| X |
|
|
Reach Below Shoulder Level |
| X |
|
|
Employee Must Use Hands for Repetitive Action: | Simple Grasping | Pushing | Pulling | Fingering |
Yes: |
|
|
|
|
No: | X | X | X | X |
Definitions:
Employee Must Use Feet for Repetitive Action: | Right | Left |
Yes: |
|
|
No: | X | X |
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.