Data Architect

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 i 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.