Job Title                                   : Business Intelligence Engineer
Experience                               : 3 - 7 Years
Location                                   : Chennai

Description :

Job Duties
•    Develops and deploys systems to support business intelligence, reporting, data warehouse and integration with enterprise applications; implements user access controls and data security measures where appropriate.

•    Own the design, development, and maintenance of ongoing metrics, reports, analyses, dashboards, etc. to drive key business decisions.

•    Anticipates opportunities for improvement; outlines and identifies alternate solutions and presents to management for final approval and implementation.

•    Develops and performs system testing and fixes defects identified during testing and re-executes unit tests to validate results.

•    Assists in the coordination efforts with management and end-users to evaluate the business to support delivery of effective business intelligence and reporting solutions. 

•    Develops and tests database scripts, stored procedures, triggers, functions, SSIS packages, and other back-end processes to support system integration and ETL (Extract, Transform, Load) to facilitate the creation and population of the Enterprise Data Warehouse. 

•    Assists with tabular and multi-dimensional modeling in addition to development of the Enterprise Data Warehouse.

•    Designs and develops interactive dashboards and reports. Creates and maintains documentation of processes, reports, applications, and procedures in accordance with department policy. 

Experience & Skills
•    In addition to the education outlined above, at least 3 years prior experience in business intelligence, data analytics and data warehouse reporting required.  
•    Proven track record of developing and testing database scripts, stored procedures, triggers, functions, SSIS Packages, and other back-end processes to support system integration and ETL to facilitate the creation and population of the Enterprise Data Warehouse.  
•    Strong SQL skills, business intelligence tool expertise, and report development skills are required.  
•    In depth knowledge of BI/Analytics/Statistical tools like Power BI, Tableau, Business Objects, SSRS, SSAS, and Excel.  
•    Strong knowledge of data modeling, data quality, and ETL/SQL server, in writing relational database queries and a general knowledge of SSAS (DAX/MDX) database queries. 
•    Working knowledge in configuring, deploying, and maintaining database servers is expected.   
•    Preferred programming skills using .Net along with general knowledge of NoSQL platforms, such as MongoDB.  
•    Strong written and oral communication skills with the ability to work in a cross functional team environment. 
•    Refined analytical thinking and problem-solving skills are needed.