Sr. Developer (Business Intelligence and Database)
IT | San Francisco, CA | Full Time | From $60.00 to $65.00 per hour
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
· Proven expertise with Corelation’s KeyStone core banking system, including environment management (Production, UAT), configuration, upgrades, and integrations.
· Strong proficiency in Java, and API integration, with hands-on experience using KeyBridge API.
· Advanced skills in SQL and database development, including performance tuning, CTE optimization, stored procedures, and complex query design.
· Experience developing and maintaining ETL processes, data models, and data integration pipelines across multiple systems.
· Proficiency in Jaspersoft report design, automation, and scheduling.
· Strong working knowledge of Power BI, and other business intelligence and visualization tools.
· Familiarity with data warehousing, data governance, and data security best practices.
· In-depth understanding of banking and credit union operations, particularly data flows within KeyStone environments.
· Experience with core banking data structures, financial reporting, and system integration between KeyStone and third-party services.
· Excellent analytical and diagnostic abilities for resolving KeyStone-related and data-centric technical issues.
· Strong attention to detail, accuracy, and system reliability, with a proactive approach to process optimization.
· Exceptional interpersonal and communication skills with the ability to collaborate effectively with both technical and business stakeholders.
· Ability to translate business requirements into scalable, maintainable technical solutions.
· Capable of managing multiple projects simultaneously with minimal supervision.
· Self-motivated, organized, and committed to high-quality work and continuous improvement.
· Demonstrated ownership, accountability, and adaptability in a fast-paced technical environment.