Business Intelligence Developer

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 Charlotte, NC location. The Senior BI Developer will be responsible for the design, development and customization of SQL Server Analysis Services (SSAS) multidimensional solutions using cube structures to deliver business data across multiple business units and KPI’s.

The Senior Business Intelligence Developer will need to have expert level knowledge of the Microsoft Business Intelligence stack (i.e. SQL Server 2012/2014, T-SQL, Stored Procedures, SSAS, SSIS, SSRS etc.) Additionally, he/she will be an expert with data architecture (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.

Apply Today If Your Background Includes:

  • 4+ years of experience working with Microsoft SSAS and developing multidimensional cubes from inception to completion.
  • Expert level skills with Microsoft SQL, T-SQL, OLAP and the MS BI suite of tools
  • 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.
  • 6+ years of professional BI/DW experience with a clear history of career progression and advancement.

What The Right Professional Will Enjoy!

  • 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 including SQL Server 2014, MS Azure, SSAS, etc.
  • Possibility of getting equity in the company!


  • Design, development, testing, and implementation of Microsoft SQL Server Analysis Services (SSAS) cubes or other OLAP/multi-dimensional solutions 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 with OLAP, Analysis Services, T-SQL, Stored Procedures and developing cubes.
  • 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

Job Type: Full-time

Job Location:

  • Charlotte, NC

Required license or certification:

  • Do you require sponsorship to work in the US
Share this job

Career Evolutions is looking for a Business Intelligence Developer for a fast-growing real estate company headquartered in Phoenix, AZ. Full-time, direct hire role with a compensation up to $100k and an amazing benefits plan.

If you excel in fast-paced environments, are flexible and able to roll with changing scenarios, and want to join a fast-growing, entrepreneurial company then this is the perfect opportunity for you!

Job Summary: The Business Intelligence Developer works with both business and financial analyst in order to collect and transform requirements into views, models, reports and dashboards. Requires proficiency with complex T-SQL, views, SSDT, SSRS, Tableau, or similar reporting platforms.

Develop database objects structures (stored procedures and views) for data retrieval and reporting.

Support data engineers and DBAs when needed

Develop reports and dashboards using SSRS, Tableau, or other tools as necessary, following best practices for information delivery and dashboard design.

Manage meetings and workshops with business leaders to produce and elaborate requirements for business intelligence reporting.

Track, log and manage issues, bugs, and enhancement requests

Bachelor’s degree in computer science or related field strongly preferred OR 7+ years of progressive development may be considered in place of degree

Experience creating stored procedures, views, scheduled jobs and indexes

Experience with SSIS, AWS, Redshift, Yardi, Microsoft SQL server certifications are all a strong plus

Attention to detail and technical writing skills

Strong analytical, evaluative and problem-solving abilities

Flexibility and attitude to achieve firm deadlines

Founded in 2008, Career Evolutions is a leading Executive Search based in Scottsdale, Arizona. Career Evolutions provides products and services to identify top talent, develop employees, and maximize human capital to enhance the bottom line. For more info, please visit , check out our Current Opportunities , and contact us via phone 480.626.5253

Share this job