Business Intelligence Developer

Join to apply for the Business Intelligence Developer role at Columbia Bank New Jersey

This range is provided by Columbia Bank New Jersey. Your actual pay will be based on your skills and experience — talk with your recruiter to learn more.

$90,107.00/yr - $/yr

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.

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

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