Data Analyst
Our mission is to help APAC businesses to lead the world in technology, agility, and productivity.
Hype & Dexter is one of the top HubSpot partners in the world - leading the way in digital transformation, Sales CRM, and Marketing Automation excellence. Hype & Dexter isn’t like the other agencies - we are a technology business merged with a digital agency. It’s an exciting place to be, and the opportunity for growth here really is expansive.
Role responsibilities:
- Prepare and Facilitate Data/Integration Discovery Workshop/s with Client Subject Matter Experts
- Review of existing source platform and data
- Create Detailed Briefs and Documentation
- Collaboration with H&D Subject Matter Experts to provide Data Discovery recommendations and High-Level Solution
- Provide recommendation for Data Discovery Costs, Data Discovery Schedule and estimated Data Execution Cost and Schedule range
- Provide Data High-level Solution Architecture, ERD Mapping and High-Level Requirements
- Hands on support for Data Cleansing, iPaaS configuration, Data Extraction and Data imports for smaller jobs and where required
- Quality Assurance of Data Imports and Integrations
- Facilitate Delta Import Process (i.e. import of changed data between original full extract and cutover, where applicable)
Your skills:
Essential
- ETL experience with Data, specifically with regard to data integrity and management
- Experience with data cleansing
- Great problem solving and investigation skills are key
- Comfortable working with internal and/or external clients to take briefs and managing actions
- Ability to influence stakeholder relationships
- Excellent documentation and communication skills to ensure clarity and alignment of understanding across the numerous parties
- Exceptional attention to detail and a quality assurance focus
- Keep up to date with the latest digital technologies and/or design trends
- Using existing Data brief templates to take Data Briefs with clients
- Work with the Client to get access to platforms or data to test imports
- Define Data Brief Clean-up specifications and make recommendations for Data Integrity of systems
- Work with the PM and Clients to either quote or brief in the Client to cleanse data prior to imports
- Experience with creating and executing data verification and test use case
Preferred
- Experience with integration projects and working with APIs
- Experience with scripting to automate data cleansing processes
- Create scripts and processes to export data from source platforms
- Experience delivering enterprise digital projects
- Ability to write SQL queries and use various methods to extract data from a myriad of platforms and sources
Bonus qualifications/experience
- Salesforce Migration
- Experience with Node.JS or a strong understanding of JS
- Experience with React
- Experience within UI/UX, Customer Journeys, or Digital Transformations
- Experience working in Agile/Scrum teams and Waterfall environment
- Experience with Python for Data wrangling
- Experience with iPass Platforms