Data Analyst – SQL/PL/SQL & ETL

Computer Task; Dallas (TX); On-site; USD 55,000 - 83,000; Part time

Job summary

CTG is seeking a Data Analyst in Dallas to analyze complex data requirements and develop SQL/PLSQL queries across OLTP, Data Warehouse, and Big Data environments. You will support data movement, ETL, API, OLAP, and data tracking while collaborating with stakeholders to deliver reliable data solutions.

The role requires 4+ years in data analytics, strong SQL/PLSQL skills, and a Bachelor’s degree in a related field. Experience with Denodo and other big data technologies is a plus.

Qualifications

• 4+ years of SQL and PL/SQL experience with OLTP, Data Warehouse, and Big Data environments.
• Strong SQL development skills with complex queries.
• Experience with data movement, ETL, API, OLAP, and data tracking best practices.
• Excellent data accuracy, attention to detail, and analytical problem solving.
• Strong written and verbal communication; ability to collaborate with diverse teams.

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 environments.
• Develop, maintain, and optimize complex SQL queries and stored procedures.
• Analyze and validate data for accuracy, completeness, and integrity.
• Support data movement and processing activities, including ETL, API, OLAP, and data tracking.
• Collaborate with technical teams and stakeholders to deliver effective data solutions.
• Investigate data issues and recommend resolutions.
• Apply data management best practices to improve data quality and reliability.
• Support data integration across multiple systems and technologies.
• Document data requirements, processes, findings, and technical solutions.
• Participate in team discussions, project planning, testing, and implementation.

Skills

SQL & PL/SQL

Data analysis

ETL knowledge

Attention to detail

Problem solving

Communication

Team collaboration

Self-motivation

Denodo

Big Data tools

Education

Bachelor’s degree in Computer Science, Information Technology, Data Analytics, Business Analytics, or related field

Tools

Denodo

Hadoop

MongoDB

Exadata

Job description

Location: Dallas, TX

Duration: 6 months

Duties:

• 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.

Skills:

• 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.
• Denodo experience is a plus.
• Big Data experience with technologies such as Hadoop, MongoDB, and Exadata is a plus.

Nice to Have Skills:

• 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.

Experience:

• 4+ years of experience working in a Data Analyst role.
• 4+ years of hands‑on SQL and PL/SQL experience.
• 2+ years of experience writing medium to complex stored procedures is preferred.
• Experience working with complex data environments, data integration, and ETL processes.
• Experience analyzing data across relational, data warehouse, and/or Big Data platforms.

Education:

• 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.

CTG does not accept unsolicited resumes from headhunters, recruitment agencies, or fee based recruitment services for this role.

About CTG

CTG, a Cegeka company, delivers IT and business solutions that enhance clients’ digital agility, empowering them to seize new opportunities and overcome any challenge. Backed by more than 60 years’ experience and a commitment to being a reliable, results‑driven partner, we work shoulder to shoulder with clients to shape digital together. Our vision is to be an indispensable partner to our clients and the preferred career destination for digital and technology experts. With more than 9,000 team members in over 15 countries, we combine global expertise with local insight to deliver innovative solutions. We operate across the Americas, Europe, and India, working with over 3,000 clients in many of today's highest‑growth industries.

Together, we shape what’s next—working shoulder to shoulder to deliver impactful solutions for our clients and society. Our culture is built by the people who work at CTG, the values we hold, and the actions we take. It's a living, breathing thing that is renewed every day through the ways we engage with each other, our clients, and our communities. At CTG, you’ll find a workplace where you are encouraged to grow, supported in your ambitions, and empowered to shape your own career journey. For more information, visit www.ctg.com.

CTG will consider for employment all qualified applicants including those with criminal histories in a manner consistent with the requirements of all applicable local, state, and federal laws.

CTG is an Equal Opportunity Employer. CTG will assure equal opportunity and consideration to all applicants and employees in recruitment, selection, placement, training, benefits, compensation, promotion, transfer, and release of individuals without regard to race, creed, religion, color, national origin, sex, sexual orientation, gender identity and gender expression, age, disability, marital or veteran status, citizenship status, or any other discriminatory factors as required by law. CTG is fully committed to promoting employment opportunities for members of protected classes.