Senior Data Warehouse Solutions Architect / Data Integration Engineer

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., 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.

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, 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