01Overview
Typical Functions:
Manipulates and queries data by building SQL and stored procedures single handedly in SnowflakeWrites and executes test cases for data-related release items within Agile processesWrites complex SQL queries and handle large data set quality validationBuilds a Data Quality Testing Framework from scratch to monitor the quality of data.Understands the basic concepts of data Warehousing, ETL to validate changes to themExecutes common data quality tests to validate data accuracy, data completeness, data freshness, data integrity, data consistencyBuilds test cases to validate the generated data analytical report and dashboardCreates database tests to enforce data validation and constraints quality standardsApplies your knowledge of dimensional modeling and data warehouse concepts, such as star schemas, snowflakes, dimensions, facts to conduct data analysisPerforms statistical tests on large datasets to determine data quality and integrityEvaluates system performance and design, as well as its effect on data qualityCollaborates with database developers to improve data collection and storage processesRuns data queries to identify coding issues and data exceptions, as well as cleaning dataGathers data from primary or secondary data sources to identify and interpret trendsKeeps abreast of developments and trends in data quality analysisCollects, stores, processes, and analyses raw and/or complex data from multiple sources, recommends ways to apply the data, chooses and designs optimal data solutions, and builds data processing systems, using expertise in data warehousing solutions and working with the latest database technologies.Maintains, implements, and monitors the quality of the data and information with the architecture used across the company; reports on results and identifies and recommends system application changes required to improve the quality of data in all applications.Investigates data quality problems, conducts analysis to determine root causes of problems, corrects errors, and develops prototypes, process improvement plans across all programs, and proof of concepts for the selected solutions.Processes unstructured data into a form suitable for analysis, followed by doing the analysis.Integrates innovations and algorithms into the organizations data systems, working closely with engineering team.Implements complex data projects with a focus on collecting, parsing, managing, analysing, and visualising large sets of data to turn information into insights using multiple platforms.Serves as a data subject matter expert, collaborates with business owners or external clients to establish an analysis plan to answer key business questions, and delivers both reporting results and insights.Generates specific and operational reports in support of objectives and initiatives, and presents and communicates complex analytical data and results to appropriate audiences.Other duties or functions may be assigned.Requirements
Bachelors Degree in Engineering, Computer Science, or equivalent experience6+ Years of Software Quality Assurance experience which includes Data Warehouse TestingProficiency in SQL ideally within SnowflakeSQL with MySQL, SQL Server, and/or PostgreSQLExperience with Sisense or Power BI5+ years experience developing data driven softwareProficiency in programming languages, including Structured Query Language (SQL)Experience writing DBT testsExperience in Agile methods, particularly Scrum, preferredDemonstrated knowledge of critical thinkingProfessional experience around the data science lifecycle (feature engineering, training, model deployment) .
