ALTA IT Services, LLC · 3 hours ago
Systems Analyst - Data Warehouse Design
Baltimore, MD
Contract
Hybrid
Senior Level, Lead/Staff
$40/hr - $40/hr
9+ years expALTA IT Services, LLC is a leader in delivering outsourced services and workforce solutions across North America. They are seeking a Systems Analyst to design and implement data warehouse solutions, analyze customer needs, and develop customized solutions for complex applications.
ConsultingInformation TechnologyStaffing Agency
No H1B
U.S. Citizen Only
Responsibilities
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
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
Must possess 7 years of systems analysis experience in a data warehouse environment using MS tools (MS Word, Excel, PowerPoint, and Project)
At least 3 years of recent hands-on architecting data warehouse solutions
9-13 years related experience
Bachelor of Science in related field or equivalent years of experience
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
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
Extensive working knowledge of the SDLC and the associated processes and documentation
Preferred
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 and database data modeling tools similar to Erwin, source to target mapping tools similar to Erwin Mapping Manager
Experience with MicroStrategy BI tool is advantage
Benefits
Health and welfare benefits coverage options including medical, dental, vision, spending accounts, life insurance, voluntary plans
Participation in a 401(k) plan
Company
ALTA IT Services, LLC
ALTA IT Services, LLC combines experience and expertise to deliver IT talent that meets and exceeds the expectations of our clients.
201-500 employees
Funding
Current Stage
Growth StageTotal Funding
unknown2015-12-18Acquired
Leadership Team
Bonnie Wells
Senior Business Development Manager - Strategic Staffing Partner
Company data provided by crunchbase