Log In
Sign Up
GENERAL SUMMARY:
The Business Intelligence Developer (BID) designs, develops and maintains decision intelligence solutions, data analytics platforms, and ETL processes throughout the Enterprise Data Warehouse environment. In collaboration with company resources and stakeholders, the BID analyzes requests, forms them into working requirements and delivers visualizations and solutions to enable users to find the information they need and drive a data driven culture.
The Business Intelligence Developer (BID) designs, develops and maintains decision intelligence solutions, data analytics platforms, and ETL processes throughout the Enterprise Data Warehouse environment. In collaboration with company resources and stakeholders, the BID analyzes requests, forms them into working requirements and delivers visualizations and solutions to enable users to find the information they need and drive a data driven culture.
QUALIFICATIONS:
Minimum Education & Experience Requirements:
- Bachelor’s degree in MIS, Computer Science, Finance, Math or related degree, or equivalent work experience
- 3 years experience in creating database objects and building queries (SQL, T-SQL, PL/SQL, etc.)
Additional Preferred Education & Experience:
- Experience working with Symitar Episys
- Experience working with financial institutions, or within finance industry
- Experience supporting database management systems (SQLServer, Oracle, MySQL, DB2, etc.)
- Experience working with ETL concepts and strategies (DataStage, Informatica, SSIS, etc.)
- Experience in creating data visualization objects (reports, dashboards, scorecards, etc.) with analytic tools (Tableau, Power BI, Qlik, etc.)
- Data modeling architecture and design
Minimum Knowledge & Skill Requirements:
- Experience working within an Agile (SCRUM, Kanban) project management environment
- Ability to plan and manage multiple projects and tasks simultaneously
- Ability to interact comfortably with a wide range of stakeholders, from end-user staff through C level
- Ability to deal effectively and courteously with a wide variety of people
- Detail oriented with strong time management skills
COMPETENCIES:
- Problem Solving
- Functional/Technical Skills
- Customer Focus
- Dealing with Ambiguity
WORKING CONDITIONS/ENVIRONMENT:
Requires the employee to sit and stand a majority of the time. Some travel may be necessary for training/conferences. Infrequent lifting of up to 25 pounds is required.
OTHER REQUIREMENTS:
Must comply with all aspects of the Bank Secrecy Act.
MAJOR ACCOUNTABILITIES AND TASKS:
1. Technical Expertise – Will have expertise and knowledge in one or more components of the decision intelligence environment (analysis, data modeling, data visualization, ETL, etc.). Able to concurrently deliver on 1-2 small-scale initiatives in addition to tasks on customer request backlog.
2. Business Analysis – Fosters a collaborative relationship across all business functions. Works closely with end user departments to understand business needs and translate them into functional requirements. Tackles large or complicated requests with a high level of accomplishment and accuracy. Will have expertise and knowledge in at least one business domain (Lending, Finance, Core Systems, etc)
3. Data Modeling – Participates in building a unified environment for storage of all corporate information. Understands, optimizes, and documents movement of data between disparate sources and target repositories (raw data, data lake, EDW, data marts).
4. Data Visualization – Specialization in customer-facing, end-to-end, aspects of the data pipeline. Possesses a strong understanding of the underlying data infrastructure to effect development of reports, dashboards, score cards, etc. using data visualization tools.
5. Extract / Transform / Load – Evaluate, design, develop, test, implement and maintain ETL strategies from the raw data source layer, into the data warehouse layer and finally for visualization into the reporting layer.
6. Production Support – Participates in supporting the EDW environment through on-call rotations, in-depth knowledge of the batch cycle and proactive resolution management.
7. Best Practices – Adheres to standards, best practices, policies, and procedures pertaining to architecture, security, and compliance/regulatory requirements. Participates in code reviews to advance domain knowledge sharing and ensure code validation.
8. Performs other duties as assigned.
Equal Opportunity Employer
Salary Range: $59,721.63 – $78,384.64. Job Grade 13, Exempt. Final salary is dependent on a candidate’s experience and qualifications.
