Data Platform Administrator
7 days ago
We have an opening for **Data Platform Administrator - Snowflake.**
**Job Summary**:
**Key Responsibilities**:
**Snowflake Administration**:
- Administer and manage the Snowflake cloud data platform, ensuring optimal performance, security, and reliability.
- Implement and configure Snowflake solutions, including data warehousing, data integration, and data migration.
- Optimize Snowflake performance through query tuning, resource management, and data modeling.
- Monitor and troubleshoot Snowflake environments to ensure high availability and performance.
- Implement cost optimization strategies, such as right-sizing virtual warehouses, reducing auto-suspend times, and consolidating workloads.
- Utilize Snowflake's cost insights to identify and act on opportunities for cost savings.
**AWS Integration**:
- Integrate Snowflake with AWS services such as S3, Glue, Lambda, and EC2 to enhance data workflows and analytics.
- Design and implement data pipelines using AWS services to facilitate seamless data movement and transformation.
**PostgreSQL Management**:
- Manage PostgreSQL databases, including performance tuning, backups, and recovery.
- Ensure data integrity and security across PostgreSQL environments.
- Develop and implement automation scripts for database management tasks.
**Performance Tuning**:
- Optimize query performance by leveraging techniques such as clustering, query pruning, and result caching.
- Conduct regular performance assessments and implement improvements to enhance query execution times and overall system efficiency.
- Use Snowflake's Query Acceleration Service and other advanced features to improve performance for complex queries.
**On-Prem to Cloud Migration**:
- Lead and manage the migration of on-premise databases to cloud platforms, ensuring mínimal downtime and data integrity.
- Collaborate with stakeholders to ensure seamless transition and address any migration-related issues.
**Collaboration and Support**:
- Collaborate with data engineering, analytics, and IT teams to ensure effective communication and integration.
- Provide technical support and guidance to team members and stakeholders.
- Participate in on-call rotations to provide 24/7 support for critical issues.
**Documentation and Best Practices**:
- Maintain comprehensive documentation of Snowflake and PostgreSQL configurations, processes, and procedures.
- Develop and enforce best practices for database management, security, and compliance.
**Requirements**:
- 5+ years of experience as a Snowflake Administrator.
- Proven experience in implementing and managing Snowflake solutions.
- Strong knowledge of AWS cloud services and integration.
- Proficiency in PostgreSQL database administration.
- Experience with cloud computing platforms (e.g., AWS, Azure, GCP).
- Excellent problem-solving skills and attention to detail.
- Strong communication and collaboration skills.
- Ability to work independently and as part of a team in a fast-paced environment.
**Preferred Qualifications**:
- Experience with other cloud platforms like AWS.
- Knowledge of Python, Terraform or other scripting languages for automation.
- Familiarity with CI/CD pipelines and DevOps practices.
- Certification in Snowflake, AWS, or PostgreSQL.
**Job Types**: Full-time, Permanent
Pay: $130,000.00-$150,000.00 per year
Application question(s):
- Years of experience in Snowflake
- Overall years of experince
Work Location: Hybrid remote in Newmarket, ON
-
Newmarket, Canada Southlake Academic Family Health Team (we are not the hospital) Full time**Information, Technology and Data Administrator** The Southlake Academic Family Health Team is seeking a full-time Information, Technology and Data Administrator to support our large primary care practice. Job Responsibilities: - Oversee IT and telecommunication platforms, including, but not limited to our electronic medical records (EMR), patient...
-
Newmarket, Canada York Region Full time**Job Description**: **POSITION PURPOSE** Reporting to Manager, Data & Technical Support, is responsible for supervising and coordinating program administrative staff and ensuring appropriate levels of administrative support; supervising data entry into the integrated Public Health Information System (iPHIS), and Case and Contact Management (CCM) to ensure...
-
Data Architect: Hybrid Cloud
4 days ago
Newmarket, Canada Util-Assist Inc. Full timeA consultancy for utilities is seeking a Data Architect with extensive experience in designing and implementing data architectures. This role focuses on developing data solutions that support advanced analytics and digital transformation. The ideal candidate will have proficiency in SQL, experience with cloud platforms, and strong communication skills. Join...
-
Data Architect: Hybrid Cloud
3 days ago
Newmarket, Canada Util-Assist Inc. Full timeA consultancy for utilities is seeking a Data Architect with extensive experience in designing and implementing data architectures. This role focuses on developing data solutions that support advanced analytics and digital transformation. The ideal candidate will have proficiency in SQL, experience with cloud platforms, and strong communication skills. Join...
-
Data Architect: Hybrid Cloud
9 hours ago
Newmarket, Canada Util-Assist Inc. Full timeA consultancy for utilities is seeking a Data Architect with extensive experience in designing and implementing data architectures. This role focuses on developing data solutions that support advanced analytics and digital transformation. The ideal candidate will have proficiency in SQL, experience with cloud platforms, and strong communication skills. Join...
-
Data Entry/administration
3 days ago
Newmarket, Canada Utility Energy Services Full timeUtility Energy Services (Canada) inc is looking for a person interested in a full time data entry/admin position, this position includes assisting with scheduling, data input and record keeping to start. The chosen individual will be a team player who is looking to grow their career, they will be organized, a problem solver and willing and open to...
-
Data Architect
2 weeks ago
Newmarket, Ontario, Canada bf-24b9-4933-b2a4-faf68fdad9bd Full timeData Architect (Hybrid/Remote)Who We Are:Util-Assist is a leading consulting and services partner to electric, water, and gas utilities across North America. We help utilities navigate digital transformation—empowering them with smart technology, data-driven solutions, and customer-first services. From outage communications to billing support and grid...
-
Product Manager, Data
2 weeks ago
Newmarket, Ontario, Canada Util-Assist Inc. Full timeProduct Manager, Data & Analytics (Hybrid/Remote)Who We Are:Util-Assist is a leading consulting and services partner to electric, water, and gas utilities across North America. We help utilities navigate digital transformation—empowering them with smart technology, data-driven solutions, and customer-first services. From outage communications to billing...
-
Data Architect
4 days ago
Newmarket, Canada Util-Assist Inc. Full timeUtil-Assist is a leading consulting and services partner to electric, water, and gas utilities across North America. We help utilities navigate digital transformation—empowering them with smart technology, data-driven solutions, and customer-first services. From outage communications to billing support and grid security, we’re reshaping how utilities...
-
Data Architect
3 days ago
Newmarket, Canada Util-Assist Inc. Full timeUtil-Assist is a leading consulting and services partner to electric, water, and gas utilities across North America. We help utilities navigate digital transformation—empowering them with smart technology, data-driven solutions, and customer-first services. From outage communications to billing support and grid security, we’re reshaping how utilities...