Apply on Employer Site

Columbia Bank New Jersey · 1 day ago

Business Intelligence Developer

Fair Lawn, NJ

Full-time

Hybrid

Mid Level

$92K/yr - $139K/yr

3+ years exp

Columbia Bank New Jersey is seeking a Business Intelligence Developer to develop, enhance, and maintain Business Intelligence solutions that enable data-driven decision-making. This role involves collaborating with stakeholders to translate business requirements into analytical solutions while working under the guidance of senior BI team members.

BankingFinancial ServicesMortgage

Responsibilities

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

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

Support future data integration strategies

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

Perform other job-related duties as may be assigned

Qualification

Microsoft SQL ServerPower BISQL Server Reporting ServicesData modelingData validationTroubleshootingExcel proficiencyPowerPoint proficiencyProject managementCommunication skillsCollaborationAttention to detail

Required

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