Solutions Consultant - Data Management

The role

You will build data pipelines, applications, and reporting capabilities to process financial datasets. You will also lead data modelling activities and design ETL pipelines to support reporting solutions.

What you will do

• 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.
• Define, build and publish reporting capabilities in BI/reporting tools like Tableau and Power BI.
• Design, code, and tune ETL pipelines using Boomi, Talend, Informatica or similar technologies.
• Perform data profiling and source-to-target mapping.
• Apply modern data management toolsets to design, build, implement, and optimize data solutions.
• Define and socialise technical approaches for SDLC, data migration, integrations and reporting.
• Analyze, review and document business, functional, and technical requirements.
• Drive documentation and development according to specifications and standards.
• Participate in project team meetings and communicate with internal and client peers.

Required 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.
• Understanding of financial technology vendors and data elements similar to Bloomberg, Blackrock, Simcorp or Charles River.

Nice to have

• Experience with object-oriented programming (OOP) languages like Python, Ruby, Java, or similar language
• Data handling with AI/ML: Python, R
• ETL: Talend, Boomi, Databricks, Azure Data Factory
• Low Code platforms: MS PowerApps, Mendix, Outworks
• CRM: Salesforce, MS Dynamics
• Workflow: Unqork, Appian, Boomi Flow
• Marketing Automation: Pardot, Marketing Cloud, Marketo, Eloqua
• CMS: Adobe Experience Manager, Optimizely, Kurtosys

Benefits

• Annual profit-sharing opportunity
• 401k/RRSP matching
• 25 days of annual paid time off
• Up to 7 days annually for sick leave
• Supplemented medical, dental and vision coverage
• Reimbursement for commuting, mobile phone, and home internet expenses
• North America team-wide training and retreats
• Sponsorship towards professional certifications / training with 5 days of paid training time
• Comprehensive parental leave including 8 weeks of birthing leave and 8 weeks of bonding leave
• Return with Care Program
• Child Sickness Leave (up to 5 days)
• Menstrual care support

About the company

Alpha Group is a leading global consultancy to the financial services industry. Alpha Tech Services is the technology implementation/business integration arm of the Alpha group.