Apply on Employer Site

Pacific Service Credit Union · 3 months ago

Business Intelligence Data Engineer

Concord, CA, US

Full-time

Onsite

Entry, Mid Level

$100K/yr - $131K/yr

2+ years exp

Pacific Service Credit Union is committed to putting people first, including its members and employees. The Business Intelligence Data Engineer will gather requirements, design and develop ETL processes, and create data visualizations to support data-driven decision-making across the organization.

BankingCreditFinancial Services

Comp. & Benefits

Responsibilities

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 discretion 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

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

Qualification

SQLPowerBIETL designData visualizationAzure PortalSSISSSRSSSASDimensional modelingCollaborationEffective CommunicationProblem solvingOrganizational skillsTime management

Required

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

Bachelor's degree from an accredited university or college in Computer Science, MIS, Mathematics or related field required

Preferred

Experience with Credit Unions and/or financial institutions is highly preferred

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

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.