MSBI Data Analyst

TT Technologies, Inc. is looking for MSBI Data Analyst to work in Flushing, NY and various unanticipated locations throughout the U.S. Must possess a minimum of a Bachelor of Science degree in Engineering/Management/Computers/ Business Administration/ Information Systems/ Finance/Math or Foreign Equivalent.  

Job duties must consist but are not limited to the following:

  1. Utilize ETL tool SSIS for developing the Data Warehouse Loads with Data Acquisition and Data Integration.
  2. Design confirmed and traditional ETL Architecture involving source databases such as DB2, SQL Server and Target databases such as SQL Server, XML, and Flat Files (fixed width and delimited)
  3. Design Fact and Dimension Tables as per the reporting requirements and ease of future enhancements.
  4. Design and Develop Complex Mappings applying various transformations such as lookup, sequence container, aggregator, ranking, stored procedures, joins, and sort.
  5. Work with Entity Relationship (ER) Diagrams, star and Snowflake schemas.
  6. Create database objects such as Tables, Views, Stored Procedures, Triggers, etc.
  7. Use constrains to maintain Referential Integrity, Domain Integrity, and Column Integrity.
  8. Identify Primary Keys at design time and creating the same.

Position may require travel.  Send resumes to, or Fax # 347-626-2535