Senior Business Intelligence Developer

Location: Denver, Colorado

Type: Contract To Hire

Senior Business Intelligence Developer

Optomi, in partnership with a rapidly growing Healthcare SaaS Business Intelligence provider, is seeking a Senior Business Intelligence Developer for their Denver, CO location.

The Senior Business Intelligence Developer will be need to have expert level knowledge of the Microsoft Business Intelligence Stack (SQL Server 2012/2014, T-SQL, Stored Procs, SSIS, SSRS, SSAS) and data architecture expertise (logical and physical database/table designs, dimensional modeling, ETL architecture) to design, develop, test, and deploy BI Solutions which perform optimally and produce high data quality and timely results for our business.


  • 5+ years of experience working with Microsoft SSAS and developing OLAP or OLTP cubes from inception to completion.
  • Expert level skills with Microsoft SQL, T-SQL and the BI suite of tools to include SSIS, SSRS and SSAS.
  • Deep interest and enthusiasm for business intelligence, data warehousing, data analytics; demonstrated through dialog and ultimately results in the delivery of quality BI Solutions which are valued by business.


  • Work for a RAPIDLY growing, technology driven company where the solutions you develop are revenue generating and client facing!
  • Work on a collaborative team with top-level Business Intelligence professionals.
  • Work with the latest and greatest technologies in the Microsoft suite of Business Intelligence tools.


  • Design, development, testing, and implementation of Microsoft SQL Server Analysis Services (SSAS) or other OLAP/multi-dimensional databases with the ability to create calculated members and KPIs
  • Design, development, testing and deployment of data integration packages using Microsoft SQL Server Integration Services(SSIS), including the ability to develop ETL processes to load data warehouse applications
  • Design, development, testing and deployment of customer facing and internal analytics solutions using Microsoft SQL Server Reporting Services (SSRS) and dashboard and data visualization tools (Excel Services, PowerBI, PowerPivot, Tableau)
  • Review and optimize current processes to improve business results for internal and external customers
  • Performance tuning across the data warehouse processing platforms: ODS, DW, Cubes
  • Collaborate with BI Support Team and QA Team in the development, testing and support of BI Solutions
  • Development and implementation of standard BI development processes and templates
  • Ensure data quality, completeness, accuracy, and timeliness are built into every BI Solution
  • Design, develop, and implement logical and physical database designs in Microsoft SQL Server 2012/2014.
  • Design/Development/Testing/Implementation of ETL load processes, reporting and dashboard BI solutions
  • Maintain standards and data quality in data loads and reporting for internal and external customers


  • Expert level skills in every area of the Microsoft BI Stack: SSIS, SSRS, SSAS, T-SQL, Stored Procedures
  • Minimum of 5 years of experience employing data warehouse principles and theories, including knowledge of the various tactical approaches to data warehouse development
  • Experience developing and optimizing high throughput ETL processes using SSIS
  • Experience with report/dashboard design and working knowledge of a reporting suite such as SSRS and data visualization tools: Excel Services, PowerBI, PowerPivot, Tableau
  • Understanding of database modeling and design principles and ability to use and create data model diagrams