Company Statement
ConnectiCare is a leading health plan in the state of Connecticut. ConnectiCare’s mission is to make it easy for members to get the care they need. A local company for over 35 years, ConnectiCare has a full range of products and services for businesses, municipalities, individuals and those who are Medicare-eligible. A subsidiary of EmblemHealth, ConnectiCare leads the individual and small group markets in the state, and is ranked among the top commercial health plans in the nation, according to the National Committee for Quality Assurance.
We’re looking for individuals who want to make a difference in the communities we serve. If you want to join a local team and help change the way health care is delivered, ConnectiCare is the place for you.
Data Exchange Manager
- Oversee the ETL design practices of our CTS partners, instill a best-practice framework on building and deploying jobs, design job testing procedures and validation standards, and facilitate communication with data governance business partners.
- Maintain the primary listing of inbound/outbound data assets; and monitor each job against agreed-upon SLA’s set with our CTS partners.
- Build out a robust Audit, Balance, and Control plan to monitor the performance of all DWH jobs.
- Closely monitor the entire TranZform ETL environment, track performance, diagnose bottlenecks, trouble shoot errors, and respond to emergency data requests.
- Become familiar with starting data sources and the data governance processes established by Emblem; establish necessary relationships with data source providers/teams/external vendors to facilitate smoother data delivery to and from Emblem.
- Respond to and address approved business requests and asks pertaining to DWH job performance.
- BS in Information Management, Computer Science, Mathematics, Statistics or equivalent/relevant field.
- Professional certifications related to data warehousing techniques, project management, and emerging Big Data technologies preferred
- 10 – 12 years of relevant work experience, preferably in a healthcare environment required
- 6+ years working in an Enterprise DWH/BI and or data-centric environment with a focus on ETL job execution required
- Experience and knowledge of traditional RDBMS systems, ETL tools (DataStage, Informatica), job scheduling tools, Master Data management tools, Data Quality tools, and data governance platforms required
- Extensive and direct experience in using and managing data of a healthcare payer required
- Experience in ETL job design, job optimization, and deployment required
- Staff development and management experience within a data warehousing environment required
- Experience with/on Big Data platforms and Big Data ingestion/extraction tools, preferred
- Experience in setting up an ETL development environment for a team of distributed ETL developers preferred
- Extensive experience with large DWH projects in a health payer setting preferred
- Clear communication style, a desire to help, and focus required
EEOC Statement
We are committed to leveraging the diverse backgrounds, perspectives and experiences of our workforce to create opportunities for our people and our business. We are an equal opportunity/affirmative action employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability, protected veteran status or any other characteristic protected by law.