Data Warehouse Architect & Systems Analyst

Global CI (Global Commerce & Information, Inc.); Baltimore (MD); On-site; USD 110,000 - 170,000; Full time

Benefits offered by this job

Medical insurance

Dental & vision coverage

401k retirement plan

Paid time off & holidays

Tuition reimbursement

Employee discounts

Job summary

Global Commerce & Information, Inc. seeks an experienced data warehouse architect/analyst to design, develop, and optimize complex DW solutions. You will lead data modeling, ETL mappings, and performance tuning across Oracle and Redshift environments, coordinating SDLC activities with cross-functional teams.

The role requires 7 years in DW analytics, 3+ years in architecture, and hands-on experience with AWS Glue and MicroStrategy. Bachelor’s degree in a related field is required.

Qualifications

• 7 years of systems analysis in a data warehouse environment.
• 3+ years of hands-on DW architecture experience.
• Experience with AWS Glue, MicroStrategy, Oracle, and Redshift.
• Knowledge of Erwin data modeling and mapping tools.

Responsibilities

• Lead data analysis and database design for DW projects.
• Develop logical and physical data models for complex apps.
• Prepare mapping documents and transformation logic.
• Write DDL for Oracle and Redshift; optimize performance.
• Coordinate SDLC activities and project milestones.
• Mentor peers and ensure data quality across pipelines.

Skills

Data warehouse design

SQL queries

SDLC knowledge

Analytical thinking

Education

Bachelor's degree in related field

Tools

AWS Glue

MicroStrategy

Oracle

Redshift

Erwin

MS Office (Word, Excel, PowerPoint, Project)

Job description

Global Commerce & Information, Inc. seeks an experienced data warehouse architect/analyst to design, develop, and optimize complex DW solutions. You will lead data modeling, ETL mappings, and performance tuning across Oracle and Redshift environments, coordinating SDLC activities with cross-functional teams.

The role requires 7 years in DW analytics, 3+ years in architecture, and hands-on experience with AWS Glue and MicroStrategy. Bachelor’s degree in a related field is required.