Business Intelligence SME / Architect

About the role

A qualified professional with experience building highly visual dashboards and reports across multiple marketing channels. The role acts as the reporting Subject Matter Expert (SME) for strategic clients, working with client teams on complex analytics challenges, guiding stakeholders on problem-solving strategies and measuring marketing effectiveness. It is a full-time, permanent position based at DGS India's Thane Ashar IT Park office.

Key responsibilities

• Gather and analyse reporting requirements from stakeholders, including new data needs, layout preferences and business objectives.
• Develop and maintain advanced interactive dashboards and reports that give actionable insights.
• Share reporting best practices and guide team members in solving business challenges.
• Lead client-facing presentations and read-outs, and drive overall client engagement as reporting SME.
• Create and review QA plans for deliverables, identify discrepancies and troubleshoot issues.
• Define best practices for designing, developing, deploying and maintaining reports, and ensure project milestones are met.
• Work with internal and external stakeholders to build the project plan, manage day-to-day tasks and meet deadlines.

Required profile

• 8+ years of experience in data analysis and visualization.
• Degree in computer science, information systems or another technology-related field.
• Intermediate proficiency in SQL and Google BigQuery.
• Good to have: familiarity with Google Dataform, Composer and Looker; optional marketing analytics experience.

Required skills

• Power BI (certification required)
• DAX for calculated columns, measures and KPIs
• Power Query (M language) for data transformation and ETL
• Data modelling: star schema, snowflake schema and normalization
• Power BI Service: row-level security, workspace management, app deployment, gateway configuration and scheduled refreshes