Software Engineer, with the following duties:
Designing, Developing and Maintenance of Data Warehouses Systems. Designing, Developing, Implementing and supporting the ETL jobs using SSIS for data extraction from transactional systems to Data warehouses systems. Designing and Development of BI Systems using BI Tool Microstrategy 9.x/10.6 (Intelligence Server, Agent, MDX Adapter/OLAP Provider, Object Manager, Web, Mobile Server and Narrowcast Server). Designing and Development of Business Critical Reports, Ad-hoc Analysis, Dashboards, Documents and other Microstrategy objects (Attributes, Facts, Metrics, Hierarchies, and Transformations etc.).Adept in Dash boarding and Documents for web/mobile. Strong knowledge of Retail, Reinsurance and Mortgage functional domain to support in providing detailed data analytics to meet business critical decisions. Live support in day to day Production issues, and Troubleshooting ETL job failures. Data analysis and troubleshooting data related issues. Work with end user for requirement gathering and day to day production issues. Focus on achieving best possible performance by using advanced design techniques. Strong problem solving and reports development skills. Perform unit testing on finished work items.
BS degree in computer science or a related field.
2 years of experience in the offered position, or in the alternate job title of Advisory Software Engineer or a related occupation.
Microstrategy 9.x/10.x,SSIS,SQL Server 2008/2012, Oracle10g,PLSQL. Employer will accept any suitable combination of education, training, or experience.
The position is 40 hours per week, 9.00 a.m.- 5.00 p.m., Monday-Friday. Current job site is in New York, NY but there is a possibility of relocation to either Pittsburgh, PA or Cranbury,NJ.