Required Skills

SQL Server database engine Integration Services (SSIS) Analysis Services (SSAS) Reporting Services (SSRS) SharePoint

Work Authorization

  • Us Citizen

  • Green Card

  • EAD (OPT/CPT/GC/H4)

  • H1B Work Permit

Preferred Employment

  • Corp-Corp

Employment Type

  • Consulting/Contract

education qualification

  • UG :- - Not Required

  • PG :- - Not Required

Other Information

  • No of position :- ( 1 )

  • Post :- 22nd Dec 2020

JOB DETAIL

Sr. SQL Server DBA

Framingham, MA (Local Only)

Contract to hire

 

Additional Job Responsibilities Include:

•       Provide technical design and architecture guidance for complex enterprise data sources integration.

•       Establish and follow data gathering organization and delivering practices.

•       Recommended best technical solution options to meet current and future data growth.

•       Develop domain expertise to deliver high quality reports and dashboards.

•       Provide resource estimates, budgets, timelines and scope of work for different projects.

•       Follow industry and standard data governance and privacy policies (including PCI and PII).

•       Lead and mentor multiple technical team members.

•       Review, analyze, and evaluate business systems and user needs.

•       Design and document data flow and schema diagrams.

•       Design and develop BI solutions using SQL Server technology stack.

•       Develop reports and dashboards using SQL Reporting Services, Excel and SharePoint.

•       Work with QA team and end-users to perform testing/validation for release of cubes, new reports, features, and functionality.

•       Prepare and continuously refine Executive Level management reports measuring performance of various core metrics.

•       Respond to requests from key partners. Generate ad-hoc datasets to identify and solve day to day business issues.

 

Requirements:

Minimum job skills required to perform this job:

•       8+ Years of Database/Reporting/Business Intelligence Solutions

•       Bachelor's Degree in technology or information systems or equivalent work experience.

•       Master’s in Computer Science is a plus, any database certificate course/certifications is an added advantage.

•       Advanced level of Database Design and Business Intelligence Systems architecture

•       Designing large-scale high-performance systems

•       Being able to interpret business requirements into functional and then technical requirements

•       Understanding of designing workflow/process-based systems

•       Ability to write SQL code & stored procedures, performance tuning and optimization.

•       Microsoft SQL Server technologies SQL Server database engine, Integration Services (SSIS),Analysis Services (SSAS) and Reporting Services (SSRS).

•       Data Modeling principles for relational and Data warehouse design principles (Kimball)

•       Data integration from multiple sources such as Oracle, MS-Access and NetSuite.

•       SharePoint Foundation Services/SharePoint Performance Point Services

•       Advanced level Excel and PowerPivot for Excel

•       Experience with Dashboarding and Data visualization tools & technologies (ex: Cognos, Tableau)

•       ASP.NET, C# development experience would be helpful

•       Retail Operations, Shipping & logistics experience a big plus

•       NetSuite/other ERP systems integration preferred

 

 

 

Amar

A - IDC Technologies Inc. | Milpitas, CA

E-:amar@idctechnologies.com  

P-:408-668-9228 (Prefer)

L-: https://www.linkedin.com/in/amar-65288155/

W-:http://www.idctechnologies.com

Company Information