Job Description

Key Responsibilities

Data Analysis and Profiling:

  • Analyze and understand complex data landscapes
  • Perform in-depth data discovery and profiling to assess data quality and relevance
  • Document data findings and processes comprehensively

Collaboration and Requirements Gathering:

  • Work closely with Subject Matter Experts (SMEs) to gather requirements and understand business needs
  • Translate business requirements into actionable data insights

Data Validation and Quality Assurance:

  • Ensure data accuracy and validity across all sources
  • Validate metrics and data from source systems
  • Implement and maintain data quality standards

Database Management and SQL:

  • Connect to and analyze data from various databases, including DB2, SQL Server, Teradata, and MongoDB
  • Write and optimize complex SQL queries for efficient data retrieval and analysis

Data Preparation and Analytics:

  • Utilize Alteryx for data blending, preparation, and advanced analytics
  • Automate data workflows and processes to improve efficiency

Requirements

Experience and Skills:

  • 8+ years of experience as a Data Analyst
  • Proficiency in DB2 and MongoDB and SQL server databases
  • Extensive experience with SQL across multiple database platforms
  • Hands-on experience with Alteryx for data preparation and analytics
  • Strong skills in data validation and metric verification
  • Ability to work independently and as part of a team

Technical Proficiencies:

  • Advanced SQL skills (DB2, Teradata, MongoDB)
  • Alteryx
  • Data profiling and discovery techniques
  • Data visualization tools (e.g., Tableau, Power BI)

Soft Skills:

  • Excellent communication and interpersonal skills
  • Strong analytical and problem-solving abilities
  • Attention to detail and commitment to data accuracy
  • Ability to manage multiple projects and priorities