Match score not available

Data Architect

Remote: 
Full Remote
Experience: 
Mid-level (2-5 years)
Work from: 

Offer summary

Qualifications:

8+ years technical data analysis, Strong SQL and ETL experience, Data analytics and KNIME knowledge, Experience with IBM DB2 platform, Utility Industry experience is a plus.

Key responsabilities:

  • Lead data migrations for new clients
  • Educate and train clients on data templates
  • Communicate regularly with client stakeholders
  • Process and validate data quality
  • Assist in preparing data for import to database
VertexOne logo
VertexOne https://www.vertexone.net
201 - 500 Employees
See more VertexOne offers

Job description

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.

Essential Job Duties

The Data Architect will be in a lead role and will be primarily assisting our new clients to perform data migrations from 3rd party legacy systems / databases into the VertexOne VxCIS system. VertexOne is regularly migrating new clients to VxCIS. Clients are responsible for the primary tasks of data extraction and transformation from their legacy systems to fit our VxCIS data input template formats designed for this purpose.

This role will educate and train clients to understand our data templates. Using tools developed using KNIME, this role will process the template data provided by the client to validate data quality. Data of sufficient quality will then undergo minor data transformations and cleansing for preparing it to be imported into an IBM i DB2 database. This role involves regular communication with client company project stakeholders and data extractors.

Skills/Requirements

  • 8 years+ experience in a lead technical data analysis role (Data Architech, Data Engineer, or Data Analyst) preferred
  • Must have strong SQL development experience
  • Must have experience with ETL
  • Strong Data Analytics is required
  • KNIME development experience preferred
  • IBM DB2 or other DB2 platform experience
  • End user training experience preferred
  • Experience working with offshore teams
  • Microsoft Excel VBA development experience preferred
  • Utility Industry experience is a plus (Water, Sewer, Electric, Gas, Refuse)
  • This role will include travel to client sites about 5% of the time

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
  • 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

About VertexOne

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.

Apply Now

Required profile

Experience

Level of experience: Mid-level (2-5 years)
Spoken language(s):
English
Check out the description to know which languages are mandatory.

Other Skills

  • Teamwork
  • Communication

Data Architect Related jobs