Business Intelligence Data Engineer

Pacific Service Credit Union•Concord, CA

96d

About The Position

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.

Requirements

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.

Nice To Haves

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.

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

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.

Stand Out From the Crowd

Upload your resume and get instant feedback on how well it matches this job.

Upload and Match Resume