Business Intelligence Developer I

JOB SUMMARY

Responsible for the management, analysis and dissemination of accurate and actionable information that facilitates data-informed decisions. Collaborates with stakeholders to develop business requirements and to improve business processes. Works directly with project stakeholders, business leaders and other team members to deliver insightful analysis and critical operational reporting. Influences the direction and success of the business unit through proactive analysis and recommendations. Organizes, develops and implements numerous analytical processes and tools to tackle complex reporting challenges while driving business. Performs other duties of a similar nature as may be required.

ESSENTIAL FUNCTIONS

- Develops and monitors "on demand" or "ad hoc" reports and dashboards using tools such as Excel, SQL, Tableau, Angles for Oracle, Noetix, Power BI and Oracle Analytics Cloud.

- Builds custom business applications using Power Apps and Power Automate to automate workflows, streamline processes and address specific business needs across departments.

- Manages user access, troubleshoots system and applications issues and optimizes performance within Power Platform.

- Evaluates, documents and optimizes business processes, recommending and implementing improvements to drive efficiency, reduce costs and enhance performance.

- Supports and manages Customer Relationship Management (CRM) systems such as Salesforce. Ensures data integrity, optimizes workflows, develops reports and customizes CRM solutions to improve customer engagement and operational efficiency.

- Collaborates with business leaders and other associates to understand and document business requirements and needs.

- Delivers data-driven insights, produces actionable strategic direction and helps drive business prioritization that will support growth and maximize results.

- Provides solutions tailored to individual departments while considering organization-wide impact.

- Leads various projects in a way that supports existing deployed tools and processes.

- Supports executive leadership with day, week and month-end reporting.

- Analyzes departmental results within the context of the entire business, including data, goals, processes and organization.

- Suggests reporting solutions to optimize business performance, writes detailed technical documentation and collaborates with various teams to operationalize proposed solutions.

- Communicates complex analyses and insights to stakeholders and business leaders both verbally and in writing.

- Trains staff to effectively use reports and/or dashboards.

- Evaluates and documents business processes and recommends/provides improvements.

- Performs other duties of a similar nature as may be required.

MINIMUM JOB REQUIREMENTS

EDUCATION

- Candidate must possess a bachelor's degree, preferably in Information Systems, Computer Science, Information Technology or closely related field.

- Equivalent combination of relevant education and experience may be substituted as outlined in the Education Equivalencies Policy.

EXPERIENCE

- Candidate must possess two (2) years of experience analyzing business needs and providing valuable, data-centric solutions and reports.

- Experience must include working with a variety of data formats to access, import, extract, transform and transfer or load data.

OTHER REQUIREMENTS

KNOWLEDGE, SKILLS AND ABILITIES

- Candidate must possess advanced knowledge in Microsoft Business Intelligence technologies, as well as SQL or Oracle, SQL Data Tools, Cognos, Oracle Business Intelligence Application or PowerBI skills and proficient working knowledge in Excel.

- Candidate must possess strong analytical, technical, organizational, time management, communication, interpersonal and customer service skills.

- Candidate must have the ability to present information to a broad audience of users including business leaders; ability to adapt to a rapidly changing environment, anticipate business needs, multitask and work efficiently with minimal supervision.

PHYSICAL AND MENTAL REQUIREMENTS

During the course of performing the essential functions of this position, the employee must be able to analyze, communicate, comprehend, coordinate, make decisions, possess general intelligence, interact, interpret, negotiate, possess numerical intelligence, organize, problem solve, have resilience and perform tasks. Physical work will need to be performed, such as driving, sitting, standing, talking, typing and walking. Position will require visual demands of accommodation and near acuity. Ability to withstand faint to moderate noise exposure for fifteen minutes or longer on a frequent basis is required.

Pay Range: USD, Commensurate with Experience

$72,700 - $90,875

Our Employee Benefits & Wellness Programs
We offer a comprehensive employee benefits package including Health Insurance Coverage, Various Retirement Planning Options (Ohio Public Employee Retirement System and Deferred Compensation Plans), Flexible Spending Accounts, Employee Assistance Program, Free Parking at our facilities, Corporate Discounts, and more! We also have an active Health & Wellness Program that promotes a life/work balance.

NEORSD supports the use of hybrid work as a way to help attract and retain talented individuals in public service, increase worker productivity and better prepares the agency to operate during emergencies. This position may be authorized for hybrid work. hybrid eligibility will be discussed during the interview process.

DISCLAIMER: The information outlined in this job description indicates the general nature and type of work performed by employees within this classification. It is not intended to provide a comprehensive inventory of all duties, responsibilities or competencies required of employees within this classification.