4 Datawarehouse Concepts Jobs

As a Business Analyst with 7-14 years of experience, you will be responsible for various tasks including Business Requirement Documents (BRD) and Functional Requirement Documents (FRD) creation, Stakeholder Management, User Acceptance Testing (UAT), understanding Datawarehouse Concepts, SQL queries, and subqueries, as well as utilizing Data Visualization tools such as Power BI or MicroStrategy. It is essential that you have a deep understanding of the Investment Domain, specifically in areas like Capital markets, Asset management, and Wealth management. Your primary responsibilities will involve working closely with stakeholders to gather requirements, analyzing data, and testing systems to ensure they meet business needs. Additionally, you should have a strong background in investment management or financial services, with experience in areas like Asset management, Investment operations, and Insurance. Your familiarity with concepts like Critical Data Elements (CDEs), data traps, and reconciliation workflows will be beneficial in this role. Technical expertise in BI and analytics tools like Power BI, Tableau, and MicroStrategy is required, along with proficiency in SQL. You should also possess excellent communication skills, analytical thinking capabilities, and the ability to engage effectively with stakeholders. Experience in working within Agile/Scrum environments with cross-functional teams is highly valued. In terms of technical skills, you should demonstrate proven abilities in analytical problem-solving, with a deep knowledge of investment data platforms such as Golden Source, NeoXam, RIMES, and JPM Fusion. Expertise in cloud data technologies like Snowflake, Databricks, and AWS/GCP/Azure data services is essential. Understanding data governance frameworks, metadata management, and data lineage is crucial, along with compliance standards in the investment management industry. Hands-on experience with Investment Book of Records (IBORs) like Blackrock Alladin, CRD, Eagle STAR (ABOR), Eagle Pace, and Eagle DataMart is preferred. Familiarity with investment data platforms including Golden Source, FINBOURNE, NeoXam, RIMES, and JPM Fusion, as well as cloud data platforms like Snowflake and Databricks, will be advantageous. Your background in data governance, metadata management, and data lineage frameworks will be essential in ensuring data accuracy and compliance within the organization.,

Role: Business Analyst Experience: 7-15 Years Skills: BRD/FRD Stakeholder Mngt UAT Testing Datawarehouse Concepts SQL joints and subqueries Data Visualization tools-Power BI/MSTR Finance Domain Technical Skills: 8+ years of experience as a BSA or similar role supporting finance or data analytics projects. Proven track record of Analytical and Problem-Solving skills. Good understanding of corporate finance processes (e.g., FP&A, treasury, controllership, capital planning). Familiarity with data engineering concepts: ETL/ELT, data lakes, data warehouses. Experience with BI tools (e.g., Power BI, MicroStrategy, Tableau) and SQL querying. Excellent communication, analytical thinking, and stakeholder engagement skills. Experience working in Agile/Scrum environments with cross-functional delivery teams.

You are being offered the opportunity to join GeBBS Healthcare Solutions as a Datawarehouse ETL Lead with 6-9 years of experience in SSIS & ADF. The role is based in Airoli Navi Mumbai and requires you to work from the office. As an ideal candidate, you should hold a qualification in any IT Graduate/Post Graduate. Your responsibilities will include developing, designing, tuning, and maintaining ADF/SSIS packages for the ETL process. You will be required to design and develop SQL Server stored procedures, functions, views, and triggers to support the ETL process. Additionally, you will design and implement ETL solutions using data integration tools to interface between the source application and the Enterprise Data Warehouse. In this role, you will create ETL technical specifications, designs, and test data solutions for optimal performance. You will integrate ETL development with existing projects to maximize object reuse and document unit test plans for ETL and data integration processes. It will be your responsibility to troubleshoot data issues and defects, perform root cause analysis, and provide resolution. Moreover, you will be expected to focus on performance tuning of the ETL process and SQL queries. You will also develop transformation queries, views, and stored procedures for ETL processes and automation. Team handling, task distribution, task estimates, and collaboration with the HR team will also be part of your responsibilities. Key skills required for this position include T-SQL, Azure Data Factory (ADF), SQL Server Integration Service (SSIS), and knowledge of Datawarehouse concepts. Additionally, familiarity with Power BI would be advantageous. If you are interested in this exciting opportunity, please share your application with Nidhi Parekh from the HR team at nidhi.parekh@gebbs.com. We look forward to potentially welcoming you to the team at GeBBS Healthcare Solutions.,

Tableau Position Mandatory Skills : Strong Tableau Dashboard Creation and SQL skills Desired Skills : Worked on Datawarehouse like BigQuery, Ad Tech Domain knowledge Work Location : Pune Experience : 5-6 years of Tableau Dashboard creation Job Responsibilities : Understand requirements for Dashboards and creating effective dashboards in Tableau as per clients UX standards. Strong in SQL and Datawarehouse concepts. Experience in creating extracts and worked on Tableau server. Data Understanding: Collaborate with business stakeholders to understand their data requirements and reporting needs. Analyze complex datasets to identify key insights and trends. Data Preparation: Cleanse, transform, and prepare data for visualization. Use SQL queries to extract and manipulate data from various sources, such as databases, data warehouses, and cloud platforms. Dashboard Creation: Design and develop visually appealing and interactive dashboards using Tableau's drag-and-drop interface. Create custom calculations, parameters, and filters to provide dynamic insights. Format dashboards to adhere to client branding and UX standards. Data Storytelling: Present data in a clear and compelling manner, using charts, graphs, and other visualization techniques. Tailor dashboards to specific audiences, adjusting the level of detail and complexity. Performance Optimization: Optimize dashboard performance to ensure fast loading times and smooth interactions. Implement best practices for data extraction, calculation, and visualization. Collaboration: Work closely with data analysts, data engineers, and business users to deliver timely and accurate insights. Provide technical support and training to end-users.