Direct Client:Sr. BI & Data Integration Consultant in Arkansas



Hello ,


Greetings from WizSoftech!!


This job position is for one of our direct client in Little Rock, AR. Let me know if you are interested asap.


Role:  Sr. BI & Data Integration Consultant

Expected Duration: 6 Months+

Interview Type: Either Phone or In Person

Location :  Little Rock, AR


Job Description: 

 

Supporting Arkansas Insurance Department’s role in the Affordable Care Act implementation with DW/Data Mart creation, Data Integration and Reporting using Microsoft and other technologies.

 

Candidates should be W-2 to the submitting Vendor.

Upload three verifiable references needed with candidate submittal (two from direct supervisors).

Candidate answers to questions must be provided upon submittal.

Please insure the resume identifies the candidates

   1) Highest Education Qualifications(s), year, place attended & GPA

   2) All certifications obtained 

 

This senior role and calls for ability to work alone and deliver with minimal supervision and guidance. This is much more than a BI developer role. Candidate must be able to single handedly design and create sound Data Warehouse/Data marts & deliver reports using Microsoft technologies (SQL Server/SSIS/SSRS etc.). Person should be able to advise and engage with experienced Server Administrators, DBAs and/or BI experts on development and production standards, security, best practices and architecture implementations while building DW/DM/ETL/Reporting environments using Microsoft technologies. Data modelling skills will be needed from conceptual models to physical models. Candidate will be responsible for producing quality reports with an eye for detail.

 

This role will call for the ability to engage with non-technical customers, anticipate their data needs and deliver on them. Excellent communication skills needed (both oral as well as written) with ability to elicit requirements from non-technical Subject Matter Experts and organization leaders & executives.

 

It is expected that the candidate would be able to immediately demonstrate at site, self-sufficient mastery using Microsoft technologies such as SQL, SSIS & SSRS. Person should be skilled in writing and maintaining complex SQL. High quality automation should be second nature to this person. Automation should be replete with failures alerts and logs for quick debugging.    

 

Candidate should be able and willing to quickly learn and use new tools as needed.

 

Candidate must be able to produce quality documentation.

 

Candidate should have familiarity with Project Management and reporting.

 

Should be able to prioritize and manage multiple tasks and adapt in a changing environment.

 

Experience in Health Insurance industry would be a big plus.

 

Skill

Required / Desired

Amount

of Experience

Experience in a Senior advisory role using Microsoft Technologies in BI/DW

Required

8

Years

 

ANSI SQL

Required

12

Years

Expert SSIS Skills

Required

6

Years

 

Data Modeling (DW plus Dimensional)

Required

12

Years

Data Processing Automation in the Windows Platform

Required

12

Years

 

SSRS/Crystal Reports

Required

6

Years

Excel (Superior Level)

Required

4

Years

 

Presentation Experience to Key Stakeholders

Required

4

Years

Superior Communication Skills

Required

 

 

 

Questionnaire::

 


 

 

 

Question1:


Ans
Describe your experience in advising and engaging with experienced Server Administrators, DBAs and/or BI experts on development and production standards, security, best practices and architecture implementations while building DW/DM/ETL/Reporting environments using Microsoft technologies.
Question2:

Ans:


Describe a) one of the more elaborate SSIS packages you developed and b) a DW/DM where you had the leading role in implementing.

--   Thanks and Regards    Sagar|IT-Recruiter|WizSofTech Inc  PH:608-721-0211,  Email: sagar@wizsoftech.net  Gmail: sagar.wizsoftech@gmail.com