Data Architect

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:
• Comprehensive medical, dental, vision, disability, life insurance
• 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