SQL & ETL

Computer Task Group, Inc•Dallas, TX

1d•Onsite

About The Position

CTG is seeking to fill a Data Analyst – SQL/PL/SQL & ETL position for our client. This role involves analyzing complex data requirements, developing SQL and PL/SQL queries, and working with data across various database environments including OLTP, Data Warehouse, and Big Data. The analyst will be responsible for developing, maintaining, and optimizing SQL queries and stored procedures, as well as analyzing and validating data for accuracy and completeness. The position also supports data movement and processing activities such as ETL, API, OLAP, and data tracking, and requires collaboration with technical teams and business stakeholders to deliver effective data solutions. The role includes investigating data issues, identifying root causes, and recommending resolutions, while applying data management best practices. Support for data integration initiatives and documentation of processes and solutions are also key responsibilities. The analyst will participate in team discussions, project planning, testing, and implementation activities.

Requirements

4+ years of SQL and PL/SQL experience working with OLTP, Data Warehouse, and Big Data databases.
Strong SQL development skills with extensive experience writing complex queries.
Strong understanding of data movement and processing, including ETL, API, OLAP, and data tracking best practices.
Strong attention to detail and commitment to data accuracy.
Excellent analytical, problem-solving, and troubleshooting skills.
Ability to collaborate effectively and work as part of a team.
Strong written and verbal communication skills.
Self-motivated with the ability to work independently and prioritize tasks.
Bachelor’s degree in Computer Science, Information Technology, Data Analytics, Business Analytics, or a related field preferred, or equivalent combination of education and experience.
Excellent verbal and written English communication skills and the ability to interact professionally with a diverse group are required.

Nice To Haves

Denodo experience is a plus.
Big Data experience with technologies such as Hadoop, MongoDB, and Exadata is a plus.
Experience with cloud platforms such as AWS, Azure, or GCP.
Experience with containerization technologies such as Docker and Kubernetes.
Knowledge of API Gateways, microservices architecture, and security standards including OAuth2, SSL, and certificates.
Familiarity with monitoring and logging tools such as Dynatrace and Grafana.

Responsibilities

Analyze complex data requirements and develop SQL and PL/SQL queries to support business and technical needs.
Work with data across OLTP, Data Warehouse, and Big Data database environments.
Develop, maintain, and optimize complex SQL queries and medium to complex stored procedures.
Analyze and validate data to ensure accuracy, completeness, consistency, and integrity.
Support data movement and processing activities, including ETL, API, OLAP, and data tracking.
Collaborate with technical teams, business stakeholders, and other analysts to understand requirements and deliver effective data solutions.
Investigate data issues, identify root causes, and recommend appropriate resolutions.
Apply data management and processing best practices to improve data quality and reliability.
Support data integration initiatives involving multiple systems and technologies.
Document data requirements, processes, findings, and technical solutions.
Participate in team discussions, project planning, testing, and implementation activities.