Technical Data Analyst (SQL)
Core
Maintaining investment data for clients by analyzing raw data, building data systems and pipelines, and presenting insights through visualization.
Role type
Technical Data Analyst (SQL)
Builds
Data systems, pipelines, and analytical tools for investment data
Domain
Finance / Investment Data
Deliverable
dashboards & analysis
Required skills
SQL, NoSQL, data pipeline construction, data visualization, data cleansing, cloud platforms (AWS/GCP/Azure), database design, data governance, Python/Java/VBA
Preferred skills
Investment data domain knowledge, dbt/Prophecy
Technologies
SQL, NoSQL, AWS, GCP, Azure, Tableau, Power BI, D3.js, dbt, Prophecy, Java, Python, VBA
Responsibilities
Analyze and organize raw investment data into valuable insights; Build efficient data systems and pipelines; Conduct complex data analysis and deliver reports; Create data visualizations; Merge data from multiple sources; Improve data quality and reliability; Develop analytical tools for data-driven decisions.
Seniority
Mid-level, hands-on IC