Business Intelligence Architect

  • Next Gen Cyber LLC
  • Bridgepoint Education - San Diego, CA
  • Apr 29, 2018
Full time Systems Architecture Knowledge Management Customer Service and Technical Support Network Services

Job Description

Reporting to the Business Intelligence Director the Business Intelligence Architect is a full-time position located in San Diego, California. This position is a key part of the Business Intelligence team which is responsible for delivering best-in-class analytical data solutions. This position will have a senior role in data warehouse projects and reporting system maintenance, with opportunities to develop innovative solutions and explore new technologies. Accountable for creating and supporting the development of the overall long term strategies and direction, defining and governing architecture principles and standards, and developing business and technology oriented reference models to optimize the use of BI Solutions and information at Bridgepoint Education to support both transactional and decision making capabilities. This position will provide architecture leadership and oversight to internal development initiatives and alternative sourcing partners to effectively deliver cost effective and high-quality solutions. Candidate will also be responsible for keeping current on new technologies entering the market and best practices associated with the development, use and governance of data and information within a dynamic enterprise. Has direct impact on creation of ETL packages, tabular model design and data visualizations. Serves as a role model and mentor for team members. Has extensive specialized technical expertise in data collection (files, database and streams). Applies expert knowledge and broad understanding of multiple disciplines. Integrates of technical principles/methods of multiple disciplines with knowledge of products/services and internal operations.

Essential Job Duties:

  • Participate in the entire lifecycle for Business Intelligence Solution Delivery
  • Design, build, document and manage data warehouse objects
  • Design and develop ETL processes using SQL Server Integration Services (SSIS)
  • Assist with BI Solution (DBMS, SSIS, SSAS) architecture and performance tuning
  • Develop, test and deliver error free data
  • Stay abreast of BI industry best practices and relevant new technologies

Additional Job Duties (include but are not limited to):

  • Design and develop reports using SQL Server Reporting Services and Tableau
  • Design and develop OLAP Cubes and Tabular models using Analysis Services (SSAS)
  • Perform technical analysis documentation
  • Ability to work independently (as well as within a team environment) and unsupervised
  • Ability to work a flexible day schedule required including occasional evenings

Minimum Requirements:

  • 8+ years developing Business Intelligence solutions.
  • 6+ years developing solutions using the MS SQL Server Business Intelligence Stack
  • Knowledge and experience in development of data warehouse architectures for large volume reporting solutions.
  • Experience in designing data models to support reporting and analysis. Knowledge of industry accepted design techniques including Star, and third normal form schemas.
  • Experience in providing technical leadership to project team members and BI consumers.
  • Database development experience with MS SQL Server.
  • Knowledge and experience in multiple reporting tools such as MS-SSRS, Data Zen, or Tableau reports utilizing both relational and multidimensional tool architectures

Preferred Qualifications :

  • Knowledge of Business Requirements definition and documentation.
  • Knowledge of Project Management principles and processes.
  • Knowledge of Higher Education industry (3+ years’ experience).
  • 2+ Years SSAS Tabular Model Architecture and Design
  • Security implementation in databases and BI solutions
  • Agile BI DW development methodologies
  • TDWI -CBIP -Certified Business Intelligence Professional * Microsoft - MCITP - BI DeveloperEducation:
  • A Bachelor’s Degree is required
  • A Master’s Degree is preferredEC162016

Education Requirements:

If a degree(s) is required for the position, completed degree(s) must be conferred by a regionally accredited or approved nationally accredited institution. All candidates must provide proof of higher education (official transcripts) upon request.

Physical Requirements:

Physical Demands: While performing the duties of the job, the employee is regularly required to use hands and arms and talk or hear. The employee requires dexterity in using telephone, computer keyboard, mouse and calculator while seated at a desk. The employee is frequently required to stand, walk and sit. The employee may frequently move to interact with fellow employees and/or clients. Specific vision abilities required by this job include close vision, depth perception and ability to adjust focus.Communication Skills: While performing Duties of the job, the employee is required to read and comprehend instructions, correspondence and memos. The employee requires the ability to write effective and detailed correspondence and to effectively present information both in one-on-one and small group situations.Mental Demands: While performing duties of this job, the employee is required to deal with stress associated with a fast-paced work environment and multiple priorities/tasks. The employee will be required to make judgment decisions and adapt to changing work situations, grasp and apply new ideas, communicate with various personalities at all levels and have the ability to apply common sense understanding to carry out detailed instructions.Work Environment: While performing duties of this job, the employee is required to work in an office environment, and the noise level is usually moderate to loud.

Note: This opportunity of employment will require a completed pre-employment screening to be inclusive of, but not limited to: a criminal background investigation, verification of education credentials, verification of prior employment history, professional reference checks and public social media postings; with review prior to an offer of employment being extended. As an employer, we participate in E-Verify. To learn more please visit

Job Type: Full-time

Salary: $150,000.00 /year

Job Location:

  • San Diego, CA

Required education:

  • Bachelor's

Required experience:

  • Designing Data Models: 5 years
  • developing solutions using the MS SQL Server Business Intelligence Stack: 6 years
  • Designing and developing OLAP Cubes and Tabular models using Analysis Services (SSAS): 5 years


$150,000.00 /year