SQL BI

For more than 18 years, CareWorks Tech has been delivering technology solutions that drive results. As your advocate, the common thread across our associates is crafting the right tech-savvy solutions. Whether it’s IT Consulting, Infrastructure Services, Security, Enterprise Service Management or Interactive, we’re all about finding solutions that advance your career aspirations. Our ongoing client relationships speak to our long-term collaborative partnerships.

Position Description: Provide consultation on current solution and potential improvements. Provide consultation on setting up test environment(s) and data flow for testing purposes. Develop and execute database queries and conduct analysis to extract, transform and load data from source to target. Develop and fine-tune views and stored procedures. Create regression test scripts; troubleshoot and resolve issues utilizing SQL. Develop and update technical documentation for transition to maintenance and support team

Minimum Qualifications:

Excellent knowledge of database design, SQL, data warehousing

Strong working knowledge in BI methodologies

Proficient in SQL queries, SSMS

Experience with ETL testing and troubleshooting

Experience in performance tuning

Analytical mind with a problem-solving aptitude

Absence Management and/or claims management experience helpful

Required Experience

A Bachelor’s degree with an emphasis in Computer Science, Databases, Technology, or equivalent work experience. 5+ years of business experience

System support includes issues related to automation, system functionality, improving efficiency related to the applicable system(s), or training end-users.

5+ years of MS SQL Server (2008-2016), Transact-SQL, Stored Procedures

Strong understanding of data modeling for both OLTP and OLAP purposes

Strong proficiency in Integration Services (SSIS) or other ETL tools, proficiency in Analysis Services (SSAS)

Retrieve data from various sources and prepares data for analysis. Working on data manipulation and extraction using Microsoft SQL Server Management Studio

Develop complex SQL queries against various data and computer sources. Including complex Sub queries, correlated queries, and nested queries.

Gather requirements for new BI solutions from multiple users; able to translate business requirements into actual solutions while maintaining a high level of accuracy and data integrity

Analyze and interpret data, producing clear and compelling reports for different audiences which may include graphs and charts of data developed by analyzing situations and/or data models from which answers can be obtained.

Supports business area projects by applying general knowledge of the business area processes including best practices.

May provide data and respond to questions to external groups/agencies/vendors.

Intermediate MS Office skills including the ability to create, manipulate and formulate spreadsheets. Knowledge of spreadsheet functionality including v-look-up, pivot tables, charts and graphing.

Must be well organized, extremely detail oriented and have great communication skills, both oral and written.

Concisely summarize and communicate recommendations to various levels of management maintaining confidential information

Must be flexible and have the ability to adapt quickly as external environment and organizational changes occur.

Self-Motivated and can work with little direction

Willing to learn a range of BI Tools to include (Cognos, PowerBI, Tableau)

The CareWorks Family of Companies is committed to providing career opportunity and growth to all Associates without regard to race, color, religion, sex, national origin, age, marital or veteran status, medical condition or disability.

CareWorks Tech Strategically-Led Technology Solutions

5555 Glendon, CT

Dublin, OH 43016

614-789-3767

david.horvay@careworkstech.com

Thank you for considering CareWorks Tech for your next career opportunity. CareWorks Tech is not your typical technology company. We are part of the CareWork’s family of companies which is one of Ohio’s largest managed care organizations, serving over 115,000 employers and owned by York Risk Services Group. We have 4 guiding principles: (1) Customer Commitment (2)Attitude of Service (3) Respect for the Individual and Team and (4) Exceeding Expectations. We invest in your training, professional development, benefits (medical, 401k, paid holidays/vacation, etc.) and personally focus on your career success. We have operations in 85 locations worldwide and employ 5,000+ people.