Business Intelligence Developer

Capital Bank, N.A. - Horsham, PA (30+ days ago)

Capital Bank is a highly profitable, stable and growing Community Bank headquartered in the Washington, DC Metro area with an office located in Horsham, PA. We currently hold assets in excess of $1B and have been consistently ranked as one of the most profitable Bank's for our size (both locally and nationally) in the past few years.

Our VALUES - What We Believe and How We Behave:

  • Demonstrate Professionalism With our Customers
  • Act as An Owner
  • Function as One Team
  • Drive Operational Excellence
  • Operate With Uncompromising Integrity
  • Employ Rigorous and Balanced Risk Management

If you are tired of working for an organization that is not willing to listen to your ideas and you want direct access to the Executive Team, then Capital Bank is the place for you!

We are currently looking for an experienced Business Intelligence Developer to work with the BI team to implement and construct BI solutions which will fulfill and improve the company’s various data and information needs. As a member of our growing data team, experience with transact SQL, stored procedures, SSRS, SSIS, is essential. This data expert will have the opportunity to be involved with all areas of data management including data modelling, report development, and technical documentation.

Position Responsibilities

  • Creates business intelligence tools and reports to support Business Analytics and Executive Management.
  • Creates logical and physical data models using best practices to ensure high data quality and reduced redundancy.
  • Utilizes and champions the use of Master data management (MDM) to discover and define non-transactional lists of data, and compile maintainable, reliable master lists.
  • Designs, codes, tests, and aggregates results from SQL queries to provide information to users.
  • Creates technical documents to document database contents, concepts, and mapping between databases.
  • Participates in the design, development, and analysis of data architecture and warehousing approaches.

Minimum Education & Experience:

  • 3 years of SQL Server – SSIS and strong transact SQL skills
  • Business Intelligence Experience – writing reports (Excel) PowerBI and SSRS
  • Experience with Data Governance and Data Warehouse design
  • Detail-oriented with excellent problem solving skills
  • Demonstrated ability to identify business needs and deliver innovative and resourceful solutions
  • Capacity to prioritize and manage multiple tasks and projects simultaneously without sacrificing quality
  • Data Governance and Data Warehouse design: 1 years
  • SQL Server, SSIS and strong transact SQL skills: 3 years

Nice to Have Skills/ Desired Skills

  • Experience with implementation and use of SQL Server 2016 Master Data Services
  • Experience with Google Analytics and Salesforce
  • Experience with SSAS
  • Experience with Excel (Pivot tables, Power pivot etc.…)
  • Bachelor’s degree in computer science
  • SQL Master Data Services: 1 year
  • PowerBI & SSRS: 1 year
  • Business Intelligence: 3 years

Job Type: Full-time


  • Business Intelligence: 3 years