Job Description

:Principal Data EngineerYou will play a pivotal role in leading and delivering complex data engineering solutions with a focus on data analysis, data modeling, and designing ETL processes. As a Principal Data Engineer, you will work with a variety of advanced tools, platforms, and techniques to ensure high-quality data solutions that support the business and its goals.Key Responsibilities:

• Data Engineering & Architecture:

• Design and implement scalable data models and ETL processes to support the company's analytics and reporting needs.
• Work with Data Mesh architecture principles and Data Products to ensure effective data sharing and governance across the organization.
• Lead the development of end-to-end data solutions using Azure Synapse, Azure SQL Database, SSAS, Power Query/DAX, Microsoft Fabric, and Power BI.
• Develop data solutions in Azure, leveraging Data Lakes, Data Warehouses, and Azure Data Factory to deliver robust data pipelines.
• Technical Expertise:

• Expert in T-SQL, with strong performance tuning skills for handling large volumes of data.
• Design and implement solutions using Snowflake and open-source frameworks, while ensuring multi-cloud infrastructure support.
• Proficiency in understanding and applying enterprise big data architecture concepts.
• Experience in implementing Power Platform solutions (Power Automate, Power Apps) is a plus.
• Security & Data Governance:

• Design and implement security models within the data estate to ensure compliance and protect sensitive information.
• Maintain and promote high standards of Data Quality, adopting approaches such as shift-left strategies to ensure data integrity from the beginning of the development lifecycle.
• Collaboration & Leadership:

• Collaborate with cross-functional teams to gather requirements and translate them into efficient data engineering solutions.
• Lead the full Software Development Lifecycle (SDLC), including the use of Azure DevOps, GitHub for continuous integration and deployment, and Visual Studio (SSDT).
• Provide mentorship and guidance to junior team members, fostering a culture of knowledge sharing and skill development.
• Business & Financial Services Knowledge:

• Bring a strong understanding of the financial investment services domain to design and implement data solutions aligned with business needs.
• Experience working in the financial industry is highly beneficial.
• Agile Practices:

• Work in an Agile environment, ensuring timely and high-quality delivery of data solutions that meet business requirements.

Qualifications:

• Proven experience as a Data Engineer or in a similar role, with experience in data engineering and analytics.
• Expertise in T-SQL, performance tuning, and working with large data volumes.
• Strong knowledge of Azure Synapse, Azure SQL Database, SSAS, Power BI, Power Query/DAX, and Microsoft Fabric.
• Experience in Data Lakes, Data Warehouses, and Azure Data Factory.
• Familiarity with Snowflake, open-source frameworks, and multi-cloud infrastructure.
• Experience with Power Platform (Power Automate, Power Apps) is a plus.
• Solid understanding of Data Mesh, Data Products, and enterprise big data architectures.
• Experience with SDLC, Azure DevOps, GitHub, and Visual Studio (SSDT).
• Strong business acumen, particularly in the financial investment services industry.
• Experience in Agile methodologies.
• Excellent attention to detail, with the ability to balance the bigger picture and strategic vision.
• Strong communication skills, able to engage with non-technical and senior stakeholders effectively.
• Ability to adapt to changing environments and proactively contribute to team growth and knowledge sharing.

Skills:

• Data Modeling & ETL Development
• Performance Tuning in T-SQL
• Azure Ecosystem (Azure Synapse, SQL Database, Power BI)
• Data Mesh & Data Products
• Snowflake & Open Source Frameworks
• Data Security & Governance
• Power Platform (Power Automate, Power Apps)
• Agile Methodologies
• SDLC & DevOps Tools (Azure DevOps, GitHub, Visual Studio)

Personality Traits:

• Personable, credible, and able to build strong relationships with both technical and non-technical stakeholders.
• Strong leadership and mentorship abilities, with a passion for helping others grow and succeed.
• Open-minded, proactive, and eager to contribute to a collaborative team environment.
• Excellent problem-solving skills with the ability to think strategically while focusing on execution.

Skills:Microsoft Azure,adf,sqlAbout Company:UST is a global digital transformation solutions provider. For more than 20 years, UST has worked side by side with the worldxe2x80x99s 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 clientsxe2x80x99 organizations. With over 30,000 employees in 30 countries, UST builds for boundless impactxe2x80x94touching billions of lives in the process.

UST