Business Intelligence Developer

Summary:

The Business Intelligence (BI) Developer is responsible for developing, enhancing, and maintaining Business Intelligence solutions that enable stakeholders to make data-driven decisions. Working under the guidance of the Chief Data Officer and senior BI team members, this role will help translate business requirements into analytical solutions that drive data-driven decision-making across the organization. The BI developer will work well in a team setting and have excellent organizational, prioritization, communication, and project management skills. The successful candidate will demonstrate accountability, flexibility, and adaptability to handle multiple priorities and successfully collaborate with development teams, technology groups, and key stakeholders.

Job Responsibilities:

Analytics & Reporting

• Collaborate with organizational stakeholders to understand business requirements, needs, gaps, and issues to design and create relevant Business Intelligence objects and support Senior Developers for the same.
• Apply established data visualization standards and best practices to ensure usability and clarity with the use of DAX, MDX, or other BI-specific calculation languages.
• Maintain basic working knowledge of relational database architecture and data normalization.
• Transform raw data by writing simple SELECT (DQL) statements in SQL with JOINs to design data sets for reports to discover meaningful insights.
• Use various sources to pull data into reports, such as SQL Server, Oracle, SQL Azure, Excel, etc.
• Assist with developing, building, and optimizing data models to support analytical and reporting needs.
• Work with users and team members at all levels for performance improvement and suggestions.
• Develop and maintain effective and productive working relationships with other departments and senior managers.
• Troubleshoot report, dashboard, and data issues to identify root cause and fixes.
• Present reports to the business users and provide training as required.
• Implement row-level security, role-based access and data governance best practices within Power BI.
• Remain current in emerging business intelligence technology trends, primarily related to the financial services industry.

Business Requirements & Specifications

• Create and maintain business requirement documents and gain stakeholder approvals and support Senior Developers for the same.
• Maintain version control by tracking changes for reports and dashboards.
• Help stakeholders define business terms and report descriptions to catalog key business terms and calculations to add to the Business Intelligence book of knowledge.
• Use the workflow management and prioritization tool to catalog status, stakeholder approvals, and communication of current deliverables.
• Understand business requirements and convert them into technical specifications to design reports.

Extract/Database Development Support

• Support future data integration strategies.

Data Validation

• Perform validation to ensure the data's accuracy, quality, and completeness using SQL Server Management Studio, Oracle Developer Studio, Excel, Etc.

Other Responsibilities

• Perform other job-related duties as may be assigned.

Job Requirements:

• Bachelor's degree.
• 3+ years' related experience in BI development or data analytics.
• 3+ years' experience developing and implementing enterprise-scale reports and dashboards, including:
  • Working with users in a requirements analysis role
  • Basic experience with data warehouse implementations
• 3+ years' experience with Microsoft SQL Server Business Intelligence suite, including:
  • Microsoft Power BI (paginated reports)
  • SQL Server Reporting Services (SSRS)
• Working knowledge of logical and physical data modeling concepts.
• Project and workflow management skills.
• Excellent written and verbal communication skills.
• Ability to collaborate with stakeholders across the organization.
• Ability to independently troubleshoot and identify root cause.
• Basic proficiency with MS Excel & MS PowerPoint (creating graphics, charts).
• Ability to collect, coordinate, analyze and disseminate significant amounts of information with attention to detail and accuracy.
• Ability to properly safeguard highly confidential data.

Preferred

• Degree in Computer Science, Information Systems, or related field.
• Industry related certifications.
• Financial Services and Banking Background.

Columbia Bank offers the following benefits:

• Medical, Dental, Vision and Rx which are contributory.
• Bonus programs.
• Employee Stock Option Program (ESOP).
• Life Insurance, Long Term Disability and Accidental Death and Dismemberment (LTD&AD&D).
• Paid Time Off (PTO) which includes Personal and Vacation Time.
• Paid Sick Time.
• Bank Holidays.
• Employees may participate in the 401k program.

Schedule:

This role is eligible for a hybrid schedule; 3 days in the office and 2 days' work from home based on business need.

Columbia Bank and its affiliates is an Equal Opportunity Employer, including individuals with disabilities and veterans.