Data Analyst/Programmer
Core
Extract, transform, and load complex datasets from legacy systems into Milsoft software solutions, ensuring data integrity and seamless migrations.
Role type
Data Analyst/Programmer (ETL & Data Migration)
Builds
ETL pipelines and automated data migration tools for Milsoft software solutions
Domain
Software implementation and data migration
Required skills
Python scripting, SQL (PostgreSQL, SQL Server), ETL pipeline development, data mapping, data quality analysis, JSON/XML/CSV parsing, database indexing, automated tool creation
Preferred skills
Experience with diverse file formats, legacy system analysis
Technologies
Python, PostgreSQL, SQL Server, JSON, XML, CSV
Responsibilities
Design and execute scripts for data extraction, transformation, and loading; Analyze source data structures to identify quality issues; Collaborate with clients to define data mapping rules; Write scalable scripts to streamline migration processes; Maintain documentation of conversion routines and produce reconciliation reports; Diagnose and resolve data discrepancies and performance issues during cutovers.