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 its IT Consulting, Infrastructure Services, Security, Enterprise Service Management or Interactive, were 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
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
A Bachelors 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
Thank you for considering CareWorks Tech for your next career opportunity. CareWorks Tech is not your typical technology company.
We are part of the CareWorks family of companies which is one of Ohios 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.