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 Engineering Architect
Summary of Position-
- Ensure that WellSpark has the architecture to support technology functions needed to drive business results.
- Research, ideate, develop and implement solutions to support smooth operating function across multiple sources, channels, platforms, etc.
- Ensure that the data analytics functions are enabled and supported such that the business(es) can utilize them to drive decisions accurately.
- Oversee alignment of digital strategy efforts with business and corporate goals.
Principal Accountabilities-
- Responsible for data architecting the specialized software capabilities required to support WellSpark and for maintaining high-level data architectural designs and artifacts, data configuration, implementation, and automation.
- Design and solution resolutions of operational issues linked to data quality from several independent digital information channels.
- Architect and implement processes for analyzing and improving digital data sources, enabling digital analytics and data-driven decision making.
- Accountability for full lifecycle ETL development leveraging SQL, SSIS and .NET technologies, including design, development, and end to end quality.
Interpret internal and external business challenges and recommend best practices to improve products, processes, or services. - Provide leadership to translate requirements into architecture and formulate solutions and integrations that resolve issues and mitigate risks.
- Provide architectural guidance on database design, implementation, data modeling, migration, quality, governance, warehouse, and ETL processes.
- Collaborate with the team and the business to ensure that digital initiatives align with existing Enterprise strategy, as well as with the security team to define security architecture and appropriate controls in the WellSpark HITRUST data environment.
- Work with customers and internal teams to ensure interfaces
Qualifications-
- Education, Training, Licenses, Certifications
- BA/BS in STEM, Math, Computer Science, or related discipline
- Professional certifications in the fields of Data Science, Cloud Data Centers, Data Engineering and Operations, Healthcare analysis, and other related disciplines, preferred.
Relevant Work Experience, Knowledge, Skills, and Abilities-
- 10 – 12+ years of relevant, professional work experience
- 5 – 8+ years’ experience as data and analytics engineers or related equivalent
- 5+ years’ experience as a data architect
- Architectural expertise of enterprise data solutions, digital solutions, and legacy environments, such as Visual Studio.NET, C#, and Visual C++. SQL Server, stored procedures, functions, triggers, indexes, and database architecture from Microsoft, in addition to SQL, PL/SQL, MySQL, Visual Basic, and Python
- Database design (theories such as Star Schemas, Snowflakes, and Dimensional Models), configuration, and implementation
- Understanding of concepts such as CMDBs
- Ability to provide exceptional relational database design and architecting
- Adept with ETL tools, such as SSIS, SAS, Data Stage, and Informatica
- Knowledge of architecting web technology solutions with various technologies
- Extensive knowledge of front-end software engineering and architecture
- Excellent communication skills (verbal, written, presentation, interpersonal) with all types/levels of audience
- Experience with architecting BI reporting solutions with various tools
- Knowledge of Frontend, Backend, and Web development
- Strong understanding of development processes agile and waterfall methodologies
- Knowledge of JIRA, Confluence, Smartsheet, and other project management software
- Expertise with cloud-based technologies such as Azure, Amazon Web Services, or others
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.