Live Chat
Contact

SENIOR BUSINESS INTELLIGENCE DEVELOPER Job in Independence, Ohio US

SENIOR BUSINESS INTELLIGENCE DEVELOPER

Northwest Bank - Independence, OH

Posted: 4/20/2021 - Expires: 7/19/2021

Job ID: 226457794

Print 

Job Description

Description
The Senior Business Intelligence Developer will work independently and be instrumental in leading BI development technology initiatives, modeling new datasets, applying artificial intelligence/machine learning and developing analytics tools for our stakeholders. They may use Microsoft technologies like SQL Server SSRS or Power BI, writing ETL scripts and developing / executing test plans. The incumbent in this role will possess expertise about our industry, our bank and our data and learn how to best apply the technology stack to achieve successful outcomes.

Locations available:
Buffalo, NY
Cleveland, OH
Columbus, OH
Pittsburgh, PA
Warren, PA






Essential Functions







*




Design simple integrations and implements data integration solutions designed by an integration architect ensuring that solution meets defined requirements using C#, SQL or other equivalent programming languages





*




Ensure that the solution follows data integration best practices





*




Determine how to import and transform the data to fit approved data architectures





*




Work with DBAs and data administrators to determine how to meet service level agreements. May assist in defining SLAs.





*




Design simple rules and implement all rules for cleansing the data in adherence with data quality policies





*




Help with the selection of data integration tools and seeks ways to improve services through the use of tools.





*




Follow PMO governance processes to initiate, execute, and close a project on behalf of a customer/sponsor





*




Maintain awareness of current technology stacks and recommends developments that can have positive impact on the enterprise to management





*




Design and develop ETL solutions using SQL Server Integration Services (SSIS), SQL Server and other languages/tools





*




Write technical specifications for data integrations, applications, systems and solutions





*




Create and maintain architecture diagrams, design diagrams and data flow diagrams using Microsoft Visio or other equivalent tools





*




Work with internal customers to assess business needs and work with a team to design solutions





*




Support and provide maintenance programming for applications using approved technologies





*




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





*




Develop, implement, and participate in all phases of the software development life cycle (SDLC)





*




Lead requirements gathering, analysis and application design for meduim and large projects





*




Establish best practice to embed 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 Tier 1 support teams





*




Accept mentorship from senior developers and may mentor Application Developer I and II





*




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











Additional Essential Functions









Essential Functions







*




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











Additional Responsibilities







*




Participate in other projects on request.











Safety and Health for those without supervisory duties







*




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











QUALIFICATIONS





To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.











Education





Education Level




Education Details




Req




Pref











Bachelor's Degree




Computer Science, Information Technology (Software Development track) or Engineering with a concentration in data management, analytics, programming or related AND at least10 years relevant work experience








X




Or





Master's Degree




Computer Science, Information Technology (Software Development track) or Engineering with a concentration in programming AND 8 years equivalent work experience








X




Or











Work Experience





Experience




Experience Details




Req




Pref











6 - 8 years




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








X









2 - 6 years




Writing SQL statements for relational database management systems like SQL Server, Oracle, or MySQL








X















Role Type for KSAs




General Employee











General Employee Knowledge, Skills, and Abilities













Proficiency







*




Ability to establish effective working relationships among team members and participate in solving problems and making decisions









*




Ability to present and express ideas and information clearly and concisely in a manner appropriate to the audience, whether oral or written









*




Ability to actively listen to what others are saying to achieve understanding, sharing information with others and facilitating the open exchange of ideas and information









*




Ability to establish courses of action for self to accomplish specific goals, develop and use tracking systems for monitoring own work progress, and effectively use resources such as time and information









*




Ability to make right decisions based on perceptive and analytical processes, practicing good judgment in gray areas



















Additional Knowledge, Skills and Abilities





KSAs




Proficiency







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




Extensive





Knowledge of relational data model




Extensive





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




Extensive





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




Extensive





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.




Extensive





Ability to work with application development and SQL on Hadoop




Extensive





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




Extensive





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;




Extensive





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




Extensive





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




Extensive





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




Extensive





Ability to monitor, support, and trouble-shoot applications/systems running on Windows servers and Microsoft SQL servers




Extensive





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




Extensive





Ability to work in agile environments. Exposure to Scrum framework




Extensive





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




Extensive





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




Extensive





Skill in developing data warehouses and data marts.




Extensive





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




Extensive











Licenses and Certifications





Enter Licenses/Certifications




Licenses/Certification Details




Time Frame




Req




Pref















Microsoft Certified Solutions Developer (MCSD), Data Management or Analytics Development track




Within 1 year








X




Or









Microsoft Certified Solutions Expert (MCSE)




Within 1 year








X




Or









Microsoft Certified Solutions Architect (MCSA), Data Management or Analytics Development track




Within 1 year








X















Standard ADA Requirements





The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. All individuals in this position are required to have regular, onsite attendance and be able to perform these tasks without risk of injury to themselves or others, or to otherwise demonstrate or explain how they can perform the essential functions listed.











Physical Demands





Physical Demand




N/A




Rarely




Occasionally




Frequently




Constantly




Weight







Stationary position




















X









Traverse (Move About)












X

















Position objects (one person)








X





















Position objects (with another)




X

























Ascend/Descend (ladders, stairs, scaffolds, etc.)




X

























Position self to stationary objects








X





















Operate standard office equipment




















X









Grasp








X





















Repetitive Motions
















X













Ability to observe




















X









Communicate
















X



















Additional Physical Demands





Physical Demand




N/A




Rarely




Occasionally




Frequently




Constantly




Weight











X





























X





























X































Travel Requirements





Est. Amount




Brief Description







As Needed




Training and as needed occasionally




Qualifications
Licenses & Certifications
MICR CERT SOL DEV (preferred)

The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor's legal duty to furnish information. 41 CFR 60-1.35(c)

Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities

Identified Skills


Job Summary

Employment Type:
Full Time Employee
Job type:
Federal Contractor
Skill Based Partner:
No
Education Level:
Bachelor's degree
Work Days:
Mon, Tue, Wed, Thu, Fri
Job Reference Code
53706654
Salary
N/A
Licenses / Certifications:
N/A
Display Recommended WorkKeys®Recommended WorkKeys®:
N/A