Sign in

SSIS

Company:
CareWorks Technologies
Location:
Columbus, Ohio, United States
Posted:
November 08, 2018

Description:

Location: Columbus, OH

For more than 17 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.

Description of Duties:

25% of Total Work Effort: Requires 5-7 years’ experience as an SSIS ETL Developer working in Microsoft SQL Server

25% of Total Work Effort: Knowledge of administration of SQL Server for transactional and analysis systems

25% of Total Work Effort: Strong analytical data model design expertise (preferred)

25% of Total Work Effort: Snowflake and Star Schema design

The SSIS ETL Developer is responsible for designing, developing, and delivering high-quality output and proactive involvement in the successful delivery of BI systems; through coordination within the rest of the technology department and the business owners.

The SSIS ETL Developer is responsible for data profiling of new source systems, designing custom reporting tables (such as fact and dimension), and using SSIS to create ETL packages to fully support reporting solutions in Cognos. Has thorough knowledge of data warehousing and ETL (SSIS required).

You must have a good understanding of the business needs and the technical capabilities and be able to help align the BI solutions to meet the business growth objectives.

Must have:

• 5-7 years of experience as an SSIS ETL developer

• Data profiling and data modeling experience

• Strong in data warehousing concepts and techniques

• SQL, T-SQL, PL/SQL techniques

• Experience creating custom reporting tables using SQL (such as fact, dimension, aggregate, slowly-changing dimension)

• Snowflake and Star Schema design

• Effective verbal and written communications skills and effective presentation skills

• Self-motivator, independent, cooperative, flexible, creative

Preferred:

• Strong OLAP/analytical data model design expertise

• Cognos experience

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 which includes more than 5,800 public entities and public entity pools; more than 300 program administrators/MGAs/carriers; more than 50 insurance carriers and more than 500 self-insured/high deductible clients. We have operations in 85 locations worldwide and employ 5,000+ people.