Sr. Enterprise Data Analyst
Location
India | India
Job description
Senior Enterprise Data Analyst :
Responsibilities: - Data Modeling and Development:
- Design, develop, and maintain Analysis Services tabular models (SSAS).
- Create efficient data structures to support complex reporting and analysis.
- Implement calculated measures, hierarchies, and KPIs.
- Understand existing power BI datasets and logic and provide ways to improve and simplify the data modelling via Analysis Services.
- Excellent understanding and proven experience with Analysis services roles and implementation of complex data security scenarios.
- Data Integration and ETL:
- Extract, transform, and load data from various sources into SSAS.
- Collaborate with ETL developers to ensure seamless data flow.
- Optimize data processing for performance and scalability.
- Report Development:
- Build interactive dashboards and reports using SSAS cubes.
- Customize report layouts and visualizations.
- Collaborate with business users to gather requirements and refine reports.
- Proven experience of effectively using SSAS cubes with Power BI implementation along with Excel implementation.
- Performance Tuning and Troubleshooting:
- Monitor SSAS performance and identify bottlenecks.
- Optimize query performance and cube processing times.
- Investigate and resolve data-related issues.
- Investigate data access related issues.
- Documentation and Training:
- Document SSAS models, data lineage, and best practices.
- Provide training to end-users on SSAS usage and self-service reporting.
To qualify for the role you must have: - Bachelor's degree in Computer Science, Information Systems, or related field.
- Minimum of 6 years of experience as an SSAS Developer role.
- Proficiency in SSAS tabular models.
- Strong SQL skills for data extraction and transformation.
- Excellent problem-solving and analytical abilities.
- Knowledge of data warehouse concepts and data governance.
Preferred Skills: - Certification in Power BI and Azure administration (e.g., Microsoft Certified: Data Analyst Associate, Azure Administrator Associate).
What working at ACA offers: We offer a competitive compensation package where you'll be rewarded based on your performance and recognized for the value you bring to our business. Our Total Rewards package includes medical coverage fully funded by ACA for employees and their family as well as access to Maternity & Fertility and Wellness programs. ACA also provides Personal Accident Insurance, Group Term Life Insurance, Employee Discount programs and Employee Resource Groups. You'll be granted time off for designated ACA Paid Holidays, Privilege Leave, Casual/Sick Leave, and other leaves of absence to support your physical, financial and emotional well-being.
About ACA: ACA Group is the leading governance, risk, and compliance (GRC) advisor in financial services. We empower our clients to reimagine GRC and protect and grow their business. Our innovative approach integrates consulting, managed services, and our ComplianceAlpha® technology platform with the specialized expertise of former regulators and practitioners and our deep understanding of the global regulatory landscape.
What we commit to: ACA is firmly committed to a policy of nondiscrimination, which applies to recruiting, hiring, placement, promotions, training, discipline, terminations, layoffs, transfers, leaves of absence, compensation and all other terms and conditions of employment. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability or protected veteran status, or any other legally protected status.
Job tags
Salary
