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!

Responsibilities:

• 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

Competencies:

• 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