SENIOR POWERBUILDER BI ENGINEER

Business Advisory Solutions Group (BASG) is interviewing candidates for a Senior BI Engineer staff position in Charlotte, NC.  Residence in Charlotte is required; this is not a remote position!!!

Reporting into the Application Development Manager, this position is responsible for delivering Business Intelligence solutions as well as supporting, trouble shooting, implementing, and maintaining information systems to meet the company’s needs.

Additional responsibilities of the Sr. BI Engineer role include:

  • Assist in determining objectives and business requirements in anticipation of using BI and the data warehouse as a solution to drive business decisions.
  • Architect/design/develop/implement comprehensive BI solutions (from data model to dashboards) to problems assuring system quality, integrity, and performance efficiency.
  • Plan, direct, monitor, and control new development, maintenance, and enhancement of BI interfaces, cubes, reports, dashboards and assigned software modules.
  • Prepare system specifications, data element identification, database design, detailed program specifications, and data model designs.
  • Create ETL/SSIS packages for data warehousing
  • Assist in the development and compliance of departmental programming standards.
  • Analyze data model and interface design specifications for completeness and conformity to standards.
  • Write or oversee the writing of code in compliance with programming standards.
  • Prepare test data and test programs.
  • Delineate project activities from user requirements and system specifications.  Assist in the preparation of plans, schedules, and estimates for projects.
  • Provide support for BI, reporting and/or all assigned systems as needed.
  • Assist developers and provide data access guidance as needed.
  • Create SSRS reports with the data queried/provided.
  • Produce and maintain SQL programming objects such as stored procedures, user defined functions, common table expressions, scheduled SQL Agent jobs, and clustered/non-clustered/covering indexes.
  • Create documents and other artifacts to promote sustainable knowledge management within the organization.
  • Participate in on-call rotation and assist with after-hours issues as required.

PLEASE NOTE: BASG cannot work through any agencies to fill these positions.  BASG cannot work with offshore resources or respond to requests for Visa transfers. 

Qualified candidates for this role must offer a Bachelor’s degree in computer science or information systems.  You must offer excellent communication, technical and project management skills.

Technical skills and experience required of the Sr. BI Engineer role include:

  • 7+ years of experience with Microsoft SSAS/SSIS/SSRS.
  • 7+ years of experience extracting and transforming data within Business Intelligence environment.
  • 7+ years of experience with Microsoft SQL Server, including SQL Agent jobs, SSIS packages.
  • 7+ years of experience with SQL programming objects, including stored procedures, user defined functions, and common table expressions is required.
  • 5+ years of comprehensive data warehouse analysis and design experience, with full knowledge of data warehouse methodologies and data modeling.
  • 2+ years of experience with SharePoint PerformancePoint or Microstrategy is helpful
  • 5+ years of experience with database tuning and optimization.
  • Must have a minimum of a MCSA Database certification.
  • Experience with mobile Business Intelligence solutions is a plus.
  • Ability to effectively gather and analyze requirements and concisely communicate results.

Submit a Resumé

    Business Advisory Solutions Group (BASG) is an Equal Opportunity Employer and Prohibits Discrimination and Harassment of Any Kind. BASG does not discriminate on the basis of race, religion, color, sex, gender identity, sexual orientation, age, non-disqualifying physical or mental disability, national origin, veteran status, or any other basis covered by appropriate law. All employment is decided on the basis of qualifications, merit, and business needs.