MS BI Architect

10 - 20 Years

Job Description

MS BI Architect

Location : Noida
Experience : 12-15 years

Practitioner of Microsoft Business Intelligence with Warehouse, ETL, Data reporting, Data prediction experience. SSIS, Power BI, Azure platform experience is mandatory. Good leadership and communication skills.

Job Description
Gather and analyze business requirements and translate business needs into long-term business intelligence solutions
Architect the Microsoft Business Intelligence solutions utilizing MS SQL Server 2012/2014/higher SSAS, SSRS, SSIS, Power BI, Performance Point, integration with Excel and SharePoint, for large Enterprises with multiple functions
Tailor solutions for Management dashboards, Financial Reporting and Operational Business Intelligence
Configure and optimize BI environment, which includes relational, and OLAP layers, and data migration components; work in collaboration with the data warehouse environment and team
Create predictive solution using concepts of data sciences by using appropriate toolsets
Define Business Intelligence framework and data model, semantic layers and BI Metadata repositories to support reporting and administration
Collaborate with application developers, business owners, and operation engineers to ensure the creation of production Business Intelligence designs and implementations
Define and enforce coding standards, design styles and best practices as a process
Participate in analysis sessions with the user community to capture, define data requirements clearly, completely and correctly
Motivate, coach and train young BI engineers on latest MS BI technology and trends

The person
At least 3 years of experience in design and architecting, developing and/or managing the implementation of Business Intelligence solutions using Microsoft SQL Server, MS BI technology stack
Experience in identifying, analyzing and translating business requirements and rules into intuitive analytical solutions, business scorecards and management dashboards- for Industries like Govt, Retail, Financial services
Understanding of Business Intelligence solutions: operational and analytical and predictive
Knowledge of relational and multi-dimensional database architectures- Expertise in the Microsoft BI solution offerings including SQL Server 2012/2014/higher (SSRS, SSAS, SSIS), Power BI, SharePoint
Hands on experience of using Azure BI stack for warehouse, ETL, Cubes. Experience in Azure usage standards and computing to estimate transaction and costs involved for migration
Should have knowledge in SharePoint, ASP.NET, MVC design patterns and design methodologies
Understanding of multidimensional database design and architecture- Experience and/or understanding of SQL Server Tabular Model - Excellent data analysis skills using SQL
Knowledge on competing products like Qlikview, Tableau, SAS, IBM Cognos, Oracle and open source products
Ability to document, articulate and present a compelling story about the solution and why is this the best fit in the form of Architectural diagram
Ability to create step by step Approach to build Intelligence and prediction
Ability to respond to commercial RFPs with solution, estimates
Strong analytical skills, an ability to present and communicate data, trends, insights and recommendations involving clients
Ability to conduct quality control/auditing to ensure accurate and appropriate use of data during the project system, integration test and UAT- Experience in delivering quality work on time with multiple, competing priorities

Salary: Not Disclosed by Recruiter

Industry:IT-Software / Software Services

Functional Area:IT Software - Application Programming, Maintenance

Role Category:Programming & Design

Role:Technical Architect

Employment Type:Permanent Job, Full Time


Desired Candidate Profile

Please refer to the Job description above

Company Profile

Agreeya Solutions India Private Limited

AgreeYa Solutions India Private Limited

AgreeYa Solutions is a global provider of software, solutions, and services focused on deploying business-driven, technology-enabled solutions that create next-generation competitive advantages for customers. Headquartered in Folsom, California, AgreeYa is a growing and dynamic organization with 15 offices in 8 countries employing more than 1,100 professionals. Over the last 15 years, AgreeYa has worked with 200+ companies ranging from Fortune 100 firms to small and large businesses, delivering solutions for variety of industries including telecommunications, BFSI, healthcare, high-tech, manufacturing, utility and government. AgreeYa's software portfolio includes SocialXtend (enterprise intranet and social collaboration), VDIXtend (Desktop-on-Cloud), Onvelop (enterprise mobility productivity suite), and Edvelop (single window collaboration and communication solution for 21st century learning). As part of its solutions and services offerings, AgreeYa provides intranet and enterprise collaboration on SharePoint, cloud and infrastructure, enterprise mobility, product engineering, application development and management, independent software testing, and staffing (IT and risk/compliance) solutions.
In just 15 short years, AgreeYa Solutions has amassed an impressive array of honors and recognitions including:
* Top 20 Most Promising Enterprise Software Companies for 2014 - CIOReview
* Named Gartner '2013 Cool Vendor in Enterprise Mobility'
* 'Top 3 Exciting Emerging Companies to Work For' in India, as selected by NASSCOM
* 'Top 5 Outsourced Product Development Companies,' selected by Silicon India
* Included in Sacramento Business Journal's 'Top Companies List'
* ISO 9001:2008, SEI CMMI certified
* Dell Preferred Partner
* Microsoft Gold Certified Partner

Our clients include leading organizations like Dell, Deloitte, Encore Capital, Hewlett Packard, JP Morgan Chase, Kaiser Permanente, LG Electronics, Liberty Videocon, Maruti Suzuki, Mitsubishi Motors, Sacramento Municipal Utility District (SMUD), Samsung, Tribune, Tesla, Verizon, Vodafone, Southern California Association of Governments (SCAG), Revionics among others.
For more information, visit To get the latest updates on AgreeYa Solutions
View Contact Details+

Recruiter Name:Amit

Contact Company:Agreeya Solutions India Private Limited