Solutions Architect

HKA Enterprises

East Hartford, CT, United States

3 months ago

Apply on hkaa.com

Prepare application

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Working hours

Regular working hours

Job source

hkaa.com

Tech stack

Amazon Web Services Microsoft Azure Big Data Spreadsheets Cloud Computing Databases Extract Transform Load (ETL) Data Mart Data Sharing Data Systems Software Design Patterns Python (Programming Language)

+16 more

Microsoft SQL Server SQL Azure MySQL Oracle (Applications) Raw Data Cloud Services Simple Data Format SQL Stored Procedures PL-SQL SQL Databases Data Streaming Data Lakes Integration Tests Legacy Systems Databricks Programming Languages

Job description

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 execute
Serve 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 Databases
Understands the concept of Data Marts and Data lakes and experience with migrating legacy systems to data marts/lake
Uses additional cloud technologies (e.g., understands concept of Cloud services like Azure SQL server)
Maintain comprehensive project documentation

Requirements

We are seeking a Solution Architect with experience in projects emphasizing complex data solutions., + Strong 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:

Programming languages, frameworks, and file formats such as: Python, SQL, PLSQL, DBT
Database platforms such as: Oracle, SQL Server, MySQL
Big data concepts and technologies such as Synapse & Databricks
AWS and Azure cloud computing