Sr. Data Analyst

Annik Inc.

$90K — $120K *
Information Technology
5 - 7 years of experience
Job Overview by Ladders

Qualifications

  • 7-10 years of relevant experience
  • Proficient in SQL Server 2014/16 with strong SQL & ETL skills
  • Expertise in SSAS, SSIS & COSMOS or Big Data
  • Proficient in PowerBI with strong analytical capabilities
  • Advanced Excel skills including Pivots and PowerPivots
  • Understanding of Data Management and BI concepts
  • Familiarity with Microsoft ecosystem is preferred

Responsibilities

  • Troubleshoot complex data-related issues from Tier 1 support
  • Resolve data discrepancies and deliver business intelligence insights
  • Understand and manage data lineage, quality, and relationships
  • Monitor ETL jobs and address any failures proactively
  • Provide development support for assigned platforms and applications
  • Document knowledge base articles for use by support tiers
  • Automate operational activities and develop data quality checks and features
  • Engage in flexible support for production issues during off hours

Benefits

  • Opportunity to work with cutting-edge technologies in data analytics
  • Collaborative work environment focused on continuous improvement
  • Chance to develop and automate processes, enhancing efficiency
  • Exposure to a variety of platforms within the Microsoft ecosystem
  • Flexibility in working hours to accommodate urgent production issues
Full Job Description
Job Description

Responsibilities include:
• Troubleshoot complex data related issues escalated from Tier 1
• Solving data discrepancies and providing business intelligence insights.
• Understand data lineage, data quality and relationships
• Monitor data extract, transform, and load (ETL) jobs and respond to any job failures.
• Development Support for platforms and applications as assigned by designated manager
• Document knowledge base articles for Tier 1 and Tier 2
• Dedicate 20-25% of time for Development efforts - Automation of operational activities, data quality checks, application feature development, develop tabular models, bug fixes and reporting
• Perform data engineering related activities
• Flexibility to support production issues during off hours.

Qualifications

Must have 7-10 years of related experience.

Technology:
• SQL Server 2014/16, Good SQL & ETL skills
• Strong on SSAS, SSIS & COSMOS or Big Data
• Good knowledge of PowerBI
• Strong data analytical skills
• Ability to make business conclusions from data, connect scenarios
• Strong knowledge on Excel - Pivots, PowerPivots, Charts

Additional skills:
• Understanding Data Management & BI concepts, Data Analysis, Analytics, Cubes, Reporting Technologies, ETL
• Prior experience in Microsoft landscape is preferred
• Ability to deal with ambiguity and work in agile environment.
• Excellent communications skills
• Attention to detail
• Strong troubleshooting skills
• Hands on experience with SharePoint

Additional Information

Similar Jobs

More Jobs at Annik Inc.

  • Sr. Data Analyst
    $90K — $120K *
    Bellevue, WA 98006 (King County)
    Information Technology
    In-Person

More Information Technology Jobs

Find similar Sr. Data Analyst jobs: