Data Analyst/Programmer

Job not on LinkedIn

🕒 September 24

🤠 Texas – Remote

🤠 Texas – Remote

⏰ Full Time

🟡 Mid-level

🟠 Senior

📉 Data Analyst

👻 Ghost score 22%

What it means: how likely this posting is sitting open without active hiring.How to read it: 60% or higher means we think this is a ghost. Lower scores are less of a worry.How we score it: age, reposts, open roles vs team size, how fast jobs close, and whether pay is listed.Fine print: an estimate from public data, not a judgment of the company. Real jobs can score high, so treat it as a hint, not a fact.

Apply Now

Find Similar Remote Jobs

Set Up Email Alert For New Jobs

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume

Milsoft Utility Solutions

WebsiteLinkedInAll Job Openings

51 - 200 employees

Founded 1989

🤝 B2B

☁️ SaaS

⚡ Energy

B2B • SaaS • Energy

Milsoft Utility Solutions is a software company that provides integrated engineering, operations, outage management, and customer information systems for utility providers. Their platform includes GIS and field engineering tools, outage and storm management, contingency and engineering analysis, enterprise accounting and utility billing (CIS), meter data management/AMI support, work and financial management, and communications solutions such as IVR and automated customer service. Milsoft offers both on-premise and hosted solutions and integrates with best-of-breed partners to help utilities plan, operate, and communicate with customers more reliably and efficiently.

📋 Description

• Design, develop, test, and execute scripts to extract, transform, and load data from source systems into target databases • Analyze source data structures, field mappings, and legacy databases to identify data quality issues, missing fields, and conversion bottlenecks • Collaborate with business analysts and clients to define data mapping rules • Run validation scripts to verify completeness and accuracy before and after migration • Write scalable scripts and automated tools to streamline repeatable migration processes • Maintain documentation of data conversion routines, mapping logic, and exception-handling procedures • Produce post-conversion reconciliation reports • Diagnose and resolve data discrepancies, transformation errors, and performance issues during testing and production cutovers • Uphold Milsoft’s values and philosophy regarding ethics, integrity, and corporate responsibility • Maintain regular, consistent, and professional attendance and adherence to health and safety procedures • Perform other duties as assigned

🎯 Requirements

• 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 • Experience with PostgreSQL or SQL Server • Experience working with 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 • Ability to translate complex data mapping challenges into simple terms for non-technical stakeholders