Lead BI Developer

Job Description

The Lead Business Intelligence Developer will work independently and provide leadership to a team of BI developers. The lead must have experience in SQL, SSIS, SSRS, and SSAS. Azure ADF, Synapse pipeline; Power BI, experience beneficial.

The lead will be responsible for complex ETL, query, and reporting development, production support, change control monitoring / approval, proactively reviewing existing data environment (on-prem SQL, and Azure technologies) identify issues, identifying continuous improvement opportunities.

The lead will participate in daily team standups, ensure adherence to SDLC and coding standards, ensure the code repository's integrity, perform code reviews and release notes reviews.

The lead may need to model new data structures and develop new analytics tools for our stakeholders. The lead will also be required to participate in project team meetings and provide input on work execution, develop roadmaps. mentor and support onshore and offshore team members. The lead will assist in project planning and resource assignments.

Essential Functions

• Conduct meetings with senior business leaders to clarify requirements (e.g. Reports, Dashboards, Queries, Extracts, etc.), discuss status of work in progress, issues and their solutions
• Support onshore and offshore team members with technical guidance, adherence to standard, code and release notes reviews, lessons learned
• Design and implement ETL and ELT solutions using SQL, SSIS, C#, ADF, and Python / PySpark. Support and provide maintenance programming for ETL and ELT solutions
• Adhere (and ensure team adherence) to Northwest SDLC procedures while performing all build, test and deployment activities
• Ensure team members follow best practice for all design and build work
• Determine approach to import and transform data to fit existing data architecture
• Ensure service level agreements (SLAs) are achieved. Assist in defining these SLAs, and automation to monitor SLAs
• Perform production support as needed. Troubleshoot and resolve issues with the perspective of minimizing incidents and developing supporting documentation that may be used by Tier 1 support teams
• Maintain data quality as a priority, and engage with teams on any needed Data clean-up
• Mentor team members and plan their growth in current and new technologies
• Write technical documentation for data flows and jobs
• Manage team and coordinate completion of project requests
• Follow Change Management procedures
• Assist with deployments to preproduction environment
• Protect customer PII data
  
  

Additional 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.
• Abide by the rules of the safety and loss prevention program
  
  

Safety and Health for Supervisors with Direct Reports

• Provide leadership and positive direction for maintaining the safety and loss prevention program
• Actively participate in and support employee participation in the safety and loss prevention program by ensuring that employees know how to properly report a safety issue, making sure that all accidents are promptly reported to Human Resources and documented, and ensuring that prompt action is taken whenever workplace hazards are identified
• Help implement emergency procedures
  
  

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

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 Or

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

Work Experience

8 - 12 years BI/Analytics development experience using Microsoft technology stack (e.g. SSIS, SSRS, SSAS, SQL Server) or equivalent technologies and toolset e.g. , Python, MySQL, etc.

5 - 6 years Writing SQL statements for relational database management systems for MS SQL Server, or MySQL

Banking experience

General Supervisory/Manager Knowledge, Skills, And Abilities

• Ability to identify existing and potential problems, obtain and evaluate relevant information, identify possible causes of the problems, and suggest an alternative course of action including innovative or creative approaches
• Ability to allocate and effectively use information, personnel, time, and other resources necessary for implementation of Northwest’s strategic plans
• Ability to make decisions, render judgments, and take action on tasks within the scope of given authority in a timely fashion
• Ability to develop, evaluate, and implement alternative courses of action, based on correct assumptions concerning resources and guidelines, and support decisions or recommendations with data or reasoning
• Ability to present and express ideas and information effectively and concisely in an oral and/or written mode in a manner appropriate for the audience
• Ability to listen and comprehend what others are saying and facilitate the open exchange of ideas and information
• Ability to motivate and provide direction in the activities of others, appropriately assigning work and authority, in the accomplishment of goals; providing advice and assistance as required
• Ability to understand and appropriately apply procedures, requirements, regulations, and policies; maintain credibility with others on specialty matters
  
  

Additional Knowledge, Skills And Abilities

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

Knowledge of relational data model

Knowledge of Microsoft SQL Server, SSIS, SSRS, 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.

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 trouble-shoot 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

Licenses and Certifications

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

Microsoft Certified Solutions Expert (MCSE) Within 1 year Or

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

Northwest is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees.