— February 6, 2017

Experience : 5 – years
Requirements :
Task Info :


Minimum Job Description (Purpose of the Position)

– Proven experience in database design, data modeling, SQL server, T-SQL, query optimization,

   common DW principles and ETL development a plus including SSAS, SSRS, SSIS.

– Detail oriented, with ability to produce high quality analytical reports and specifications.

– Reporting to offshore lead and communication with US based Project Manager (at times clients


– Providing support to clients/customers over conference calls/emails/IM.

– Documentation of activities performed.

– Ensure that established standards, processes and best practices are adhered to.

– Work under supervision executing the responsibilities of the job and ensure that all commitments

    and deliverables are met.

– Manage and support SQL Server databases that include but not limited to- writing complex

   SQL queries, stored procedures, functions, triggers, managing permissions etc. – preferred.

– In-depth understanding of SSIS based solutions.

– Open to work in US/UK shift timings.

Key Roles and Responsibilities in detail

– Monitor, troubleshoot & resolve SQL Jobs (Database processing & tabular cube processing)

– Communicating with teams upon success / failures

– Engaging with FTE Leads for any clarifications on timely manner

– Streamlining the job failures so it doesn’t fail again with similar reason

– Will be involved in Development (Sprint activities) depends on bandwidth

– Feature Analysis, Feature, Code & output validation-

– Deployment release management (Dev, UAT & Production)

– Job development

– Infrastructure Management & Run Management

– Job Logging & Auditing-

– Feature Testing

– Data analysis and profiling acquisition/usage i.e. AX7, CRMOL, any new product.

Competencies required other than skills:

– Advanced Excel Skills (Pivot table modifications, Data Connections, Power Pivot, Power Query &

   Power BI)

– Advanced SQL Services Skills (Reading and writing SProcs, Data Models, Data manipulation

   queries & Joins etc.) and intent to learn further

– Experience working in VSTF & TFS (Navigating source control explorer & Opening Tabular Models,

   Managing source code)

– Experience reading and writing Multidimensional Expressions (MDX)

– Experience with navigating, modifying and managing SSAS Cubes

– Good verbal/written communication skills to comprehend assigned work and provide status.

   Should be able to work in a team of data analysts.

– Very Good analytical and problem solving skills on given data to provide insights

– Experience in using MS Office (Excel, Word, Outlook and SharePoint).

– Perform in-depth statistical/data analysis for reporting purpose.

– Be able to independently work on multiple tasks under some supervision.

– Ability to "think outside the box" and ability to work productively in a team.

– Familiarity with the Microsoft system & environment preferred.

College Preference : no-bar
Min Qualification : ug
Skills : business intelligence, database, data modeling, etl, excel, sql server, sql server integration service (SSIS), ssrs
Location : Gurugram

About the Author

Our Top Authors

Download Analytics Vidhya App for the Latest blog/Article

Leave a Reply Your email address will not be published. Required fields are marked *