Location: Fair Lawn, NJ
Company: Columbia Bank
work well in a team setting and have excellent organizational, prioritization, communication, and time 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. Develop, document, validate, and deploy Power BI paginated reports, models, and dashboards. Follow and conform to steps outlined in the Software Develop
Life Cycle, such as requirements gathering, development, documentation, and deployment to various environments. Transform raw data by writing complex SELECT (DQL) statements in SQL with JOINs to design data sets for reports and dashboards to discover meaningful insights.
Write complex DAX functions in Power BI to generate calculated columns and measures to support additional logic where SQL is not an option. Use various sources to pull data into reports and dashboards, such as SQL Server, Oracle, SQL Azure, Excel, etc. Create and manage access to workspaces and content packs so business users can view the developed reports and dashboards. 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. Schedule automatic refresh and report distribution in Power BI service. 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. 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, dashboards, and data models. Extract/Database Development Support Have working knowledge to modify and create tables, views, stored procedures, and user-defined functions to update/insert data.
Create simple SSIS packages to import data from Access, Excel, XML, OLE DB Source, and flat files to import and transform data between databases and external data sources. Database tables and view creation (DDL, DML, DQL), database tuning, SQL tuning, and performance planning. 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. Help improve the organization's data quality through reporting. Identify, communicate, and resolve data quality and data reconciliation issues.
Other Mentor and assist other bank analysts in preparing queries and presenting data using self-service tools. Perform other job-related duties as may be assigned. Requirements 5+ years' experience developing and implementing enterprise-scale reports and dashboards, including: Working with users in a requirements analysis role Extensive experience with data warehouse implementations Knowledge of logical and physical data modeling concepts (relational and dimensional) 2+ years' experience with Microsoft SQL Server Business Intelligence suite, including: Microsoft Power BI (Both dashboards and paginated reports) SQL Server Reporting Services (SSRS) SQL Server Integration services (SSIS) Advanced proficiency with MS Excel & MS Power Point (creating graphics, charts)Ability to collect, coordinate, analyze and disseminate significant amounts of information with attention to detail and accuracy and with highly confidential data Prior experience with data governance, auditing and developing standards / documentation Education Required: BA/BS in Computer Science or 5 years in a related field Requirement: Full vaccination against COVID-19 is required as a condition of employment, unless a legally required exception applies.
Columbia Bank and its affiliates is an Equal Opportunity Employer Affirmative Action Employer/Males/Females/Protected Veterans/Individuals with Disabilities Hybrid Opportunity - Three (3) days work in office; Two (2) days work from home. PDN-9acbbeaee0-9cfc-23ff2cd2deed
Participate in full lifecycle development of software including analysis, design, coding, testing, implementation, deployment, and support. Write, translate, and code software programs and applications according to specifications. Take a leadership role with the development effort in building scalable, extensible, secure applications while employing best practices.
Assist/mentor other developers with full stack enterprise application design and development strategies utilizing best practices. Design and develop n-tier WPF applications, Windows services and console applications using C#, SQL Server/SQLite, Entity Framework and Prism. Perform unit testing and analyze application and database
performance on new and existing programs for the purposes of correcting errors, isolating areas for improvement, resolving performance bottlenecks, and general debugging.
Participate in code reviews ensuring the team is consistently producing optimal code. Learn and adhere to the SAFe concepts. Requirements: Bachelor? s degree in engineering, computer science, information systems, or a related field from an accredited college or university is preferred. 3+ years of experience designing/developing desktop applications using WPF, C#, Entity Framework, Prism, and SQL integrations. Ability to complete all phases of SDLC including analysis, design, development, testing, and support utilizing
Agile methodologies. Ability to innovate and provide functional applications with intuitive interfaces.
Proven analytical and problem-solving abilities. Ability to interpret complex business requirements and encapsulate business logic/rules into reusable libraries. Strong understanding and demonstrated usage of object-oriented design concepts. Experience with software versioning and release management. Working knowledge of Git and branching concepts. Experience with JIRA and Confluence. Ability to effectively prioritize and execute tasks. Experience working both independently and in a team-oriented, collaborative environment. Excellent communication skills.
IT jobs, short for Information Technology jobs, encompass a broad range of roles focused on the creation, management, and support of computer-based information systems. These roles typically include software development, system integration, data analysis, network administration, and cybersecurity. The field is known for its fast-paced nature, constant evolution with emerging technologies, and high demand for skilled professionals. IT jobs often offer flexibility, competitive salaries, and opportunities for both technical and creative problem-solving. With technology being integral to virtually all industries, IT professionals can work in diverse environments from tech startups to large multinational corporations.
IT jobs refer to positions focused on the creation, maintenance, and support of computer systems and networks in various industries. These roles can include software development, network architecture, system administration, cybersecurity, information systems management, and technical support. Characteristically, IT jobs require a blend of technical skills, problem-solving abilities, and a continuous learning mindset due to the fast-paced nature of technological advancements. They often involve working with complex systems and data, necessitating attention to detail and a methodical approach to work. Additionally, collaboration with other professionals and clear communication are key, as IT roles typically support businesses in achieving strategic goals through technological solutions.
IT jobs refer to employment within the field of information technology, an industry centered on the creation, maintenance, and support of computer systems and networks. Characteristically, these roles demand technical expertise in areas such as software development, cybersecurity, and data analysis. IT professionals are typically required to quickly adapt to new technologies and solve complex problems, often working in dynamic, fast-paced environments. The sector is known for its diverse career opportunities and has become essential across virtually all business sectors, reflecting the critical role technology plays in modern society.
