Senior Architect - Business Intelligence

KAMMS Management Consultants Private Ltd
  • Chennai
  • 25-35 lakh
  • 15-25 years
  • Views
  • 31 Oct 2018

  • IT/ Information Technology

  • Consumer Durables/ Semi Durables
Job Description

Role & Responsibilities: 
Understand business goals and develop a strategy aligned to the goals that capitalizes on technology insights to improve the value of analytical data, improve effectiveness of information stewardship, and streamline the flow of data in the organization.
Create and implement detail level design for both Data Warehouse and Business Intelligence layers
Design data models, data flows and data architecture artifacts at a detail level to accommodate global regions, multiple business lines and multiple product lines in one consolidated GDW
Provide alternative options and approach to possible BI solutions to a problem
Manage and plan task framework for implementation of solutions
Interact closely with business and source system SMEs on source system analysis and gap analysis with current Data Warehouse environment as related to the requirements in hand
Partner with cross functional / technical teams in the areas of database, infrastructure, network and licensing
Capacity planning for all aspects of Data Warehousing, including databases, servers and tools
Follow the SDLC/Agile approach in implementation of the WBS
Skills:
15+ years of Experience in Architecting Data Warehousing and Business Intelligence solutions
15+ years of experience in Data Modeling with 10+ years in Dimensional Modeling, using ERwin and/or other industry leading data modeling tools
10+ years of experience with leading matrix teams on technical discussions (Designer/Developer/Ops Support)
10+ years of experience in SQL and Oracle PL/SQL. Should be able to write complex ad-hoc queries using tools like TOAD and also be able to generate ad-hoc reports as needed by the Leadership/Business
10+ years of experience in ETL (Informatica, IBM DataStage or other industry leaders), Reporting (Cognos, SAP Business Objects or other industry leaders) and Dash boarding (Tableau, TIBCO Spotfire or other industry leaders) in an architectural role
4+ years of experience with Data Quality (IBM QualityStage, Informatica Data Quality or other industry leaders)
5+ years of experience with shell scripting and/or other scripting languages such a Perl
Strong communication skills and ability to run meetings and establish credibility with the Business team
Experience with tool and technology evaluations; business process re-engineering principles and processes; and Master Data Management
Experience in diverse environments including disparate data sources and varied implementations such as On-cloud/On-premise solutions, is critical
Experience in data profiling, preparation and cleansing
Well versed with upgrades related to database platform, ETL tools and BI tools
Experience and certification in Six sigma / ITIL concepts is a plus
Experience with Oracle Financials, including AR, AP and GL modules, as a source system is highly preferred
Experience with Progress database and 4GL language is a plus 


Job Posted By