Analyze insurance policy, premium, claims, billing, and financial data; build KPI dashboards and reports; write and optimize SQL; validate and model datasets; identify trends, anomalies, fraud indicators, and leakage; and translate business questions into clear recommendations for underwriting, actuarial, claims, finance, and other stakeholders. The role supports pricing, reserving, portfolio management, retention, and loss-ratio analyses.
DATAECONOMY is one of the fastest-growing Data & Analytics company with global presence. We are well-differentiated and are known for our Thought leadership, out-of-the-box products, cutting-edge solutions, accelerators, innovative use cases, and cost-effective service offerings.
We offer products and solutions in Cloud, Data Engineering, Data Governance, AI/ML, DevOps and Blockchain to large corporates across the globe. Strategic Partners with AWS, Collibra, cloudera, neo4j, DataRobot, Global IDs, tableau, MuleSoft and Talend.
Data Analyst
Charlotte, NC
Full-time
Insurance Domain
- Turn business questions from underwriting, claims, actuarial, and finance teams into well-structured analyses and repeatable reports.
- Build and maintain dashboards and scorecards for KPIs such as loss ratio, combined ratio, premium growth, retention/lapse, and claims cycle time.
- Perform exploratory analysis to surface trends, anomalies, and opportunities (e.g., emerging loss patterns, fraud indicators, leakage).
- Document assumptions, definitions, and methodology so results are transparent and auditable.
- Analyze policy, premium, claims, and billing data to support pricing, reserving, and portfolio management discussions.
- Support loss-ratio, frequency/severity, and retention/churn analyses for P&C and/or L&A lines of business.
- Partner with actuarial and underwriting teams to validate data and interpret results in business context.
- Write and optimize SQL to extract, join, and aggregate data from the lakehouse / data warehouse.
- Profile, clean, and validate datasets; flag and help resolve data quality issues with engineering.
- Build reusable, well-documented queries, views, and semantic-layer definitions.
- Design clear, decision-oriented visualizations in Power BI / Tableau (or equivalent).
- Translate analysis into concise narratives and recommendations for non-technical business stakeholders.
- Enable self-service by documenting metrics and curating trusted data sources.
- Strong SQL across cloud data warehouse / lakehouse environments (Databricks SQL, Snowflake, BigQuery, or similar).
- BI/visualization tools Power BI and/or Tableau.
- Spreadsheet modeling (Excel) for ad-hoc analysis.
- Working knowledge of Python (pandas) for data wrangling is a plus.
- 4–7+ years of experience in data analysis, business intelligence, or reporting.
- Strong, demonstrable SQL skills (complex joins, window functions, aggregations, query tuning).
- Proven experience building dashboards and reports in Power BI and/or Tableau.
- Solid understanding of data modeling concepts (dimensional / star schema) from a consumer's perspective.
- Ability to translate ambiguous business questions into structured analysis and clear deliverables.
- Strong written and verbal communication with business stakeholders.
- Insurance domain knowledge P&C and/or Life & Annuities; familiarity with premium, claims, and loss-ratio concepts.
- Experience with cloud data platforms (Databricks, Snowflake, Azure/AWS/GCP).
- Python (pandas) or R for analysis and automation.
- Statistical analysis fundamentals and A/B or cohort analysis experience.
- Exposure to data governance, metadata, and trusted-source / semantic-layer practices.
- Awareness of PII/PHI handling and regulated-data sensitivity.
Requirements
- Strong SQL complex joins, window functions, aggregation, query tuning
- Power BI and/or Tableau dashboard and report development
- Data modeling literacy dimensional / star schema (consumer perspective)
- Ability to translate business questions into structured analysis
- Strong stakeholder communication and storytelling
- 4–7+ years in data analysis / BI / reporting
Benefits
Standard full-time benefits.
DATAECONOMY Charlotte, North Carolina, USA Office
Charlotte, Charlotte, United States, 28656
Similar Jobs
Fintech • Information Technology • Insurance • Financial Services • Big Data Analytics
Analyze reinsurance data and business processes, gather requirements, create data mappings and flow diagrams, and support FAIRR Data Hub solutions. The role validates data quality, governance, reconciliation, and technical specifications while partnering with business, technology, architecture, engineering, and governance teams. It also contributes to reporting, AI-enabled analytics, solution testing, stakeholder communication, and mentoring junior analysts.
Top Skills:
AgileAzureData GovernanceData LakesData MartsData QualityData WarehousesDatabricksDocument DatabasesErwinMedallion ArchitectureNoSQLPythonRelational DatabasesServerless SqlSQL
Cloud • Fintech • Software • Business Intelligence • Consulting • Financial Services
Performs data profiling, quality analysis, governance, metadata and lineage management, and Master Data Management support. Collaborates with data owners, stewards, business stakeholders, and technical teams to resolve issues and improve governance processes. Maintains glossaries, dictionaries, controls, metrics, and reports; supports enterprise data initiatives, communications, training, and stakeholder adoption. Provides guidance to less experienced analysts while applying governance standards and documenting business requirements.
Top Skills:
Data ModelingData WarehousingEtl/EltMicrosoft PurviewPower BIProfiseeSQLTableau
Insurance
Supports insurance financial data analysis, source-to-target reconciliation, data conversions, reference data maintenance, and financial close activities. Validates premium calculations, investigates variances, supports General Ledger reporting, and documents audit and SOX evidence. Owns business and technical stories, manages development backlogs, coordinates testing and releases, and partners with finance, developers, QA teams, project managers, and senior leaders to deliver data and systems enhancements.
Top Skills:
AgileCloud ComputingData LakeData MartsEnterprise Data WarehouseETLOdsOracle General LedgerSQLTest Automation
What you need to know about the Charlotte Tech Scene
Ranked among the hottest tech cities in 2024 by CompTIA, Charlotte is quickly cementing its place as a major U.S. tech hub. Home to more than 90,000 tech workers, the city’s ecosystem is primed for continued growth, fueled by billions in annual funding from heavyweights like Microsoft and RevTech Labs, which has created thousands of fintech jobs and made the city a go-to for tech pros looking for their next big opportunity.
Key Facts About Charlotte Tech
- Number of Tech Workers: 90,859; 6.5% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Lowe’s, Bank of America, TIAA, Microsoft, Honeywell
- Key Industries: Fintech, artificial intelligence, cybersecurity, cloud computing, e-commerce
- Funding Landscape: $3.1 billion in venture capital funding in 2024 (CED)
- Notable Investors: Microsoft, Google, Falfurrias Management Partners, RevTech Labs Foundation
- Research Centers and Universities: University of North Carolina at Charlotte, Northeastern University, North Carolina Research Campus
