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.
Similar Jobs
Automotive • Big Data • Insurance • Software • Transportation
Lead data analyst responsible for advanced analytics, real-time performance dashboards, network capacity modeling, and generating actionable insights for third-party service providers. Drives testing and pilots, analyzes stakeholder feedback, and serves as an internal analytics subject-matter expert to inform network strategy and operational improvements.
Top Skills:
BiCrm ToolsGoogle WorkspaceRelational DatabasesSQL
AdTech • eCommerce • Food • Marketing Tech • Retail
Supports vendor and item master data setup and maintenance across the organization. Serves as a contact for vendors and internal teams, facilitates training and communication, monitors compliance, supports audits and risk assessments, analyzes vendor data, prepares reports, tracks KPIs, resolves issues, and contributes to process improvements.
Top Skills:
Master Data Management
Fintech • Legal Tech • Software • Financial Services • Cybersecurity • Data Privacy
The Senior Data Analyst gathers BI requirements, analyzes enterprise and offline datasets, writes and optimizes SQL queries, and builds dashboards using Power BI, Tableau, and Domo. The role translates business needs into technical specifications, designs dashboard wireframes, validates data, documents processes, and collaborates with engineering, product, and business teams. Knowledge of the US trust business is essential for interpreting data within financial and regulatory contexts.
Top Skills:
DomoPower BISQLSql DeveloperTableau
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
