Senior Business Intelligence Developer

Central Bank; Sioux Falls (SD); On-site; USD 100,000 - 150,000; Full time

Job summary

Central Bank in Urbandale, IA or Sioux Falls, SD seeks a Senior Business Intelligence Developer to design, develop, and maintain reporting, data and BI solutions that illuminate operations, customers, and performance. You will work with multiple bank departments to deliver practical data solutions and reliable information.

The ideal candidate has eight or more years in BI, strong SQL and Power BI expertise, data modeling and ETL/ELT experience, and familiarity with SQL Server, SSRS, Snowflake or

Qualifications

• Bachelor's degree or equivalent work experience.
• Minimum eight years of experience in business intelligence, SQL development, data development, analytics or similar.
• Advanced experience developing reports, dashboards and data solutions using Microsoft Power BI and SQL.
• Experience with data modeling, ETL/ELT, database development and data integration.

Responsibilities

• Develop and maintain reports, dashboards, scorecards and other BI tools.
• Translate department reporting needs into practical data solutions.
• Analyze data to identify trends and opportunities for Bank leaders.
• Establish meaningful measures and reporting to monitor performance.
• Ensure reports are understandable and useful for the audience.
• Research discrepancies and resolve issues affecting data usefulness.

Skills

Power BI

SQL development

Data analytics

Data visualization

BI development

Education

Bachelor's degree

8+ years BI/SQL experience

Tools

Microsoft SQL Server

SSRS

Snowflake

Microsoft Fabric

Job description

POSITION SUMMARY

The Senior Business Intelligence Developer is responsible for developing and maintaining reporting, data and business intelligence solutions that help the Bank better understand its operations, customers and overall performance. This role combines strong technical expertise with an understanding of business needs to turn data from across the Bank into accurate, useful and accessible information.

Description

The Senior Business Intelligence Developer is responsible for developing and maintaining reporting, data and business intelligence solutions that help the Bank better understand its operations, customers and overall performance. This role combines strong technical expertise with an understanding of business needs to turn data from across the Bank into accurate, useful and accessible information. The position works with departments throughout the Bank to understand reporting and data needs, develop practical solutions and identify opportunities to improve reporting, processes and decision-making. The role also maintains the underlying data connections, models and processes needed to ensure information is reliable and available when needed.

Essential Duties And Responsibilities

Business Intelligence, Reporting & Analytics

• Develop and maintain reports, dashboards, scorecards and other business intelligence tools that support Bank operations and decision-making.
• Work with departments to understand reporting and information needs and translate those needs into practical data solutions.
• Analyze data to identify trends, variances, opportunities and other information useful to Bank leaders and departments.
• Help establish meaningful measures and reporting that allow departments to monitor performance and make informed decisions.
• Ensure reports and dashboards are understandable, useful and appropriate for the intended audience.
• Research reporting discrepancies and resolve issues affecting the accuracy or usefulness of information.

Data Development & Integration

• Develop and maintain data processes that integrate information from the Bank's core system, lending systems, third-party platforms and other business applications to support reporting and analytical needs.
• Write and maintain SQL queries, stored procedures and scripts used to support reporting, analysis and data integration.
• Develop and maintain data models, reporting databases and ETL/ELT processes that support reliable and efficient reporting.
• Monitor and troubleshoot data processes, integrations and reporting issues.
• Support system implementations, conversions and upgrades involving reporting or data integration.
• Monitor and improve query, database and reporting performance as needed.

Data Quality, Governance & Documentation

• Validate the accuracy, completeness and consistency of information used in reports and dashboards.
• Research and resolve data discrepancies in partnership with the appropriate departments.
• Maintain consistent data definitions and reporting standards across the Bank.
• Maintain documentation for reports, data sources, processes, integrations and developed solutions.
• Apply appropriate security and access controls to protect customer, team member and Bank information.
• Support data governance practices that promote reliable and consistent use of information throughout the Bank.

Technology & Process Improvement

• Identify opportunities to simplify or automate recurring reports, manual data processes and other reporting activities.
• Improve existing reporting and data processes to increase accuracy, efficiency and usability.
• Evaluate new reporting tools, technologies and capabilities based on practical Bank needs.
• Provide technical support for data and reporting needs associated with Bank projects and initiatives.
• Support continued improvement of the Bank's reporting and business intelligence capabilities as organizational needs evolve.

Additional Responsibilities

• Support Bank initiatives and special projects as assigned.
• Perform other related duties and responsibilities as assigned by management.

Requirements

EDUCATION & EXPERIENCE

• Bachelor's degree required or equivalent work experience.
• Minimum of eight (8) years of experience in business intelligence, SQL development, data development, analytics or similar job duties.
• Advanced experience developing reports, dashboards and data solutions using Microsoft Power BI and SQL.
• Experience with data modeling, ETL/ELT, database development and data integration.
• Strong understanding of data visualization, reporting and business intelligence development practices.
• Experience with Microsoft SQL Server, SSRS, Snowflake, Microsoft Fabric or similar technologies preferred.
• Banking or financial services experience preferred.
• Advanced degree or relevant certifications preferred.

LOCATION

Urbandale, IA, or Sioux Falls, SD. Note: Only one position will be filled across these locations.

Central Bank is an Equal Opportunity Employer. All qualified applicants will receive consideration without regard to race, color, religion, national origin, ancestry, pregnancy status, sex, age, marital status, disability, medical condition, sexual orientation, gender identity, status as a protected veteran, or any other characteristic protected by law. We make all reasonable accommodations to meet the obligations under the Americans with Disabilities Act (ADA) and applicable state disability laws.