Demo

SQL Developer

CityFirst Bank
Washington, DC Full Time
POSTED ON 2/23/2025
AVAILABLE BEFORE 5/21/2025

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 lending 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.4 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 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.
  • 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 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
  • 3 years experience with MS SQL Server (2012 or greater); T-SQL, 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
  • In-depth 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 problem-solving aptitude
  • Salary Description

    95,000 - $110,000, annually

    Salary : $95,000 - $110,000

    If your compensation planning software is too rigid to deploy winning incentive strategies, it’s time to find an adaptable solution. Compensation Planning
    Enhance your organization's compensation strategy with salary data sets that HR and team managers can use to pay your staff right. Surveys & Data Sets

    What is the career path for a SQL Developer?

    Sign up to receive alerts about other jobs on the SQL Developer career path by checking the boxes next to the positions that interest you.
    Income Estimation: 
    $81,298 - $105,685
    Income Estimation: 
    $101,449 - $132,468
    Income Estimation: 
    $101,449 - $132,468
    Income Estimation: 
    $124,087 - $161,899
    Income Estimation: 
    $141,014 - $186,880
    Income Estimation: 
    $180,084 - $244,913
    Income Estimation: 
    $64,949 - $84,690
    Income Estimation: 
    $81,298 - $105,685
    View Core, Job Family, and Industry Job Skills and Competency Data for more than 15,000 Job Titles Skills Library

    Job openings at CityFirst Bank

    CityFirst Bank
    Hired Organization Address Inglewood, CA Full Time
    WHO WE ARE City First Bank N.A. is a mission-driven Community Development Financial Institution (CDFI) principally focus...
    CityFirst Bank
    Hired Organization Address Washington, DC Full Time
    WHO WE ARE City First Bank N.A. is a mission-driven Community Development Financial Institution (CDFI) principally focus...

    Not the job you're looking for? Here are some other SQL Developer jobs in the Washington, DC area that may be a better fit.

    SQL Developer

    Go Intellects Inc, Washington, DC

    SQL and C# Developer

    Creative Information Technology, Inc., Upper Marlboro, MD

    AI Assistant is available now!

    Feel free to start your new journey!