About the Opportunity

Strategic Solutions, LLC is seeking an experienced Senior Data Warehouse Solutions Architect / Data Integration Engineer to support enterprise data warehouse modernization and business intelligence initiatives. This position requires an accomplished data professional with extensive experience designing, developing, and supporting enterprise data warehouse solutions, ETL processes, database architectures, metadata management, and business intelligence platforms.

The successful candidate will serve as a technical leader responsible for analyzing business requirements, designing scalable data solutions, developing complex database objects, documenting data transformations, and supporting enterprise reporting and analytics initiatives.

Required Qualifications

Applicants must meet all of the following minimum qualifications:

U.S. Citizen or Green Card Holder

Verifiable Bachelor's degree in Computer Science, Information Systems, Engineering, Mathematics, or a related discipline is required

Master's degree or higher is preferred.

Minimum 9 years of professional IT experience

Minimum 9 years of hands-on experience with the following technologies:

General AWS experience

Oracle Database

SQL Development

ETL Development

Source-to-Target Mapping

Experience working throughout the Software Development Life Cycle (SDLC).

Strong written and verbal communication skills.

Excellent analytical, organizational, and problem-solving abilities.

Required Technical Experience

Candidates should possess extensive experience in the following technologies:

AWS

General AWS experience

AWS Glue

Amazon Redshift

Database Technologies

Oracle Database (10g or higher)

Database performance tuning

DDL development

Relational database design

SQL Development

Demonstrated expertise developing:

Complex SQL queries

Stored Procedures

Functions

Views

Packages

Performance tuning

Query optimization

ETL & Data Integration

Enterprise ETL development

Complex ETL mapping analysis

Data transformation

Data migration

Data validation

Data quality implementation

Data reconciliation

Data Modeling & Metadata

Logical Data Modeling

Physical Data Modeling

Dimensional Modeling

Relational Modeling

Metadata Management

Data Lineage

Data Mapping

Source-to-Target Mapping

Transformation Logic Documentation

Business Rule Documentation

Mapping tools such as Erwin Mapping Manager

Business Intelligence

MicroStrategy (2019 or later preferred)

Dashboard development

BI metadata

Reporting solutions

Key Responsibilities

Analyze existing enterprise systems and determine business, functional, and technical requirements.

Design, develop, implement, and maintain enterprise data warehouse solutions.

Design scalable data architectures supporting Oracle, Amazon Redshift, and AWS Glue.

Develop logical and physical data models for enterprise data warehouse environments.

Create detailed source-to-target mapping documentation and transformation specifications.

Develop complex SQL functions, procedures, packages, views, and queries supporting reporting and analytics.

Read, analyze, and enhance existing ETL mappings to understand enterprise data flows.

Design and document transformation logic for enterprise data integration initiatives.

Develop and maintain metadata across Oracle, Redshift, AWS Glue, MicroStrategy, and Erwin.

Create and maintain database structures using Oracle and Amazon Redshift.

Develop DDL scripts manually or using Erwin modeling tools.

Tune Oracle and Redshift database performance.

Conduct Gap Analysis and Impact Analysis resulting from source system or business requirement changes.

Derive pseudo-code and business calculation logic for use by design, development, and testing teams.

Analyze large volumes of structured and semi-structured data using advanced SQL.

Identify opportunities to improve multi-data mart integration and enterprise data architecture.

Recommend technical solutions, testing methodologies, and implementation strategies.

Participate in peer reviews, code reviews, and quality assurance activities.

Collaborate with developers, architects, business analysts, QA teams, and project stakeholders.

Produce technical documentation, standards, operating procedures, and architecture documentation.

Support project planning and ensure milestones and deliverables are completed on schedule.

Troubleshoot production issues and recommend long-term solutions.

Preferred Qualifications

The ideal candidate will also have experience with:

AWS Glue ETL development

Amazon Redshift administration

MicroStrategy 2019 or higher

Erwin Data Modeler

Erwin Mapping Manager

Data Quality Rule development

Enterprise Metadata Management

Large-scale Data Warehouse modernization

Government or Public Sector projects

Professional Skills

The successful candidate will demonstrate:

Exceptional analytical and critical thinking skills

Strong organizational abilities

Excellent written and verbal communication

Ability to manage multiple priorities simultaneously

Strong collaboration and leadership skills

Extensive understanding of Software Development Life Cycle (SDLC)

Attention to detail and commitment to quality

Ability to work independently with minimal supervision

This is a remote position.