Business Intelligence Developer
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. 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. 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 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 an email 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.