IT Business Intelligence Analyst I

Overview

INFORMATION TECHNOLOGY:

GreenState’s Information Technology department adheres to the corporate values and acts as a business partner who understands the needs of the business, enables business units to meet strategic objectives through technology, and provides employees and members with quality technology platforms that are always available, always relevant, and always scalable.

POSITION SUMMARY:

The Business Intelligence Analyst I is responsible for development, summarizing and presenting financial and business information to the credit union team from various reporting environments such as our database and data warehouse, financial ledger systems and 3rd party environments. With general and specific guidance, the BIA will conduct and present financial analysis and utilize data to identify process gaps and help implement master data management processes.

GREENSTATE CULTURE:

At GreenState, we exist to create lasting value for those we serve. We do this by putting immense value into our employees, members and communities. We empower our employees to create endless opportunities, which will then impact the lives of our members and enhance the vitality of our communities.

Salary range for this position is $103,793.30 - $138,917.48 with a progressive benefit package.

Performs essential duties and responsibilities in the following areas which may include, but are not limited to those listed and are subject to change:

1. Adheres to the Credit Union's core values and Service Standards in carrying out GreenState's mission and vision.
2. Demonstrates a positive member service (internal and external) focus at all times.
3. Demonstrates teamwork in all interactions with coworkers and in the completion of all duties and responsibilities.
4. Ensures confidentiality of member information.
5. Supports a diverse and inclusive work environment.
6. Presents a professional image from a personal and professional level that will be beneficial to both the Credit Union and GreenState Wealth Management.
7. Works with stakeholders to develop and/or modify reporting or processes to resolve simple business problems by using IT solutions, includes analysis of business and user needs, documenting business requirements and translating business requirements into functional solutions.
8. Develops reports, visualizations, and custom extracts using business intelligence tools including, but not limited to SQL Server Management Studio, Episys PowerOn, SQL Server Reporting Services, R, Python, Excel Power Query and Power BI.
9. Develops stored procedures, views, custom tables, and defined business rules for reporting and analytic solutions. Develop a combination of simple to complex SQL queries to fulfill stakeholder’s requests.
10. Evaluates and works to improve the capabilities of Business Intelligence tools through new methodologies, technology, and data management. Review reports to improve accuracy, functionality, and consistency.
11. Integrates data sources from multiple systems to provide seamless reporting. Understand database relationships and interconnections among data sources. Maintain and enhance data integrity of all information connection through the Data Warehouse.
12. Analyzes data extracted from the database and validate accuracy of data and collaborates with other Power BI Pros within the organization to resolve data integrity issues.
13. Assists in the coaching and development of Power BI Pros throughout the organization.

JOB REQUIREMENTS:

1. Bachelor’s Degree in Computer Science, Business Administration, Management Information Systems or related field, or equivalent combination of training and experience of at least six years, with three years of experience in report creation.
2. Proficiency in business intelligence tools such as SQL, Qlik, SSRS, R, Python, Excel Power Query and Power BI.
3. Ability to work with multiple data sources and validate accuracy of information.
4. Basic understanding of data modeling to assist DBA in development of new source data models to align with existing DW.
5. Inquisitive nature for data discovery and aligning solutions to business needs.
6. Ability to prioritize and organize a wide variety of assignments and duties and large volumes of details.
7. Excellent analytical and problem-solving skills.
8. Experience in the financial industry a plus but not required.
9. Interpersonal skills to promote and represent the credit union and its products.
10. Must be able and willing to work a flexible schedule as needed to accomplish all duties.

PI11e5fd58c0b9-37344-36297856