Responsibilities of the Candidate:
- Data Transformation: Using Alteryx and ETL techniques to extract data from various sources, transform it into a structured format, and load it into databases or data warehouses.
- Data Analysis: Performing in-depth data analysis to identify trends, patterns, and anomalies, and present findings in a clear and concise manner.
- SQL Queries: Writing and optimizing SQL queries to retrieve, manipulate, and analyze data from relational databases.
- Data Cleansing: Cleansing and pre-processing data to ensure accuracy, consistency, and completeness.
- Data Visualization: Creating visually appealing and insightful dashboards and reports using Excel, presenting data in a meaningful way to stakeholders.
- Data Quality Assurance: Conducting data quality checks to ensure the accuracy and integrity of data and resolve any discrepancies or issues that may arise.
- Collaborate with Teams: Working closely with cross-functional teams to understand data requirements, provide data-driven insights, and support decision-making processes.
- Continuous Improvement: Staying up to date with industry trends, best practices, and new technologies to enhance data analysis capabilities.
Requirements:
- Excellent communication, project management, and people skills
- Problem-solving skills with quick learning ability and adaptability to change
- Should be open to working in different time zones and travel as required
- Should have a high standard of integrity and confidentiality
- Should be willing to work under tight timelines delivering good quality work
- Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy
- Ability to work within a matrix organization
- Alteryx: Hands-on experience with Alteryx Designer, utilizing workflows for data blending, data preparation, and advanced analytics.
- ETL (Extract, Transform, Load): Proficiency in ETL processes and tools, extracting data from diverse sources, transforming it, and loading it into target systems.
- SQL: Strong command of SQL for querying, aggregating, and manipulating data from relational databases.
- Excel: Excellent knowledge of Excel, including advanced formulas, functions, pivot tables, and data visualization techniques.
- Data Visualization Tools: Familiarity with data visualization tools like Tableau or Power BI is a plus.
- Programming Languages: Knowledge of programming languages such as Python or R is advantageous but not mandatory.
- B.E/B. Tech./M. Tech./MCA in Computer Science or Information Technology with a techno-functional background or accounting graduates/postgraduates having worked in the business analytics domain.
- Self-driven and highly motivated individual with 2+ years of experience
- Experience in managing multiple concurrent initiatives from multiple regions or clients
- A strong track record of successful delivery and benefits realization
- Interest in business and commerciality.
- Flexibility to work in different time zones and travel as required
- A Team of people with commercial acumen, technical experience, and enthusiasm to learn new things in this fast-moving environment
- An opportunity to be part of a market-leading, multi-disciplinary team in the only integrated global assurance business worldwide.
- Opportunity to work with EY GDS Assurance practices globally with leading businesses across a range of industries