Solutions Consultant - Data Management
Alpha Financial Markets Consulting, North America
In your role as a Solutions Consultant, you will
- Build data pipelines and applications to stream and process financial datasets.
- Lead data modelling activities to capture and model data requirements, business rules, and logical and physical models to support reporting solutions and downstream processes
- Define, build and publish reporting capabilities in leading BI/reporting tools, such as Tableau and Power BI.
- Design, code, and tune ETL pipelines using Boomi, Talend, Informatica or similar technologies.
- Data profiling and source-to-target mapping (including complex business rules)
- Apply modern data management toolsets and methods to design, build, implement, and optimize data solutions of all types including data warehouses, data pipelines, data cleansing.
- Define and socialise technical approaches for SDLC, data migration, integrations and reporting supported by a Solution Architect, the client and project management team.
- Analyze, review and document business, functional, and technical requirements.
- Drive the documentation and development according to specifications and standards.
- Participate in project team meetings and communicate effectively with internal and client peers, architects, system analysts, business analysts, project managers, quality control, and across other technology team boundaries, reporting project status as required.
- Support Alpha’s internal product/accelerator development for future client projects.
- Mentor and coach junior team members.
Role Requirements (Skills, Experience and Qualifications)
- 2-5 years of experience in data analysis & modelling, reporting, architecture roles, including experience with transformational efforts.
- Experience in the Asset & Wealth Management industry.
- Experience in data mining, profiling, and analysis.
- Experience with complex data modelling, ETL design (AWS Glue, Talend, Azure Data Factory), and using large databases in a business environment.
- Experience with deploying compute and orchestrating workloads directly in Azure or AWS, or platforms such as Databricks.
- Knowledge of data warehousing concepts and experience with cloud data platforms like Snowflake, Azure Synapse or AWS Redshift.
- Experience with object-oriented programming (OOP) languages like Python, Ruby, Java, or similar language preferred.
- Understanding of financial technology vendors and data elements similar to Bloomberg, Blackrock, Simcorp or Charles River.
- Experience with the following would as an advantage:
- Data handling with AI/ML: Python, R