> Markdown version of [/jobs/ext/1995860-senior-data-warehouse-solutions-architect-data-integration-engineer](https://www.wearedevelopers.com/jobs/ext/1995860-senior-data-warehouse-solutions-architect-data-integration-engineer). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Senior Data Warehouse Solutions Architect / Data Integration Engineer - **Company:** Strategic Inc - **Location:** Woodlawn, MD, United States (Remote available) - **Experience:** Expert - **Salary:** $83,200.0 - $93,600.0 - **Contract:** Permanent contract - **Skills:** Amazon Web Services, Big Data, Code Review, Information Systems, Databases, Data Architecture, Data Validation, Data Integration, Extract Transform Load (ETL), Data Mapping, Data Mart, Data Transformation, Data Migration, Data Warehousing, Relational Databases, Database Development, Database Storage Structures, Dimensional Modeling, Metadata, Meta-Data Management, MicroStrategy, Oracle Databases, Oracle (Applications), Performance Tuning, Query Optimization, Software Engineering, SQL Stored Procedures, SQL Databases, Strategies of Testing, Enterprise Data Management, Freeform SQL, Database Optimization, Database Performance, Er-Win, Semi-structured Data, Information Technology, Data Lineage, AWS Glue, Tools for Reporting, Amazon Redshift - **Published:** August 8, 2026 - **Apply:** https://www.careerjet.com/job/us5d24223cd98d2054776ca0eb4a83e12a/eaa ## About the Role * 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., 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, * 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 ## Description 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., 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, * 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., Senior AWS Database Architect Location: Woodlawn, MD (Onsite - 5 Days/Week) Employment Type: Contract (or Full-Time, as applicable) Clearance: Ability to obtain and maintain a … + 12 days ago ## Related Videos - [Alibaba Big Data and Machine Learning Technology](https://www.wearedevelopers.com/videos/37-alibaba-big-data-and-machine-learning-technology) - [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering) - [How we built an AI-powered code reviewer in 80 hours](https://www.wearedevelopers.com/videos/1511-how-we-built-an-ai-powered-code-reviewer-in-80-hours) - [Making Data Warehouses fast. A developer's story.](https://www.wearedevelopers.com/videos/302-making-data-warehouses-fast-a-developer-s-story) - [Tips, Techniques, and Common Pitfalls Debugging Kafka](https://www.wearedevelopers.com/videos/838-tips-techniques-and-common-pitfalls-debugging-kafka) - [PySpark - Combining Machine Learning & Big Data](https://www.wearedevelopers.com/videos/44-pyspark-combining-machine-learning-big-data) ## Related Articles - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [Is Software Engineering Over-Saturated?](https://www.wearedevelopers.com/magazine/418-is-software-engineering-over-saturated) - [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know)