Business Intelligence Cnslt

About this role

About This Position  

  Job Description: Business Intelligence Consultant

Purpose: Under general supervision, is responsible for utilizing Business Intelligence (BI) tools to help business teams maintain and drive improvement in business results.

Duties, Functions and Responsibilities: Essential duties and functions, pursuant to the Americans with Disabilities Act, may include the following. Other related duties may be assigned. • Analyzes business and functional requirements and translates these requirements into robust, scalable, and operable solutions.

• Collects, analyzes, and shares data to help business teams drive improvement in key business metrics, customer experience, and business results.

• Utilizes database and web application technologies to design, develop, and evaluate innovative business intelligence tools and automated reports.

• Designs, develops, and tests BI solutions such as databases, data warehouses, queries and views, reports, and dashboards.

• Performs conversions, imports, and exports of data within and between internal and external software systems.

• Merges BI platforms with enterprise systems and applications and documents new and existing models, solutions, and implementations.

• Enhances the performance of BI tools by defining data to filter and indexes.

• Troubleshoots BI tools, systems, and software. Troubleshoots reported data loads or reconciliation inconsistencies in conjunction with the sites for data models and/or reports.

• Tracks, monitors, and analyzes performance and production issues, and implements improvements.

• Supports and helps manage external resources, such as service providers and vendor support and participates in vendor evaluations.

• Maintains the quality of Metadata Repository by adding, modifying, and deleting data.

• Provides input to the development of data/information quality metrics.

• Tracks and reports on issues and enhancement requests for the business in a timely manner.

• Analyzes and tests new releases/versions of software.

• Designs and delivers end-user training and training materials. Trains users to transform data into action-oriented information and to use that information correctly.

Responsibilities - Supervisor and/or Leadership Exercised: May provide leadership, work assignments, evaluation, training, and guidance to others.

Knowledge, Skills, and Abilities: Must possess required knowledge, skills, abilities, and experience and be able to explain and demonstrate, with or without reasonable accommodations, that the essential functions of the job can be performed. • Knowledge of reporting analysis, design, and programming principles as well as knowledge of multiple industry standard reporting tools such as Crystal and Business Objects.

• Knowledge of industry standard database systems such as MS, SQL, and Oracle.

• Knowledge of Software Development Life Cycle (SDLC) and Information Technology Infrastructure Library (ITIL) concepts.

• Knowledge of release, change, configuration, and incident management.

• Knowledge of industry reporting techniques and developing and maintaining interactive reports.

• Knowledge of relational data modeling and relational database design.

• Knowledge of standard industry ERP technologies such as SAP.

• Knowledge of business operations as well as one or more business functional areas.

• Skill in data analysis and data mining.

• Skill in identifying and solving system and application problems.

• Skill in coordinating work projects and providing technical assistance.

• Skill in preparing data structures, flowcharts, and logic flow diagrams.

• Skill in applying migration procedures.

• Skill in analyzing and meeting the data processing needs of users.

• Skill in working with people of varying technical abilities in a team environment.

• Skill in training groups on reporting standards.

• Skill in analyzing major system reporting problems and applying appropriate solutions.

• Skill in actively participating in functional unit testing, integration testing, stress testing, systems testing, and user acceptance testing.

• Ability to learn City specific and industry standard reporting tool sets.

• Ability to explain complex technical information in business terms and communicate clearly and effectively both verbally and in writing.

• Ability to support and work with Business Intelligence/Data Warehousing environments.

• Ability to establish and maintain effective working relationships with City staff and the general public.

Minimum Qualifications: • Graduation with a Bachelor's degree from an accredited four (4) year college or university with major coursework in a related field, plus five (5) years of relevant experience in consultation and the utilization of BI tools.

• Graduation with a Master's degree from an accredited college or university may substitute for up to two (2) years of the required experience.

Preferred Qualifications: • Experience translating business requirements into scalable BI or data solutions

• Strong analytical skills with the ability to turn complex data into actionable insights

• Proficiency with SQL, databases, and automated reporting tools

• Hands‑on experience developing dashboards, queries, and data warehouse components

• Knowledge of ETL processes and data transfer between systems

• Experience integrating BI tools with enterprise platforms and documenting data models

• Ability to optimize BI performance through indexing, filtering, and data modeling

• Strong troubleshooting skills for BI tools, data loads, and reconciliation issues

• Experience monitoring system performance and implementing improvements

• Ability to coordinate with vendors or service providers and support technical evaluations

  Notes to Candidate: The purpose of this BI professional is to build scalable data solutions, develop dashboards and automated reports, and translate business requirements into actionable insights. Responsibilities include

Similar jobs

• Business Intelligence Analyst — Guidehouse · Remote
• Business Intelligence Analyst — Astreya · Remote
• Business Intelligence Analyst — KBI · NC, Durham, Emperor Blvd | NC, Durham, Hamlin Rd
• Business Intelligence Analyst — Allwebleads · Remote
• Business Intelligence Analyst — Veeamsoftware · Remote
• Business Intelligence Analyst — Equipmentsharecom · Remote
• Business Intelligence Analyst — Point72 · Stamford, CT
• Business Intelligence Analyst — Gartner · Stamford, CT