All jobs
Capgemini Technology ServicesData
Fbs - Data Analyst I
MexicoPosted 2 days ago
Join the Business Insurance Finance team as a Business Intelligence Analyst to transform data into meaningful insights, design dashboards, automate reports, and support financial and business performance initiatives.
Location: Mexico
Responsibilities
- Design, develop, and maintain Power BI dashboards and reports for Finance and Business Insurance initiatives
- Partner with stakeholders to gather reporting requirements and translate needs into analytical solutions
- Build data models and develop DAX measures for dashboards
- Extract, clean, validate, and transform data from multiple sources using SQL, Power BI, Excel, and other tools
- Develop automated reporting solutions using Excel macros, VBA, Python, or similar technologies
- Perform data quality analysis and implement corrective actions
- Support financial planning, trend analysis, and business performance monitoring
- Build dynamic reporting models for agent segmentation, promotions, profitability analysis, and growth initiatives
- Collaborate with teams to validate results and monitor post-launch performance
- Support system enhancements, testing, and infrastructure improvements
- Communicate technical findings and insights clearly to stakeholders
- Continuously improve reporting processes, usability, and visualization standards
Requirements
- Experience in business intelligence, financial reporting, data analytics, or related field
- Strong experience with Power BI, including DAX and data modeling
- Advanced Excel skills including PivotTables, Power Query, macros, and complex formulas
- Strong SQL skills for querying and manipulating large datasets
- Experience with ODBC data connections, relational databases, and data warehouses
- VBA, Python, or automation tools experience is preferred
- Analytical and problem-solving skills with attention to detail
- Experience validating data quality and troubleshooting reports
- Ability to communicate complex data insights clearly
- Customer service mindset, managing multiple priorities and deadlines
- Insurance or financial services experience is a plus
Benefits
- Comprehensive benefits package
- Career development and training opportunities
- Flexible work arrangements
- Dynamic and inclusive work culture within a globally renowned group
- Private Health Insurance
- Pension Plan
- Paid Time Off
- Training & Development
Additional Information
- CVs must be submitted in English. Applications in other languages will not be considered.