Data Warehouse Specialist
Mevotech
- North York, ON
- Permanent
- Full-time
- Implement robust ETL (Extract, Transform, Load) processes to integrate data from various sources into the data warehouse.
- Ensure data quality, consistency, and integrity through data validation, cleansing, and normalization techniques.
- Optimize data warehouse performance by fine-tuning queries, indexes, and database configurations.
- Scale data infrastructure to accommodate growing data volumes and evolving analytical needs while maintaining performance and reliability.
- Implement caching mechanisms and data partitioning strategies to improve query performance and resource utilization.
- Develop interactive dashboards and visualizations using tools like Tableau and Power BI
- Install, configure, and maintain database management systems (DBMS), ensuring optimal performance and reliability.
- Implement backup and recovery strategies to protect against data loss and minimize downtime in case of system failures or disasters.
- Monitor database performance metrics and system health indicators, identifying and addressing issues to maintain data warehouse availability and performance.
- Experiment with various AI and machine learning models to extract preliminary insights, identify patterns, and explore predictive capabilities within the initial datasets.
- Work closely with data owners to prototype AI models using techniques such as regression, classification, clustering, and shallow learning algorithms.
- Iterate on model development based on feedback, performance evaluation, and early-stage experimentation to refine the approach.
- Deploy AI models into production environments and integrate them with existing systems for real-time data analysis and decision-making.
- Establish data governance frameworks and policies to ensure data quality, security, and regulatory compliance.
- Define data access controls, encryption standards, and audit trails to protect sensitive information and mitigate risks.
- Conduct regular audits and assessments to monitor compliance with data governance standards and industry regulations.
- Collaborate with cross-functional teams including data analyst, business analysts, and IT professionals to understand business requirements and deliver data-driven solutions.
- Share expertise and best practices with team members through training sessions, documentation, and knowledge sharing sessions.
- Stay abreast of emerging technologies, industry trends, and best practices in data warehousing, AI, and analytics to drive innovation and continuous improvement.
- Bachelor's degree in computer science, information systems, or a related field; or equivalent work experience.
- Proven experience in designing and implementing an operational production grade large-scale data solution on Snowflake.
- Proficiency in SQL and experience with relational database management systems (e.g. SQL Server, Informix).
- Familiarity with ETL tools and processes such as SSIS and Azure Data Factory.
- Familiarity with AI and machine learning concepts and frameworks, including supervised and unsupervised learning, regression analysis, and neural networks.
- Experience with programming languages such as Python, R, or Java for data analysis, scripting, and automation tasks.
- Demonstrated expertise in writing complex T-SQL scripts to perform data manipulation, retrieval, and transformation tasks.
- Knowledge of data visualization tools (e.g., Tableau, Power BI) is desirable.
- Excellent analytical, problem-solving, and troubleshooting skills.
- Strong communication and collaboration abilities, with the ability to work effectively in a cross-functional team environment.
- Strong analytical skills, ability to interpret business requirements and produce functional and technical design documents.
- Good time management skills – Ability to prioritize and multi-task, handling multiple efforts at once.
- At Mevotech, diversity goes beyond demographics. We embrace unique perspectives and voices in our culture. We actively seek out different viewpoints and incorporate them into our organization.
- Mevotech provides accessibility accommodations during the recruitment process. If you require accommodations, please let us know, and we'll work with you to meet your needs.