Job ID

30522

Location

Indianapolis, United States

Work Types

Full Time

Categories

Information Technology

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.

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.

Our 9,100 experts and 120 offices in 85 jurisdictions worldwide serve corporates, financial institutions, asset managers, private clients and family offices, providing the combination of accounting, tax, payroll, fund administration, compliance and entity management services essential to global business success.

We help businesses achieve global compliance, transparency and consistency.

Discover the Role

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-cla ss 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.

Key Responsibilities

Here's what a typical day for you might look like:
* Working closely with the solution leads on solution design, architecture, and i mplementation.
* Perform extraction, t ransformation, 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/QUA LIFICATIONS

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/inge stion 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/lakehous es/warehouses.
* 3+ years of experience creating, managing, and troubleshootin g 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-solvin g 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 Requirements

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

What's in it for you?

Pathways for career development

Work with colleagues and clients around the world on interesting and challenging work.
We provide internal career opportunities, so you can take your career further within TMF.
Continuous development is supported through global learning opportunities from the TMF Business Academy.

Making an impact

You'll be helping us to make the world a simpler place to do business for our clients.
Through our corporate social responsibility program, you'll also be making a difference in the communities where we work.

A supportive environment

Strong feedback culture to help build an engaging workplace.
Regardless of where you are in your career, TMF Group opens a world of opportunity where you will be part of our team and is supported in your global career journey.
Our inclusive work environment allows you to work from our offices around the world, as well as from home, helping you find the right work-life balance to perform at your best.
At TMF Group, it's our people who make us who we are. Our company thrives on entrepreneurial spirit and is full of proactive people who combine enthusiasm with responsibility and accountability.

Other Benefits

Anniversary & Birthday Leave policy
Be part of One TMF
Paternity & Adoption leaves
Salary advance policy
Work flexibility - Hybrid work model
Talk about growth opportunities (we invest in talent)
Well-being initiatives

We're looking forward to getting to know you!

TMF Group

New Jobs

Data Engineer