Data Integration Analyst
WalkerHughes•Carmel, IN
21h
About The Position
WalkerHughes Insurance is seeking a Data Integration Analyst to lead data onboarding for newly acquired businesses and third-party systems as well as reporting enablement for existing data sets. This role is approximately 60% data integration/migration and 40% BI reporting and analytics, focused on practical ingestion, SQL transformation, validation, and business reporting. This position supports data onboarding and reporting delivery but does not own a full-scale ETL or data engineering platform.
Requirements
- 3–7+ years of experience in data analytics, BI, or data integration roles
- Strong SQL skills (joins, CTEs, aggregations, performance optimization)
- Experience integrating data from third-party systems, APIs, and flat files
- Demonstrated experience building business-facing reporting solutions
- Advanced Excel skills
- Clear communicator able to partner with both technical and non-technical teams
Nice To Haves
- Power BI expertise (DAX, Power Query, data modeling, performance optimization)
- Experience in acquisition or multi-entity environments
- Scripting/automation experience (Python, PowerShell, or similar)
- Experience with CRM, AMS, ERP, or accounting systems
Responsibilities
- Lead end-to-end data onboarding for acquisitions (field mapping, transformation rules, validation, and alignment)
- Build and maintain ingestion / extraction scripts and repeatable import processes (API and file-based loads) from 3 rd party systems
- Perform SQL-based migrations, normalization, and data transformations
- Execute validation and reconciliation processes (record counts, financial totals, exception reporting)
- Maintain integration documentation including mapping sheets and runbooks
- Coordinate with operations, finance, IT, vendors, and stakeholders on integration timelines and cutovers
- Develop and maintain Power BI dashboards, datasets, and reporting assets
- Produce operational reports and executive-level summaries
- Perform structured and ad hoc data analysis to identify trends and business insights
- Define and document key metrics and reporting logic for consistency
- Ensure ongoing data quality through validation, monitoring, and anomaly detection
- Troubleshoot reporting and integration issues
- Recommend improvements to increase automation and repeatability
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
Upload and Match Resume
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
Education Level
No Education Listed
Number of Employees
11-50 employees
