Skip to content
CV Rocket
Get started
How it worksThe enginePricingBlogContactSign in

Open nowPosted 39 hours ago

Data Analyst, II - Utility experience required

VertexOne13 open roles

Where
United States
Get the CV for this job

From $25 per CV, paid once. No subscription.

Your applicationOpen nowData Analyst, II - Utility experience requiredVertexOne · United States

  1. YouYes, apply to this one.

  2. CV RocketCV written for this posting.

  3. 25 readersRecruiter, hiring manager, skeptic. Round after round.

  4. CV RocketApplied on VertexOne's own form.

The reply lands in your private mailbox

3×more interviews than doing it yourself with ChatGPT.

The clock on this job

Early applications get read.

11.5% of postings close within 7 days. Measured by our own scanner across the market. VertexOne postings stay open a median of 20 days.

Share of postings closed within
  1. 2.0%1 day
  2. 4.3%3 days
  3. 11.5%7 days
  4. 18.1%14 days
  5. 35.6%30 days
  6. 44.6%60 days
This job: posted 39 hours ago

VertexOne median: 20 days open

The posting

Data Analyst II, Data Migration Job Description

Overview of Role/Job Purpose:

The Data Analyst II, Data Migration is a highly visibility role focused on migrating and onboarding utility customers to VertexOne's CIS platform. Reporting to the Data Migration Manager, this analyst extracts, profiles, maps, transforms, and validates customer data from legacy systems. They ensure data accuracy, conversion stability, and clear exceptions handling through every phase of delivery.

The role combines analytical judgement with practical automation and process improvement. This person will help improve the way we deliver migrations so that each conversion is more repeatable, efficient, and reliable. They will work closely with internal teams and utility clients during discovery, mapping, mock conversions, validation, and go-live.

The successful candidate is deeply data driven, meticulous, and able to communicate complex data issues clearly to both technical and business audiences. They will partner closely with the Data Migration Manager on delivery planning, team direction, and practical AI automation, and act as the manager's delegate when needed. This is a hands-on role for someone who is technology-curious, eager to learn, enjoys solving messy data problems, building practical expertise, and growing into team leadership within the data migration organization.

Essential Duties:

Work with clients to extract, profile, and analyze source data from legacy utility CIS, billing, and metering systems, including relational databases, and flat or fixed width files. Lead day-to-day technical direction for migration engineers, including reviewing and approving mappings, transformation logic, and validation results before they go to clients. Create and maintain project and team weekly status reports. Develop and maintain source to target data mappings and transformation logic in partnership with Implementation, Product, and utility client teams. Write, optimize, and maintain SQL for data extraction, transformation, reconciliation, and validation. Execute mock conversions and production cutovers, validating record counts, balances, and business rules at each migration phase. Own cutover readiness for assigned client migrations, including runbooks, go/no-go recommendations, and post-migration validation sign-off. Design and implement data quality checks, reconciliation reports, and exception handling that surface issues early and ensure stability through go live. Identify manual and repetitive migration tasks and build automated, reusable workflows using KNIME, scripting, and other automation tooling. Contribute to the continuous improvement of migration methodology, templates, and standards to increase accuracy, efficiency, and repeatability. Perform root cause analysis on data defects and conversion errors, and drive resolution with internal and client stakeholders. Own one or more client migration streams end to end and act as interim decision-maker when the Data Migration Manager is unavailable. Lead data and migration training sessions for clients, explaining utilities CIS data entities and relationships, including functional concepts on how they relate to each other. Communicate migration status, data quality findings, risks, and readiness clearly to project teams, leadership, and utility clients. Document mappings, processes, workflows, and lessons learned for internal knowledge sharing. Uphold data governance, privacy, and security standards for sensitive customer and billing data.

Job Qualifications:

4 to 8 years of experience in data analysis, data migration, ETL, or a related technical role. Experience leading or reviewing the work of other analysts or engineers on data migration or ETL projects. Strong proficiency in SQL, including complex joins, aggregations, and data validation queries. Experience with utility CIS or billing platforms (e.g., SAP IS-U, Oracle CC&B, or similar) and utility meter or billing data. Demonstrated experience with data mapping, data profiling, and data quality or reconciliation practices. Experience with ETL or workflow tools (e.g., KNIME, SSIS, Talend, Alteryx, Airflow, Python). Exceptional attention to detail and a data driven approach to problem solving and decision making. Ability to manage multiple migration workstreams and deadlines in a fast paced, high visibility environment. Excellent written and verbal communication skills, with the ability to explain technical findings to business and client audiences. Flexibility to work occasional evenings and weekends during production cutovers and go live events. Coordinate with an offshore delivery team, including regular working-hour overlap.

