Position Summary

We are seeking a highly skilled Senior Analytics Developer with extensive experience in Business Intelligence, Data Warehousing, ETL development, and Analytics Engineering. The ideal candidate will be responsible for designing scalable BI solutions, developing enterprise reporting platforms, optimizing data pipelines, and delivering actionable insights that drive strategic business decisions.

This role requires strong expertise in BI tools (MicroStrategy preferred), SQL optimization, data modeling, ETL processes, and dashboard development, along with the ability to collaborate with business stakeholders, data engineers, and solution architects in a hybrid cloud environment.

Key Responsibilities

Business Intelligence & Analytics Development

• Design, develop, and maintain enterprise-grade BI dashboards, reports, scorecards, and self-service analytics solutions.
• Build interactive dashboards and visualizations that enable business users to monitor KPIs and make data-driven decisions.
• Develop reusable BI objects, semantic layers, datasets, and reporting frameworks.
• Optimize report performance for large-scale enterprise datasets.

ETL & Data Engineering

• Design, develop, and optimize ETL/ELT workflows for integrating structured and semi-structured data from multiple enterprise systems.
• Develop and maintain Materialized Views, Intelligent Cubes, Incremental Loads, and data transformation processes using MicroStrategy or equivalent BI platforms.
• Implement data extraction, cleansing, transformation, validation, and loading processes.
• Monitor ETL jobs and resolve data integration issues to ensure high availability and data accuracy.

Data Warehousing & Data Modeling

• Design logical and physical data models for enterprise reporting.
• Develop Star Schema and Snowflake Schema models.
• Build Fact and Dimension tables supporting analytical workloads.
• Optimize SQL queries, indexing strategies, partitioning, and database performance.
• Work closely with Data Architects to improve scalability and performance of the analytics platform.

BI Platform Administration & Optimization

• Administer and optimize BI environments, including MicroStrategy metadata, security, caching, scheduling, subscriptions, and user access.
• Monitor platform performance and implement tuning strategies for reports, dashboards, Intelligent Cubes, and database queries.
• Ensure high availability, scalability, and reliability of BI infrastructure.

Data Quality & Governance

• Implement data quality validation processes and reconciliation mechanisms.
• Ensure compliance with enterprise data governance, security, and audit requirements.
• Develop automated validation reports and exception monitoring.
• Maintain metadata, business definitions, and documentation.

Stakeholder Collaboration

• Work closely with business users, product owners, and functional teams to gather reporting and analytics requirements.
• Translate business requirements into scalable technical solutions.
• Conduct requirement analysis, solution design sessions, and user acceptance testing (UAT).
• Provide technical guidance and user training for BI solutions.

Performance Optimization

• Optimize SQL queries, stored procedures, views, and reporting performance.
• Improve dashboard load times and report execution through query tuning and caching strategies.
• Identify bottlenecks across ETL pipelines, BI reports, and database environments.