What are the responsibilities and job description for the Data Analyst - Big Tech Experience position at SGS Consulting?
Summary:
- We are seeking a highly skilled and experienced Data Analyst to join our Data Engineering team.
- As a key member of our team, you will be responsible for providing data analysis support to Global Operations across the organization.
- Your primary focus will be on resolving privacy tasks, oncall tasks that require backfilling, tracking DDT tasks, creating bug intake forms, and deprecating stale tables.
- The main function of a data analyst is to coordinate changes to computer databases, test, and implement the database applying knowledge of database management systems.
- A typical database analyst/programmer is responsible for planning, coordinating and implementing security measures to safeguard the computer database.
Job Responsibilities:
- Maintain and build documentation for data assets (pipelines and dashboards) developed by Data Engineering team
- Resolve privacy issues and implement data quality checks where applicable
- Ensure timely availability of data tables
- Deprecate tables with 0 usage or stale data and identify next tables for deprecation
- Test programs or databases, correct errors and make necessary modifications.
- Modify existing databases and database management systems or direct programmers and analysts to make changes.
- Write and code logical and physical database descriptions and specify identifiers of database to management system or direct others in coding descriptions.
Education/Experience:
- Associate's degree in computer programming or equivalent training required.
Must-Have Skills:
- 2 years of experience in developing ETL pipelines, modify existing databases and database management systems
- Strong SQL skills AND Experience with data visualization tools such as Tableau or Power BI
- Knowledge of data warehousing concepts and ETL processes
Nice to Have:
- Familiarity with data infrastructure and tools (e.g., Hive, Presto, Spark)
- Experience with data governance and data quality best practices
- Experience with Python programming language
- Experience with cloud-based data platforms (e.g., AWS, GCP, Azure)
Salary : $55 - $60