Dieses Stellenangebot ist nicht mehr verfügbar
Business Intelligence Data Engineer
Pacific Service Credit Union
- United States
- United States
Über
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. 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 discretion 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) including stakeholder 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. 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.
Sprachkenntnisse
- English
Hinweis für Nutzer
Dieses Stellenangebot wurde von einem unserer Partner veröffentlicht. Sie können das Originalangebot einsehen hier.