Overview
The Data Analyst is responsible for creating project data requirements, processing ETL jobs, checking data quality, analyzing results using SQL, generating output datasets and creating job reports. This role will need to communicate with customers directly to understand their data needs and work with the software development team to generate the required results for customers. Strong communication skills and a customer service oriented attitude are a must for success in this role. We are looking for an individual who is passionate about data, quality, analytics and customer success.
Responsibilities
- Communicate with clients to understand their data needs and create project requirement documents
- Process ETL jobs to collect data and generate results in Python based Jupyter Notebook
- Monitor job status, check data quality and identify issues by analyzing results using efficient SQL queries
- Create output data and send files through SFTP, S3 and API
- Develop reports for jobs and data results
- Provide customer support to clients for questions, issues and special requests
Qualifications
- Bachelor’s degree in Computer Science, Math, Statistics or related discipline
- Minimum 2 years work experience in data analysis with solid experience in writing SQL queries and using Microsoft Excel
- Strong knowledge of database operations, SQL, ETL automation, Python programming and various file formats in JSON, XML, CSV
- Attention to detail with strong skills in organization and documentation
- Excellent communication and customer service skills
- Ability to work remote independently with minimal supervision
Ficstar is a fast-paced company based in Toronto providing leading-edge web data mining solutions to customers. Our system is fully built in the Cloud for capability of crawling millions of websites and saving billions of records everyday. Our development and support team is collaborative, passionate, disciplined, open and responsible while we highly encourage self-motivation and new initiatives. We are proud of providing advanced technology solutions to customers including NASA, Dell, IKEA, Goldman Sachs and Amazon. For more details about us, please visit https://ficstar.com.
Please note this is a remote position - you will work at home only, not in the office. Only candidates currently living in Canada and legally eligible to work in Canada will be accepted.
We thank all applicants in advance, however, only those who meet the requirements will be contacted for next steps. Ficstar is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees.