Profile / Function
To be a key member of this dynamic team, you should have expertise in the design, creation, management and business use of large datasets. You should have excellent business and communication skills to be able to work with business owners to develop and define key business questions, and to build data sets that answer those questions. You should be expert at designing, implementing and developing stable code for user-facing reporting. Above all, you should be passionate about working with data, discovering anomalies and trends, someone who understands data and can apply it to answer business questions and drive change. The Business Intelligence Reporting Team works with various business units to provide the key performance indicators and detailed information required to help make business decisions by identifying trends and patterns in stored operational data.
Essential Job Duties
- Statistical analysis on data and turning it effectively into actionable information for both internal and external customers.
- Design, develop, and deploy business intelligence reporting solutions using a variety of BI reporting tools.
- Work with other teams and core database engineers to develop and document business-specific data marts and reporting aggregate strategy.
- Assist in building and deploying OLAP cubes (dimensions, measures, calculated members) based on business requirements.
- Troubleshoot and resolve reporting environment issues.
- Work with business units to enhance the reporting environment and adapt to changes.
Key Responsibilities
12–15 years of experience in delivering Business Intelligence content to end users using various front-end tools (Microsoft SQL Server 2008, Oracle).Should have played the role of database architect in at least two end-to-end large-scale engagements.Prior experience in designing data models and data loading processes.Expert knowledge in SQL and MDX programming required to generate queries, stored procedures, derived tables, and performance tuning.Experience in ETL / Reporting / OLAP tools and various DWH appliances like ETL design / metadata management.Understanding and implementation of Data Warehouses and Marts, multidimensional database architecture, virtual cubes, and perspectives.Excellent verbal and non-verbal communication skills.Microsoft SQL Server and Oracle background with excellent SQL skills.Analytical and problem-solving skills.Ability to work well in a dynamic, fast-paced environment.Very methodical and capable of devising strategies to make sense of large volumes of data.Web development experience (ASP, HTML & .NET MVC) is a plus.SharePoint BI integration tools experience is a plus.Logical thinker who can work well in teams and individually.Requires an innovative individual with initiative and flexibility, open to ideas and concepts.Proven ability to analyze data, create high-quality reports / presentations for senior management, manage change, and provide leadership in complex data management solutions.Demonstrates functional and professional knowledge to ensure that deliverables are completed on time and meet quality standards.Tools
MS Reporting / Analysis Services 2005 & 2008, SSIS and DTS packages, SQL Server 2012 / 2016, Oracle 12c, FileZilla, WinSCP, SSH Secure Shell, WinZip tools, Various ETL Engines
Languages
SQL, PL / SQL, XML, Oracle
Qualifications
Post-Graduate / Graduate (IT Qualification Required : BE IT / BCA / MCA preferred or / and Certified Course from reputed IT institutes)
Skills Required
Business Intelligence, Data Analysis, Data Warehousing, Data Modeling, Olap, Sql, Pl / sql