Technical Business Analyst – Data & SQL

Computer Task; Dallas (TX); On-site; USD 90,000 - 110,000; Full time

Job summary

CTG is seeking a Technical Business Analyst for a 6-month engagement in Dallas, TX. The candidate will partner with business and technical teams to translate requirements into data-driven specifications and documentation.

This role emphasizes SQL analysis, data troubleshooting, and delivering BRDs, TDDs, and data lineage artifacts. The ideal candidate has 4+ years in data-focused BA roles, strong SQL skills with Oracle/SQL Server, and familiarity with MongoDB a plus.

Qualifications

• 4+ years as a Technical Business Analyst.
• Experience on Agile projects.
• Strong SQL skills with Oracle/SQL Server; MongoDB a plus.

Responsibilities

• Translate business needs into technical requirements and data solutions.
• Analyze data, troubleshoot issues, and identify root causes.
• Create and maintain BRDs, TDDs, and Data Lineage documents.
• Write and validate SQL queries across enterprise databases.

Skills

SQL

Data Analysis

Agile

Requirements Docs

Stakeholder Mgmt

Education

Bachelor's degree

Tools

Oracle

SQL Server

MongoDB

Job description

Location

Dallas, TX

Duration

6 months

Duties

• Serve as a Technical Business Analyst supporting data-focused projects and initiatives.
• Partner with business stakeholders, technical teams, developers, and data professionals to understand business needs and translate them into technical requirements.
• Gather, analyze, document, and validate business and technical requirements.
• Perform data analysis and troubleshooting to identify issues, root causes, and potential solutions.
• Develop and maintain Business Requirements Documents, Technical Design Documents, and Data Lineage Documents.
• Write and execute SQL queries to analyze, validate, and troubleshoot data across enterprise databases.
• Work with Oracle and SQL Server databases; MongoDB experience is a plus.
• Facilitate requirements-gathering sessions, project meetings, working sessions, and stakeholder discussions.
• Collaborate with Agile project teams throughout the development lifecycle, including requirements, refinement, testing, and implementation.
• Identify dependencies, risks, issues, and opportunities related to data and technical requirements.
• Ensure requirements and technical documentation are clear, complete, accurate, and aligned with business objectives.
• Effectively manage multiple priorities and projects while meeting deadlines.

Skills

• Strong technical business analysis skills with the ability to interpret business requirements into detailed technical requirements.
• Strong SQL skills, including experience with Oracle and SQL Server; MongoDB is a plus.
• Strong data analysis and troubleshooting capabilities.
• Excellent requirements documentation and technical writing skills.
• Strong meeting facilitation and stakeholder management skills.
• Ability to multi-task effectively in a fast-paced environment.
• Excellent organizational, analytical, and problem-solving skills.
• Excellent verbal and written communication skills.
• Strong understanding of Agile methodologies and project delivery practices.

Experience

• 4+ years of experience working as a Technical Business Analyst.
• 4+ years of experience working on Agile projects.
• 2-4+ years of SQL experience, preferably with Oracle and SQL Server; MongoDB is a plus.
• 4+ years of experience in data analysis and troubleshooting.
• 4+ years of experience writing Business Requirements, Technical Design, and Data Lineage documentation.
• Demonstrated ability to translate business requirements into technical requirements and actionable solutions.
• Proven experience facilitating meetings and collaborating with diverse business and technical stakeholders.

Education

• Bachelor's degree in Business, Information Technology, Computer Science, or a related field preferred.
• Equivalent combination of education and relevant experience may be considered.

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.