Business Intelligence Data Engineer

Pacific Service Credit Union • Concord, CA

5h • Hybrid

About The Position

At Pacific Service Credit Union, we are committed to strategic growth through trust, innovation, and operational excellence. By empowering our internal teams with the tools and support they need to succeed, we strengthen organizational efficiency, ensure compliance, and advance our mission of enhancing 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.

This role requires an organized and dependable individual with strong communication skills and the ability to complete tasks accurately and on time. The position supports the team and organization by assisting with day-to-day activities, completing assigned projects, and contributing to efforts that advance organizational goals and uphold core values, while enhancing member/service outcomes.

Requirements

• Bachelor’s degree from an accredited university or college in computer science, MIS, mathematics, or related field, required.
• Demonstrated ability to collaborate effectively across business and technical teams to coordinato tasks and achieve shared objectives.
• Ability to establish and maintain positive and effective work relationships with management, coworkers, and business users, consistently delivering high-quality results. 
• Strong problem-solving, critical thinking, organizational, and time management skills.
• Two to three years of recent experience working as a Data Engineer.
• Two to three years of experience writing advanced SQL queries.
• Two to three years of experience designing reports, dashboards, and data visualizations using Power BI, Tableau, or equivalent tools.
• Demonstrated experience working with cloud technologies, required.
• Excellent oral and written communication skills, required.
• Must be proficient in computer programs (e.g., Microsoft Office Suite).

Nice To Haves

• Experience within credit unions and/or financial institutions, strongly preferred.
• Demonstrated ability to work independently, with minimal supervision and ability to manage multiple concurrent efforts.
• Ability to perform effectively under tight delivery deadlines with strong attention to detail.

Responsibilities

• Apply strong business acumen and technical knowledge to partner with PSCU leadership to understand strategic goals, business requirements, and operational challenges, and to design BI solutions aligned with organizational priorities.
• Consult with business leaders to elicit, analyze, and document business requirements, translating complex needs into effective BI and reporting solutions.
• Provide actionable insights and analytical reporting to support data-driven decision-making for executives and teams across the organization.
• Exercise discrection and independent judgement to design, develop, and deliver Microsoft PowerBI reporting solutions for stakeholders.
• Transform complex data into intuitive, interactive dashboards, reports, and visualizations that support collaboration and strategic decision making.
• Create and deliver PowerBI data visualizations, ensuring insights are clearly translated and effectively communicated to technical and non-technical audiences.
• Design and implement innovative solutions leveraging database software and reporting tools.
• Perform responsibilities using system development lifecycle (SDLC) includingstakeholder requirement elicitation, prototyping, develop code, conduct UAT, and deliver data visualizations in PowerBI reports.
• Own the User Acceptance Test (UAT) process by developing test plans, defining testing scenarios and acceptance criteria, and overseeing the execution of UAT case testing.
• Develop and program complex SQL stored procedures, views, and functions using Transact Structured Query Language (T-SQL), efficient coding techniques, and industry best practices.
• Provide procedural programming expertise within the SQL Server, writing efficient and optimized SQL queries, and clear, well-documented, and readable code.
• Maintain SQL queries, procedures, and program code using source control tools and adhere to established change management process for migration.
• Promote advanced software and data management practices, including complex data operations, modularity, and reusability; ensure data integrity through secure data access interfaces; and facilitate prototype testing to accurate and efficient implementation of software modifications.
• Independently transform complex data into interactive reports, dashboards, and visual formats to support collaboration and sharing among stakeholders.
• Contribute to company 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. 
• Demonstrate dependable performance including attendance and punctuality, recognizing that it is essential to organizational excellence and operational success.
• Comply with all anti-money laundering laws, including the Bank Secrecy Act, OFAC regulations, and the USA PATRIOT Act, as well as all related policies and procedures.
• Provide back-up and support to management, as directed.
• Performs special projects and other responsibilities, as directed.

Benefits

• 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.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level