Business Intelligence Developer

Job Description

Job Description

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

Extract / Database Development Support

Data Validation

Other Responsibilities

Job Requirements :

Working with users in a requirements analysis role

Microsoft Power BI (paginated reports)

Preferred

Columbia Bank offers the following benefits :

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.