Systems Analyst / Database Design Tier 4

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

Your Success is Our Success. Global CI is an award-winning 30-year IT Services company founded on the principles of providing high-quality, value-added technology consulting services. Our vision is to create a better future by improving the lives of the people we serve through emerging technologies. Join us and together we will advance the future of technology services.

Global CI offers competitive compensation and non-salary benefits to all eligible employees.

Job Description

General Job Description: Designs, develops, programs, installs, implements, conducts research for, and maintains internal data processing computer systems and utilities, and/or for customers on a contract basis. Analyzes internal or external customers' needs and determines equipment and software requirements for solutions to problems by means of automated systems; develops customized solutions to customer/user problems. Designs, models, documents, and guides the logical and conceptual relationship of data and database changes for complex applications. Establishes system parameters and formats; ensures hardware/software compatibility; and coordinates and/or modifies user requirements in terms of existing and projected computer capacity and capabilities. May make programming changes as required to adapt or enhance existing or new programs and/or utilities. Maintains supplied software packages for internal users. Analyzes new hardware to determine its need or application in the existing or proposed system; advises on new techniques and estimated costs associated with new or revised programs and utilities, taking into consideration personnel, time, and hardware requirements, and makes trade‑off analyses; develops general and detailed documentation describing system specifications and operating instructions; and revises existing systems and procedures to correct deficiencies and maintain more effective data handling, conversion, input/output requirements, and storage.

Specific Job Description

• Gathers information from existing systems, analyzes program and time requirements. Provides technical advice on complex programming. Writes and prepares detailed specifications for programs at all levels of complexity.
• Designs systems and programs to meet complex business needs including enhancements to existing programs. Ensures programs meet standards and technical specifications. Performs technical analysis and component delivery. Supports project personnel in resolving complex program problems.
• Conducts quality assurance activities such as peer/code reviews.
• Works with all technical areas to resolve issues and validate programming requirements. Enhances processes where applicable.
• Ability to derive the pseudo code on metric calculations that can be used by the SDLC teams for Design, Development, and testing. Perform Gap and Impact analysis on any type of source changes and/or requirement updates.
• Ability to write complex SQL queries to perform analysis on complex and large sets of data in various file formats.
• Provides technical advice on complex data warehouse scenarios. Experience in AWS Glue is required to understand the data flow from source to Data warehouse by reading the existing complex ETL mappings. Experience with MicroStrategy BI tool is advantage.
• Leads data analysis, database design, develop Logical and Physical Data Models, including Relational and Dimensional Models.
• Develop Design Logic for the data transformation from Source to Target; prepare Mapping documents with all the transformation logics, BI Objects, Data Quality Rule creation/ enforcement, etc.
• Write DDL script to create/update database structures supporting Oracle and Redshift either manually or through Erwin, ability to tune database performance.
• Analyzes multi-data mart system integration opportunities and challenges. Proposes and communicates recommended solutions. Recommend testing methodologies for the proposed design.
• Works individually and with peers to perform metadata management across Erwin, Oracle, Redshift, AWS Glue and MicroStrategy.
• Develops, documents, and maintains data architecture-related standards and documentation.
• Responsible for supporting planning activities and supporting the on-schedule delivery of milestones and deliverables.
• Must possess effective organizational, interpersonal, oral and written skills, strong analytical and problem‑solving capabilities and close attention to detail. Must be a team player able to multi-task in a dynamic environment and have an extensive working knowledge of the SDLC and the associated processes and documentation.

Specific Experience

• Must possess 7 years of systems analysis experience in a data warehouse environment using MS tools (MS Word, Excel, PowerPoint, and Project) and at least 3 years of recent hands‑on architecting data warehouse solutions.
• Prefer experience implementing solutions in AWS Glue, MicroStrategy (2019 or higher), Oracle (10g or higher), and Redshift environment with a strong background in SQL commands/ functions/ Procedures
• Database data modeling tools similar to Erwin, source to target mapping tools similar to Erwin Mapping Manager.

General Experience: 9-13 years related experience

Education:

Bachelor of Science in related field or equivalent years of experience

Benefits Include

• Comprehensive medical, dental, vision, life, and short & long-term disability insurance + health savings account
• Matching 401k retirement plan + IRA's and Roth IRA's
• Generous paid time off and paid holidays
• Employee recruitment/referral bonus
• Paid community service hours
• Tuition reimbursement
• Employee discounts

At Global Commerce & Information, Inc. we celebrate, support, and are committed to creating a diverse and inclusive environment. We're proud to be an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, disability, age, veteran status, or any other legally protected characteristics.

Global Commerce & Information, Inc maintains a drug‑free workplace.