• Phone: +1-425-502-5094
  • info@deevita.com
  1. Home
  2. /
  3. Careers
  4. /
  5. Current Openings
  6. /
  7. Senior SQL Server MSBI Developer

Senior SQL Server MSBI Developer

Job Description

Do you have experience in building enterprise scale data integration and reporting solutions? Are you looking for a challenging role to build large scale BI platform for enterprises? If yes, we would like to talk to you about this excitingrole. 


DeeVita is looking for a Senior SQL Server MSBI developer with strong exposure SQL, SSIS, SSRS to be part of a passionate team that is building Data & Analytics solutions for our strategic enterprise customers. The person will be building enterprise scale data integration platform and solutions for our customers in USA that enables workflow integration of core products and services in more agile manner. The position requires someone with deep knowledge of SQL Server T- SQL, SSRS, Integration Services (SSIS) and exhibit advanced level working knowledge to deliver complex systems and solutions by leading Design, Architecture and implementation efforts. Preferred experience in Healthcare, Financial industries.

Responsibilities

  • Review and understand product requirements through specification reviews, engagement with customers and peer team members
  • Design holistic system leveraging various SSIS/SSRS advanced level features and develop system design and document that outlines implementation scope for entire team, review & get sign off from all stakeholders 
  • Design database schema, data modelling and T-SQL, Stored procedure development to implement core backend functionality of the features. 
  • Implement SSIS based complex solutions that involves heterogeneous set of data sources 
  • Develop advanced reporting solutions using SSRS/SQL server technologies 
  • Engage with Customers and stakeholders in all phases of project life cycle requirements gathering, solution design reviews, execution, and status reviews 
  • Deliver innovation in design and solutions leveraging latest best practices in the area of expertise, evangelize across the team to adopt them, and continuously keep updated oneself on latest technologies 
  • Ensure the design proposal makes balanced tradeoff across schedule, cost, technology and compliance requirements 
  • Sets best practices for systems development and diligently enforces them across the projects through combination of process, education, training and sufficient review processes.

Required Qualifications

  • 3-5 years of relevant experience in architecting, design and development of data systems (OLTP, BI/ETL) at enterprise scale
  • Masters/Bachelor’s degree in computer science/engineering or related fields 
  • At least 2+ years of experience in SSIS, ETL, Data Integration development in driving design, implementation of larger scale data integration, data systems development 
  • At least 2+ years of experience in Reporting development using SSRS (and related technologies) implementing complex business logic, performance tuning of large volume queries 
  • At least 2+ years of experience in SQL Server Database development in stored procedures implementing complex business logic, performance tuning of large volume queries
  • At least 2+ years of experience in .NET/C#, Scripting languages and web technologies to enable data access through API, Web and from SSIS 
  • Experience in developing a real time production transaction processing system.