Data Engineer

Overview

Company: Cayuse Civil Services, LLC

Location: Hybrid in Austin, TX

Salary: $ - $

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.

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.

• 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 Power Center 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.

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 Power Center 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.

• 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…