Business Intelligence Developer - Community Credit Union of Florida
Rockledge, FL 32955
About the Job
The primary purpose of this position is to assist Community Credit Union of Florida in living out our Mission, “Always improve the financial well-being of our members and make a positive difference in our community,” by delivering outstanding service to both internal and external members. In addition, Business Intelligence Developer is responsible for analyzing, developing and writing new application and analytical programs and/or updating existing application programs, and providing technical direction and programming support in the development of custom reports and programs as requested by Credit Union’s user departments. A wide degree of creativity and latitude is required. The incumbent relies on experience and independent judgment to plan and accomplish goals.
Community Credit Union of Florida is an Equal Opportunity Employer (EEO) and supports a drug-free workplace.
ESSENTIAL DUTIES
- Demonstrates enthusiastic support of corporate mission, core values and long-term objectives by performing job duties within our bylaws, regulations, Board of Directors policies, established internal and external service standards, and our work procedures while possessing adequate product knowledge as measured by the annual product knowledge assessment.
- Delivers service to both internal and external members that is in alignment with the credit union’s Service Promises, and meets all established service goals.
- Abides by CCU’s Service Promises when helping a member or co-worker to ensure timely responsiveness to the individual’s needs. Promotes teamwork, respects opinions, abilities and contributions of others and conveys a willingness to assist and cooperate with others for the benefit of the organization.
- Assists in attaining established departmental goals and adheres to all credit union standard operating policies and procedures, as well as state and federal regulations and guidelines.
- Using approved credit union development tools, performs a variety of complex programming tasks such as designing, documenting and coding programming logic for systems and reports as required to meet user departments’ business needs and goals, and to improve the use and integration of third party systems and platforms.
- Maintains a proficient level of knowledge of the database and application software being used in order to provide high levels of support to users to develop SQL queries, program to create reports, automate processes, detect errors, and provide recovery.
- Maintains database data to ensure daily data loads happen and the data integrity remains solid. Balances the data as needed, on a monthly basis, or more frequently. Keeps senior management informed by preparing reports on system performance and problems.
- Works to develop methods of data accumulation, extraction, delivery, and storage. Maintains data documentation and procedures for all areas of responsibility. Produces extracts that contain no erroneous data, no duplicated data, and no missing data. Troubleshoots problems with data extractions to ensure data is according to specs and formatted correctly. Develops, organizes, and utilizes best practices to ensure the integrity of all data extracts.
- Creates ad-hoc reports in support of existing or new report requests through the use of approved credit union development tools. Documents coding logic for systems and reports as required to meet user departments’ business needs and goals, and to improve the use and integration of third-party systems and platforms. Acts as liaison between the Business Intelligence Unit (BIU) and other departments for the purpose of data presentation so that data and reports are built to specification.
- Develop and refine models and machine learning algorithms. Develops and implements metrics for assessing model performance. Deploys models, algorithms, and code with the BIU team and external vendors.
- Develops automated, standardized, and custom reporting solutions to predict trends, develop strategy, evaluate organizational performance, and provide oversight. Analyzes reviews, enhances, and modifies existing programs to increase operational efficiency, add capability, and ensure compliance.
- Uses industry best practices to build new visualizations and dashboards per user requirements. Works with users to ensure requirements are met prior to the release of visualizations or dashboards into production. Updates and maintains existing report visualizations and dashboards.
- Works with Access databases and converts them into a SQL databases and assists with the development of an enterprise data catalog.
- Develop data quality routines and exception reports for unclean data within the database. Works cross-functionally with other business units to ensure exception reports are worked.
- Must have advanced knowledge of relational database concepts.
- Follows policy and procedures related to Bank Secrecy Act (BSA), Anti-Money Laundering (AML), Customer Identification Program (CIP), and Customer Due Diligence (CDD) daily to ensure compliance with current regulations.
- Performs other related duties and works on special projects as assigned.
ENVIRONMENT AND PHYSICAL ACTIVITY
The environment for this position is an open, non-confined office-type setting that is clean and comfortable where the incumbent is free to move about at will. It may include some minor annoyances such as noise, odors, and drafts.
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 essential functions.
While performing the duties of this job, the employee is frequently required to spend time writing, typing, speaking, listening, lifting (up to 50 pounds), carrying, seeing (such as close, color, and peripheral vision, depth perception, and adjusted focus), sitting for long periods of time (up to 8 hours), pulling, walking, standing, squatting, kneeling, and reaching.
The incumbent for this position may operate any or all of the following: telephone, copy and fax machines, calculator, computer terminal, personal computer, and related printers.
MENTAL DEMANDS
The incumbent in this position must be able to read documents or instruments, perform detailed work and problem solving, possess excellent member contact and verbal and written communication skills, have strong math and analytical reasoning skills, and the ability to effectively handle stress, multiple concurrent tasks, and constant interruptions.
POSITION REQUIREMENTS
These specifications are general guidelines based on the minimum experience normally considered essential to the satisfactory performance of this position. The requirements listed below are representative of the knowledge, skill, and/or ability required to perform the position satisfactorily. Individual abilities may result in some deviation from these guidelines.
- Bachelor’s degree from a four-year college or university; or five (5) to eight (8) years of related experience and/or training; or the equivalent combination of education and experience. with the implementation, operation, programming, and support of software applications or an equivalent combination of education and experience.
- Two (2) to Five (5) years of experience with a visualization tool such as Spotfire, Power BI, Tableau, etc. Experience with Spotfire is preferable.
- Two (2) to Five (5) years of experience with SSIS and SSRS.
- Must have basic knowledge of Microsoft Excel and Microsoft Word.
- Proficient user of SQL, and other programming languages. An understanding of Episys and Advanced Reporting for Credit Unions is a plus (ARCU). Ability to use those languages to build statistical models and complete various analytical projects for marketing, underwriting, member solutions, and support internal product development projects.
- In-depth expertise in data mining, predictive modeling, forecasting, machine learning, data mapping, and statistical analysis using CRISP-DM. Ability to design and build data sets for predictive software systems. Ability to solve complex business problems utilizing a variety of statistical techniques.
- Capable of translating non-technical user requests into complex technical specifications and solutions that meet these requirements. Ability to read, analyze, and interpret technical manuals and resources to resolve problems.
- Familiar with standard concepts, practices, and procedures within a financial services environment. Have an understanding of related state and federal compliance regulations, credit union operational policies and procedures, and the credit union’s products and services.
- Must have the ability to articulate issues and make recommendations for solutions to achieve deliverables along with exceptional written communication skills with the ability to apply common sense to present complex data and analyses in an easy-to-understand, clear, and concise manner.
- Must be able to work in a general office environment and complete all assignments with minimal supervision.
- Should possess a strong commitment to providing excellent service to members.
- Excellent organization and time management skills, with the ability to multi-task, ability to work with limited supervision while performing duties, and be a strong team player. Relies on experience and independent judgment to plan and accomplish goals. Requires expert-level troubleshooting, problem-solving, and analytical skills.
- Excellent interpersonal skills and attitude, with the ability to apply common sense to carry out instructions and instruct others, interpret documents, understand procedures, write reports and correspondence, and speak clearly to members and employees.
The incumbent must be able to perform this position safely, without endangering the health or safety to individual or others.