Working for Pacific Service Credit Union
We put people first. That includes our members, our employees and the communities we serve. We hire energetic and enthusiastic people who want to work as part of our team.
What’s in it for you?
Health insurance coverage: We provide our employees with 100% premium employer-paid medical, dental, vision, disability and basic life insurance for full-time employees and a low monthly premium for eligible dependents.
401k: We contribute 3% of your base salary to your 401k account regardless of whether you contribute or not. In addition, we match 75% of your contributions up to the first 3% of eligible compensation beginning after your first day of employment and up to 6% after three years of service.
Bonus program: All employees are rewarded for attaining our annual organizational goals.
Tuition Reimbursement program for employees eligible after six months of service.
Recognition program where employees can be nominated by management, their peers or by members.
Employee referral bonus.
Student Loan Repayment Assistance: Contributions toward your student loans every month by the credit union after six months of service.
Employees are eligible to receive a consumer loan rate discount
Vacation and sick time: Full-time employees receive more than two weeks’ vacation per year, 11 paid holidays and 10 days of sick leave.
Our Hiring Process
We believe it’s important for you to know where you stand in our hiring process. Below is an outline of the steps we take to make the best hires possible.
Apply: Submit your resume for one of our job openings.
Our Talent Team and our partner – Total Quality Consulting (TQC Team) will review your submitted information and will call or email successful applicants for an interview as soon as possible.
In-Person Interview: After a screening call with TQC, we’ll invite a final number of candidates to our office for an in-person interview or set up a live Zoom meeting with the hiring manager(s).
If we believe that you have what it takes, we'll make an offer and provide next steps in the hiring process!
At Pacific Service Credit Union, we uphold trustworthy practices, deliver innovative solutions, and provide exceptional support to our internal teams. Every employee contributes to operational excellence, efficiency, and compliance, driving our success and member financial well-being.
The Business Intelligence Data Engineer is knowledgeable with requirement gathering, stored procedure design and development, ETL design and development, multidimensional/tabular model design and development, assisting users with UAT, and a heavy emphasis on visualization and report development.
Works within the Microsoft Technology Stack, including Azure Portal, SSMS, SSIS, SSRS, SSAS, and PowerBI, requiring knowledge of star schemas and dimensional modeling concepts. The position will support a culture of data-driven decision-making by democratizing access to data, ensuring the quality of data, reporting, and tools, and supporting stakeholders with guidance on how to use them.
Essential Job Functions
-
Develop and program complex SQL stored procedures, views, and functions using Transact Structured Query Language (T-SQL), efficient coding techniques, and programming best practices.
-
Utilizes business acumen and strong technical knowledge to partner with PSCU leadership to understand strategic goals, business requirements, and operational blocks and design BI solutions to ensure strategic alignment to meet PSCU’s strategic priorities.
-
Uses discrection and independent judgement to develop Microsoft PowerBI reporting solutions for our stakeholders.
-
Consult with business leaders to develop business requirements for BI solutions.
-
Provide business information for data-driven decision-making and reporting to support executives and teams from across the organization.
-
Maintain SQL queries, procedures, and programming code using source version control tools and follows change management process for migration.
-
Create and deliver data visualization in PowerBI, ensuring that insights are translated and effectively communicated.
-
Independently act to transform complex data into interactive reports, dashboards, visual formats for the use of collaboration and sharing among stakeholders.
-
Promote critical complex software management procedures such as complex data operations and promote modularity and reusability, ensure data integrity rules by providing a secure interface for data access, and facilitate prototype testing to ensure software modifications are implemented correctly and efficiently.
-
Perform duties using system development lifecycle (SDLC): Elicit requirements from stakeholders, create prototypes, develop code, conduct UAT, and deliver data visualizations in PowerBI reports.
-
Invent solutions, leveraging database software and reporting tools.
-
Own the User Acceptance Test (UAT) which entails developing the UAT test plan, defining testing scenarios, and determining guiding criteria and overseeing the execution of UAT case testing.
-
Provide procedural programming capabilities within the SQL Server, writing efficient and optimized SQL queries, and clear, readable code.
-
Maintain regular and reliable attendance, including punctuality, are essential to achieving organizational excellence.
Supporting Functions
-
Create training and knowledge transfer of technology to the business.
-
Creative problem-solving that combines innovative and comprehensive data-driven solutions.
-
Drive innovation and continuous improvement. Foster a culture of evolution by adapting to changes, optimizing processes, and contributing to the growth and success of the organization.
-
Demonstrate accountability in your work by taking ownership of responsibilities, setting clear goals, meeting deadlines, and delivering high-quality results. Act with integrity, follow through on commitments, and uphold professional standards.
-
Support and uphold company culture by aligning your work with the credit union’s mission and values, contributing to a positive, high-performing environment. Serve as a role model for professionalism, collaboration, and the pursuit of excellence.
-
Maintain regular and reliable attendance, including punctuality, are essential to achieving organizational excellence.
Competencies
The following competencies are essential for success in this role:
-
Collaboration: Establishes and maintains effective relationships, exhibits tact and consideration, displays positive outlook and pleasant manner, offers assistance and support to co-workers, works cooperatively in group situations, works actively to resolve conflicts
-
Effective Communication: Expresses ideas and information in a clear and concise manner; tailors message to fit the interests and needs of the audience; delivers information in a manner that is interesting and compelling to the listener; keeps others adequately informed
-
Execution: Turns strategy into action, aggressively pursues challenging goals and objectives; willing to put in requisite time and effort to accomplish objectives; takes a highly focused, goal driven approach toward work; implements plans efficiently and produces desired results within a specified timeframe
-
Job Knowledge: Competent in required job skills and knowledge, exhibits ability to learn and apply new skills, requires minimal supervision, displays understanding of how job relates to others, uses resources effectively
-
Member/Customer Focus: Displays courtesy and sensitivity, manages difficult member/internal customer situations, meets commitments, responds promptly to member/internal customer needs, solicits feedback to improve service
-
Problem solving: Identifies and resolves problems in a timely manner, gathers and analyzes information skillfully, develops alternative solutions, resolves problems in early stages, works well in group solving situations
-
Quality of work: Demonstrates accuracy and thoroughness; critically reviews work processes to ensure quality; identifies and resolves problems that could impact quality; makes sure deliverables and services meet all requirements, expectations and deadlines; does not make the same mistakes twice
These competencies are essential to upholding our values and delivering exceptional service to our internal and external members.
Minimum Qualifications
-
2-3 years’ recent experience working as a Data Engineer, 2-3 years’ experience advanced SQL query writing, 2-3 years’ experience designing reports, dashboards, and visualizations in PowerBI/Tableau equivalent interfaces, experience working in cloud technologies.
-
Experience with Credit Unions and/or financial institutions is highly preferred
-
Bachelor’s degree from an accredited university or college in Computer Science, MIS, Mathematics or related field required.
Preferred Qualifications
-
Ability to work independently, with minimal supervision and ability to manage multiple efforts concurrently.
-
Ability to work quickly and under tight delivery deadlines with focus on details.
-
Ability to establish and maintain positive and effective work relationships with management, coworkers, and business users. Demonstrated ability to produce high quality deliverables.
-
Excellent verbal and written communication skills, strong problem-solving and critical thinking skills, strong organizational and time management skills.
-
Effective collaboration of tasks across the business and technical teams.
Physical Requirements:
-
Ability to sit or stand at a desk for extended periods of time, with the option to adjust to a sit/stand desk to accommodate comfort.
-
Hearing Ability: Ability to hear and understand spoken communication, both in person and via phone.
-
Lifting and Carrying: Occasionally lift and carry materials such as files or office supplies weighing between 0 and 30 lbs.
-
Manual Dexterity: Proficient use of hands and fingers for typing, using office equipment, and handling documents.
-
Mobility: Ability to move around the office to attend meetings or assist colleagues as needed.
-
Verbal Communication Skills: Ability to speak clearly and effectively to communicate with internal and/or external members. Frequent use of telephone headset may be required.
-
Visual Acuity: Ability to view and read computer screens and related documentation with accuracy.
Hours and Travel
-
A work schedule of Monday through Friday, generally 8 a.m. to 5 p.m. Hours may fluctuate moderately to accommodate business needs.
-
Less than 5% local travel time required.
-
This position is eligible for the credit union's telecommute policy.
This job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee. Duties, responsibilities, and activities may change, or new ones may be assigned at any time with or without notice.
