Company DescriptionBig challenges need bold thinkers.If you're someone who sees problems as opportunities, you'll thrive here.
RESPEC is 100% employee-owned, which means we take ownership of every challenge. Here, your ideas drive real solutions. Since 1969, we've tackled complex challenges in energy transition, infrastructure resilience, digital transformation, and sustainability.
At RESPEC, you'll work alongside clients to take on critical problems. Depending on your expertise, you might design infrastructure in remote locations, develop renewable energy solutions for global projects, or apply data-driven technology to improve mining and water systems.
We bring deep technical knowledge, real-world experience, and a commitment to work that matters. If you're looking for a place where your contributions have real impact, you'll fit right in.
We do not accept unsolicited resumes from third-party recruiters.Job DescriptionRESPEC is seeking a Systems Analyst 3 / Data Engineer to support a local SLED client in the Austin, Texas area. This is a hands-on technical role for a senior-level professional with strong experience in data integration, ETL development, Snowflake SQL, and analytics platform support.
This opportunity is ideal for someone with a background in data engineering, ETL development, data warehousing, and systems analysis who is comfortable working across multiple data sources and collaborating in an Agile environment.
Key Responsibilities- Design, develop, enhance, and support data integration workflows and ETL processes
- Build and maintain mappings, workflows, and related components using Informatica PowerCenter and/or IICS
- Develop and optimize complex SQL queries, stored logic, views, and materialized views in Snowflake and Oracle environments
- Perform systems analysis for data analytics, reporting, and performance management initiatives
- Integrate data from multiple sources, including Oracle, SQL Server, Excel, Access, and Adobe PDF
- Support data warehouse and analytics solutions through data modeling, validation, testing, and troubleshooting
- Create technical documentation, process flows, diagrams, and system specifications using tools such as Visio and Erwin
- Participate in Agile ceremonies and work closely with cross-functional business and technical teams
- Write efficient, maintainable, and testable code aligned with best practices
- Support platform planning, implementation, and ongoing improvement efforts
QualificationsRequired:- 8+ years of experience with Informatica PowerCenter and/or Informatica Intelligent Cloud Services (IICS) for ETL development
- 8+ years of experience integrating data from multiple structured and unstructured sources
- 8+ years of experience writing complex SQL, including strong experience in Snowflake
- 8+ years of experience in systems analysis supporting data analytics, performance management, or data warehouse initiatives
- 8+ years of experience with technical documentation, diagramming, and productivity tools such as Visio, Erwin, Microsoft Office, and MS Project
- 8+ years of experience planning and delivering software or data platforms across multiple teams or business units
- Strong understanding of ETL best practices, data validation, and testing methodologies
Preferred Qualifications:- Experience working in an Agile environment
- Prior experience supporting state, local, education, or healthcare clients
- Experience working with PII/PHI and sensitive data environments
- Experience with Python scripting
- Experience with JIRA
- Familiarity with REST and SOAP web services
- Exposure to Java or JavaScript
- Experience with GitHub, GitHub Actions, or CI/CD pipelines
- Experience with MuleSoft
- Familiarity with AI-enabled data tools such as Snowflake Cortex or Informatica Claire
Work Location:- Hybrid role
- Austin, Texas
- 3 days onsite / 2 days remote
- Candidates must be local to the Austin area
Additional InformationAll your information will be kept confidential according to EEO guidelines.
All your information will be kept confidential according to EEO guidelines.
Never miss an opportunity! Create an alert based on the job you applied for.
