Data Analytics

2 months ago


Vadodara Gujarat, India bankbenchers Full time

**Job description**

**Required Experience: 2 to 5 Years**

**Position Overview**: As a Data Manager cum Analytics, you will take a lead role in managing and optimizing databases, crafting efficient SQL queries, and collaborating closely with developers to enhance query performance. Your expertise in Excel, Python, and Visual Basics will be essential for data manipulation, and your proficiency in data visualization will be crucial for creating insightful dashboards.

Your responsibilities will extend to implementing data table structures, optimizing indexing strategies, and ensuring effective data tenancy models. Additionally, you will be involved in data modeling, encompassing entity relationship diagrams (ERDs), unified modeling language diagrams (UML diagrams), and various other modeling techniques.

**Experience**:

- 2-3 Years of proven experience as a Database Administrator, managing and optimizing database systems.
- Proficiency in handling various database management systems (e.g., PGSQL, SQL Server etc).
- Proficiency in Python and various libraries
- Preferable background in Java Spring Boot, and familiarity with JavaScript will be advantageous.

**Key Responsibilities**:
**SQL Query Optimization**:

- Craft and optimize SQL queries to ensure efficient data retrieval.
- Collaborate with developers to enhance overall database performance.

**Data Modeling**:

- Develop entity relationship diagrams (ERDs), unified modeling language diagrams (UML diagrams), and other data modeling techniques.
- Ensure alignment of data models with organizational requirements.

**Data Visualization**:

- Create visually impactful dashboards to communicate complex data trends.
- Utilize tools such as Tableau or Power BI for effective data representation.

**Programming Proficiency**:

- Demonstrate expertise in Excel, Python, and Visual Basics for data manipulation and automation.
- Leverage scripting skills to streamline data processes.

**Database Architecture**:

- Implement and manage data table structures to efficiently organize and store information.
- Optimize indexing strategies for enhanced database performance.

**Data Tenancy Implementation**:

- Ensure effective data tenancy models for logical separation of data in multi-tenant environments.
- Customize data access and permissions based on tenancy structures.

**Database Design and Implementation**:

- Design and implement database structures based on organizational needs.
- Collaborate with developers to ensure efficient data storage and retrieval.

**Database Maintenance and Optimization**:

- Perform regular database maintenance tasks, including backups, restores, and integrity checks.
- Optimize database performance through indexing, query optimization, and system monitoring.

**Security Management**:

- Implement and maintain database security measures to protect sensitive data.
- Monitor access controls, permissions, and audit trails to ensure compliance with security policies.

**Data Integrity and Recovery**:

- Ensure data integrity through proper database design and validation rules.
- Develop and implement disaster recovery plans to minimize data loss in case of system failures.

**Software Upgrades and Patch Management**:

- Coordinate and implement database software upgrades and patches.
- Stay informed about the latest updates and security patches for the database management system.

**Performance Monitoring and Tuning**:

- Monitor database performance using tools and system logs.
- Identify and address performance issues, bottlenecks, and inefficiencies.

**Troubleshooting and Issue Resolution**:

- Investigate and resolve database-related issues in a timely manner.
- Collaborate with support teams and vendors to address technical challenges.

**Documentation**:

- Maintain comprehensive documentation of database configurations, procedures, and troubleshooting guides.
- Develop and update documentation for database-related processes.

**Data Analysis and Manipulation**:
1. **Data Analysis**:

- Utilize database management software for comprehensive data analysis.
- Employ SQL for querying requests from the database.

2. **Advanced Excel**:

- Utilize advanced Excel functionalities for in-depth data analysis and manipulation.
- Implement Excel for complex calculations, data organization, and reporting.

3. **Data Visualization Tools**:

- Use Tableau or Power BI to visually represent data insights.
- Design and develop interactive dashboards for effective data communication using Excel/Google Sheet.

**Qualifications and Skills**:

