We need a strong ETL/Data warehouse tester, someone with BI knowledge and experience testing in a Data warehouse environment. This resource should have Strong SQL skills Azure Data Factory and Snowflake experience is HIGHLY preferred, a candidate who has basic knowledge/experience with Azure and Snowflake Database will likely get the job.
Key Responsibilities:
- Develop data quality and testing plans to validate data pipelines
- Take ownership of end to end data quality and rules implementation
- Develop data quality and testing plans to validate KPIs & quality trends for the data across multiple systems
- Design, develop and implement automation testing, data quality processes and requirements
- Execute and automate test cases, and track data issues
- Actively engage in data validation technology discovery and implementation for on-prem and cloud
- Develop scripts in SQL/Python/etc. to achieve data quality objectives
- Incorporate data quality standards and best practices into data pipelines
- Participate in architecture design and discussions
- Be part of the Agile team to collaborate and to help shape requirements
- Supports the development and design of the internal data integration framework
- Works with system owners to resolve source data issues and refine transformation rules
Key Qualifications:
- Have a B.A./B.S. and 5 to 8 years of relevant work experience; or an equivalent in education and experience
- 5 to 8 years of experience in highly technical data organization supporting Business Intelligence projects
- Hands on experience with programming languages such as SQL, Python, etc.
- Experience with Microsoft Stack - SQL, SSIS, etc.
- Possess strong analytical skills with the ability to analyze, profile and validate data to identify potential data quality issues
- Experience with the Agile development process preferred
- Hands on data validation experience on AWS or Azure cloud technologies and no-sql databases
- Experience with big data environment and validation
- Proven track-record of excellence and consistently delivered tasks in hand successfully
- Experience with XML, JSON, CSV, etc. file format
- Have excellent interpersonal and written/verbal communication skills
- Manage financial information in a confidential and professional manner
- Be highly motivated and flexible
- Effectively handle multiple projects simultaneously and pay close attention to detail
- Have experience in a multi-dimensional data environment