Business Intelligence Data Engineer
Pacific Service Credit Union
- United States
- United States
Über
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.
ABOUT THIS ROLE:
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.
ESSENTIAL JOB FUNCTIONS: 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. SUPPORTING FUNCTIONS:
Provide back-up and support to management, as directed. Performs special projects and other responsibilities, as directed. COMPETENCIES:
The following competencies are essential for success in this role:
Job knowledge:
Demonstrates solid job expertise; learns and applies new skills effectively; works with minimal supervision; understands how work impacts others; uses resources efficiently.
Effective communication:
Communicates clearly and concisely; tailors messages to audience needs; engages listeners; keeps stakeholders informed.
Problem solving:
Identifies issues early; gathers and analyzes information effectively; develops alternatives; resolves problems promptly; contributes productively to group solutions.
Quality of work:
Delivers accurate, thorough work; proactively reviews processes; prevents recurring issues; ensures deliverables meet all standards, expectations, and deadlines.
Member focus:
Shows courtesy and professionalism; manages difficult situations constructively; meets commitments; responds promptly; seeks feedback to improve service.
Collaboration:
Builds strong working relationships; demonstrates tact and professionalism; supports others; works cooperatively; helps resolve conflicts productively.
Execution:
Translates strategy into action; pursues goals with focus and urgency; commits the necessary effort; implements plans efficiently and delivers results within required timeframes.
REQUIRED MINIMUM QUALIFICATIONS:
Education:
Bachelor's degree from an accredited university or college in computer science, MIS, mathematics, or related field, required. Experience:
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). PREFERRED QUALIFICATIONS:
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.
PHYSICAL REQUIREMENTS:
Hearing: Ability to hear and comprehend spoken communication in person and over the phone.
Vision: Ability to view computer screens and read documentation with clarity and accuracy.
Verbal Communication: Ability to speak clearly and effectively to interact with colleagues and/or members. Frequent use of telephone headset may be required.
Manual Dexterity: Proficient use of hands and fingers for typing, operating office equipment, and handling documents.
Posture and Endurance:
Ability to sit or stand at a workstation for extended periods; adjustable sit/stand desk options may be available to support comfort.
Mobility: Ability to move within the office environment to attend meetings or assist colleagues, as needed.
Lifting and Carrying: Occasionally required to lift and carry materials weighing up to 30 lbs.
OTHER INFORMATION:
Hours Required:
A work schedule of Monday through Friday, generally 8 a.m. to 5 p.m., with some alternate work schedules. This position is eligible for the credit union's telecommute policy.
Travel Requirements:
Less than 5% local travel required. Limited travel during the work schedule, primarily for training, meetings, or special projects.
Work Environment:
This position is based in a climate-controlled office environment with ergonomic workstations in a two-story building with an elevator. Subject to standard background noise found in an office environment. Natural light from large windows, supplemented by artificial lighting to ensure a comfortable working atmosphere.
DISCLAIMER:
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.
Sprachkenntnisse
- English
Hinweis für Nutzer
Dieses Stellenangebot stammt von einer Partnerplattform von TieTalent. Klicken Sie auf „Jetzt Bewerben“, um Ihre Bewerbung direkt auf deren Website einzureichen.