Data Engineer

We never ask for payment as part of our selection process, and we always contact candidates via our corporate accounts and platforms. If you are approached for payment, this is likely to be fraudulent. Please check to see whether the role you are interested in is posted on our career website. JOB DESCRIPTION We are looking for a Data Engineer to join our talented data intelligence practice. This position will allow a talented and enthusiastic candidate the opportunity to have an immediate impact within the organization. As a Data Engineer, you will work closely with many teams across our company on complex, data warehousing, advanced analytical projects to perform data sourcing, data profiling, and other data manipulation functions. You will assist the data intelligence team in the development of enterprise-class data solutions that serve various purposes. An individual in this role will be called upon to support various operational tasks and support internal or external projects within the company. 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 TMF Group is a fast-paced environment with high demand for a Data Intelligence team. A successful candidate sets a high standard for their delivery of quality solutions. Listed below are the desired experience and skills demonstrated by a successful candidate. Bachelor's degree in computer science or data analytics or software engineering or mathematics (master's degree is a plus). 3+ years of experience in data engineering, data ingestion, data warehouse, data modeling, data migration/ingestion assessments. 3+ years of advanced SQL development and database experience (example: Snowflake, Azure SQL Database, Azure Synapse, Redshift, Oracle, SQL Server, MySQL, NoSQL, etc.). 3+ years in a data engineer role or similar delivering enterprise data lakes/lakehouses/warehouses. 3+ years of experience creating, managing, and troubleshooting complex data ingestion pipeline, SQL queries, views, procedures, and functions. 3+ 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. 3+ years of experience in managing and maintaining data integration between different applications and databases using APIs or REST APIs. 3+ years of experience working with geospatial and geography data. 3+ years of experience with data extraction with a wide variety of ETL/ELT tools and processes. 3+ years of experience building data warehouses, data mart, and symantec data layers. 3+ years of experience with scripting in python, power shell, etc. 3+ years of experience with Azure Data Factory, Azure SQL, Azure Synapse, Azure Databricks, ML/AI, Databricks, and ML Ops. 3+ years of experience with Talend or Informatica ETL tool. 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.). Experience working with project management applications (example: JIRA, Kimble, Salesforce, etc.). Experience with version control applications (example: Azure DevOps, GitHub, BitBucket, 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. Experience with Private Equity applications (Investran, Allvue, eFront) Real Estate (Yardi, MRI), Credit servicing (WSO, Black Mountain, Sentry, Loan IQ) technology stacks 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 clients' issues and address them accordingly Will keep up to date with business trends/ changes in law that will impact their role Commercial awareness Understands TMF Groups' business lines and any relevant local regulatory requirements Has a good understanding of how TMF is structured Be able to demonstrate the impact of own actions on immediate team Leadership and resource management Plans, coordinates and manages internal and external resources to deliver results in a timely, accurate and professional manner Will share knowledge to ensure team targets are met Informally manages expectations of more senior colleagues regularly Interpersonal skills Manages internal and external stakeholders' expectations with regards to delivery, escalating concerns as appropriate Builds credibility across all stakeholder groups Able to engage with individuals all areas of an organization on area of specialism Client excellence Manages expectations so clients always feel valued Proactive in identifying opportunities and seeking solutions Ensures relevant information is obtained and shared as needed Takes responsibility for delivering superior products and services Implements improvements to client service