200+ applicants

Company

Original Job Post

Northwest Bank · 5 days ago

Senior Business Intelligence Developer

Chicago, IL

Full-time

Remote

Senior Level

8+ years exp

Wonder how qualified you are to the job?

Maximize your interview chances

BankingFinancial Services

H1B Sponsorship

Insider Connection @Northwest Bank

Discover valuable connections within the company who might provide insights and potential referrals, giving your job application an inside edge.

Responsibilities

Adhere to FDIC and FRB data regulatory guidelines for SDLC

Design, develop, test and deploy ETL solutions, reports, etc. which meet defined requirements using SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), Power BI, Python, ADF, T-SQL and other languages and tools. In addition, Synapse skills are a positive add.

Import data from 3rd party sources (Using APIs, SFTP, Flat Files, Websites, etc.) to improve the Bank’s ability to market, control, and enhance client and / or banker experience – data imports must align with approved data architectures and standards

Contribute to requirements refinement, analysis and design for all-sized projects

Improve Data Environment for our business partners by improving daily job efficiency and success, resolving defects, enhancements, Interfacing with Data Governance to maintain Data Catalog, reviewing metrics for areas of improvement, automating daily data team functions, etc.

Adhere to best practice development, testing, deployment and operations policies, procedures and guidelines and contribute to the further refinement of those guidelines

Work with DBAs to determine how to meet service level agreements, and assist in defining SLAs

Adhere to data quality standards, dat governance standards, coding standards and SDLC

Contribute to Data Democratization of Northwest by working with Analysts and LOB partners to design and implement complex user stories

Maintain awareness of current data technology trends and recommend enhancements that will improve the data environment

Write technical specifications for data integrations, solutions, etc.

Create and maintain design and data flow diagrams

Ensure compliance with Northwest’s policies and procedures, and Federal/State regulations

Navigate Microsoft Office Software, computer applications, and software specific to the department in order to maximize technology tools and gain efficiency

Work as part of a team

Work with on-site equipment

Maintain expertise in current technology stacks and best practices to recommend changes that can have positive impact on the enterprise

Ensure best practice align information security and regulatory requirements in SDLC

Works with team to complete project requests

Troubleshoot and resolve daily issues with the perspective of minimizing incidents and developing supporting documentation that may be used by support teams

Provide mentorship to junior developers

Develop and execute plans to install new software and custom software changes following Change Management disciplines

Abide by the rules of the safety and loss prevention program

Perform work tasks in a safe manner

Report any and all injuries to supervisor

Know what to do in case of an emergency

Qualification

Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.

BI/AnalyticsMicrosoft stackC#SQL Server.NETJavaPythonMySQLSQLObject-oriented programmingRelational data modelSSISSSASNOSQL databasesMongoCassandraData integrationAPIsSQL on HadoopSource code repositoriesMicrosoft Team Foundation ServicesTFSGitHubSVNMergingRelease managementVersioningMicrosoft AzureAmazon Web ServicesCloud ecosystem

Required

Bachelor's Degree in Engineering, Computer Science, Information Systems, Software Development / Programming, Sciences, Mathematics, Data Management

6 - 8 years experience as a developer in banking

8 - 12 BI/Analytics development experience using Microsoft technology stack (e.g. C#, SQL Server, .NET) or equivalent technologies and toolset, e.g. Java, Python, MySQL, etc.

2 - 6 years Writing SQL statements for relational database management systems like SQL Server, MYSQL, etc.

Knowledge of object-oriented programming using C#, Java or similar contemporary programming languages

Knowledge of relational data model

Knowledge of Microsoft SQL Server, SSIS, SSAS (tabular model) and equivalent technologies available from other vendors

Ability to write SQL statements for relational database management systems like SQL Server, Oracle, or MySQL and using contemporary NOSQL databases like Mongo or Cassandra

Ability to work with large datasets in building pipelines, pipeline architectures and integrated datasets using traditional data integration technologies using APIs, SQL Server SSIS, etc.

Ability to work with application development and SQL on Hadoop

Skill in working with and optimizing existing applications and helping to move them in production

Skill in working with source code repositories like Microsoft Team Foundation Services (TFS), GitHub, SVN or other equivalent tools Experienced in branching, merging, release management, versioning, etc;

Knowledge of Microsoft Azure, Amazon Web Services or any other cloud ecosystem.

Skill in incorporating best practices on information security into development efforts;

Ability to work within a team environment and possessing communication skills necessary to function with a team

Ability to monitor, support, and troubleshoot applications/systems running on Windows servers and Microsoft SQL servers

Knowledge of development solutions adhering to software development lifecycle and technology standards

Ability to work in agile environments. Exposure to Scrum framework

Knowledge of message queuing technologies such as Kafka, Azure Service Bus, and stream data integration technologies or stream analytics technologies such as Apache Kafka KSQL, Spark Streaming and others

Skill in creating ETL solutions using SQL Server Integration Services (SSIS) or other equivalent technologies

Skill in developing data warehouses and data marts.

Skill in creating dashboards and reports using SQL Server Reporting Services (SSRS) and Power BI.

Preferred

Synapse skills are a positive add

Anyone of the following certifications in SSIS, SSRS and Azure (e.g., MS Azure Developer, MS Azure Engineer, MS SQL Server Reporting, MS Azure Data Fundamentals) or a willingness to complete the certifications in the first year of employment

Company

Northwest Bank

Northwest Bank is a full-service financial institution offering a complete line of business and personal banking products.

Founded in 1896

Warren, Pennsylvania, USA

1,001-5,000 employees

https://www.northwest.bank

H1B Sponsorship

Northwest Bank has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)

Distribution of Different Job Fields Receiving Sponsorship

Trends of Total Sponsorships

2023 (1)

2022 (2)

2021 (5)

2020 (2)