Project Description:
- We are seeking a highly skilled and experienced Data Engineer to join our Data & Analytics team. The ideal candidate will have a strong background in Snowflake SQL, investment reporting data, and financial knowledge related to investment management. As a Data Engineer, you will play a critical role in designing, implementing, and maintaining our data infrastructure to support investment reporting and analytics.
Responsibilities
:Data Infrastructure Development
- :Design, implement, and maintain scalable and efficient data pipelines using Snowflake and SQL
- .Develop data models, ETL processes, and data integration workflows to ensure high data quality and reliability
- .Optimize data storage and retrieval performance in Snowflake
.
Data Manipulation and Transformatio
- n:Perform complex data manipulation and transformation using SQL to prepare data for analysis and reportin
- g.Implement data cleansing, aggregation, and enrichment processes to ensure data accuracy and consistenc
- y.Develop and maintain reusable SQL scripts and stored procedures for data processin
g.
Collaboration and Suppo
- rt:Collaborate with data analysts and other stakeholders to understand data requirements and deliver solutions that meet their nee
- ds.Provide technical guidance and mentorship to junior data engineers and other team membe
- rs.Work closely with IT and DevOps teams to ensure seamless data integration and deployme
nt.
Data Layer Preparat
- ion:Design and build data layers to support various analytical and reporting ne
- eds.Ensure data layers are well-documented, easily accessible, and perform
- ant.Implement data governance and security best practices to protect sensitive informat
- ion.Performance Tuning and Optimizat
ion:
Monitor and optimize the performance of data pipelines, databases, and que
- ries.Identify and resolve performance bottlenecks to ensure timely and efficient data proces
- sing.Stay up-to-date with the latest trends and best practices in data engineering and apply them to improve our data infrastruc
ture.
Mandatory Skills Descri
- ption:Bachelor's degree in Computer Science, Information Technology, Engineering, or a related
- fieldMinimum of 1-2 years of experience in data engineering, with a strong focus on SQL and data manipul
- ation.Proven experience working with Snowflake or other cloud-based data warehousing solu
- tions.Experience with T
- ableauStrong background in designing data model and building scalable data pipelines and data m
- odels.Solid understanding of financial instruments, investment operations, investment reporting and portfolio management con
- cepts.Knowledge of investment performance measurement, risk analysis, and portfolio management co
- nceptsExpert-level proficiency in SQL, with the ability to write complex queries and optimize them for perfor
- mance.Strong experience with ETL tools and proc
- esses.Familiarity with T
- ableauKnowledge of data governance, security, and compliance best prac
- tices.Excellent problem-solving and analytical s
- kills.Strong communication and collaboration s
kills.
Nice-to-Have Skills Descr
- iption:Familiarity with Qlikview, Ql
- iksenseFamiliarity with programming languages such as
Python.
