Business Intelligence Data Engineer

Job Description

Job Description

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

Competencies

The following competencies are essential for success in this role :

These competencies are essential to upholding our values and delivering exceptional service to our internal and external members.

Minimum Qualifications

Preferred Qualifications

Physical Requirements :

Hours and Travel

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.