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