(Remote) Data Specialist Jobs

Are you enthusiastic about working alongside a team of highly skilled professionals dedicated to data transformation? Do you possess a natural ability to solve complex problems with elegant solutions? Are you in search of a better work-life balance and the freedom to work from home? If this sounds like you, then you might be the perfect fit for Advanced Utility Systems.

The ideal candidate will join the Data Conversion team at Advanced Utility Systems, where they will play a crucial role in migrating and converting data from legacy databases to our core application database (CIS / MS SQL). Additionally, they will be responsible for handling reporting tasks, including the creation of customized reports and bill printing for our clients.

This remote role welcomes candidates anywhere in Canada and the US. The successful candidate will be working in the EST time zone.

What will be your impact?

• Develop data conversion scripts for project-specific conversion tasks with emphasis on re-use and efficiency.
• Work directly with customers to ensure that data conversion and reporting/analytics requirements and issues are addressed in a timely manner, as dictated by project schedules.
• Use various tools and processes to complete data migrations from different data sources into Microsoft SQL Server in a timely and accurate manner for customer implementation.
• Develop data mapping documentation, associated templates, and estimates for projects.
• Communicate regularly with Project Managers and Implementation Specialists to ensure timelines are met and project risks are mitigated.
• Build reports, bill prints, and dashboards for new and existing customers.

What are we looking for?

• 1+ year of experience with Crystal Reports and Power BI.
• Travel internationally for meetings and conferences may be required.
• 3+ years of experience in data migration, with at least one full project cycle.
• Bachelor’s degree in computer science, or related discipline, or equivalent job experience.
• Working knowledge of SQL admin database duties (Backup, restore, maintenance, performance, etc.).
• Experience with data warehouse design and data mining.
• Exceptional Microsoft SQL Server/T-SQL scripting skills to perform complex queries and write data conversion scripts.

What Will Make You Stand Out

• Experience with Utility/Billing applications, or other CIS applications.
• Strong Oracle and/or PostgreSQL knowledge.
• Experience with Disaster Recovery database testing and recovery.
• Experience installing, maintaining, and upgrading Oracle and MS SQL databases.
• Understanding of cloud based solutions and concepts.

What We Can Offer

• Lifestyle rewards
• Employee stock ownership and RRSP/401k matching programs
• 3 weeks' vacation and 5 personal days
• Remote work and more!
• Comprehensive Medical, Dental, and Vision benefits starting from your first day of employment

About Us

Advanced Utility Systems is a market leader in utility software solutions. As one of the largest providers of water, electric and natural gas utility software, Advanced Utility Systems offers an all-encompassing suite of integrated systems from billing to service management. Advanced is committed to long-term solutions for the utilities industry, through investment in its employees, products, services, technologies, and continuous improvement.

About Harris

Harris is a leading provider of mission critical software to the public sector in North America. As a wholly owned subsidiary of Constellation Software Inc. (“CSI”, symbol CSU on the TSX), Harris has become the cornerstone for CSI’s investment in utility, local government, school districts, public safety, and healthcare software verticals. Our success has been realized through investments in our proprietary software and market expertise. This focus, combined with acquiring businesses that build upon or complement our offerings, has helped drive our success. Harris will continue to growth through reinvestment – both in the people and products that we offer and making investments in acquiring new businesses.