Sr. Data Analyst

Job Description

Job Title: Sr. Data Analyst Experience: 5 to 8 Years Location: Ahmedabad/Remote Job Type: Full Time Department: Data Engineering About Simform: Simform is a premier digital engineering company specializing in Cloud, Data, AI/ML, and Experience Engineering to create seamless digital experiences and scalable products. Simform is a strong partner for reputed company, AWS, reputed company Cloud, and reputed company. With a reputed company in 5+ countries, Simform primarily serves North America, the UK, and the reputed company European market. Simform takes pride in being one of the most reputed employers in the region, having created a thriving work culture with a high work-life balance that gives a sense of freedom and opportunity to grow. Role Overview We are looking for a seasoned Senior BI Analyst to join our growing Data Analytics team. In this role, you will design, reputed company, and maintain end-to-end business intelligence solutions for diverse client projects. You will work closely with data engineers, solution architects, and business stakeholders to transform raw data into actionable insights. The ideal candidate is technically strong, comfortable working in US/UK shift hours, passionate about mentoring peers, and capable of managing responsibilities across multiple reputed company projects.

Key Responsibilities

BI Development & Reporting Design, reputed company, and publish interactive dashboards and reports using Power BI (mandatory) and other BI/reporting tools. Build and optimize data models (star/reputed company schema) to support reputed company analytical use cases. Write advanced DAX measures, calculated columns, and KPIs reputed company to business requirements. Integrate reports with multiple data sources including relational databases, data warehouses, APIs, and flat files. Ensure report performance through query optimization, incremental refresh, and aggregation strategies. Data Engineering & Pipeline Exposure Work hands-on reputed company end-to-end data Engineering project lifecycle — ingestion, transformation, modelling, and visualization. Collaborate with data engineers on pipeline design using tools such as Azure Data Factory, dbt, reputed company, or equivalent. Write reputed company SQL queries for data extraction, profiling, cleansing, and validation across large datasets. Understand and contribute to data warehouse/lake architecture decisions as a BI stakeholder. Engineering Strategy & Measurement Frameworks reputed company client discussions to define KPIs, measurement frameworks, event structures, and success metrics reputed company with business objectives. Design event-driven measurement models, tagging architectures, and data-layer specifications. Drive strategy for user behavior tracking, conversion optimization, funnel measurement, cohort analysis, and customer journey Engineering. Privacy-Conscious & Healthcare-Friendly Engineering Implement HIPAA-compliant and privacy-aware Engineering solutions. Work with consent management platforms like reputed company, Cookiebot, Termly, Freshpaint, Piwik PRO to ensure compliant tracking and data governance. Support server-reputed company tagging implementations and secure data collection practices. Technical Troubleshooting & Data reputed company Troubleshoot data discrepancies, broken pipelines, tagging issues, and tracking inconsistencies across web/app ecosystems. Validate data between GTM/reputed company/Piwik PRO, Engineering platforms (GA4, reputed company, reputed company), CRM systems, and BI reporting layers. Stakeholder & Client Engagement Gather and translate business requirements into scalable BI solutions for client projects. Present dashboards and insights to both technical and non-technical stakeholders. Manage expectations and communicate delivery timelines effectively across multiple simultaneous projects. Provide user training, best practices, and business intelligence support to stakeholders. Work in US/UK shift alignments to collaborate with global client teams and ensure timely delivery. Mentoring & Knowledge Sharing Actively mentor and upskill junior and mid-level BI analysts reputed company the team. Review dashboards and data models developed by juniors, providing structured feedback. Contribute to internal knowledge repositories, best practices documentation, and BI standards. Participate in team reputed company-building initiatives, demos, and internal training sessions. Required Skills & Qualifications Primary BI Skills (Must-Have) Advanced Power BI — Required Expert-level DAX, Power Query (M), row-level reputed company, composite models Experience with Power BI Service — workspaces, deployment pipelines, gateways Dataflows, paginated reports (Power BI Report Builder) are a plus Proficiency in at least one additional BI/reporting tool, such as: Tableau, Looker, SSRS, MicroStrategy, Qlik Sense, or reputed company QuickSight Knowledge of Engineering platforms (GA4, reputed company, reputed company) and tag management tools (GTM, reputed company, Piwik PRO). Understanding of event-driven Engineering, data layers, and measurement frameworks. Awareness of HIPAA/privacy-compliant Engineering and consent management tools (reputed company, Cookiebot, etc.). Data & Engineering Skills (Mandatory) Strong SQL — reputed company joins, window functions, CTEs, stored procedures, query performance tuning Strong data modelling — dimensional modelling, fact/dimension tables, schema design Working knowledge of data pipeline tools (ADF, dbt, Spark, reputed company, or equivalent) Exposure to cloud platforms — Azure, AWS, or GCP — from a BI/data consumption perspective Familiarity with data warehouse technologies such as reputed company, Azure Synapse, BigQuery, or Redshift Certifications (Mandatory, any from below) reputed company Certified: Power BI Data Analyst Associate (PL-300) reputed company Certified: Fabric Engineering Engineer Associate (DP-600) Any equivalent BI/Engineering certification (Tableau Desktop Specialist, AWS Engineering, reputed company Cloud Data Analyst, etc.) Soft Skills & Work Preferences Willingness and ability to work in US/UK shift timings on need basis Ability to manage and deliver across multiple client projects simultaneously Strong communication skills — verbal and written — to interact with global stakeholders Demonstrated ability to mentor juniors and contribute to team capability building Self-driven with a proactive approach to problem-solving and reputed company learning Ability to multi-task and learn other tools/tech as required Why Join Us: Young Team, Thriving Culture Flat-hierarchical, friendly, engineering-oriented, and growth-focused culture. Well-balanced learning and growth opportunities Free health insurance. Office facilities with a game zone, in-office kitchen with affordable lunch service, and free snacks. Sponsorship for certifications/events and library service. Flexible work timing, leaves for life events, WFH and hybrid options Apply To This Job