Open Systems Technologies is a national provider of smart staffing solutions, providing contract staffing, permanent placements and executive searches in the following skill areas:
- Technology
- Finance, Accounting, and Operations
- Government Services
- Legal
- Global Services
Established in New York in 1990, Open Systems Technologies is one of the largest, privately held, staffing companies in the world. We have experienced organic growth over the past 25 years and currently employ over 1,500 consultants in 16 domestic and international markets. Through our brands of Open Systems, OST Financial, OST Legal, OST Government Services, and OST Global we strive for continued expansion and excellence in the staffing industry. With the Global Services division, starting Jan-2012, Open Systems has expanded into the ITO & BPO Projects/Solutions business.
Required Skills: 2+ years of experience with Big data access integration and analuyics 8+ years of experience in data modeling, relational and dimensional 8+ years of experience with Erwin or ER/Studio tools 8+ years of experience in Data Integration architecture 8+ years of experience in BI reporting architecture and strategy 8+ years of experience in multiple relational database systems (SQL Server, Oracle, DB2) Experience with high volume systems Working experience in data architecture and modeling using industry best practices Strong verbal, presentation, and written communication skills Strong initiative, ability to self-manage, and also work in a team environment
Critical Skills: Solution design skills for data related functions of projects Big data access integration skills Conceptual, logical, and physical data modeling skills as applicable to Relational and Dimensional data model design Data Integration architecture skills BI Reporting architecture skills ER/Studio 8/9 data modeling tool skills Application DBA Skills Data Quality and Data Analysis skills Oracle 10g/11g SQL/PLSQL skills SQL Server 2008/2012 MS-SQL skills Preferred Skills: Experience in Hadoop ecosystem: cloudera/pivotal Experience in mapreduce, Hive, Impala Experience in ER/Studio portal Experience in Informatica PowerCenter Experience in Unix (AIX) shell scripting Experience in Financial projects Experience in Data migration projects
Responsibilities:
Conform to the capabilities in the reference architecture Allow for data access using defined business driven sharing constraints Incorporate new and existing technology platforms with defined use (e.g. NoSQL, content management) Rationalize solution and costs of new data assets integration Incorporate modeling standards to represent the data (metadata) and drive search Provide search capabilities to understand a full picture of business terms and source of that data Ability to request access to data including the workflow necessary (data marketplace) Ability to understand the interfaces that can provide that functionality Provide sandbox functionality to users of the datasets to build models for analysis in a secure way Provide physical access to the data assets for current analytics tools such as Stata, SAS, etc Provide physical access to using advanced analytics tools Lead and facilitate information gathering sessions to validate business cases Perform data analysis to gain understanding of various subject areas Provide design artifacts and documentations Mentor team members as required by providing guidance on technical and procedural questions Communicate with data architects/developers, SMEs, Infrastructure DBA, application architects/developers, business users, stakeholders, and project managers
All your information will be kept confidential according to EEO guidelines.