Data Analyst/Programmer

Posted 5 Days Ago
Hiring Remotely in Abilene, TX, USA
In-Office or Remote
Entry level
Software • Analytics • Utilities
The Role
Extracts, transforms, validates, and loads complex datasets from legacy systems into Milsoft software solutions. Develops Python and SQL scripts, analyzes data structures and quality issues, defines mapping rules, maintains ETL tools and documentation, produces reconciliation reports, and resolves migration discrepancies and performance issues during testing and production cutovers.
Summary Generated by Built In

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


  1. 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.
  2. Analyzes source data structures, field mappings, and legacy databases to identify data quality issues, missing fields, or potential conversion bottlenecks.
  3. Collaborates with business analysts and clients to define data mapping rules and runs validation scripts to verify completeness and accuracy pre- and post-migration.
  4. Writes scalable scripts and automated tools to streamline repeatable migration processes and reduce manual intervention.
  5. Maintains documentation of data conversion routines, mapping logic, and exception-handling procedures, and produces post-conversion reconciliation reports.
  6. Efficiently diagnoses and resolves complex data discrepancies, transformation errors, and performance issues during testing and production cutovers.
  7. Upholds, safeguards, and promotes Milsoft’s values and philosophy regarding ethics, integrity, and corporate responsibility.
  8. Maintains regular, consistent, and professional attendance, punctuality, personal appearance, and adherence to relevant health and safety procedures.
  9. Any other duties that may be necessary or assigned occasionally.

QUALIFICATIONS


  1. Bachelor’s degree in Computer Science, Information Technology, Data Analytics, or equivalent hands-on experience.
  2. Advanced scripting abilities in languages such as Python for data parsing and file manipulation.
  3. Proficiency in writing complex SQL queries, stored procedures, joins, and indexing (e.g., PostgreSQL, SQL Server).
  4. Experience working with diverse file formats, including JSON, XML, CSV, fixed-width files, and relational database dumps.
  5. Experience building, running, and/or maintaining ETL pipelines is desirable.
  6. Excellent interpersonal, problem-solving, and communication skills to translate complex data mapping challenges into simple terms for non-technical stakeholders.

Skills Required

  • Bachelor’s degree in Computer Science, Information Technology, Data Analytics, or equivalent hands-on experience
  • Advanced scripting abilities in Python or similar languages for data parsing and file manipulation
  • Proficiency writing complex SQL queries, stored procedures, joins, and indexes
  • Experience with PostgreSQL, SQL Server, or similar relational databases
  • Experience working with JSON, XML, CSV, fixed-width files, and relational database dumps
  • Experience building, running, or maintaining ETL pipelines
  • Excellent interpersonal, problem-solving, and communication skills
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
129 Employees
Year Founded: 1989

What We Do

Milsoft Utility Solutions develops, sells, and supports an Engineering and Operations (E&O) System for electric utility planning, analysis, operations, and management. Founded in 1989 and headquartered in Abilene, Texas, the company integrates Engineering Analysis, Outage Management, Geographic Information, Field Engineering, and IVR Communications into one platform, serving more than 1,000 utilities, consultants, municipalities, and universities in the US and abroad to help them operate electrical distribution systems efficiently, reliably, and safely.

Similar Jobs

Babylist Logo Babylist

Senior SEO & AEO Manager

eCommerce • Healthtech • Kids + Family • Retail • Social Media
Easy Apply
Remote or Hybrid
United States
300 Employees
144K-192K Annually

Hewlett Packard Enterprise Logo Hewlett Packard Enterprise

Channel SE Manager, HPE Networking

Artificial Intelligence • Cloud • Information Technology • Consulting
Remote
2 Locations
85422 Employees
179K-420K Annually

Applied Systems Logo Applied Systems

Associate Billing Coordinator

Artificial Intelligence • Cloud • Payments • Software • Business Intelligence • Generative AI • Automation
Remote or Hybrid
United States
3116 Employees
45K-51K Annually

Applied Systems Logo Applied Systems

Associate Billing Coordinator

Artificial Intelligence • Cloud • Payments • Software • Business Intelligence • Generative AI • Automation
Remote or Hybrid
United States
3116 Employees
45K-51K Annually

Similar Companies Hiring

Ford Energy Thumbnail
Automotive • Software • Energy • Utilities • Manufacturing • Renewable Energy
US
Revel Thumbnail
Aerospace • Hardware • Robotics • Software
Marina Del Rey, California
70 Employees
Blee Thumbnail
Artificial Intelligence • Marketing Tech • Software
New York, New York
33 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account