Data Analyst

Capgemini

Posted: July 18, 2024 Openings: 10 Experience: 0-3 Salary: Preferred by Company
Education: B.Com / B.Tech/ B.E./ M.Com/ B.Sc / MBA / M.Tech/ M.E./ M.Sc/ BBA/ BA/ Any Graduate Location: Noida
Job Type: Full Time Skills required: Python Communication Skills Power Bi Numpy Pandas Sql Data Analysis

Job description

Job Description

Responsibilities:

Business Interaction:
- Interact with business users to understand their requirements.
- Communicate complex topics to the team through both written and oral communications.
- Ensure all discussions with business users are documented and adhere to the change management process.
Project Management:
- Take complete ownership of end-to-end project management.
- Understand business requirements, suggest improvements (To-be process flow), prepare design documents, develop, conduct unit testing, and ensure timely delivery of projects.
- Provide regular updates on assigned tasks to team members.
Data Handling:
- Perform end-to-end data validation and data modeling if required.
- Write complex SQL queries on multiple tables using complex joins.
- Conduct unit tests and develop database queries to analyze effects and troubleshoot issues.
- Design and develop ETL workflows and datasets in Alteryx for BI use.
- Solid experience with ETL tools like Alteryx.
- Prepare technical specifications and documentation for Alteryx workflows supporting BI reports.
Technical Expertise:
- Possess knowledge of Python, including tools and libraries, with some hands-on coding experience.
- Develop and update technical documentation for senior leaders and colleagues as a reference guide.
- Understand and document any technical or business limitations to implement technology controls/configurations.
Process Improvement:
- Provide recommendations to strengthen current processes and controls related to technology platforms.
- Understand and document compensating controls for managing or mitigating security risks due to technical or business limitations.
Presentation and Documentation:
- Develop impactful presentations and documents to communicate project details and progress to stakeholders.

Primary Responsibility:

Write complex SQL queries on multiple tables using complex joins.
Knowledge of Python, tools used, and its libraries, with some hands-on coding experience.
Conduct unit tests and develop database queries to analyze effects and troubleshoot any issues.
Develop and update technical documentation for senior leaders and colleagues.
Provide regular updates on assigned tasks to team members.

This structured format ensures clarity in the job description, highlighting key responsibilities and primary duties in an organized manner.