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 VP 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: Designing, developing and maintaining business intelligence solutions. Crafting and executing queries upon request for data. Presenting 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. Ability to use 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 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. Networks with others in the credit union industry and interface with vendors. Perform other related duties as assigned. 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. Continuing education a plus. EXPERIENCE: 4 - 6 years of experience with a financial institution. 3 - 5 years data warehouse management experience a plus. 2 - 3 year's systems administration experience a plus. Minimum 2 - 3 years' experience creating reports using SQL Server Reporting Services (SSRS) or Crystal Reports, writing complex stored procedures and functions. Experience with Tableau or Power BI a plus. 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. 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. Continuing education a plus. EXPERIENCE: 4 - 6 years of experience with a financial institution. 3 - 5 years data warehouse management experience a plus. 2 - 3 year's systems administration experience a plus. Minimum 2 - 3 years' experience creating reports using SQL Server Reporting Services (SSRS) or Crystal Reports, writing complex stored procedures and functions. Experience with Tableau or Power BI a plus. 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.