SQL Developer
SQL Developer
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
$ 95000 - 110000
1 Vacancy
Job Description
WHO WE ARE
City First Bank N.A. is a missiondriven 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 NotforProfit 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 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 is also responsible for ensuring high levels of availability through support functions and indepth 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.
- Document solutions and maintain information libraries and data dictionaries.
- Create and manage ETL processes to automate and support integration between applications.
- Collaborate with Business Process & Integration Manager and Analyst to define reporting requirements.
- Support ad hoc business data requests by understanding requirements and developing queries/ SSRS reporting to present necessary data.
- Stay uptodate on the latest Technologies Processes and IT advancements to automate and modernize systems.
- Performs other duties as assigned.
EDUCATION & EXPERIENCE
Required Education/Experience:
- Bachelors degree in computer science information management or the equivalent combination of education and work experience
- 3 years experience with MS SQL Server 2012 or greater); TSQL SQL Server Integration Services (SSIS) SQL Server Reporting Services (SSRS) Microsoft Power BI and SAP Business Objects.
- Experience using dynamic SQL Triggers Functions Stored Procedures Constraints and Flow Control.
- Strong understanding of data modeling Query Optimization and enterprise database concepts.
- 3 years banking industry experience with strong knowledge of lending/deposit product
CERTIFICATIONS
- Not applicable
KNOWLEDGE SKILLS AND ABILITIES
Required Knowledge & Skills:
- Background in data warehouse design (e.g. dimensional modeling) and data mining
- Indepth understanding of database management systems online analytical processing (OLAP) and ETL (Extract transform load) framework
- Familiarity with BI technologies (e.g. Microsoft Power BI Oracle BI)
- Knowledge of SQL queries SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS)
- Analytical mind with problemsolving aptitude
Employment Type
Full-Time
