Senior Data Analyst

Job Description:

Responsibilities

• Collaborate with product managers and engineers to gather and evaluate user requirements.

• Interact with business analysts on behalf of project teams and the Automation team to create reports and dashboards.

• Utilize excellent analytical, problem-solving, and troubleshooting skills to develop reporting solutions.

• Illustrate design ideas using storyboards, process flows, and sitemaps.

• Work with databases such as SQL Server, PostgreSQL, and Oracle.

• Develop UI mockups and prototypes that clearly illustrate site functionality and appearance.

• Prepare and present rough drafts to internal teams and key stakeholders.

• Demonstrate fluency in English, both written and spoken

Skills

Must have

• Undergraduate degree or equivalent experience.

• 4+ years of experience in reporting development.

• 4+ years of experience with Microsoft SQL Server (2014 or higher).

• 4+ years of experience optimizing code for performance tuning.

• 3+ years of experience with Power BI.

• 3+ years of experience in SQL query optimization.

Preferred:

• Advanced proficiency with MS Excel.

• Experience with SQL/T-SQL, DML/DDL statements, and stored procedures.

• Ability to write complex T-SQL logic to extract key insights from data.

• Exposure to tools such as Microsoft Excel, Power BI Desktop & Services, Tableau Professional Desktop, SSRS, and SQL Server Management Studio.

• Skills in sourcing data from OLTP, SaaS, OLAP, and REST APIs applications.

• Knowledge of Agile methodology.

• Excellent troubleshooting skills.

• Strong communication and collaboration skills.

• High accountability and self-motivation.

• Familiarity with Level 1 or Level 2 support processes.

Nice to have

• Big Data, Marklogic, Talend, MDM, Data Bricks, Snowflake, Data factory etc