At a Glance
- Tasks: Design and develop DBT models and data pipelines for analytics.
- Company: Join DXC Technology, a Fortune 500 leader in IT services.
- Benefits: Flexible work options, tailored development paths, and training opportunities.
- Why this job: Make an impact with cutting-edge technology and collaborative teams.
- Qualifications: 8+ years of DBT experience and strong SQL skills required.
- Other info: Dynamic environment with opportunities for career growth and innovation.
The predicted salary is between 36000 - 60000 £ per year.
Overview
DXC – a Fortune 500 global IT services leader. At DXC Technology we deliver the mission-critical IT services that move the world. Every day we use the power of technology to build better futures for our customers, colleagues, environment, and communities across the globe. We are flexible – we provide everything you need to comfortably work from home, but we also keep our offices open for collaboration, meetings, and building a strong team spirit. We tailor everyone\’s development path to their individual interests through training and additional certifications.
Responsibilities
- Design, develop, and maintain DBT models, transformations, and SQL code to build efficient data pipelines for analytics and reporting.
- Design, develop, and maintain ETL/ELT pipelines using DBT and pulling data from Snowflake.
- Define and implement data modelling best practices, including data warehousing, ETL processes, and data transformations using DBT.
- Build complex SQL queries within DBT to build incremental models, enhancing data processing efficiency.
- Establish data governance practices and ensure data accuracy, quality, and consistency within the data transformation process.
- Collaborate with data engineers, data analysts, and other stakeholders to understand and meet data requirements for various business units.
- Identify and address performance bottlenecks in data transformation processes and optimize DBT models for faster query performance.
- Maintain thorough documentation of DBT models, transformations, and data dictionaries to ensure transparency and accessibility to team members.
- Implement data security measures to protect sensitive information and comply with data privacy regulations.
- Stay updated on industry best practices and new features in DBT, and continuously improve the data transformation processes.
- Provide training and support to other team members in using DBT effectively.
- Implement data quality checks and validation processes to ensure data accuracy and consistency.
Skills
Must have
- 8+ years of experience in DBT.
- Hands-on experience in implementing data governance, data quality rules and validation mechanisms within Collibra is added plus.
- Knowledge of workflow orchestration tools like Tidal.
- Experience with Python or other scripting languages is a plus.
- Familiarity with Azure cloud platforms.
- Exposure to DevOps practices and CI/CD pipelines for data engineering.
Nice to have
- Certification
#J-18808-Ljbffr
DBT Developer employer: Luxoft
Contact Detail:
Luxoft Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land DBT Developer
✨Tip Number 1
Network like a pro! Reach out to your connections in the industry, especially those who work at DXC or similar companies. A friendly chat can sometimes lead to job opportunities that aren't even advertised.
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your DBT models and SQL queries. This gives potential employers a tangible look at what you can do and sets you apart from the crowd.
✨Tip Number 3
Prepare for interviews by brushing up on common DBT scenarios and challenges. Practise explaining your thought process and how you've tackled data governance and quality issues in the past.
✨Tip Number 4
Don't forget to apply through our website! It’s the best way to ensure your application gets noticed. Plus, we love seeing candidates who are proactive about their job search!
We think you need these skills to ace DBT Developer
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights your experience with DBT and SQL. We want to see how you've designed and maintained data pipelines, so don’t hold back on those details!
Showcase Your Projects: Include specific examples of projects where you’ve implemented data governance or optimised DBT models. We love seeing real-world applications of your skills!
Be Clear and Concise: When writing your cover letter, keep it straightforward. We appreciate clarity, so get to the point about why you're a great fit for the role and how you can contribute to our team.
Apply Through Our Website: Don’t forget to apply through our website! It’s the best way for us to receive your application and ensures you’re considered for the role. We can’t wait to hear from you!
How to prepare for a job interview at Luxoft
✨Know Your DBT Inside Out
Make sure you’re well-versed in DBT and its functionalities. Brush up on your experience with building models, transformations, and SQL code. Be ready to discuss specific projects where you’ve designed and maintained DBT models, as this will show your hands-on expertise.
✨Showcase Your Collaboration Skills
Since the role involves working closely with data engineers and analysts, prepare examples of how you've successfully collaborated in the past. Highlight any instances where you’ve gathered requirements or addressed performance bottlenecks, as this demonstrates your ability to work within a team.
✨Emphasise Data Governance Knowledge
Familiarise yourself with data governance practices and be prepared to discuss how you’ve implemented data quality rules and validation mechanisms. If you have experience with tools like Collibra, make sure to mention it, as it could set you apart from other candidates.
✨Stay Updated on Industry Trends
Research the latest features in DBT and industry best practices. Being able to discuss recent developments shows your commitment to continuous improvement. You might even want to share how you’ve applied new techniques in your previous roles to enhance data processing efficiency.