Job summary:


Title:
MS BI Developer - w2 or 1099

Location:
Phoenix, AZ, United States

Length and terms:
Long term - W2 or 1099 only


Position created on 03/27/2020 05:55 pm

Job description:


**  Initial PO for 12 months; usually projects with this customer goes for 3+ years *** Possible contract to hire; no visa candidates ***

W2 or 1099 only - no c2c ; hourly contract.

The Sr. Database Developer contributes to the success by designing and developing complex data-centric solutions, including data warehousing, system integration, ETL & data integration, and BI/semantic models, e.g. SSAS.

The incumbent will participate in the full life-cycle of solution implementation, from requirements gathering/review and data modelling through development, testing, implementation and maintenance.

Expert level skills with Microsoft SQL Server database and BI technologies and data modeling/architecture are required.


Duties

  •  Work with business analysts and subject matter experts to assess and understand business’ data and BI requirements.
  •  Design, develop and implement and maintain data integration solutions data between operational systems and data warehouses.
  •  Design and implement robust data models (relational and dimensional) that are right-sized, scalable, and maintainable.
  •  Ensure that solutions/code are well-managed in source-control.
  •  Serve as an administrator for data warehouse, reporting, and BI solutions; contribute to database backup/restore strategies, security, and change-management/deployment practices.
  •  Create and maintain documentation of data-warehouse/BI architecture, including ERDs, process flows, data flow diagrams, etc.
  •  Mentor other team members, providing design guidance, troubleshooting and code-reviews as necessary.
  •  Stay current with industry best practices and technologies related to data, reporting, and Business Intelligence (BI), including cloud-based technologies, e.g. SQL Server stack in Azure. Provide guidance as we chart our path to the cloud within the data/BI space.

Skills

  •  Minimum of five years progressive experience as a Database Developer or DBA, including physical database design/implementation, ETL development, and report development. Experience must include support of DW/BI systems. Experience in healthcare services industry is preferred.
  •  Ability to understand and deconstruct complex business processes, e.g. loan origination & servicing, into meaningful data structures.
  •  The ability to work in teams (and with individuals) of diverse backgrounds in a cooperative and productive partnership.
  •  Strong organizational skills and attention to detail, able to work with a minimum of supervision, ability to meet deadlines, work independently, and manage multiple tasks and priorities
  •  The ability to learn rapidly, to ask relevant and insightful questions, and take instruction constructively.
  •  The ability to analyze problems, identify root-causes and make good decisions quickly
  •  5+ years experience directly supporting data warehousing and data integration solutions
  •  5+ years experience with the Microsoft SQL Server stack; i.e., SQL Database Engine, Integration Services (SSIS), Analysis Services (SSAS), Reporting Services (SSRS).
  •  Advanced experience with the T-SQL scripting/programming language, including the ability to develop, test, and debug complex ad-hoc queries, stored procedures, and data migration scripts.
  •  Strong knowledge of standard data modeling patterns and best-practices, e.g. 3NF, dimensional models.
  •  Strong understanding and experience with various ETL/ELT strategies and system design (staging environments, data transformation, change data capture, slowly changing dimensions, etc.), with an eye towards delivering functional, scalable and maintainable solutions in a timely manner.
  •  2+ years developing and supporting SSAS Tabular or PowerBI solutions.
  •  Experience supporting user-facing Report/BI tools (SSRS, PowerBI, Tableau, etc.)

Contact the recruiter working on this position:



The recruiter working on this position is Karthik Gudaboinya(Shaji Team)
His/her contact number is +(1) (703) 5742066
His/her contact email is karthik@msysinc.com

Our recruiters will be more than happy to help you to get this contract.