Power BI Developer 1

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 hirestalented, creative and dedicated individualsto 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

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
• 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)