Senior Data Engineer

UFCU • Austin, TX

15h • Hybrid

About The Position

The Senior Data Warehouse Data Engineer will develop, implement and maintain data platform solutions, ensuring optimal performance, reliability, and scalability for business and analytics teams. This role requires a strong background in data warehousing and data lakes, ETL processes, data pipelines, data governance, and collaboration, along with excellent problem-solving and analytical skills. The Senior Data Warehouse Data Engineer is an exempt position and reports to the Manager, Data Warehouse and will be a part of the Enterprise Data Platform team at UFCU.

Requirements

• Experience building data products for use by AI/ML
• Knowledge of data modeling techniques and tools (e.g., ERwin, Toad Data Modeler).
• Excellent communication and collaboration skills, with the ability to work effectively with cross-functional teams.
• Attention to detail and a commitment to data quality and accuracy.
• Ability to manage multiple priorities and work in a fast-paced, agile, dynamic environment.
• Bachelor's degree in Computer Science, Information Technology, or a related field or equivalent years of experience.
• Minimum of 5-7 years of experience in data warehousing, database management, or a related role.
• Minimum of 2-3 years of hands-on experience using Databricks.
• Strong proficiency in SQL and experience with database management systems (e.g., Oracle, SQL Server, MySQL, PostgreSQL).
• 5-7 years of hands-on experience with ETL tools and processes (e.g., Informatica, Talend, SSIS, Azure Data Factory).
• 5-7 years of hands-on experience with data warehousing concepts and best practices, and dimensional modeling.
• Experience with data integration from various sources, including structured and unstructured data, batch, and real-time.
• Experience building business and reporting views in a semantic layer.
• Must be bondable

Nice To Haves

• Experience in the financial services or credit union industry.
• Proficiency in programming languages such as Python, C#.

Responsibilities

• Design, develop, and maintain data warehouse solutions that meet business requirements and support data-driven decision-making.
• Develop and manage ETL (Extract, Transform, Load) pipelines and processes to ensure accurate and timely data integration from various sources into the data warehouse.
• Create and maintain logical and physical data models to support data warehouse solutions, ensuring data integrity, consistency, and accuracy.
• Monitor and optimize data warehouse performance, including query optimization, indexing, and partitioning strategies to ensure efficient data retrieval and processing.
• Implement and monitor data quality checks and validation processes to ensure adherence to defined SLAs.
• Work closely with business stakeholders, data analysts, and other IT teams to understand data requirements, common pain points, evaluate their common needs, and finally turn them into internal warehouse tables or data services.
• Create and maintain comprehensive documentation of data warehouse architecture, processes, and procedures, and provide regular status reports to management.
• Collaborate with cross-functional teams to define and execute data strategies that leverage virtualization and fabric concepts to enhance data agility and support evolving business needs.
• Work directly with our Analytics and Data Science teams to define requirements and troubleshoot technical data issues in the Data Platform or Data Mappings/Pipelines.
• Design and implement data virtualization solutions to provide seamless data access and integration across diverse data sources. Ensure that data is easily accessible, governed, and secure, while enabling real-time data processing and analytics.
• Participate in on-call support rotation.

Benefits

• The physical demands described are representative of those that must be met by an employee, with or without accommodation, to successfully perform the essential functions of this job. Reasonable accommodation may be made to enable individuals with disabilities to perform the essential functions.
• Employee will make extensive use of the telephone and virtual communications requiring the ability to explain complex information effectively and accurately.
• This position requires frequently working onsite at UFCU Plaza in Austin, Texas. Expectations for this hybrid role are on average, 50% in office time.
• This position may involve periodic stressful conditions.
• May occasionally require an adjusted work schedule, overtime, and evening/weekend hours.
• May occasionally move from one work location/branch to another.
• Public contact position, requiring appropriate professional appearance.
• Frequent computer use at a workstation of up to two hours at a time.
• The noise level in the work environment is usually moderate.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Education Level: Associate degree