(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?

• 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.
• Build reports, bill prints, and dashboards for new and existing customers.
• Communicate regularly with Project Managers and Implementation Specialists to ensure timelines are met and project risks are mitigated.
• 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.
• Develop data conversion scripts for project-specific conversion tasks with emphasis on re-use and efficiency.

What are we looking for?

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

What will make you stand out:

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

What we can offer:

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

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:

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

Job Type: Full-time

Salary: $80,000.00 - $90,000.00 per year

Benefits:

• Dental insurance
• Paid time off
• Vision insurance
• Health insurance
• Life insurance
• Referral program

Schedule:

• 8 hour shift

Work Location: Remote