Previous Job
MSBI Developer
Ref No.: 18-08391
Location: Purchase, New York
Job Title               :                  MSBI Developer
Location               :                  Purchase, NY
Job Type              :                   Fulltime / Permanent 
Job Description: 
  • The successful candidate will be responsible for developing, supporting and integrating new and existing business systems.
  • The candidate will support the Business Intelligence and Self-Service reporting, institutional reporting, visualization, and analytic initiatives. 
  • Developing, supporting and integrating a variety of financial and airline operations systems.
  • Gather business requirements based on process analysis and user interviews to develop application specifications.
  • Integrate data between operational systems and business reporting tools.
  • Interact with business users to identify dashboard strategies, report layouts, and analysis presentations.
  • Create/manage Projects, Database Views, Data Sources and Data Connections using SSRS.
  • Build, customize and publish interactive reports, visualizations and dashboards using SSRS.
  • Lead meetings with technical peers regarding the solution designs.
  • Lead unit and integration testing activities and participate in user acceptance testing as needed.
  • Efficiently manage time for timely project deadlines as well as ad hoc requests. 
  • MS or BS in computer science or equivalent education
  • At least 5 years of experience in data warehouse and/or data integration development and maintenance.
  • Excellent knowledge of data warehousing concepts, theories and best practices.
  • At least 2 years of experience in working with ETL & BI tools (SSIS, SSRS)
  • At least 3 years of experience working SQL Server (T-SQL and Stored Procedures)
  • Ability to design and develop complex ETL structures to extract, transform and load data from multiple data sources into data warehouse and other databases based on requirements.
  • Ability to collaborate with Business Analysts and Project Mangers to convert functional specifications into technical specifications.
  • Excellent communication (oral and written) and interpersonal skills, is a proficient problem solver, ability to acquire new skills quickly and thrive in a collaborative team environment.
  • Solid critical thinking & trouble shooting skills.
  • Must be a self-starter, able to work independently and as part of team.
  • Provides status updates to appropriate levels of management.
  • Familiarity with Tableau Desktop a plus.
  • Hands-on Tableau Server Administration a major plus.
  • Familiarity with Clarity a plus.
  • Familiarity with Cognos Reporting a plus.
 EEO Employer – Minorities/Females/Disabled/Veterans/Gender Identity/Sexual Orientation.

Warm Regards,
Viren Singh
Lancesoft Inc.
Direct: 703-889-6697 |