- Bachelor's degree in Computer Science, Information Technology, or a related field.
- Proven working experience as a Data Analyst
- Technical expertise regarding data models, database design development, data mining and segmentation techniques
- Strong knowledge of and experience with reporting packages (Business Objects etc), databases (SQL etc), programming (XML, Javascript, or ETL frameworks)
- Knowledge of sta



  • Vadodara, India KMK Consulting Full time

    KMK is a global data analytics and technology consulting company empowering leaders across the Life Sciences industries to make better data-driven decisions.Our data analytics and software platforms support data science, commercial operations, real world evidence, and cloud information management. We help to optimize business strategy and operations by...


  • Vadodara, India KMK Consulting Full time

    KMK is a global data analytics and technology consulting company empowering leaders across the Life Sciences industries to make better data-driven decisions. Our data analytics and software platforms support data science, commercial operations, real world evidence, and cloud information management. We help to optimize business strategy and operations by...


  • Vadodara, India KMK Consulting Full time

    KMK is a global data analytics and technology consulting company empowering leaders across the Life Sciences industries to make better data-driven decisions.Our data analytics and software platforms support data science, commercial operations, real world evidence, and cloud information management. We help to optimize business strategy and operations by...


  • Vadodara, India KMK Consulting Full time

    KMK is a global data analytics and technology consulting company empowering leaders across the Life Sciences industries to make better data-driven decisions. Our data analytics and software platforms support data science, commercial operations, real world evidence, and cloud information management. We help to optimize business strategy and operations by...


  • Vadodara, India BRIGHT Education Full time

    Python programming knowledge - Machine Learning knowledge - Excel - Data analytics tools like Tableau, Power bi knowledge - Natural Language Processing - Good communication skill - Flexible to learn new technologies - Online and offline batches handling - Demo sessions need to give - Being with the part of academic activities like class video recording,...


  • vadodara, India Prometrics Solutions Full time

    As a Data Analyst you will be responsiblefor collecting processing analyzing and interpreting data toprovide valuable insights that support informed decisionmaking anddrive business strategies within the ecommerceplatform.KeyResponsibilities: Performexploratory data analysis apply statistical techniques and generateactionable insights to address business...


  • Vadodara, India Prometrics Solutions Full time

    As a Data Analyst you will be responsiblefor collecting processing analyzing and interpreting data toprovide valuable insights that support informed decisionmaking anddrive business strategies within the ecommerceplatform.KeyResponsibilities:Performexploratory data analysis apply statistical techniques and generateactionable insights to address business...


  • Vadodara, India Prometrics Solutions Full time

    As a Data Analyst you will be responsiblefor collecting processing analyzing and interpreting data toprovide valuable insights that support informed decisionmaking anddrive business strategies within the ecommerceplatform.KeyResponsibilities:Performexploratory data analysis apply statistical techniques and generateactionable insights to address business...

  • Data Scientist

    2 months ago


    Vadodara, Gujarat, India Servilink System Full time

    Qualification : BE- Chemical, Mathemetics + Graduate Degree in Data Science or equivalent certificate - Experience : 1-2 Years - Location : Vadodara - Description : MUST Programming SKILLS / TOOLS / LANGUAGE -Python, R, Power BI, SQL Server, PostgreSQL, IoT MUST Have Skills: - Extract and present valuable information from data - Build mathematical and...


  • Vadodara, India KMK Consulting Inc. Full time

    KMK is a global data analytics and technology consulting company empowering leaders across the Life Sciences industries to make better data-driven decisions. Our data analytics and software platforms support data science, commercial operations, realworld evidence, and cloud information management. We help to optimize business strategy and operations by...


  • Vadodara, India KMK Consulting Inc. Full time

    KMK is a global data analytics and technology consulting company empowering leaders across the Life Sciences industries to make better data-driven decisions. Our data analytics and software platforms support data science, commercial operations, realworld evidence, and cloud information management. We help to optimize business strategy and operations by...


  • Vadodara, India KMK Consulting Inc. Full time

    KMK is a global data analytics and technology consulting company empowering leaders across the Life Sciences industries to make better data-driven decisions. Our data analytics and software platforms support data science, commercial operations, realworld evidence, and cloud information management. We help to optimize business strategy and operations by...


  • Vadodara, India KMK Consulting Inc. Full time

    KMK is a global data analytics and technology consulting company empowering leaders across the Life Sciences industries to make better data-driven decisions. Our data analytics and software platforms support data science, commercial operations, realworld evidence, and cloud information management. We help to optimize business strategy and operations by...


  • Vadodara, India KMK Consulting Inc. Full time

    KMK is a global data analytics and technology consulting company empowering leaders across the Life Sciences industries to make better data-driven decisions. Our data analytics and software platforms support data science, commercial operations, realworld evidence, and cloud information management. We help to optimize business strategy and operations by...


  • Vadodara, India KMK Consulting Inc. Full time

    KMK is a global data analytics and technology consulting company empowering leaders across the Life Sciences industries to make better data-driven decisions. Our data analytics and software platforms support data science, commercial operations, realworld evidence, and cloud information management. We help to optimize business strategy and operations by...

  • Inside Sales Expert

    2 months ago


    Ahmedabad, Gujarat, India Tatvic Analytics Full time

    Responsibilities Develop and execute outbound lead generation strategies. Maintain a detailed and organized CRM tracker to manage lead data and sales activities. Set up qualified appointments for the field sales team to further develop and close. Monitor and analyze KPIs to measure the effectiveness of outbound efforts. Train team members on effective...

  • Data Science Intern

    1 week ago


    Surat, Gujarat, India Blue Data Consulting Full time

    We are looking for a Data Science Intern to join our team and help us solve some of the most challenging data science problems in the industry. As a Data Science Intern, you will work with our team of experienced data scientists to collect, analyze, and interpret data to drive business insights. You will also have the opportunity to work on a variety of...

  • Data Science Intern

    1 week ago


    Surat, Gujarat, India Blue Data Consulting Full time

    We are looking for a Data Science Intern to join our team and help us solve some of the most challenging data science problems in the industry. As a Data Science Intern, you will work with our team of experienced data scientists to collect, analyze, and interpret data to drive business insights. You will also have the opportunity to work on a variety of...

  • Google Analytics

    2 weeks ago


    Vadodara, India Horizontal Digital Full time

    **Google Analytics** At Horizontal Digital, we hold ourselves to one key belief: You’re only as good as your worst customer experience. This mantra is what drives our digital consultancy to think beyond the easy answers and instead create websites, apps, portals and other experiences that solve customer needs for Fortune 500 companies in intuitive and...

  • Google Analytics

    2 weeks ago


    Vadodara, India Horizontal Digital Full time

    **Google Analytics** At Horizontal Digital, we hold ourselves to one key belief: You’re only as good as your worst customer experience. This mantra is what drives our digital consultancy to think beyond the easy answers and instead create websites, apps, portals and other experiences that solve customer needs for Fortune 500 companies in intuitive and...