Data Engineer

Overview Company: Cayuse Civil Services, LLC Location: Hybrid in Austin, TX Salary: $108,160.00 - $153,920.00 Employee Type: Full-Time Salary Exempt Travel: No Relocation: No Employment in this role is conditional upon successful execution of the contract by the client. The Work We are seeking a professional to support the design, development, and operation of an enterprise data integration and analytics environment. This role combines advanced data engineering, systems analysis, and technical leadership to enable reliable, scalable, and high-quality data solutions. The successful candidate will: Translate complex business objectives and analytical needs into technical requirements and data solutions. Analyze user requirements, operational procedures, and existing systems to identify opportunities for automation, process improvement, and enhanced data integration. Collaborate with stakeholders across multiple business and technical units to define data inputs, data transformation rules, and reporting/visualization outputs. Produce detailed technical specifications and documentation describing user needs, system and program functionality, and steps required to develop or modify data integration components and applications. Evaluate existing system capabilities, constraints, and schedules to determine the feasibility and optimal approach for requested changes and new development. This position aligns with Cayuse's core values of excellence, innovation, and accountability by delivering high-quality, efficient, and scalable automated testing solutions. Responsibilities Guide an agile development team through the full project lifecycle. Design and implement data acquisition pipelines from a variety of data sources and technologies. Develop complex SQL scripts (including Snowflake SQL) to transform source data into a dimensional model, and create views and materialized views in relational databases (e.g., Oracle). Develop automated ETL/ELT processes using Informatica PowerCenter and/or Informatica Intelligent Cloud Services (IICS). Collaborate on the design, implementation, and optimization of data models and data flows. Verify and validate SQL scripts, Informatica automation, database views, and related integration components. Design and develop automated verification and validation processes to ensure data quality and integrity. Participate fully in agile ceremonies (e.g., sprint planning, daily stand-ups, backlog refinement, sprint reviews, and retrospectives). Work closely with architects and other engineering team members on implementation designs, data acquisition strategies, and technical solution patterns. Develop prototypes and mockups to validate requirements and solution approaches. Investigate, troubleshoot, and resolve technical issues in a timely manner. Assist with the implementation, configuration, and optimization of development tools and environments (e.g., code repositories, CI/CD pipelines, work management tools). Produce and maintain technical specifications, diagrams, data models, process flows, and other documentation. Interpret new and evolving business requirements and propose enhancements to the data integration hub. Qualifications Note: Due to the anticipated nature of the contract, this list is not all-encompassing. Additional qualifications may be identified upon award of the task order. 8 years of experience developing mappings and workflows to automate ETL processes using Informatica PowerCenter and/or Informatica IICS. 8 years of experience acquiring and integrating data from multiple sources (Oracle, SQL Server, Excel, Access, Adobe PDF, etc.) for consumption by visualization tools like Tableau. 8 years of experience designing and developing complex, high-performance Snowflake SQL scripts. 8 years of experience as a systems analyst supporting data analytics, performance management, or data warehousing initiatives. 8 years of experience with technical writing and diagramming (Microsoft Visio, Erwin, MS Office Suite, MS Project). 8 years of experience planning and delivering software platforms used across multiple products and organizational units. Proven ability to write well-designed, testable, and efficient code. Must be able to pass a background check. Desired Qualifications 6 years of excellent oral and written communication skills. 6 years of experience managing multiple responsibilities and prioritizing assignments. 4 years of experience working on an agile sprint team (Scrum or similar). 4 years of experience applying security principles to sensitive data (healthcare, PII, and/or PHI). 4 years of experience with modern software components used in performance metrics, data visualization, or business intelligence. Bachelor's degree in Computer Science, Information Systems, Business, or related field, or equivalent work experience. Prior experience in the healthcare industry and working with PII/PHI in a regulated environment. 4 years of experience designing and developing scripts using Python. 4 years of experience using JIRA or similar agile work management tools. 2 years of functional knowledge or hands-on experience with web services (REST, SOAP, etc.). 2 years of experience designing and developing code using Java and JavaScript. 2 years of experience developing CI/CD pipelines using GitHub, GitHub Actions, or similar tools. 2 years of experience as a MuleSoft developer or integrating with MuleSoft APIs. 2 years of experience using AI-enabled data and integration tools (Snowflake Cortex/Intelligence, Informatica CLAIRE). Benefits Medical, Dental and Vision Insurance; Wellness Program Flexible Spending Accounts (Healthcare, Dependent Care, Commuter) Short-Term and Long-Term Disability options Basic Life and AD&D Insurance (Company Provided) Voluntary Life and AD&D options 401(k) Retirement Savings Plan with matching after one year Paid Time Off Working Conditions Professional office environment. Ability to work on-site in Austin, TX. Must be physically and mentally able to perform duties for extended periods. May be asked to work a flexible schedule, including holidays or hours outside of normal business hours. May be asked to travel for business or professional development purposes. Cayuse is an Equal Opportunity Employer. #J-18808-Ljbffr