Anywhere APGFCU – Your Community Credit Union! For over 80 years, APGFCU has shared our financial experience and provided valuable products and services to build stability and financial independence, one member at a time.We are looking for those who want to join this movement and become a part of a growing organization.We offer competitive pay and great benefits.
SUMMARY:Reports to the Vice President of Project Management/Business Applications, with responsibility for development, maintenance, integration, data governance and data reporting. The day to day support includes, but is not limited to, coding, testing, debugging, designing, implementing newly developed tools, researching, and planning solutions for existing problems and identifying future opportunities for the credit union. As a primary focus for this position, BI developers must always be mining data and presenting it in an understandable way in order to positively affect tactical plans and achieve corporate objectives.
Essential Duties and Responsibilities:
- Design, develop and maintain business intelligence solutions.
- Craft and execute queries upon request for data.
- Present information through reports and visualization.
- Responsible for building an efficient infrastructure to deliver data to end users.
- Serve as subject matter expert (SME) for the organizations data, both structure and meaning.
- Create, enhance and modify systems using software development kits.
- Design and build “extract, transform, load” (ETL) workflows resulting in either a systems integration and / or business intelligence source table from multiple data sources.
- Provide technical and systems design expertise in the development of new and maintenance of existing databases.
- Utilize analytical programs to analyze data from different sources and produce meaningful reports and/or presentations.
Technological Responsibilities:
- Create data models, visualizations, charts, tables, and other report part objects for use by non-technical users in self-service reporting tools such as Jaspersoft, XML, SQL, Crystal Reports and Java Script.
- Provide detailed analysis, design, tuning, testing, implementation and documentation of the business intelligence system and data warehouse.
- Provide expertise in writing and editing queries that read, manipulate, and analyze data from business intelligence, relational databases, and data warehouses.
- Perform data analysis with appropriate programming and analytic methodologies; present data or reports in a meaningful fashion; work collaboratively with teams and leadership; formulate recommendations for further initiative refinement based on current data evidence.
- Responsible for business intelligence quality testing, stakeholder approval and user acceptance testing.
- Conduct periodic analysis of infrastructure and application performance and contribute to the annual IT strategic plan.
- Provide support for and implement data driven technologies and platforms such as workflow and CRM tools.
- Write and edit automated jobs that import and export data between systems.
Strategic Responsibilities:
- Constant mining of data and presenting it in an understandable way creating an environment easily accessible for end-users.
- Work directly with organizational leadership on defining data needs and provide guidance to meet business objectives.
- Review deliverables for quality, completeness, compliance to standards and adherence to approach.
- Work in a team environment to achieve goals and to optimize reporting practices.
Reporting/Communications:
- Make solid recommendations based on the analysis and provide explanations for reporting results.
- Provide end user support for reporting tool usage and data interpretation.
- Create tables and write reports on their findings, validating data output through SQL, Crystal Reports and/or Java Script and simplify highly technical language for end users in the company.
Professional Development:
- Remain current with developments in the information technology field and their potential impact on the credit union’s present and future needs.
- Continue technical professional development through seminars and workshops, membership in technical and professional organizations, and through reading technical publications and journals.
- Network with others in the credit union industry and interface with vendors.
Perform other related duties as assigned.
ADDITIONAL: Responsible for completion of applicable training and compliance on federal regulations and APGFCU policies and procedures as related to the duties of this position (Bank Secrecy Act, Information Security as examples, if applicable).
QUALIFICATIONS:
EDUCATION:Bachelor’s Degree in Information Technology or related field is required.Experience can be credited in lieu of education.Specialized training pertaining to the system in place.
EXPERIENCE:Four to six years of experience with a financial institution required. Three to five years data warehouse management experience required. Two to three year’s systems administration experience a plus. Minimum two years’ experience creating reports using SQL Server Reporting Services (SSRS) or Crystal Reports, HTML, XML, writing complex stored procedures and functions. Experience with Jaspersoft, Tableau or Power BI required.Intermediate level of programming knowledge (reporting code) and of relational databases, database structures and design, systems design, data management, data warehouse a plus.Education may be substituted in lieu of experience.High proficiency in PC related skills.Experience with Excel required.
KNOWLEDGE, SKILLS, AND ABILITIES: Extensive knowledge and hands-on experience of managing a business intelligence/data warehouse system.Demonstrates knowledge of commonly-used concepts, practices, and procedures. Analytical skills required, including a thorough understanding of how to interpret end-user business needs and translate them into application and operational requirements.Excellent verbal and written communication skills.Possesses effective interpersonal skills to effectively elicit technical information from the non-technical end-user.Demonstrated ability to manage end user expectations. Ability to manage people, timelines, and budget in accordance with standard business intelligence/data warehouse methodology. Expert knowledge and a demonstrated understanding of the general interoperability of financial industry business systems and processes, as well as a current knowledge and general understanding of financial product/service advancement and operating trends.
PHYSICAL DEMAND: 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 the essential functions.While performing the duties of this job, the employee is regularly required to stand; walk; use hands to finger, handle, or feel objects, tools, or controls; and talk or hear.The employee frequently is required to reach with hands and arms.The employee is frequently required to sit, stoop, kneel, or crouch.The employee must frequently lift and/or move up to 25 pounds, and be capable of transporting related supplies and equipment.Specific vision abilities by this job include vision, distance vision, color vision, peripheral vision, depth perception and the ability to focus.
Excellent Employee Benefits:
- 401K
- Pension Plan
- Medical, Dental, and Visual Plan
- Annual Leave, Sick and Holidays
- Tuition Reimbursement
APGFCU is an Equal Opportunity/Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability to Protected Veteran status. Please use the attached link to view the EEO law poster http://www1.eeoc.gov/employers/poster.cfm
APGFCU is committed to working with and providing reasonable accommodations to persons of all abilities, including persons with disabilities.If you need a reasonable accommodation for any part of the employment process, please send to the Human Resources Department and let us know the nature of your request and your contact information. Reasonable accommodations are considered on a case-by-case basis. Please note that only inquiries concerning a request for reasonable accommodations will be responded to from this e-mail address.
Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities
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)