Programmer Analyst

CCS Medical is looking to improve and grow Their BI support and development. They would like to automate most of the processes around how they intake data from their clients and stop doing things manually. The initial role of this candidate will be a lot of data cleansing, data validation, and reporting but I would like for them to help move the BI stack to the next level so, we can put more tools into our users hands.

MINIMUM QUALIFICATIONS: • Associate's degree or Bachelor's degree required • Minimum of 18 months of experience working with Star Schema and generation of OLAP Cubes. PREFERRED QUALIFICATIONS: • Degree in Mathematics is a plus. • Developing detail oriented expertise. Works on moderately complex projects. Exercises judgment within defined procedures and practices. • Ability to analyze and troubleshoot problems and make recommendations for remediation • Experience developing with Microsoft BI product stack. • Strong SQL developer skills. • Good experience in one of the following: Reporting Services, Integration Services, Analysis Services. • Familiarity with dimensional and relational modeling practices. • Strong analytical, conceptual, and problem-solving abilities. • Proficiency with Microsoft Excel. • Data Warehousing knowledge • Good BI experience including a specialty in data warehousing, reporting services, ETL, and/or dimension modeling. • Good communication and customer interaction skills. ESSENTIAL FUNCTIONS: • Provides analysis, design and development utilizing BI tools. Debugs and resolves data errors. • Has a strong understanding of the BI toolsets to generate ETL processes including extraction of data from source systems, data mapping into a Star Schema and the generation of OLAP cubes. • Creates reports and dashboards using the appropriate BI toolsets. • Provides guidance on business analytics offerings. • Provides second line customer support. • Provides technical documentation as appropriate. Adheres to processes to minimize data quality risks and proactively identify potential data issue.

If interested please email