See more Collapse

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

We have other current jobs related to this field that you can find below

  • Data Analytics

    7 days ago

    Vadodara, India bankbenchers Full time

    **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...

  • Associate Trainee, Data Analytics

    4 weeks ago

    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...

  • Associate Trainee, Data Analytics

    3 weeks ago

    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...

  • Associate Trainee, Data Analytics

    4 weeks ago

    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...

  • Associate Trainee, Data Analytics

    3 weeks ago

    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...

  • Associate Trainee, Data Analytics

    5 days ago

    Vadodara, Gujarat, 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...

  • Business Intelligence

    1 day ago

    vadodara, India SI2 Technologies Pvt Ltd Full time

    Job Title: Business Intelligence & Data Analytics EngineerDepartment: Information Technology – IT InfrastructureReports To: Sr. Technical Systems Architect, ITPrimary Function of Position:This position reports to Sr. Technical Systems Architect, IT, and will be responsible for providing Database Administration support to Business Applications and other...

  • Data Analytic Trainer

    3 weeks ago

    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,...

  • Business Intelligence

    22 hours ago

    Vadodara, India SI2 Technologies Pvt Ltd Full time

    Job Title: Business Intelligence & Data Analytics EngineerDepartment: Information Technology – IT InfrastructureReports To: Sr. Technical Systems Architect, ITPrimary Function of Position: This position reports to Sr. Technical Systems Architect, IT, and will be responsible for providing Database Administration support to Business Applications and other...

  • Business Intelligence

    2 days ago

    Vadodara, India SI2 Technologies Pvt Ltd Full time

    Job Title: Business Intelligence & Data Analytics Engineer Department: Information Technology – IT Infrastructure Reports To: Sr. Technical Systems Architect, IT Primary Function of Position: This position reports to Sr. Technical Systems Architect, IT, and will be responsible for providing Database Administration support to Business Applications...

  • Business Intelligence

    2 days ago

    Vadodara, India SI2 Technologies Pvt Ltd Full time

    Job Title: Business Intelligence & Data Analytics EngineerDepartment: Information Technology – IT InfrastructureReports To: Sr. Technical Systems Architect, ITPrimary Function of Position: This position reports to Sr. Technical Systems Architect, IT, and will be responsible for providing Database Administration support to Business Applications and other...

  • Data Analyst Analytics Hiring Fresher

    2 months ago

    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 Analyst Analytics Hiring Fresher

    3 weeks ago

    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 Analyst Analytics Hiring Fresher

    2 months ago

    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...

  • Manager, Commercial Analytics

    2 months ago

    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...

  • Manager, Commercial Analytics

    3 weeks ago

    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...

  • Manager, Commercial Analytics

    2 months ago

    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...

  • Manager, Commercial Analytics

    2 months ago

    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...

  • Manager, Commercial Analytics

    3 weeks ago

    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...

  • Manager, Commercial Analytics

    3 weeks ago

    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...