Data Engineer

Overview

JOB TITLE:

Data Engineer

CAYUSE 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.

The Work

The Data Engineer 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 Data Engineer 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, ensuring timely and successful project execution in hybrid work environments.

Responsibilities

• Guide an agile development team through the full project lifecycle.
• Designing and implementing data acquisition pipelines from a variety of data sources and technologies for multiple analytic and reporting use cases.
• Developing complex SQL scripts (including Snowflake SQL) to transform source data into a dimensional model, and creating views and materialized views in relational databases (e.g., Oracle).
• Developing automated ETL/ELT processes using Informatica Power Center and/or Informatica Intelligent Cloud Services (IICS) to pull data from external sources and transform it into a dimensional model.
• Collaborating with other members of the Data Engineering team on the design, implementation, and optimization of data models and data flows.
• Verifying and validating SQL scripts, Informatica automation, database views, and related integration components.
• Designing and developing automated verification and validation processes to ensure data quality and integrity.
• Participating fully in agile ceremonies (e.g., sprint planning, daily stand-ups, backlog refinement, sprint reviews, and retrospectives).
• Working closely with architects and other engineering team members on implementation designs, data acquisition strategies, and technical solution patterns.
• Developing prototypes and mockups and working directly with business and technical stakeholders to validate requirements and solution approaches.
• Collaborating with team members to investigate, troubleshoot, and resolve technical issues in a timely manner.
• Assisting with the implementation, configuration, and optimization of development tools and environments (e.g., code repositories, CI/CD pipelines, work management tools).
• Producing and maintaining technical specifications, diagrams, data models, process flows, and other documentation required to support DD&I efforts.
• Participating in requirements and design sessions with stakeholders to ensure technical solutions meet business needs.
• Interpreting new and evolving business requirements, assessing their impact on the existing data integration hub, and proposing enhancements and changes to meet these requirements.
• Other duties as assigned.

Qualifications

Here's What You Need

The qualifications and skills listed below are intended to provide a general overview of the requirements for this position. However, due to the anticipated nature of the contract and the absence of a finalized task order from the client, this list should not be considered all-encompassing. Additional qualifications, certifications, skills, or experience specific to the client's requirements may be identified and requested upon award of the task order.

Candidates should demonstrate flexibility and a willingness to adapt to evolving responsibilities as outlined by the client.

• 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 data sources/technologies (Oracle, SQL Server, Excel, Access, Adobe PDF, etc.) using Informatica Power Center or IICS for consumption by data visualization tools (e.g., 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…