Power BI Developer I

IBC; San Antonio (TX); On-site; USD 75,000 - 110,000; Full time

Job summary

IBC is seeking a Business Intelligence Developer to create and manage BI solutions, dashboards, and KPI scorecards. You will translate business needs into technical specifications and develop data sources using T-SQL for SSRS reports.

The role requires strong data analysis, Power BI expertise, and collaboration with IT and business units to ensure accurate, timely reporting and optimized performance.

Qualifications

• BS in Computer Science or Information Systems or equivalent experience.
• 5-7 years of related BI/analytics experience preferred.
• Experience with predictive analytics and forecasting is a plus.
• Knowledge of SQL queries, SSRS/SSIS, and Power BI is required.

Responsibilities

• Develop and manage BI solutions, dashboards, and KPI scorecards.
• Translate business needs into reporting solutions and technical specs.
• Create data sources using TSQL queries and maintain SSRS reports.
• Collaborate with IT and business lines to integrate systems as needed.
• Maintain technical documentation of report logic and processes.
• Support report availability and performance for internal users.

Skills

TSQL

Power BI

DAX

Data visualization

Analytical thinking

Communication

Cross-team coordination

HR/Finance data

Education

BS in Computer Science or Information Systems

5-7 years commensurate experience

Tools

Power BI

SSRS/SSIS

SQL Server

TSQL

Job description

Time Type:

Full time

This is an in-office position.

Department:

650 Management Services

Job Summary

The Business Intelligence Developer is responsible for creating and managing BI and analytical solutions that turn data into knowledge. In this role, this person should have a background in data and business analysis and have the keen ability to translate business needs to technical specifications. This position is responsible for development of visual reports, dashboards and KPI scorecards with secondary duties involving creating data sources using TSQL queries, report creation, and maintenance using SSRS. The Business Intelligence Developer will serve as a liaison between business lines and IT to collaborate with these teams to integrate systems as needed.

Job Description

Essential Job Functions

The statements on this job description are intended to describe the general nature of level of work being performed by incumbents. They are not an exhaustive list of all responsibilities, duties, and skills required by all incumbents.

• Develop and manage effective working relationships with other departments, groups and personnel with whom work must be coordinated or interfaced
• Gather and document functional and technical requirements, and translate requirements into reporting solutions, analytic tools and dashboards
• Develop visual reports, dashboards, and KPI scorecards using Power BI desktop based on business requirements; publish and support all dashboards across the company
• Develop in-depth understanding of underlying data, data structures, and business uses to ensure reports meet client need
• Expertise in using advanced level calculations on data sets
• Develop and update technical documentation of report logic and processes
• Coordinate quality control and peer review processes to ensure integrity of the data available to users
• Provide support as required to ensure the availability and optimized performance of developed reports and dashboards for both external and internal users
• Meet professional obligations through efficient work habits such as, meeting deadlines, honoring schedules, coordinating resources and meetings in an effective and timely manner, and demonstrate respect for others

Core Competencies

Displays acceptable Leadership core competencies, and is committed to continued development of strengths and gaps, in the following categories:

• Individual Work Characteristics
• Decision-Making
• Planning and Organizing
• Leadership Styles
• Interpersonal skills
• Communication skills

Skills

• TSQL programming proficiency
• Proficient in making DAX queries in Power BI desktop
• Knowledge of data visualization and visual perception
• Strong interpersonal and customer service skills
• Analytical mind with a problem solving attitude
• Excellent communicator - both verbal and written
• Ability to work with/for multiple employees and meet deadlines
• Facilitation and coordination of teams
• Strong conceptual, analytical, and judgement abilities
• Experience with HR and/or Finance data is a plus

Education

• BS in Computer Science or Information Systems preferred - will consider 5-7 year of commensurate experience
• Experience working with predictive analytics, forecasting models, and statistical software
• Experience in data preparation and data warehousing projects
• Experience and Familiarity with BI technologies, specifically Microsoft Power BI
• Knowledge of SQL queries, SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS)