Sign in

BI/DW Reports Developer

Company:
CareWorks Technologies
Location:
Columbus, Ohio, United States
Posted:
December 05, 2018

Description:

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.

Job Description: We need a Reports Developer who is proficient designing and developing enterprise and departmental Business Intelligence, Data Warehousing and reporting solutions using SQL and ETL (Informatica PowerCenter) – primarily in an Agile development environment.

Summary/Responsibility

You will improve the run time of SQL stored procedures and code and must have proven experience with Oracle and SQL server databases while also being an expert with database analysis and design using data analytical methodologies and batch integration processes. It is assumed you will have experience with multiple scripting languages such as Perl or Shell or Python. Experience working with caching approaches and technologies will be expected and you must have demonstrated capabilities driving demand and developing the code using Informatica.

You will be involved with analyzing problems and developing low cost and high efficient solutions. It is required that you will have strong lead skills with the ability to fill a Lead/key role if needed. Strong written and verbal communication skills will be vital as well the ability to work collaboratively on an Agile team and most importantly you must be able to understand and communicate the impact of project scope changes while making relevant modifications to stored procedures, user-defined functions, and overall reporting functionality.

Experience with Business Objects is a huge plus (not required) and experience with data integration with heterogeneous systems like XML, DB2, COBOL would be extremely helpful. Finally, experience moving large volumes of data and experience creating Data Marts in the Insurance Industry (claims data) domain would be a perfect skill set for this opportunity.

Qualifications

Bachelor’s degree in Computer science or equivalent discipline

Demonstrated ability to work and communicate effectively with all levels of Business and IT management

Ability to negotiate acceptable solutions to complex problems across multiple business and/or technical areas and vendors

8-10 years of experience in using SQL, PL/SQL and Reporting solutions, Business Objects XI/BI4.X experience desired

5 years of Unix scripting experience

Knowledge of Big Data and Data Warehouse concepts is a plus

Experience with Informatica/DataStage is a plus

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.