Business Intelligence Architect (ETL ; SQL Server SSIS, SSRS)

Mphasis - California3.8

Job Description

Role: Business Intelligence Architect (ETL ; SQL Server SSIS, SSRS)
Location: Woodland Hills CA.
Account - Advisor Group Inc
Rate - $65 hourly
Position - 7736492

Who are we looking for?

A resource with following skills

Should be strong in Database programming, query tuning and ability to propose new designs and systems to meet customer requirements
Should assist daily business operations by responding to user questions, analyzing user requirements and propose solutions.
Should be able to prepare adhoc reports for business users and if require should be able to build datamarts and ETL packages to support reporting requirements
Should be able to coordinate with offshore team by clarifying queries, planning production release items
Knowledge on broker dealer operations, especially advisor commission system is a plus.

Technical Skills:
Database designing and programming using SQL 2008 and 2016
ETL skills using SSIS and reporting skills using SSRS
Microsoft Power BI

Process Skills:
SDLC, Agile

Behavioral Skills :
Good coordination skills
Adapt and learn new tools and skills.

Education qualification: B.Tech, BE, BCA, MCA, M. Tech or equivalent technical degree from a reputed college