"Alerted.org

CTG is seeking to fill a Systems Analyst 3 opening for our client in Austin, TX.

**Location:** Austin, TX (hybrid remote)

Duties:

+ Analyze and understand business objectives and technical problems; identify and evaluate alternative solutions

+ Review user requirements and operational procedures to automate or improve existing systems

+ Conduct cost/benefit analyses and prepare detailed documentation on system functionality and technical processes

+ Collaborate with personnel across business units to determine data input needs, reporting formats, and processing specifications

+ Support implementation and configuration of infrastructure and development tools for a data integration hub

+ Develop and enhance SQL scripts, Oracle views, and materialized views to support a dimensional data model

+ Automate data acquisition and transformation processes using Informatica IICS, IDMC, or Power Center

+ Ensure proper validation and verification of ETL pipelines, SQL code, and output datasets

+ Work in an Agile development environment, actively participating in sprint planning, reviews, and retrospectives

+ Enhance and maintain a Java-based web interface for Tableau dashboards

+ Design mockups and validate with stakeholders

+ Collaborate on data design strategies, testing, and continuous enhancement of analytics and reporting capabilities

+ Produce technical specifications, diagrams, and documentation to support development and operational teams

+ Address technical issues and contribute to continuous improvement of development and testing processes

+ Perform other duties as assigned

Skills:

+ Proficient in Informatica (IICS, IDMC, or Power Center) for ETL development and automation

+ Strong experience in SQL development for high-performance, complex queries

+ Skilled in integrating data from multiple sources, including Oracle, SQL Server, Snowflake, Excel, Access, and PDF formats

+ Solid understanding of data warehousing, analytics, and performance management systems

+ Strong technical writing, diagramming, and modeling skills (e.g., Visio, Erwin)

+ Experience in Python scripting for automation and testing

+ Deep knowledge of defect tracking, test planning, execution, and documentation

+ Familiarity with Agile methodologies and tools

+ Excellent attention to detail, multitasking, and time management skills

+ High standards of confidentiality and discretion with sensitive information

Experience:

+ 8+ years in Informatica-based ETL development and automation

+ 8+ years acquiring/integrating data from diverse sources for Tableau use

+ 8+ years developing optimized SQL queries

+ 8+ years as a data analyst or in data engineering roles related to warehousing or analytics

+ 8+ years of technical documentation and modeling experience

+ 8+ years developing Python-based automation tools

+ 8+ years of quality assurance, including test case design and defect management

+ 4+ years improving automation frameworks and enhancing test coverage (Preferred)

+ 2+ years working with AI platforms or validating AI-enabled tools (Preferred)

+ 2+ years with testing and observability infrastructure at scale (Preferred)

Education:

+ Bachelor’s degree in Computer Science, Information Systems, or a related field. Equivalent 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.

To Apply:

To be considered, please apply directly to this requisition using the link provided. For additional information, please contact **JoAnn Abramo at [email protected]** . Kindly forward this to any other interested parties. Thank you!

About CTG

CTG, a Cegeka company, is at the forefront of digital transformation, providing IT and business solutions that accelerate project momentum and deliver desired value. Over nearly 60 years, we have earned a reputation as a faster and more reliable, results-driven partner. Our vision is to be an indispensable partner to our clients and the preferred career destination for digital and technology experts. CTG leverages the expertise of over 9,000 team members in 19 countries to provide innovative solutions. Together, we operate across the Americas, Europe, and India, working in close cooperation with over 3,000 clients in many of today's highest-growth industries. For more information, visit www.ctg.com .

Our culture is a direct result of the people who work at CTG, the values we hold, and the actions we take. In other words, our people define our culture. It's a living, breathing thing that is renewed every day through the ways we engage with each other, our clients, and our communities. Part of our mission is to cultivate a workplace that attracts and develops the best people, reflected by our recognition as a Great Place to Work Certified™ company across many of our global operations.

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.