What are the responsibilities and job description for the Data Analyst position at SGS Consulting?
Job Details
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, Google Cloud Platform, Azure).
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
