**Job no**: 565972
**Work type**: Full time
**Location**: Bogota, Colombia, San Jose, Costa Rica, Toronto, Canada
**Categories**: Information Technology
**Office Location**: Canada - Toronto
**About TMF Group**
TMF Group is a leading provider of critical administrative services, helping clients invest and operate safely around the world. We provide legal, financial and employee administration through TMF Group's teams in 120 offices.
**KEY RESPONSABILITIES**:
We are looking for self-starters with the skills necessary where you will be directly responsible for addressing business needs through requirements gathering and collaborating on solution reviews to develop end-to-end data solutions including but not limited to data modeling, data delivery pipelines, data visualization, and working through complex problems and solutioning using agile development methodology. We are looking for a data engineer who is an ideal team player.
**Here's what a typical day for you might look like**:
- Working closely with the solution leads on solution design, architecture, and implementation.
- Perform extraction, transformation, and loading (ETL) OR extraction, loading, and transformation (ELT) of data from a wide variety of data sources using various data engineering tools and methods into a data lake storage or data warehouse.
- Query and process large data sets and perform data profiling and data quality assessments.
- Design and implement data solutions for integration across systems that are both financial and operational.
- Assist in creating database models and architecture design and documentation.
- Conduct research and development as well as contribute to the long-term positioning of and emerging technologies related to data sourcing, cleansing, and integration.
- Document and demonstrate solutions by developing documentation, flowcharts, layouts, diagrams, charts, code comments and clear code.
- Improve operations by conducting systems analysis, recommending changes in policies and procedures.
- Investigate and resolve data defects, and performance issues and build data quality rules.
- Participate in client-facing project activities such as requirements gathering, solution reviews, and explaining technical complexities and business benefits in layperson terms.
**EXPERIENCE/QUALIFICATIONS**
- Bachelor's degree in computer science or data analytics or software engineering or mathematics (master's degree is a plus).
- 5+ years of experience in data engineering, data ingestion, data warehouse, data modeling, data migration/ingestion assessments.
- 5+ years of advanced SQL development and database experience (example: Snowflake, Azure SQL Database, Azure Synapse, Redshift, Oracle, SQL Server, MySQL, NoSQL, etc.).
- 5+ years in a data engineer role or similar delivering enterprise data lakes/lakehouses/warehouses.
- 5+ years of experience creating, managing, and troubleshooting complex data ingestion pipeline, SQL queries, views, procedures, and functions.
- 5+ years of experience in advanced SQL development: management of high volume of data, building aggregates, and cubes, tuning complex queries for performance, improving overall data retrieval process, indexing, and query plan analysis, and refactoring.
- 5+ years of experience working with geospatial and geography data.
- 5+ years of experience with data extraction with a wide variety of ETL/ELT tools and processes.
- 5+ years of experience building data warehouses, data mart, and symantec data layers.
- 5+ years of experience with scripting in python, power shell, etc.
- 5+ years of experience with Azure Data Factory, Azure SQL, Azure Synapse, Azure Databricks, ML/AI, Databricks, and ML Ops.
- Experienced working in the cloud and serverless database solutions (example: Azure, AWS, Snowflake, BigQuery, BigTable, etc.) in combination with any BI Tools (example: Power BI, Tableau, etc.).
**CANDIDATE PROFILE**
- Rigorous attention to detail
- Ability to communicate with internal and external stakeholders and work through data-related inquiries and issues
- Effectively manage workload with shifting priorities and varying business requirements
- Excellent problem-solving skills to identify creative ways to achieve solutions
- Capable of taking responsibility for a task and managing it through completion
- Excellent verbal and written communication skills
- Strong accounting background is a plus.
- Experience in Accounting, Investment management will be beneficial.
- Strong understanding of the Private Funds and Capital Markets (Credit/Debt Servicing) industry
- Fluent in both written and spoken English.
**KEY COMPETENCIES**
- Operational Excellence _
- Demonstrates the ability to make decisions based on insight and knowledge that impact the immediate team
- Accountable for ensuring high standards of delivery to clients
- Actively engages with customer to understand needs and will place a high priority on client service and satisfaction
- Prioritizes