Data Engineer

Austin, TX, US • Posted 6 hours ago • Updated 6 hours ago
Full Time
On-site
USD $108,160.00 - 153,920.00 per year
Company Branding Image
Fitment

Dice Job Match Score™

👾 Reticulating splines...

Job Details

Skills

  • Analytics
  • Systems Analysis
  • IT Management
  • Process Improvement
  • Collaboration
  • Visualization
  • Innovation
  • Accountability
  • Automated Testing
  • Project Implementation
  • Project Lifecycle Management
  • Analytical Skill
  • Reporting
  • Use Cases
  • Relational Databases
  • Oracle
  • ELT
  • Cloud Computing
  • Dimensional Modeling
  • Data Engineering
  • Data Flow
  • Database
  • Verification And Validation
  • Data Quality
  • UPS
  • Data Acquisition
  • Prototyping
  • Mockups
  • Optimization
  • Specification Gathering
  • Process Flow
  • Documentation
  • Data Integration
  • Workflow
  • Extract
  • Transform
  • Load
  • Informatica
  • PL/SQL
  • Adobe Acrobat
  • Informatica PowerCenter
  • Tableau
  • Snow Flake Schema
  • SQL
  • Data Analysis
  • Performance Management
  • Data Warehouse
  • Technical Writing
  • Microsoft Visio
  • ERwin
  • Microsoft Office
  • Microsoft Excel
  • Microsoft PowerPoint
  • PASS
  • Communication
  • Switches
  • Sprint
  • Scrum
  • Performance Metrics
  • Data Visualization
  • Business Intelligence
  • Computer Science
  • Information Systems
  • Health Care
  • Scripting
  • Python
  • JIRA
  • Agile
  • Management
  • Web Services
  • SOAP
  • Java
  • JavaScript
  • Continuous Integration
  • Continuous Delivery
  • GitHub
  • MuleSoft
  • Artificial Intelligence

Summary

Overview

JOB TITLE:

Data Engineer

CAYUSE 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

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 PowerCenter 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 PowerCenter 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 PowerCenter 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 initiatives
  • 8+ years of experience with technical writing and diagramming, including proficiency with tools such as Microsoft Visio, Erwin, and the Microsoft Office Suite (Word, Excel, PowerPoint) and 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 using industry best practices
  • Must be able to pass a background check. May require additional background checks as required by projects and/or clients at any time during employment.

Desired Qualifications:
  • 6+ years of excellent oral and written communication skills demonstrated in technical and business settings
  • 6+ years of experience effectively managing multiple responsibilities, prioritizing conflicting assignments, and context?switching between tasks
  • 4+ years of experience working on an agile sprint team (Scrum or similar)
  • 4+ years of experience applying security principles to sensitive data, including healthcare, PII, and/or PHI
  • 4+ years of experience with modern software components used in performance metrics, data visualization, or business intelligence environments
  • Bachelor's degree in Computer Science, Information Systems, Business, or related field, or equivalent work experience
  • Prior experience in the healthcare industry
  • Prior experience working with PII and/or 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 such as Snowflake Cortex/Snowflake Intelligence and/or Informatica CLAIRE


Our Commitment to you / overview of 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




Reports to: Program Manager

Working Conditions
  • Professional office environment.
  • Ability to work on-site in Austin, TX.
  • Must be physically and mentally able to perform duties extended periods of time.
  • Ability to use a computer and other office productivity tools with sufficient speed to meet the demands of this position.
  • Must be able to establish a productive and professional workspace.
  • Must be able to sit for long periods of time looking at computer screen.
  • May be asked to work a flexible schedule which may include holidays.
  • May be asked to travel for business or professional development purposes.
  • May be asked to work hours outside of normal business hours.


Other Duties: Please note this job description is not designed to cover or contain a comprehensive list of activities, duties or responsibilities that are required of the employee for this job. Duties, responsibilities, and activities may change at any time with or without notice.

Cayuse is an Equal Opportunity Employer. All employment decisions are based on merit, qualifications, skills, and abilities. All qualified applicants will receive consideration for employment in accordance with any applicable federal, state, or local law.

Pay Range

USD $108,160.00 - USD $153,920.00 /Yr.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
  • Dice Id: 91099930
  • Position Id: 104515
  • Posted 6 hours ago

Company Info

About Cayuse Holdings, LLC

Founded initially in 2006, Cayuse Holdings is today comprised of a family companies headquartered near Pendleton, Oregon, with offices in the Washington D.C. metro area, and Honolulu, HI. Tribally owned by the Confederated Tribes of the Umatilla Indian Reservation (CTUIR), Cayuse Holdings is a 100% Indian Owned Economic Enterprise and a foremost provider of responsible sourcing/certified diversity solutions for commercial, government, and tribal clients.

Our Mission

To become the #1 American Indian-owned commercial, government, and tribal contractor, providing trusted value for our clients, reliable and rewarding careers for our employees and contributing to the growth of the CTUIR.

 

Our Vision

Grow the Company, Grow the People!

Šapásttawaxt kutkutpama,́ Šapásttawaxt natítayt

Create job alert
Set job alertNever miss an opportunity! Create an alert based on the job you applied for.

Similar Jobs

Austin, Texas

Today

Full-time

USD 108,160.00 - 153,920.00 per year

Austin, Texas

Today

Full-time

Compensation information provided in the description

No location provided

Today

Full-time

USD 100,000.00 - 110,000.00 per year

No location provided

Today

Full-time

USD 30.00 - 32.77 per hour

Search all similar jobs