Programmer/Analyst - Business Intelligence

Community College of Baltimore County   Catonsville, MD   Full-time     Information Services / Technology (IT)
Posted on March 13, 2023
The purpose of this position is to develop and manage a suite of extract, transform, load (ETL) processes to organize and automate CCBC's existing and future data repositories and respond to ad hoc analytics requests.

Compensation within the posted range is determined by a candidate's education level and/or years of experience in the field.  Generally, employees are hired in the lower third of the scale.  

Bachelors' degree required, degree in Information Technology or related field preferred. Two (2) years of related experience in Microsoft SQL servers, Business Intelligence Products, SSIS, SSAS, Power Query, SSRS.

  1. Design, program, test, implement, and document modifications to existing systems in order to enhance processing efficiencies or a required change.
  2. Investigate and resolve application system problems reported by system users.
  3. Analyze and develop system specifications and procedures for modifications to existing computer systems (developed in-house or third party packages), in support of user requests.
  4. Apply updates to third-party software products.
  5. Identify, evaluate, recommend, and implement new products and technologies.
Essential Job Duties are intended to be examples of duties and are not intended to be all inclusive. There will be other duties as assigned.

  1. Develop and manage extract, transform, load (ETL) processes between Oracle, SQL databases and external data sources using SQL, T-SQL, C#, JavaScript.
  2. Design and create data models needed to support business analytics.
  3. Lead SQL database infrastructure development projects. 
  4. Monitor and maintain groups and user privileges in applications and databases. 
  5. Coordinate, install, and upgrade the server and application tools. 
  6. Implement and maintain Microsoft Data Analytic Products
  7. Create and maintain documentation and flow charts.
Essential Job Duties are intended to be examples of duties and are not intended to be all inclusive. There will be other duties as assigned.

Community College of Baltimore County

Catonsville , MD