live chat
LEAD BUSINESS INTELLIGENCE DEVELOPER Job in Cleveland, Ohio US

LEAD BUSINESS INTELLIGENCE DEVELOPER

Northwest Bank - Cleveland, OH

Posted: 7/27/2020 - Expires: 10/25/2020

Job ID: 219157895



Job Description

Description
Locations other than Columbus would be considered.

The Lead Business Intelligence Developer will work independently and provide thought leadership around analytics, data governance, visualizations, designing and implementing algorithms using artificial intelligence/machine learning. They constantly peruse the technology landscape to ensure that the Bank’s analytical technologies are suitable for purpose and efficiently deployed. They may lead BI technology initiatives, model new datasets and develop new analytics tools for our stakeholders. While they may use Microsoft technologies like SQL Server SSRS or Power BI, they will also consider other technologies with the goal of deriving value from our data assets.






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 needed to perform the essential duty.





 






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







At least 6 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.      Fiserv Signature, Jack Henry, FIS Core Banking System experience preferred








X









At least 2 years




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








X














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 12 months




X




OR





Microsoft Certified Solutions Expert (MCSE)








Within 12 months




X




OR





Microsoft Certified Solutions Architect (MCSA)




Data Management or Analytics Development track




Within 12 months




X









 

 






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










Essential Functions







Essential Functions












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










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










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










Work as part of a team










Work with onsite equipment










Additional Responsibilities












Participate in other projects on request.






Qualifications
Education
Bachelors of Information Technology (required)

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

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
41264762
Salary
N/A
Licenses / Certifications:
N/A
Display Recommended WorkKeys®Recommended WorkKeys®:
N/A