Sr. Developer (Business Intelligence and Database)

Job Description

Job Description

Who Are We? With an “A” health rating and solid year-over-year growth, San Francisco Federal Credit Union’s (SFFedCU) membership is now over 43,000 with assets surpassing $1.3 billion and branches located in San Francisco and San Mateo County. Continuing along it highly successful growth trajectory, SFFedCU is seeking a Sr. Developer (Business Intelligence and Database) for our Golden Gate Branch in San Francisco. The Position The Sr. Developer (Business Intelligence and Database) will play a crucial role in leveraging data to drive informed business decisions and manage Keystone banking core. This position involves designing, developing, and maintaining business intelligence solutions, as well as implementing and maintaining the Keystone banking core system and databases. The successful candidate will collaborate with cross-functional teams to gather requirements, design data models, and develop visualizations that empower stakeholders to make data-driven decisions. Responsibilities

• Maintain and Manage KeyStone environments (Production, UAT etc) to implement new products and services as per business needs including integration with 3rd party services. Also maintain the backend servers and installations and data management solutions, working with vendors
• Develop and maintain Batch programs integrating with KeyBridge API to manage and data processing including CRUD.
• Create and manage Jaspersoft report based on business needs including building scheduled reports for data extracts for business process automation. Create, optimize and maintain complex SQL queries and CTE-based reusable scripts for efficient data retrieval.
• Technical support for diagnosing and resolving Keystone issues in production environments to ensure system stability and customer satisfaction.
• Design and develop data models that support business processes and reporting requirements.
• Work with stakeholders to understand data needs and ensure integrity and accuracy of data architecture.
• Develop ETL processes to extract data from various sources, transform it into a usable format, and load it into data warehouses or other storage solutions.
• Integrate data from diverse sources to create a unified view for reporting and analysis.
• Build and maintain dashboards, reports, MS SharePoint, and visualizations using Power BI to present insights to stakeholders.
• Collaborate with business analysts, data scientists, and other stakeholders to understand business requirements and translate them into technical solutions.
• Implement data quality and governance standards to ensure the accuracy and reliability of data used for reporting and analytics.
• Optimize queries, processes, and data models for improved performance and efficiency.
• Document data models, ETL processes, report solutions to ensure knowledge transfer and maintainability. Maintain up-to-date documentation for configurations, procedures, and troubleshooting guides.
• Provide training and support to end-users on KeyStone, BI tools and data analytics platforms.
• Perform other duties commensurate to this position.

Who Are You? Requirements, Skills, and Abilities

Why You’ll Love It Here You’ll work alongside a passionate team in a mission-driven organization, get exposure to executive decision-making, and grow your skills across a broad range of functions. No two days will be the same—and that’s exactly how you like it.The compensation package includes an excellent benefits program including health insurance plans, generous PTO, 401(k) Plan, profit sharing, competitive base, bi-annual bonuses, as well as tuition reimbursement.SFFedCU is an Equal Employment Opportunity Employer. In accordance with federal and state laws, SFFedCU does not discriminate in employment because of race, color, religion, sex, national origin, age, physical and mental disability, marital status, pregnancy, childbirth, breastfeeding or related condition, ancestry, medical condition (associated with cancer, a history cancer or genetic characteristics), veteran or military status, sexual orientation, gender, gender identity or gender expression, HIV / AIDS status, genetic information or any other characteristic protected by law.Pursuant to the San Francisco Fair Chance Ordinance, we will consider for employment qualified applicants with arrest and conviction records.