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.
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 KSAs
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
Qualifications
Licenses & Certifications
MICR CERT SOL DEV (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
Follow Us