PMCU at this time does not offer VISA Sponsorship of any kind. This is a full-time position working 40 hours a week, hours Monday-Friday 8:00am – 5:00pm. POSITION SUMMARY:Responsible for aggregating data from multiple sources in an efficient data warehouse and designing solutions for line of business units. The Business Intelligence Developer will build dashboards and reports utilizing Power BI and other tools. The developer will also design and develop self-reporting solutions for the line of business. This position is expected to proactively identify meaningful data, metrics and gaps to improve credit union operations, member service and regulatory/policy compliance. Ideal candidates for this position are adept at seeing beyond the initial request and exploring the opportunities and risks beyond what is being directly requested while delivering on deadlines. This position will be required to make recommendations to staff, including executive management, defend and explain complex technical information concisely and completely in a way that supports organizational decision makers. ESSENTIAL FUNCTIONS:Write/Modify/Troubleshoot SQL code to develop data queries per end-user specificationsReview Performance and security of SQL systems to ensure optimal performance and integrityDesign and implement scalable architecture for self-service reporting solutionsCreate dashboards for the line of business using Power BIMeet with internal line of business users to gather business requirementsOversee stability, performance and integrity of Enterprise data warehouseAdhere to corporate standards, policies and proceduresGenerate and maintain data dictionary and ensure enterprise data integrity and alignmentChampion data integrity, consistency and clarity throughout the organizationIndependently coordinate with vendors and business units to achieve desired resultsProactively identify opportunities for improvement within credit union processes, business intelligence practices and future and emerging technologies that benefit the credit union and its members.Write short procedures including but not limited to ETL Processing, Report Development, Business Requirement DefinitionsResolve end user reporting problems through collaboration with IT and line of businessesResponsible for related duties as required or assignedServe as senior position of the business intelligence division developing repeatable and complete documentation of reporting processes, data sets and data architecture, accepting responsibility for championing organizational objectives. QUALIFICATIONS: Education/Certification: 4-year college degree or equivalent work experienceRequired Knowledge: 2 years Data Warehousing utilizing SSAS or other OLAP toolsetExcel- strong Excel skill, including pivots; VBA a plus, but not requiredOutlook- ability to schedule appointments, check conflicts, etc. Experience Required:Five years to eight years of similar or related experience, including preparatory experience. 2 to 5 years Transact SQL experience2 years of experience with T-SQL or other report writing language requiredPrevious experience overseeing and managing data visualization tools such as Tableau, PowerBI or similar2 – 5 years’ Experience in ETL (Extract, Transform, Load) and ELT (Extract, Load, Transform) processes, with a proven track record of optimizing data workflows and ensuring seamless data integration. Skills/Abilities:Skilled in data architecture design, implementation, and optimization, with a comprehensive understanding of database management, data modeling, and system integration to support robust and scalable data solutions. Problem solving, analytical and communication skills requiredProven ability to gain deep business insight and make recommendationsProven ability to listen to the needs of different groups and develop amicable relationship with a wide range of personalities at all levels in the organizationAbility to diplomatically and professionally communicate with all members of the organizationExcellent written and verbal communication skills. Demonstrated ability to convey information clearly, accurately, concisely and timely in consideration of audience and mediumStrong organizational and time management skillsPresentation skills WORKING CONDITIONSStandard office conditionsLow to moderate noiseLimited lifting up to 50 lbs. This description has been reviewed to ensure that only essential functions and basic duties have been included. Peripheral tasks, only incidentally related to each position, have been excluded. Essential functions, requirements, skills, and abilities included have been determined to be the minimal standards required to successfully perform the positions. In no instance, however, should the duties, responsibilities, and requirements delineated be interpreted as all-inclusive. Additional functions and requirements may be assigned by supervisors as deemed appropriate. In accordance with the Americans with Disabilities Act, it is possible that requirements may be modified to reasonably accommodate disabled individuals. However, no accommodations will be made which may pose serious health or safety risks to the employee or others or which impose undue hardships on the organization.The Credit Union believes that each employee makes a significant contribution to our success. That contribution should not be limited by the assigned responsibilities. Therefore, this job description is designed to outline primary duties, qualifications, and job scope, but not limit the incumbent. It is our expectation that each employee will offer his/her services wherever and whenever necessary to ensure the success of our endeavors. Job descriptions are not intended as and do not create employment contracts. The organization maintains its status as an at-will employer. Employees can be terminated for any reason not prohibited by law. This Job Description is not a complete statement of all duties and responsibilities of this position and may change with or without notice.