Preferred Qualifications:

Bachelor’s degree in Information Systems, Computer Science, Data Analytics, or a related field.

Hands-on SQL experience with DB2 for IBM i (AS400) or other legacy mainframe data sources.

Experience with KNIME Analytics Platform. Proficiency in Python or another modern programming language for data processing and automation. Experience with agentic engineering, including using AI agents and LLM tools to accelerate analysis, mapping, and automation. Familiarity with automation and orchestration tooling (e.g., Airflow, Bash scripting, CI/CD pipelines) and version control (e.g., Git). Experience in a SaaS organization.

Personal Attributes:

Meticulous: Treats every record as important and holds a high bar for accuracy and completeness. Data Driven: Relies on evidence, metrics, and validation results to guide decisions and recommendations. Process Improver: Continuously looks for ways to automate, standardize, and strengthen how work gets done. Clear Communicator: Conveys status, risks, and findings with clarity and confidence to technical, business, and client audiences. Composed Under Pressure: Stays steady and focused during cutovers, tight deadlines, and high visibility moments. Collaborative: Builds trust across Implementation, Product, Engineering, and client teams. Ownership Minded: Takes accountability for deliverables from mapping through go live.

From $25, paid onceGet the CV for this job

What happens when you press

One press. We do the rest.

  1. A CV for this posting

    Written against VertexOne's own wording, from every piece of relevant proof in your profile.

  2. 25 readers review it

    Recruiter, hiring manager, skeptic and more read every draft, round after round. You get the best round.

    The review screen in CV Rocket: how each CV was read, round by round.

  3. We apply on VertexOne's form

    Our application engine gets through the hardest forms there are. Where a question needs you, AI suggests the best answer. Don't want us applying from our IP addresses? Use our Chrome extension: we apply straight from your own browser.

    An application in CV Rocket: every answer filled in on the employer's form.

  4. Every reply, sorted

    VertexOne's answer lands in your private mailbox, and we classify it on arrival: interview, question, rejection.

    The CV Rocket inbox: each employer reply classified as an interview, an action or a rejection.

  5. Reply with AI

    AI helps you write the email, checks it and sends it. We show you whether the recruiter read it.

  6. The interview in your calendar

    Full integration with your calendar. The invitation goes straight in.

    An interview invitation in the CV Rocket inbox, added to the candidate's calendar.
Get the CV for this job

From $25 per CV, paid once. No subscription.

Why it works

3×

more interviews than doing it yourself with ChatGPT.

ChatGPT writes a CV and never learns what happened to it. We see every reply. For each CV we know:

  • How it was written, and how the review scored it
  • When we applied, and how long after the posting went up
  • Which posting, which company, which city
  • Who got the interview, and who heard nothing

That is how we know which CVs get called.

Get the CV for this job

From $25 per CV, paid once. No subscription.

The numbers game

More applications. More interviews.

Every application goes out with its own CV, written for that posting and paid once. Send enough of them and the law of large numbers finds you the job.

Get the CV for this job
By hand5–10
With CV Rocket100
applications a day

Nearby

Live postings like this one

Same employer first, then the same role elsewhere.

Before you press

Straight answers

Get the CV for this job

From $25 per CV, paid once. No subscription.

What if my background isn't good enough?

We make the most of the background you have. The CV uses every piece of relevant proof your profile holds, and one of the 25 readers reads your whole profile and flags what the CV left out.

Do you really apply for me?

Yes, on the employer's own form, the hardest ones included. Where a question needs you, you answer it right there and AI suggests the best answer. Don't want us applying from our IP addresses? Use our Chrome extension: we apply straight from your own browser.

Is it a subscription?

No. You pay once per CV, from $25. Every application goes out with its own CV, written for that posting.

One job. One CV.
Paid once.

Pick the posting you want. We write for it, apply for you and catch the reply.

Get the CV for this job

From $25 per CV, paid once. No subscription.