Role description
IM Senior Data Warehouse Developer
Lead I - Data Science
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 looking for an IM Senior Data Warehouse Developer who will create and support the ETL process to extract the data from source systems and place it into the data warehouse.
The opportunity:
Performs data warehouse design and testing, including data design, database architecture, metadata, and repository creation.
Designs, develops, and maintains relational databases for data storage and data mining.
Works with business and IT stakeholders to optimize reporting information by defining business requirements and populating the data warehouse table structure.
Creates data warehouse schematics and layouts; assists with developing capacity planning.
Recommends improvements and applies standards, processes, and procedures for data warehousing systems.
Seeks continuous data warehouse performance improvement and ensures security of data.
Creates and implements effective metrics and monitoring processes.
May lead small projects with manageable risks and resource requirements.
Acts as a resource and impacts the quality of work for colleagues with less experience.
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:
4+ years Data Warehouse or relevant experience
Experience in Kimball dimensional modeling
4+ years ETL, database, and scheduling experience
Demonstrated ability to quickly learn new technologies.
1+ years of Data Analysis experience
Advanced ability to solve complex problems, drawing upon creativity, experience, and multiple sources of information.
Advanced interpersonal skills, including the ability to build consensus.
Advanced communication skills, including the ability to communicate complex information in straightforward manner.
Regular and predictable attendance
Bachelor's degree or equivalent education/ experience
Preferred:
Insurance and/or reinsurance industry knowledge
Master's degree and/or LOMA certification
Experience as an ETL team lead
Required:
Informatica Power Center & Data Validation Option
Enterprise Scheduler (Tidal preferred)
Erwin Data Modeler
Database technologies (one or more of the following)
Oracle SQL & PL/SQL
Vertica
Preferred:
Talend
Tidal Enterprise Scheduler
SQL Server
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:
At UST, we strive to provide a work environment free of discrimination and harassment. We are an equal opportunity employer and employment decisions are based on merit and business needs. Our Human Rights Policy further illustrates our stand on this. We are committed to following fair employment practices that provide equal opportunities to all employees. We do not discriminate or allow harassment on the basis of race, color, religion, disability, gender, national origin, sexual orientation, gender identity, gender expression, age, genetic information, military status, or any other legally protected status. At UST, we value diversity and believe that a diverse workplace builds a competitive advantage.
UST reserves the right to periodically redefine your roles and responsibilities based on the requirements of the organization and/or your performance.
#UST
#LI-MO1
#LI-Remote
Skills
Data Warehousing, ETL, Data Analysis
#J-18808-Ljbffr