Data Engineering Architect

Data Engineering Architect

Farmington, Connecticut

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

Additional Information

• Requisition ID: (see application details)
• Hiring Range: $86,000-$165,000