What are the responsibilities and job description for the SQL Developer II position at City First Bank N.A.?
Description
WHO WE ARE
City First Bank N.A. is a mission-driven Community Development Financial Institution (CDFI) principally focused on a transformative impact in underserved, urban markets with the highest needs to drive equitable economic development. Our credit activities are purely commercial and focused on the following segments: Multifamily Affordable Housing, Not-for-Profit Finance, and Small Business Finance. As a depository and commercial lending provider with over $1.3 billion in bank assets as of December 31, 2024, our unified organization has over 100 employees in Washington DC and Los Angeles/Inglewood, CA.
ROLE SUMMARY
The position of the SQL Developer II is responsible for designing, developing and maintaining business intelligence solutions; creating and maintaining key organizational reports and data models and supporting the organizations growing analytical needs. The SQL Developer II is also responsible for ensuring high levels of availability through support functions and in-depth testing.
ESSENTIAL FUNCTIONS AND RESPONSIBILITIES
- Translate business needs into technical specifications in order to develop and implement robust, automated solutions for extracting, transforming, normalizing and integrating information from disparate data sources.
- Design, build and deploy business intelligence solutions including dashboards, reports and data extracts.
- Develop comprehensive views, functions, and procedures to support data analytics and reporting functions.
- Design, develop, and maintain SQL queries, procedures, and reports to support business operations and decision-making.
- Leverage advanced Microsoft Excel skills (including formulas, pivot tables, lookups, and complex calculations) to analyze and present data.
- Integrate and manage data within SharePoint to ensure accessibility, accuracy, and consistency across teams.
- Provide timely responses to data requests, report updates, and ad hoc analysis with accuracy and attention to detail.
- Work independently with minimal supervision, demonstrating accountability, initiative, and the ability to manage multiple priorities.
- Ensure compliance with company policies, data security standards, and confidentiality requirements.
- Document solutions and maintain information libraries and data dictionaries.
- Create and manage ETL processes to automate and support integration between applications.
- Collaborate with manager and various personnel to define reporting requirements.
- Support ad hoc business data requests by understanding requirements and developing queries/ SSRS reporting to present necessary data.
- Stay up-to-date on the latest Technologies, Processes and IT advancements to automate and modernize systems.
- Performs other duties as assigned.
Requirements
EDUCATION & EXPERIENCE
Required Education/Experience:
- Bachelor’s degree in computer science, information management, or the equivalent combination of education and work experience.
- 5 years experience with MS SQL Server (2012 or greater), T-SQL Programming, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Azure Data Factory, Microsoft Power BI and Cognos Analytics.
- Experience using dynamic SQL, Triggers, Functions, Stored Procedures, Constraints and Flow Control.
- Strong understanding of data modeling, Query Optimization and enterprise database concepts.
Preferred Experience:
- Banking industry experience with strong knowledge of lending/deposit product.
CERTIFICATIONS
- Not applicable
