Global CI (Global Commerce & Information, Inc.) · 3 days ago
Systems Analyst / Database Design Tier 4
United States
Full-time
Remote
Senior Level
7+ years expGlobal CI is an award-winning IT Services company focused on delivering high-quality technology consulting services. They are seeking a Systems Analyst / Database Design Tier 4 to design, develop, and maintain internal data processing systems, analyze customer needs, and provide customized solutions. The role involves extensive technical analysis, database design, and ensuring compatibility of hardware and software systems.
ConsultingGovernmentInformation ServicesInformation Technology
Responsibilities
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
Qualification
Required
7 years of systems analysis experience in a data warehouse environment using MS tools (MS Word, Excel, PowerPoint, and Project)
3 years of recent hands-on architecting data warehouse solutions
9-13 years related experience
Bachelor of Science in related field or equivalent
Ability to derive the pseudo code on metric calculations that can be used by the SDLC teams for Design, Development, and testing
Ability to write complex SQL queries to perform analysis on complex and large sets of data in various file formats
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
Close attention to detail
Must be a team player able to multi-task in a dynamic environment
Extensive working knowledge of the SDLC and the associated processes and documentation
Preferred
Experience implementing solutions in AWS Glue
Experience with MicroStrategy (2019 or higher)
Experience with Oracle (10g or higher)
Experience with Redshift environment
Strong background in SQL commands/functions/Procedures
Experience with database data modeling tools similar to Erwin
Experience with source to target mapping tools similar to Erwin Mapping Manager
Benefits
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
Company
Global CI (Global Commerce & Information, Inc.)
Global Commerce & Information, Inc.
51-200 employees
Funding
Current Stage
Growth StageLeadership Team
Michael Parrish
Chief Operating Officer
Company data provided by crunchbase