Open Systems Technologies is a national provider of smeart 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.
Responsibilities
- Develop and support Data Warehouse and Business Intelligence solutions
- Create and maintain complex SSIS ETL packages
- Create complex queries, data transformation, aggregation, stored procedures, and triggers
- Work with colleagues to clarify program objectives, determine scope, identify problems and recommend solutions
- Develop of ad-hoc SQL to research data questions
- Performance tune ETL, stored procedures, and reports to keep databases and applications optimized
- Identify root causes in case of ETL failures
- Perform code reviews, data validation, and system testing for Data Warehouse changes
Qualifications
- Expert knowledge of Transact-SQL
- Minimum 7 years' experience of the following technologies is required: SQL Server 2008/12, SQL Server Integration Services (SSIS)
- Experience modeling and designing Relational Databases, Star Schemas, and cubes (Kimball)
- Experience in logical and physical data modeling
- SQL Server Analysis Services (a plus, not required)
- Experience with using MDX to query Analysis Services cubes (a plus, not required)
All your information will be kept confidential according to EEO guidelines.