We're looking for a Data Engineer to join our team and help build, maintain, and optimize data integration solutions that support critical business operations. This role is intentionally flexible and may be filled at either the mid or senior level based on the selected candidate's experience, technical expertise, and ability to contribute. The ideal candidate has a strong foundation in SQL, data integration, and API-based development, with experience designing and supporting ETL/ELT processes across multiple systems.
Responsibilities
● Design, develop, and maintain scalable ETL/ELT pipelines.
● Build and support integrations between internal systems and third-party applications.
● Write, optimize, and troubleshoot complex PostgreSQL queries and database objects.
● Ensure data quality, integrity, and reliability across integrations.
● Monitor, troubleshoot, and optimize existing data pipelines.
● Develop and maintain REST API integrations.
● Create and maintain data workflows using SnapLogic.
● Collaborate with business stakeholders, analysts, and application teams to understand
reporting and integration requirements.
● Document data flows, integration processes, and technical solutions.
● Participate in code reviews and contribute to best practices for data engineering.
● Expand data warehouse and analytics capabilities
● Transform program data for use in reporting warehouse
● Monitor emails from automation and handle errors when they happen
● Monitor server performance
● Identify poorly designed queries that can be optimized.
● Analyze refresh cycles that take too long and implement optimizations to reduce
execution time.
● Support database upgrades
● Prioritize tasks in work queue
● Manage and implement the necessary automation to ensure the data warehouse is kept
up to date, including daily, hourly, and real-time data updates.
● Work with external vendors for regulatory (FCC) reporting
Experience/Qualifications
● Bachelor’s degree in Computer Science, Data Science, IT, or a related field
● 5-9 years of hands-on data engineering experience
● Strong SQL skills
● PostgreSQL experience
● Strong database design skills.
● Strong query optimization skills
● Basic Linux/MacOS script skills
● Working knowledge of GIT
● Working knowledge of AWS
● Experience with python preferred
Similar Jobs
What you need to know about the Austin Tech Scene
Key Facts About Austin Tech
- Number of Tech Workers: 180,500; 13.7% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Dell, IBM, AMD, Apple, Alphabet
- Key Industries: Artificial intelligence, hardware, cloud computing, software, healthtech
- Funding Landscape: $4.5 billion in VC funding in 2024 (Pitchbook)
- Notable Investors: Live Oak Ventures, Austin Ventures, Hinge Capital, Gigafund, KdT Ventures, Next Coast Ventures, Silverton Partners
- Research Centers and Universities: University of Texas, Southwestern University, Texas State University, Center for Complex Quantum Systems, Oden Institute for Computational Engineering and Sciences, Texas Advanced Computing Center
