This role is for one of the Weekday's clients
We are seeking a detail-oriented and technically proficient Data Analyst to join our team. The ideal candidate will have strong expertise in ETL processes, SQL, Power BI, data migration, and data mapping. This role involves transforming data into actionable insights, ensuring data integrity, and supporting data-driven decision-making within the organization.
Responsibilities
- ETL Development and Management: Design, develop, and maintain ETL processes to extract, transform, and load data from various sources into data warehouses or other storage solutions. Ensure data accuracy and consistency throughout the ETL lifecycle.
- Data Analysis and Reporting: Use SQL to query, analyze, and manipulate data to generate meaningful insights. Create and maintain reports and dashboards in Power BI to support business operations and strategic decision-making.
- Data Migration: Plan and execute data migration projects, ensuring seamless data transfer between systems. Validate and verify data post-migration to ensure completeness and accuracy.
- Data Mapping: Develop and maintain data mapping documentation to ensure accurate data integration across systems. Work closely with stakeholders to understand data requirements and establish clear mapping rules.
- Data Quality Assurance: Conduct data quality assessments and implement data cleansing procedures. Identify and resolve data discrepancies and inconsistencies.
- Collaboration and Communication: Work collaboratively with cross-functional teams, including IT, finance, marketing, and operations, to understand data needs and deliver effective solutions. Communicate findings and recommendations to stakeholders clearly and concisely.
- Documentation and Training: Maintain comprehensive documentation of ETL processes, data mappings, and analytical methodologies. Provide training and support to end-users on data tools and best practices.
Required Skills And Qualifications
- Education: Bachelor's degree in Computer Science, Information Technology, Data Science, or a related field. Advanced degrees and certifications are a plus.
- Technical Proficiency:
- ETL: Expertise in designing and implementing ETL processes using tools such as SSIS, Informatica, or Talend.
- SQL: Advanced skills in SQL for querying, data manipulation, and performance optimization.
- Power BI: Proficiency in creating interactive and visually appealing dashboards and reports in Power BI.
- Data Migration: Experience in planning and executing data migration projects.
- Data Mapping: Strong understanding of data mapping concepts and techniques.
- Analytical Skills: Strong analytical and problem-solving abilities. Experience in data analysis, data profiling, and statistical analysis.
- Attention to Detail: High level of accuracy and attention to detail. Ability to identify and resolve data quality issues.
- Communication Skills: Excellent verbal and written communication skills. Ability to present complex data insights in a clear and understandable manner.
- Project Management: Experience managing data projects, including timelines, deliverables, and stakeholder communication.
Preferred Qualifications
- Experience with additional data visualization tools such as Tableau or QlikView.
- Knowledge of programming languages such as Python or R for data analysis.
- Familiarity with cloud-based data solutions (e.g., AWS, Azure, Google Cloud).
- Understanding of data governance and compliance standards.
Location: Bengaluru, Mumbai, India (Remote)
Skills: etl,data migration,data mapping,sql,power bi
