Data Warehouse Developer

Role description

Data Warehouse Developer

Lead I - Data Engineering

Who We Are:

Born digital, UST transforms lives through the power of technology. We walk alongside our clients and partners, embedding innovation and agility into everything they do. We help them create transformative experiences and human-centered solutions for a better world.

UST is a mission-driven group of 29,000+ practical problem solvers and creative thinkers in more than 30 countries. Our entrepreneurial teams are empowered to innovate, act nimbly, and create a lasting and sustainable impact for our clients, their customers, and the communities in which we live.

With us, you’ll create a boundless impact that transforms your career - and the lives of people across the world.

Visit us at UST.com.

You Are:

UST is searching for a Data Warehouse Developer to join our Commercial Mortgage Lending technology team. This is a high-performing, Agile team composed of business and technology professionals focused on delivering trusted data solutions and reporting capabilities.

The opportunity:

Data Integration & Development:

Design, develop, maintain, and support ETL/ELT processes using Informatica and related data integration technologies.

Build and optimize data pipelines that extract, transform, and load data from multiple source systems into operational and analytical data stores.

Develop, maintain, and enhance database objects including views, stored procedures, functions, and data integration workflows.

Ensure data accuracy, consistency, and integrity through validation, testing, and monitoring processes.

Data Analysis & Warehousing:

Collaborate with business stakeholders to understand reporting and analytical requirements.

Analyze source system data and translate business requirements into scalable data warehouse solutions.

Support dimensional modeling initiatives utilizing Kimball methodologies and best practices.

Assist in the design and maintenance of data warehouse schemas, structures, and metadata repositories.

Operational Excellence:

Perform ETL/ELT testing, troubleshooting, debugging, and performance tuning activities.

Leverage established enterprise standards, governance practices, and development frameworks.

Implement monitoring, ing, and operational controls to ensure reliable data processing.

Create and maintain technical documentation, data mapping specifications, and process documentation.

Provide guidance and support to junior team members and contribute to knowledge-sharing initiatives.

This position description identifies the responsibilities and tasks typically associated with the performance of the position. Other relevant essential functions may be required.

What you need:

Required:

Bachelor s degree in Computer Science, Information Systems, Data Engineering, or equivalent combination of education and experience.

Required

Informatica PowerCenter, Informatica Cloud (IICS), or equivalent ETL platform

Strong ETL/ELT development experience

Advanced SQL querying and data manipulation skills

Data analysis and data profiling

Kimball dimensional modeling

Relational database concepts and database development

Data validation, testing, and troubleshooting

Technical documentation and data mapping

Preferred:

Erwin Data Modeler or equivalent data modeling tools

SQL Server development and performance tuning

Advanced SQL programming, stored procedures, views, and query optimization

Talend development experience (ETL/Data Integration)

SQL Server Integration Services (SSIS)

Enterprise scheduling tools (Tidal, Control-M, Autosys, or equivalent)

SQL Server Analysis Services (SSAS) or equivalent analytics technologies

Cloud data platforms (Azure, AWS, Snowflake, Databricks)

Visio, Lucidchart, or equivalent diagramming tools

Primary Skills (Must Have):

Informatica PowerCenter / IICS

ETL / ELT Development

Data Warehousing

Data Integration

Data Analysis

Dimensional Modeling (Kimball)

SQL Development

Secondary Skills (Nice to Have)

Erwin Data Modeler

SQL Server

Advanced SQL Programming

Talend

SSIS

Enterprise Scheduling Tools (Control-M, Tidal, Autosys)

Cloud Data Platforms (Azure, AWS, Snowflake, Databricks)

Financial Services / Commercial Lending Domain

Benefits

Employees receive mandatory and non-mandatory benefits such as fourteen (14) days of vacation beginning on the date of hire, vacation premium, ten (10) paid holidays, a Christmas Bonus of thirty (30) days’ pay, Monthly Food Vouchers, Saving Fund, and health insurance. Certain employees may be eligible for additional Company benefits beginning on the date of hire, including dental, disability and life insurance plans; four (4) days of personal time off per year, up to three (3) days of paid medical leave per year, and up to three (3) days of paid bereavement leave per year.

What we believe:

We proudly embrace the values that have shaped UST since day one. We build our culture of Humility, Humanity, and Integrity. These values inspire us to nurture a people-first, human centric culture that fosters diversity, prioritizes sustainable solutions, and keeps our people and clients at the forefront of all decisions.

Humility:

We will listen, learn, be empathetic and help selflessly in our interactions with everyone.

Humanity:

Through business, we will better the lives of those less fortunate than ourselves.

Integrity:

We honor our commitments and act with responsibility in all our relationships.

An Equal Opportunity Workplace, Free of Discrimination and Harassment

Un lugar de trabajo con igualdad de oportunidades y libre de discriminación y acoso

UST reserves the right to periodically redefine your roles and responsibilities based on the requirements of the organization and/or your performance.

#UST

#LI-NF1

#LI-Remote

Skills

data warehousing,informatica powercenter,elt development,data integration,kimball model,sql development,data analytics,advance sql,databricks,talend,ssis development

About UST

UST is a global digital transformation solutions provider. For more than 20 years, UST has worked side by side with the world’s best companies to make a real impact through transformation. Powered by technology, inspired by people and led by purpose, UST partners with their clients from design to operation. With deep domain expertise and a future-proof philosophy, UST embeds innovation and agility into their clients’ organizations. With over 30,000 employees in 30 countries, UST builds for boundless impact - touching billions of lives in the process.