Job Description
Opportunity for Business Analyst - Data Warehouse for Gurgaon Location - Wipro
Level: Analyst/ Sr. Analyst
Shift Timings: 12:00 IST to 21:30 IST (should be flexible with shifts)
Job Description:
At Client COE, were proud to stand at the forefront of the Technology initiatives. Using the latest analytic tools and processes, we're able to maximize our offerings and deliver unparalleled service and support. To help carry us even further, we're searching for an experienced Business Data Analyst to join our team. The ideal candidate should be highly skilled in all aspects of Datawarehouse creation, data analytics, including mining, generation, and visualization. Additionally, the candidate should be committed to transforming data into readable, goal-driven projects for continued innovation and growth.
Objectives of this Role - The success criteria and objectives are bifurcated into 3 major capabilities:
1) Business/Data Analyst Capabilities:
• BA Capabilities: Must have a good understanding of SDLC Software Development Life Cycle and hands-on experience on Datawarehouse requirement gathering, documentation of Business Requirement documents (BRDs), Functional Requirement Documentation (FRDs) & other data artefacts like data flow diagrams along with validations and testing of the developed databases.
• Business Acumen: A technical data analyst that studies and understands the company's business processes, financial systems and applications. Should be able to include their effect on data and reporting and applies the gained knowledge in designing data warehouses/databases and reports.
• Financial Domain Exposure: The technical data analyst must have hands-on implementation, development and support experience, preferably gained within one or more Commercial Real Estate, Private Equity, financial institution, investment banking and/or projects.
2) Data Modelling Capabilities:
• Data Modelling: Understanding logical and physical database designs, data modelling: LDMs, PDMs for required changes along with proficiency in both Star Schema/Snow-Flake Schema data modelling techniques and designs dimensional models with conformed dimensions, following the business processes.
• E-R Diagram preparations: Should have the ability to Reverse Engineer existing databases to understand Entity-Relationships and should be able to propose and create new dimensional models and ER diagrams of proposed states.
• Data Artifacts Preparations: Creates processes for maintaining and capturing metadata, data dictionary and data catalogues.
The ideal candidate is an
Experienced business data analyst and data modeller with PL/SQL and ETL knowledge along with development background to provide definition on new Data Schemas, Data Ingestion for Data platforms, multidimensional cubes and databases for large & complex financial datasets.
Requirements: Overall Relevant experience ranging from 3 to 5 years
Sensitivity: Internal & Restricted
• 3+ years of strong experience with Data Transformation, Datawarehouse/Database creation & ETL on large data sets.
• 3+ years of Data Modelling experience (i.e. Relational, Dimensional, Columnar)
• 3+ years of complex SQL or NoSQL experience.
• Experience in advanced Data Warehouse concepts.
• Experience with Business Requirements definition and management, structured analysis, process design, use case documentation.
• Experience in professional software development capacity using SDLC, waterfall and Agile model of development.
• Demonstrate exceptional organizational skills and the ability to multi-task simultaneously with different parallel projects.
• Strong verbal & written communication skills to interface with business teams & lead towards a successful business outcome.
• Must be self-managed, proactive and customer-focused.
• Degree in Computer Science, Information Systems, Data Science or related field.
• Good to have - Experience & knowledge with DBA activities in SQL Server 2008 R2, 2012, 2016, and 2017 as well as 2019 features along with any other cloud-based databases like Snowflake and Multidimensional databases.
Experience with more than one combination of the below software - highly desired:
• Business Intelligence Tools: Tableau, Power BI
• Expert level exposure and hands-on scripting on PL/SQL
• Good knowledge of ETL and related tools like Informatica, Alteryx.