Solutions Architect - Data - REMOTE - 85/HR 1 YEAR PLUS CONTRACT

ContractStaffingRecruiters.com; Branford (CT); Remote; USD 90,000 - 130,000; Full time

Job summary

ContractStaffingRecruiters.com is looking for a Solutions Architect specializing in data solutions. The position requires expertise in translating business requirements into technical solutions while leading data transformation efforts.

The ideal candidate will have experience with cloud technologies, strong programming skills in Python and SQL, and the ability to develop complex data products. You'll collaborate with various stakeholders ensuring documented and scalable solutions.

Qualifications

• Hands-on experience with complex data solutions and data transformation.
• Strong understanding of data architecture principles and integration patterns.
• Experience with cloud technologies, specifically AWS and Azure.

Responsibilities

• Translate business objectives into success metrics and data requirements.
• Serve as the subject matter expert for data and analytics needs.
• Develop scalable and reliable data solutions for real-time and batch processing.
• Design ETL processes for transforming raw data into SQL databases.
• Maintain comprehensive project documentation.

Skills

Python

SQL

PLSQL

DBT

Oracle

SQL Server

MySQL

Big Data concepts

AWS

Azure

Job description

Solutions Architect - Data

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.

Responsibilities

• 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, and spreadsheets into SQL databases.
• Understand the concept of Data Marts and Data Lakes and experience with migrating legacy systems to data marts/lake.
• Use additional cloud technologies (e.g., understand the concept of cloud services like Azure SQL Server).
• Maintain comprehensive project documentation.
• Strong interpersonal and communication skills to work in a team environment with customers, contractors, 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.