Description review
Data Analyst/Programmer
Milsoft Utility Solutions · United States · back to the listing
HR standards
65/100
needs work
Title ↔ description
80/100
solid
Reads as
Data Engineer
85% confident
How others title the same work
Large employers
- Data Engineer, Product Analytics Meta
- Senior Staff Data Engineer Mozilla
- Staff, Analytics Engineer, GTM Data Science & Analytics Twilio
- Senior Software Engineer - Data Platform Coinbase
- Senior Security Data Engineer Doordash
Startups
- Business Intelligence Engineer GoSats
- IPinfo.io | Data Engineer | REMOTE (Anywhere) | Full-time IPinfo.io
- Senior Data Engineer Camber
- Senior Data Engineer Instrumentl
- Cardog | Toronto, Canada or REMOTE | Full-time Cardog
What the listing never says
- No pay range published. Candidates cannot tell whether applying is worth their time. Pay transparency
The listing, marked up
DATA ANALYST/PROGRAMMER
Department: Implementation Services
Reports to: Manager of Data Operations
Division: Remote
Classification: Salary/Exempt/Full-time
JOB SUMMARY
The Data Analyst/Programmer will work closely with Project Managers, Implementation Specialists, and, when needed, clients to ensure the effective extraction, transformation, and loading of complex datasets from legacy systems into Milsoft software solutions, maintaining data integrity and seamless migrations with minimal downtime.
ESSENTIAL FUNCTIONS
• Designs, develops, tests, and executes scripts to extract data from various source systems, transform it according to business logic, and load it into target databases within project timelines.
• Analyzes source data structures, field mappings, and legacy databases to identify data quality issues, missing fields, or potential conversion bottlenecks.
• Collaborates with business analysts and clients to define data mapping rules and runs validation scripts to verify completeness and accuracy pre- and post-migration.
• Writes scalable scripts and automated tools to streamline repeatable migration processes and reduce manual intervention.
• Maintains documentation of data conversion routines, mapping logic, and exception-handling procedures, and produces post-conversion reconciliation reports.
• Efficiently diagnoses and resolves complex data discrepancies, transformation errors, and performance issues during testing and production cutovers.
• Upholds, safeguards, and promotes Milsoft’s values and philosophy regarding ethics, integrity, and corporate responsibility.
• Maintains regular, consistent, and professional attendance, punctuality, personal appearance, and adherence to relevant health and safety procedures.
• Any other duties1 that may be necessary or assigned occasionally.
QUALIFICATIONS
• Bachelor’s degree in Computer Science, Information Technology, Data Analytics, or equivalent hands-on experience.
• Advanced scripting abilities in languages such as Python for data parsing and file manipulation.
• Proficiency in writing complex SQL queries, stored procedures, joins, and indexing (e.g., PostgreSQL, SQL Server).
• Experience working with diverse file formats, including JSON, XML, CSV, fixed-width files, and relational database dumps.
• Experience building, running, and/or maintaining ETL pipelines is desirable.
• Excellent interpersonal, problem-solving, and communication skills to translate complex data mapping challenges into simple terms for non-technical stakeholders.
Originally posted on Himalayas
Department: Implementation Services
Reports to: Manager of Data Operations
Division: Remote
Classification: Salary/Exempt/Full-time
JOB SUMMARY
The Data Analyst/Programmer will work closely with Project Managers, Implementation Specialists, and, when needed, clients to ensure the effective extraction, transformation, and loading of complex datasets from legacy systems into Milsoft software solutions, maintaining data integrity and seamless migrations with minimal downtime.
ESSENTIAL FUNCTIONS
• Designs, develops, tests, and executes scripts to extract data from various source systems, transform it according to business logic, and load it into target databases within project timelines.
• Analyzes source data structures, field mappings, and legacy databases to identify data quality issues, missing fields, or potential conversion bottlenecks.
• Collaborates with business analysts and clients to define data mapping rules and runs validation scripts to verify completeness and accuracy pre- and post-migration.
• Writes scalable scripts and automated tools to streamline repeatable migration processes and reduce manual intervention.
• Maintains documentation of data conversion routines, mapping logic, and exception-handling procedures, and produces post-conversion reconciliation reports.
• Efficiently diagnoses and resolves complex data discrepancies, transformation errors, and performance issues during testing and production cutovers.
• Upholds, safeguards, and promotes Milsoft’s values and philosophy regarding ethics, integrity, and corporate responsibility.
• Maintains regular, consistent, and professional attendance, punctuality, personal appearance, and adherence to relevant health and safety procedures.
• Any other duties1 that may be necessary or assigned occasionally.
QUALIFICATIONS
• Bachelor’s degree in Computer Science, Information Technology, Data Analytics, or equivalent hands-on experience.
• Advanced scripting abilities in languages such as Python for data parsing and file manipulation.
• Proficiency in writing complex SQL queries, stored procedures, joins, and indexing (e.g., PostgreSQL, SQL Server).
• Experience working with diverse file formats, including JSON, XML, CSV, fixed-width files, and relational database dumps.
• Experience building, running, and/or maintaining ETL pipelines is desirable.
• Excellent interpersonal, problem-solving, and communication skills to translate complex data mapping challenges into simple terms for non-technical stakeholders.
Originally posted on Himalayas