Job Description
Data Analyst I
Capgemini
• Design, develop, and maintain interactive Power BI dashboards and reports that support Finance and Business Insurance initiatives • Partner with business stakeholders to gather reporting requirements and translate business needs into analytical solutions • Build data models and develop DAX measures to deliver scalable, user-friendly dashboards • Extract, clean, validate, and transform data from multiple sources using SQL, Power BI, Excel, and other reporting tools • Develop automated reporting solutions using Excel macros, VBA, Python, or similar technologies • Perform data quality analysis, identify inconsistencies, and implement corrective actions to ensure reporting accuracy • Support financial planning, trend analysis, capital expense reporting, and business performance monitoring • Build dynamic reporting models to support agent segmentation, promotions, profitability analysis, and strategic growth initiatives • Collaborate with business and implementation teams to validate results and monitor post-launch performance • Support system enhancements, testing activities, and reporting infrastructure improvements • Clearly communicate technical findings and business insights to both technical and non-technical stakeholders • Continuously improve reporting processes, dashboard usability, and data visualization standards
Job Requirements
- Years of experience in business intelligence, financial reporting, data analytics, or a related field
- Strong experience developing dashboards using **Power BI**, including DAX and data modeling
- Advanced Microsoft Excel skills, including PivotTables, Power Query, macros, data modeling, and complex formulas
- Strong SQL skills with the ability to write queries from scratch and manipulate large datasets
- Experience working with ODBC data connections, relational databases, and data warehouses
- Experience with VBA, Python, or other automation tools is preferred
- Strong analytical and problem-solving skills with excellent attention to detail
- Experience validating data quality and troubleshooting reporting issues
- Ability to communicate complex data insights clearly to business stakeholders
- Strong customer service mindset with the ability to manage multiple priorities and meet 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
Related Guides
Related Categories
Related Job Pages
More Data Analyst Jobs
• Collaborate with third-party vendors to complete required steps for extracting data from multiple source systems • Analyze legacy systems to understand data structures, relationships, and business rules • Translate legacy data into target system formats, including field-level mappings, source to destination code mapping, default values, and conditional logic • Communicate and collaborate with business owners and internal teams to improve data quality and resolve data issues prior to conversion • Lead and manage all data conversion-related meetings and calls • Work closely with the system vendor to identify, analyze, and resolve data discrepancies • Validate migrated data to ensure accuracy, completeness, and reconciliation with source systems • Perform data testing and validation for each sample delivery • Provide post-migration support and assist with data-related issues following go-live • Adhere to defined process timelines and milestones while managing data conversion activities across multiple concurrent projects
• Serve as the primary analytics partner for Marketing, supporting both Conference and Membership business lines • Develop and maintain reporting frameworks for marketing campaign performance across channels • Analyze marketing effectiveness and provide actionable recommendations to improve acquisition, engagement, and retention outcomes • Measure campaign ROI and support data-driven budget allocation decisions • Establish standardized marketing KPI definitions and reporting methodologies • Develop and maintain marketing attribution frameworks across Conference and Membership initiatives • Analyze acquisition channels, conversion funnels, and customer journeys to identify opportunities for optimization • Support conference registration reporting and performance measurement • Analyze subscriber acquisition, activation, retention, and lifetime value metrics • Design and maintain executive dashboards that provide visibility into marketing performance and business outcomes
• Analyze large healthcare datasets to identify trends, patterns, and actionable insights • Develop and maintain dashboards, scorecards, and key performance indicators (KPIs) • Extract, transform, and load (ETL) data from multiple systems into the enterprise data warehouse • Collaborate with clinical and operational teams to understand business needs and deliver reporting solutions • Perform data modeling, mapping, and visualization for quality improvement initiatives • Present findings and recommendations through clear, compelling visual and written communication • Support data governance, data quality, and performance improvement initiatives • Leverage benchmarking tools (e.g., Vizient and external datasets) to evaluate performance • Design and optimize SQL queries, tables, views, and stored procedures
• Develop and maintain reports, dashboards, scorecards, KPIs, and analytical models that support quality and performance improvement initiatives. • Analyze complex healthcare data from multiple sources, including the Enterprise Data Warehouse and clinical systems. • Create and manage SQL tables, views, stored procedures, and advanced queries to support reporting and analytics needs. • Monitor performance metrics, identify trends, and provide actionable insights to support leadership decision-making. • Gather and evaluate benchmarking data from Vizient, public reporting sites, and other industry resources. • Support quality improvement initiatives through data analysis, statistical evaluation, and performance measurement. • Collaborate with physicians, nursing leaders, quality teams, and operational stakeholders to communicate findings and recommend opportunities for improvement. • Maintain and enhance quality, risk, regulatory, and patient safety databases and reporting systems. • Participate in data governance, metadata management, and enterprise data initiatives. • Utilize Lean methodologies and performance improvement tools to help optimize processes and outcomes.



