Junior Data Engineer
Summary
Builds and maintains data pipelines and ETL processes to integrate financial platforms (e.g., Yardi, Salesforce) with BI tools, ensuring data quality and alignment with business needs.
Job Description Summary The junior data engineer is an experienced individual in at least one financial platform (ERP) supplemented by BI platform experience. Advantageous to the candidate if any of the platforms are designed by Yardi or Salesforce.
Job Overview
The junior data engineer is responsible for the maintenance of all major data integration projects between the multiple platforms under the department’s remit. The role expands with close participation in the design and development of future integrations and advising on large‑scope, multi‑regional solutions aimed at process and data optimization for our business lines. The candidate will work closely with the Platform and Design teams to design effective solutions, establish standards and best practices, and coordinate with C&W IT leadership, business stakeholders, and subject matter experts to ensure financial systems align with business processes and drivers. The position also provides maintenance, support, and enhancements to financial systems integrations based on an escalation process.
Key Responsibilities
- Coordinate systems change management through process, auditing, monitoring, and reporting systems.
- Represent the platform team as liaison between technical and non‑technical teams, fostering repeatable deployment and solution standards.
- Assist in the design, development, and maintenance of data pipelines and ETL processes.
- Collaborate with data scientists and analysts to understand data requirements and deliver solutions.
- Assemble large, complex sets of data that meet non‑functional and functional business requirements while ensuring data quality and integrity by performing data cleaning and validation.
- Identify, design, and implement internal process improvements including re‑designing infrastructure for greater scalability, optimizing data delivery, and automating manual processes.
- Build required infrastructure for optimal extraction, transformation, and loading of data from various data sources using SQL technologies.
- Create analytical tools to utilize the data pipeline, providing actionable insight into key business performance metrics, including operational efficiency and customer acquisition.
- Work with stakeholders including data, design, product, and executive teams and assist them with data‑related technical issues.
- Coordinate with stakeholders, including the Executive, Product, Data, and Design teams, to synergize data infrastructure needs and address data‑related technical issues.
- Monitor and troubleshoot data workflows to ensure smooth operation.
- Participate in code reviews and contribute to the improvement of data engineering practices.
- Document data processes and workflows for future reference.
- Coordinate with internal or external auditors and ensure the integrity of our processes.
Knowledge and Experience
- Degree in business, computer science, engineering, or marketing.
- A minimum of 2–5 years of ERP experience or related experience with a solid background in technical and data analysis, BI tools and data management, and complex multi‑platform data integrations.
- A master’s degree in data sciences can count as two years towards the minimum experience.
- Broad knowledge of SQL and relational databases.
- Basic knowledge of programming languages such as Python or Java.
- Practical ability to communicate effectively with business and technology partners to determine platform goals and gaps.
- Practical ability to manage multiple projects and work streams in a clear and effective manner.
- Practical knowledge of commercial real estate and commercial fee managers.
- Basic knowledge of Azure Integration Tools or ability to develop such skills.
- Basic knowledge of data warehousing concepts and ETL tools.
Preferred Qualifications
- Practical experience with commercial industry financial applications (Yardi, RealPage, MRI, JDE, etc.).
- Minimum experience can be replaced by at least one year of Yardi ERP or RealPage ERP work experience in a technical position.
- Practical understanding of DevOps practices and tools (e.g., CI/CD pipelines, Jenkins, Git).
- Advanced knowledge of support tools and ticketing systems (e.g., ServiceNow, Azure DevOps).
INCO: “Cushman & Wakefield”