Data Architect

VertexOne Brand; United States; Remote; USD 70,000 - 90,000; Full time

Job summary

VertexOne is seeking a Data Analyst to assist utility clients in data migrations and validations. The role requires expertise in SQL and KNIME, with a focus on enhancing customer experience through data-driven solutions. This position is fully remote, offering a flexible work environment and a range of employee benefits, including health savings accounts and professional development opportunities.

Benefits

Health Savings Account (HSA)

401K match

Flexible PTO

Employee recognition platform

Remote work environment

Initial work from home stipend

Leadership/Coaching training programs

Free access to Bizlibrary

Employee Assistance Program (EAP)

Paid parental leave

Qualifications

• Two years of experience as a Data Analyst or related role.
• Experience with data migration and validation in utilities.

Responsibilities

• Assist clients with data migrations into VertexOne VxCIS system.
• Conduct workshops for utility clients to identify gaps and provide recommendations.
• Create self-service BI tools for data analysis.

Skills

Data Validation

SQL

Data Analysis

KNIME

Business Intelligence

Education

Master’s degree in computer science

Tools

IBM i DB2

Microsoft Access VBA

Job description

Posted Tuesday, April 29, 2025 at 6:00 AM

At VertexOne , helping utilities provide the best customer service experience is what we do. VertexOne is the recognized leader in SaaS platforms for utilities across North America. Through a wide range of innovative services and solutions, VertexOne helps utilities deliver a compelling customer experience; reducing the cost to serve customers, increasing operational efficiency, improving customer satisfaction, and driving utility operations forward. It’s been in the DNA of our people since we started supporting utilities’ customer experience needs over 20 years ago. And that commitment continues to this day.

Our team members are our greatest assets, so we pride ourselves on being ‘Employee First’. As such, we listen to what our employees have to say and find ways to incorporate their ideas into the company. Whether it’s new technology, career development opportunities , or fun events, we find new ways to keep our employees engaged and incentivized to grow within the company. Our employees' well-being—both physical and mental—is a top priority at VertexOne. That's why we foster a 100% remote and flexible environment and encourage work-life balance.

VertexOne is proudly Certified as a Great Place to Work. Great Place to Work is the global authority on workplace culture, employee experience, and leadership behaviors proven to deliver market-leading revenue, employee retention and increased innovation. VertexOne is dedicated to prioritizing the employee experience and creating an exceptional company culture.

Job Description:

• Assist our new Utility Industry clients to perform data migrations from third-party legacy systems and databases into the VertexOne VxCIS system.
• Educate and train clients to understand our data templates.
• Process the template data provided by the client to analyze and validate data quality using KNIME tool development.
• Perform extensive data validations using KNIME and migrations into IBM i DB2 database using customized SQL scripts on complex and large client data within.
• Conduct various data extraction and migration workshops for utility clients to better understand the system, identify gaps, provide recommendations, and map their utilities business processes and help them extract their data based on system’s requirements.
• Perform minor data transformation and cleansing of sufficient quality data.
• Create self-service BI tools to allow utilities users to analyze data across various business dimensions with detailed visibility into granular and historical data.
• Develop and utilize SQL and Microsoft Access VBA scripts to maintain complex and large client databases.
• Extract and load utilities data, create appropriate test plans, Q/A processes, and test cases to ensure data accuracy using SQL. Collaborate with client company project stakeholders and data extractors.
• Provide detailed reports on data quality issues to all key data migration project stakeholders.
• Continually improve the KNIME and SQL script processes to improve data validations, accuracy, and performance.
• Position requires 100% telecommuting; employee’s work location can be anywhere in the United States.

Education Required:

Master’s degree in computer science, data science, data analytics engineering or related

Job Duties:

Two (2) years of experience as a Data Analyst, SAP Consultant, or related

Special Skills Required:

Must have work experience with the following:

(1) Perform extensive data validations using KNIME and migrations into IBM i DB2 database using customized SQL scripts on complex and large client data within regulated and deregulated energy market.

(2) Conduct various data extraction and migration workshops for utility clients to better understand the system, identify gaps, provide recommendations, and map their utilities business processes and help them extract their data based on system’s requirements.

(3) Create self-service BI tools to allow utilities users to analyze data across various business dimensions with detailed visibility into granular and historical data, while leveraging experience with utilities (gas, electric, water, sewer, refuse).

(4) Extract and load utilities data, create appropriate test plans, Q/A processes, and test cases to ensure data accuracy using SQL. Position requires 100% telecommuting; employee’s work location can be anywhere in the United States.

Apply online - No calls.

What VertexOne has to offer:

• Health Savings Account (HSA), Flexible Spending Account (FSAs)
• 401K match
• Flexible PTO
• Employee recognition platform with monetary rewards
• 100% Remote work environment
• Initial work from home stipend
• Leadership/Coaching training programs
• Free access to Bizlibrary for unlimited professional development
• Employee Assistance Program (EAP) with counseling sessions available 24/7
• Health and wellbeing programs
• Paid parental leave
• Employee bonus referral program
• Employee Discount Program

VertexOne is the leading provider of cloud-based SaaS software solutions powering the next generation of customer experience for utilities, energy retailers, and energy transition providers.

With over 30 years of experience and more than 350 customers in the cloud, we capitalize on our deep expertise to provide a wide range of innovative solutions for digital transformation, revenue optimization, and data-driven efficiency operations surrounding the customer.

From Customer Information Systems (CIS) and Mobile Workforce Management (MWM) to Electronic Data Interchange (EDI) and Digital Customer Engagement and self-service portals, we empower our customers to deliver a compelling customer experience, reduce costs to serve, increase operational efficiency, and improve customer satisfaction.

For more information on how VertexOne allows you to enhance the digital customer experience, improve revenue management, and leverage data analytics, visit https://www.vertexone.net .

Equal Opportunity Employer:
VertexOne is proud to be an equal opportunity employer. We value and encourage diversity and solicit applications from all qualified applicants without regard to race, color, national origin, religion, sex, age, marital status, disability, veteran status, sexual orientation, gender identity or expression, or other characteristics protected by law.

VertexOne is also committed to providing reasonable accommodation for applicants with disabilities. Individuals who need reasonable accommodation because of a disability for any part of the employment process should ask to speak with a Human Resources representative to request accommodation.