What are the responsibilities and job description for the Senior Data Warehouse Solutions Architect / Data Integration Engineer position at Strategic Solutions?
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 QualificationsApplicants 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.
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
- 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.
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
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
Salary : $40 - $45