Job Title: Business Intelligence Developer (SQL Code and Report Writer)
Department: Data and Information Services
Reports To: System Supervisor
FLSA Status: Non-exempt

SUMMARY:
The person in this position is responsible for queries, stored procedures and technical
documentation. The Business Intelligence Developer will also work with other developers optimizing in-application query statements as necessary and establishing best practices. Responsibilities will also include developing data validation edits for daily data integrity, development of BI Reporting.

ESSENTIAL DUTIES AND RESPONSIBILITIES include the following:
Collaborates with other team members and stakeholders.

Develops SSRS reports using Visual Studio.

Communicates effectively with customers to ensure accuracy of reports.

Works independently to meet deadlines.

Documents stored procedures according to standard.

Uses ticketing system to track project requests and documents progress within the ticket.

Translates business needs to technical specifications. Creates visualizations and reports for
requested projects.

Develops and updates technical documentations and specifications.

Implements stored procedures and effectively query a database and conduct analyses.

Develops data validation edits using data editing tools available.

Performs other duties as assigned.

SUPERVISORY RESPONSIBILITIES:
This job has no supervisory responsibilities.

QUALIFICATIONS:
To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required.

EDUCATION and/or EXPERIENCE:
Bachelor's degree in Computer Science, Information Systems, or equivalent area and one or more years of programming experience, or associate degree in Computer Science and three or more years of programming experience.

Proficient in SQL and one or more years of experience with database structure and query. One or more years of experience with Business Intelligence, preferred. Proficiency with database query and optimization among popular databases, preferred. Experience with some of the modern relational databases, preferred. Skilled at optimizing large, complicated query statements. Knowledge of best practices when dealing with relational databases. Proficient understanding of code versioning tools. Comprehensive knowledge of IT infrastructure and its terminology, preferred. Software application development abilities, preferred.

OTHER QUALIFICATIONS:
Experience working with restricted information and the aptitude in maintaining the integrity of sensitive data, preferred. Excellent written and verbal communication. Ability to organize and plan work independently. Ability to work in a rapidly changing environment. Ability to multi-task and context switch effectively between different activities and teams.

LANGUAGE SKILLS:
Ability to read, analyze, and interpret general business periodicals, professional journals, technical procedures, or governmental regulations. Ability to write reports, business correspondence, and procedure manuals. Ability to effectively present information and respond to questions from administrators, staff, employees, and the general public.

MATHEMATICAL SKILLS:
Ability to work with mathematical concepts such as probability and statistical inference, and fundamentals of plane and solid geometry and trigonometry. Ability to apply concepts such as fractions, percentages, ratios, and proportions to practical situations.

REASONING ABILITY:
Ability to solve practical problems and deal with a variety of concrete variables in situations where only limited standardization exists. Ability to interpret a variety of instructions furnished in written, oral, diagram, or schedule form.

OTHER SKILLS AND ABILITIES:
Ability to use peripheral devices, high level language programming concepts, data management software, and application development tools. Ability to understand Board Policies and Administrative procedures. Ability to use a variety of operating systems to include UNIX and WINDOWS NT. Ability to work independently or in a team environment.

PHYSICAL DEMANDS:
While performing the duties of this job, the employee is regularly required to sit and talk or hear. The employee frequently is required to use hands to finger, handle, or feel. The employee is occasionally required to stand and walk. The employee must occasionally lift and/or move up to 25 pounds. Specific vision abilities required by this job include close vision, distance vision, and ability to adjust focus.

WORK ENVIRONMENT:
Occasional district-wide travel to multiple campuses as assigned. The noise level in the work environment is usually quiet.

Revised Date: June 2022

The foregoing statements describe the general purpose and responsibilities assigned to this job and are not an exhaustive list of all responsibilities, duties, and skills that may be required.