Data Engineer (Contractor)

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 ResponsibilitiesDesign, develop, enhance, and support data integration workflows and ETL processesBuild and maintain mappings, workflows, and related components using Informatica PowerCenter and/or IICSDevelop and optimize complex SQL queries, stored logic, views, and materialized views in Snowflake and Oracle environmentsPerform systems analysis for data analytics, reporting, and performance management initiativesIntegrate data from multiple sources, including Oracle, SQL Server, Excel, Access, and Adobe PDFSupport data warehouse and analytics solutions through data modeling, validation, testing, and troubleshootingCreate technical documentation, process flows, diagrams, and system specifications using tools such as Visio and ErwinParticipate in Agile ceremonies and work closely with cross-functional business and technical teamsWrite efficient, maintainable, and testable code aligned with best practicesSupport platform planning, implementation, and ongoing improvement effortsQualificationsRequired:8+ years of experience with Informatica PowerCenter and/or Informatica Intelligent Cloud Services (IICS) for ETL development8+ years of experience integrating data from multiple structured and unstructured sources8+ years of experience writing complex SQL, including strong experience in Snowflake8+ years of experience in systems analysis supporting data analytics, performance management, or data warehouse initiatives8+ years of experience with technical documentation, diagramming, and productivity tools such as Visio, Erwin, Microsoft Office, and MS Project8+ years of experience planning and delivering software or data platforms across multiple teams or business unitsStrong understanding of ETL best practices, data validation, and testing methodologiesPreferred Qualifications:Experience working in an Agile environmentPrior experience supporting state, local, education, or healthcare clientsExperience working with PII/PHI and sensitive data environmentsExperience with Python scriptingExperience with JIRAFamiliarity with REST and SOAP web servicesExposure to Java or JavaScriptExperience with GitHub, GitHub Actions, or CI/CD pipelinesExperience with MuleSoftFamiliarity with AI-enabled data tools such as Snowflake Cortex or Informatica ClaireWork Location:Hybrid roleAustin, Texas3 days onsite / 2 days remoteCandidates must be local to the Austin areaAdditional InformationAll your information will be kept confidential according to EEO guidelines.All your information will be kept confidential according to EEO guidelines.