Power BI Developer I

ibc; San Antonio (TX); On-site; USD 70,000 - 100,000; Full time

Job summary

IBC Bank is seeking a Business Intelligence Developer to design and manage BI and analytics solutions that translate data into knowledge. The role focuses on developing visual reports, dashboards, and KPI scorecards using Power BI, with responsibilities for data sources via T-SQL and SSRS, while collaborating with business units and IT to ensure system integration and data integrity.

The ideal candidate will have a background in data and business analysis, strong communication skills, and

Qualifications

• Develop and manage BI reports, dashboards, and KPI scorecards based on business needs.
• Translate business requirements into reporting solutions using Power BI and SSRS.
• Collaborate with IT and business units to ensure data integrity and availability.

Responsibilities

• Develop and manage effective working relationships with other departments and personnel.
• Gather and document requirements and translate into reporting solutions and dashboards.
• Develop Power BI dashboards and KPI scorecards based on business requirements and publish across the company.
• Develop understanding of underlying data structures to ensure reports meet client needs.
• Create and update technical documentation of report logic and processes.
• Ensure data quality through peer reviews and QC processes.
• Provide support to maintain performance and availability of reports for users.
• Meet deadlines and coordinate resources and meetings effectively.

Skills

T-SQL

Power BI

Data visualization

Analytical thinking

Communication skills

Team collaboration

Education

BS in Computer Science or Information Systems

Experience with predictive analytics / forecasting models

Data warehousing experience

Power BI familiarity

SQL Server SSRS SSIS familiarity

Tools

SSRS

SSIS

Job description

IBC Bank successes are the result of an aggressive and innovative attitude. The Bank's \"We Do More\" philosophy reflects its dedication to the growth and success of its employees, customers and communities. IBC bank hires talented, creative and dedicated individuals to help our business succeed. We are a company that values leadership, community engagement and relationship building that leads to a culture of excellence. We are currently seeking to fill positions across all business segments. IBC's focus is to be customer centric and strive to provide excellent customer experience.

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

• 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
• Other duties as assigned

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)