Data Warehouse Data Engineer

Data Warehouse Data Engineer

Job Summary

We are seeking a skilled and experienced Data Warehouse Data Engineer to join our Enterprise Data Warehousing team at UFCU. The ideal candidate will be responsible for designing, implementing, and maintaining our data warehouse solutions, ensuring optimal performance, reliability, and scalability for our business and analytics teams. This role requires a strong background in data warehousing concepts, ETL processes, data governance, and collaboration, along with excellent problem-solving and analytical skills.

About UFCU

Founded in 1936, UFCU has grown to serve Members across Texas and beyond.  At UFCU, we are more than just a financial institution, and our people are more than just employees. We are dedicated to our purpose of empowering our Members to achieve financial success and build brighter futures.

In pursuit of our aspiration that UFCU is loved by millions of Members and built to thrive for generations, we are guided by our values:

Purposefully Member-Obsessed

We are driven by a profound sense of empathy to deeply understand our Members’ needs and preferences, what brighter futures means to them, and the obstacles in their way. We act in our Members’ best interests, forever seeking to empower their financial success.

Possibilities Reimagined

We are inspired to courageously experiment, learn, and iterate in pursuit of positive impact for our Members, UFCU, and coworkers. We challenge assumptions, embrace diverse perspectives, and make use of data and insights.

Performance Excellence Rooted in Unwavering Integrity

We do the right thing, always. We champion teamwork, accountability, continuous improvement, and celebrate successful outcomes of others, fostering an inclusive environment of excellence and collaboration.

ESSENTIAL DUTIES AND RESPONSIBILITIES

• Data Warehouse Design and Development: Design, develop, and maintain data warehouse solutions that meet business requirements and support data-driven decision-making.
• ETL Process Implementation: Develop and manage ETL (Extract, Transform, Load) processes to ensure accurate and timely data integration from various sources into the data warehouse.
• Data Modeling: Create and maintain logical and physical data models to support data warehouse solutions, ensuring data integrity, consistency, and accuracy.
• Performance Optimization: Monitor and optimize data warehouse performance, including query optimization, indexing, and partitioning strategies to ensure efficient data retrieval and processing.
• Data Quality Assurance: Implement and monitor data quality checks and validation processes to ensure adherence to defined SLA’s.
• Collaboration and Communication: 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.
• Documentation and Reporting: 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.
• 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.

Minimum Qualifications

• Bachelor's degree in Computer Science, Information Technology, or a related field.
• Minimum of 3-5 years of experience in data warehousing, database management, or a related role.
• Strong proficiency in SQL and experience with database management systems (e.g., Oracle, SQL Server, MySQL, PostgreSQL).
• 2-4 years of hands-on experience with ETL tools and processes (e.g., Informatica, Talend, SSIS, Azure Data Factory).
• Knowledge of data modeling techniques and tools (e.g., ERwin, Toad Data Modeler).
• 2-4 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.
• 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.

Preferred Qualifications

• Experience in the financial services or credit union industry.
• Hands-on experience using Denodo.

• Proficiency in programming languages such as Python, C#.