At a Glance
- Tasks: Build and execute ETL pipelines to manage client data for onboarding.
- Company: Join Artlogic, a leading tech platform revolutionising the art world.
- Benefits: Remote work, competitive salary, and opportunities for professional growth.
- Other info: Exciting career growth in a collaborative, global environment.
- Why this job: Be part of a dynamic team shaping the future of art technology.
- Qualifications: Proficiency in Python or C#, and a passion for problem-solving.
The predicted salary is between 30000 - 40000 £ per year.
Hours: 40 pw (9.30-6pm Monday to Friday, 1 hour lunch)
Term: FTC - 6 months
Location: UK or US (Remote)
About us
Artlogic is a leading technology platform for the art world. Founded in 1989, Artlogic empowers over 6,000 galleries, dealers, and art professionals worldwide to streamline their operations and grow their businesses. The company’s integrated platform combines inventory management, CRM, websites, sales, marketing, and payment tools, everything needed to run a modern and successful art business. In 2021, Artlogic was acquired by tech investors Cove Hill Partners to accelerate innovation and expand its global reach. Since then, the company has doubled in size, with employees across London, New York, Atlanta, and Cape Town. Today, Artlogic is entering an exciting new chapter through its merger with ArtCloud, another industry leader in art technology. Together, the two companies are uniting complementary platforms to build the most comprehensive, forward-thinking solution for the art world. This collaboration brings together deep expertise across CRM, sales, marketing, inventory, payments, and AI-powered tools, empowering galleries, artists, and collectors worldwide. Joining Artlogic means becoming part of a growing global team that is shaping the future of how art is bought, sold, and managed, both online and in person.
The Data Migration team operates within the Customer function, combining both technical and project delivery responsibilities. Project Managers act as the primary client interface, coordinating communication and requirements. Data Migration Specialists are responsible for technical execution, including ETL processes and solution design. The team also contributes to internal R&D, building tools and applications to improve migration efficiency and scalability.
The Role
As a Junior Data Engineer, you will be a vital part of the team responsible for the lifeblood of our onboarding process: client data. You will help bridge the gap between legacy client systems and the Artlogic ecosystem by building and executing robust ETL (Extract, Transform, Load) pipelines. This role is ideal for a developer early in their career who loves the "puzzle" aspect of data. You will work within the Data Migration team to dismantle complex external data structures (Relational data, FileMaker), reassemble them into our sophisticated data model, and contribute to the internal Python/Ruby libraries that make our migrations faster and smarter. You will be mentored by senior engineers and work closely with Project Managers to ensure a seamless transition for our clients.
Key Responsibilities
- ETL Development & Execution
- Execute End-to-End Migrations: Learn to navigate the full migration lifecycle, moving data from diverse client environments into Artlogic.
- Extraction: Use scripts and tools to pull data from external platforms (e.g., FileMaker, legacy SQL databases).
- Transformation: Write clean, maintainable code to map, clean, and transform "messy" legacy data to fit the Artlogic schema.
- QA & Validation: Perform rigorous data validation and unit testing to ensure 100% accuracy and data integrity before go-live.
- Technical Growth & Tooling
- Code Contribution: Assist in developing and maintaining our internal migration frameworks and R&D tools.
- Pipeline Optimization: Identify repetitive tasks in your daily workflow and work with senior engineers to automate them.
- Systems Analysis: Research unknown database structures to determine the most efficient extraction methods.
- Cross-functional Teamwork: Partner with Client Liaison Project Managers to understand client-specific data nuances.
- Documentation: Document migration mappings and technical edge cases to ensure knowledge is shared across the team.
- Iterative Delivery: Adapt migration scripts quickly as project requirements evolve during the onboarding phase.
- AI & Data
- AI Recommendation Verification and Data Mapping: Review and verify AI (Claude) recommendations for column mappings during cloud data migration, including confirming that columns fit perfectly or identifying where data requires manipulation or concatenation.
- Data Transformation and Cloud Push: Perform final data transformation steps using basic Python, Pandas, and Reax code to prepare and push relational data from Excel into the cloud environment.
Key Attributes
- Data Integrity: Success is measured by the accuracy of migrated data and the absence of "broken" records post-launch.
- Technical Progression: Demonstrates a growing ability to handle increasingly complex data structures with less supervision.
- Code Quality: Contributions to internal libraries follow team standards and improve overall migration speed.
- Reliability: Consistently meets project milestones and keeps stakeholders informed of technical blockers.
About You
- Coding Foundations: Proficiency in at least one object-oriented language—Python is preferred, but we also value strong logic in C#.
- SQL & Data Logic: Solid understanding of relational databases (Joins, Keys, Indexes) and how to manipulate data structures.
- Problem-Solving Mindset: You enjoy the "detective work" of figuring out how a legacy system was built and how to extract its value.
- Detail Oriented: An obsession with data accuracy; you catch the "edge case" before it becomes a bug.
- Communication: Ability to explain technical data hurdles to non-technical Project Managers.
- The "Data Stack": Experience with ETL tools, pandas (Python), or regular expressions (Regex).
- API Knowledge: Familiarity with REST APIs and how to handle JSON/XML data.
- Niche Systems: Previous exposure to FileMaker (Claris) or NoSQL environments.
- Web Basics: A high-level understanding of how back-end data interacts with front-end UIs.
Artlogic is an equal opportunities employer. We are committed to fair and inclusive recruitment and employment practices. We welcome applications from all suitably qualified candidates. We are committed to making reasonable adjustments for disabled applicants and employees. If you have a disability and would like us to make adjustments to the application or interview process, or to discuss any adjustments to the role, please let us know.
Please note that this position is UK or US based. Candidates must therefore have, or be able to obtain, appropriate immigration status entitling them to work in the UK or US for us in the role. Please note that we do not have a sponsor licence and we are not able to offer visa sponsorship for this position. The successful candidate will need to provide evidence/information to enable us to verify their right to work, prior to commencement of employment, and in accordance with current Home Office right to work guidance.
Data Engineer employer: Artlogic
Artlogic is an exceptional employer that fosters a collaborative and innovative work culture, empowering employees to shape the future of art technology. With a commitment to professional growth, you will receive mentorship from senior engineers while working on impactful projects that enhance data migration processes. Enjoy the flexibility of remote work in the UK or US, alongside a diverse team dedicated to inclusivity and excellence.
StudySmarter Expert Advice🤫
We think this is how you could land Data Engineer
✨Tip Number 1
Network like a pro! Reach out to people in the industry, attend meetups, and connect with Artlogic employees on LinkedIn. You never know who might have the inside scoop on job openings or can put in a good word for you.
✨Tip Number 2
Prepare for those interviews! Research common data engineering questions and practice your answers. Make sure you can explain your past projects and how they relate to the role at Artlogic. Confidence is key!
✨Tip Number 3
Show off your skills! If you have a portfolio or GitHub with relevant projects, make sure to share it during your interview. This gives us a glimpse of your coding style and problem-solving abilities.
✨Tip Number 4
Apply through our website! It’s the best way to ensure your application gets seen by the right people. Plus, it shows you’re genuinely interested in joining the Artlogic team.
We think you need these skills to ace Data Engineer
Some tips for your application 🫡
Tailor Your CV:Make sure your CV is tailored to the Data Engineer role. Highlight relevant skills like ETL processes, Python proficiency, and any experience with relational databases. We want to see how your background fits into our world!
Craft a Compelling Cover Letter:Your cover letter is your chance to shine! Share your passion for data and how you enjoy solving complex problems. Let us know why you're excited about joining Artlogic and how you can contribute to our team.
Showcase Your Projects:If you've worked on any projects related to data migration or ETL, make sure to mention them! We love seeing practical examples of your work, so include links or descriptions that demonstrate your skills in action.
Apply Through Our Website:We encourage you to apply directly through our website. It’s the best way for us to receive your application and ensures you’re considered for the role. Plus, it’s super easy to do!
How to prepare for a job interview at Artlogic
✨Know Your Data Stuff
Make sure you brush up on your knowledge of ETL processes and relational databases. Be ready to discuss how you've used Python or SQL in past projects, as this will show your technical prowess and problem-solving mindset.
✨Show Off Your Detective Skills
Prepare to talk about a time when you had to figure out a complex data structure or solve a tricky data issue. Artlogic values detail-oriented candidates, so highlight your obsession with data accuracy and how you catch edge cases before they become problems.
✨Communicate Like a Pro
Since you'll be working closely with Project Managers, practice explaining technical concepts in simple terms. Think of examples where you've successfully communicated complex ideas to non-technical folks, as this will demonstrate your ability to bridge the gap between tech and business.
✨Be Ready for Teamwork
Artlogic thrives on collaboration, so come prepared to discuss how you've worked in cross-functional teams. Share experiences where you partnered with others to achieve a common goal, especially in data migration or project delivery contexts.
