Solutions Architect

HKA Enterprises, Inc.; East Hartford (CT); On-site; USD 120,000 - 180,000; Full time

Job summary

HKA Enterprises, Inc. is seeking a Solution Architect to lead complex data solutions across business and technology teams.

This hands-on role focuses on data transformation and distribution to end consumers, requiring collaboration with BI teams and stakeholders to define metrics and acceptance criteria for engineering squads. The ideal candidate translates business requirements into repeatable design patterns, overseeing data integration across domains and ensuring alignment with enterprise

Qualifications

• Proficiency in Python, SQL, PLSQL, and DBT.
• Experience with Oracle, SQL Server, and MySQL.
• Experience with Synapse and Databricks; cloud experience with AWS/Azure.

Responsibilities

• Serve as the primary SME for data, analytics, and integration needs.
• Design and develop ETL processes transforming raw data to SQL databases.
• Plan, execute, and operate scalable data solutions in real-time and batch modes.
• Collaborate with Data Product Managers, Architects, and Engineering teams to define data flows.

Skills

Data Analysis

Communication

Tools

Python

SQL

PLSQL

DBT

Oracle

SQL Server

MySQL

Synapse

Databricks

AWS

Azure

Job description

The Opportunity: We are seeking a Solution Architect with experience in projects emphasizing complex data solutions. This is a hands-on role for someone who enjoys working across business and technology. This person will be responsible for supporting data transformation and distribution to end consumers. Candidate will assist with requirements analysis, design/develop process flow, and unit/integration testing, to deliver complex data products. Work with the Business Intelligence team and operational stakeholders to translate objectives into success metrics, system qualities, data requirements, and acceptance criteria that engineering teams can executeServe as the primary subject matter expert for data, analytics, and integration needs across assigned business domains, translating business requirements into repeatable, executable design patterns and system qualities.Partner closely with Data Product Managers, Architects, and Engineering teams to identify integration opportunities, select appropriate tools, and define shared data, interfaces, and data flows.Provide architectural and design oversight through planning, execution, and operations to ensure alignment with enterprise standards and successful implementation.Develop scalable and reliable data solutions to move data across systems from multiple sources in real time as well as batch modes.Design and develop database objects, tables, stored procedures, views, etc.Design and develop ETL Processes that will transform a variety of raw data, flat files, xl spreadsheets into SQL DatabasesUnderstands the concept of Data Marts and Data lakes and experience with migrating legacy systems to data marts/lakeUses additional cloud technologies (e.g., understands concept of Cloud services like Azure SQL server)Maintain comprehensive project documentationStrong interpersonal and communication skills to be able to work in a team environment to include customer and contractor technical, end users, and management team members.

Experience Needed:

• Python, SQL, PLSQL, DBT
• Oracle, SQL Server, MySQL
• Synapse & Databricks
• AWS and Azure cloud computing