At a Glance
- Tasks: Build and maintain analytics models, ensuring data accuracy and integrity.
- Company: A growing tech-led organisation undergoing a major analytics transformation.
- Benefits: Competitive daily rate, fully remote work, and a dynamic project environment.
- Other info: Collaborative team atmosphere with opportunities for professional growth.
- Why this job: Join a pivotal data journey and tackle exciting migration challenges.
- Qualifications: Strong dbt and SQL skills, with experience in data migration and analytics engineering.
We're supporting a growing, technology-led organisation as they undertake a major transformation of their analytics platform and data estate. This is a hands-on Analytics Engineering contract focused on data migration, reconciliation and rebuilding core analytics models. You'll play a key role in helping the business transition away from a legacy architecture while ensuring the accuracy, integrity and trustworthiness of critical business data.
Working closely with a small, highly collaborative data team, you'll be responsible for investigating legacy datasets, designing robust dbt models and supporting the build-out of a modern analytics environment.
Key Responsibilities- Build and maintain analytics models using dbt
- Reconcile and validate historical datasets during a major migration programme
- Develop and optimise SQL transformations within BigQuery
- Investigate and resolve data quality issues
- Design robust testing and validation frameworks
- Work closely with analysts and business stakeholders to understand legacy data structures and business rules
- Contribute to data governance, documentation and lineage initiatives
- Strong commercial experience with dbt
- Advanced SQL skills
- BigQuery or modern cloud data warehouse experience
- Data modelling and analytics engineering best practices
- Data migration and reconciliation projects
- Strong understanding of data quality, validation and testing
- HubSpot data or CRM migration experience
- Data lineage/catalogue tooling (Secoda, DataHub, OpenMetadata, Atlan etc.)
- GCP experience
- Looker or modern BI tooling
This is a chance to join a business at a pivotal stage of its data journey, helping to shape a modern analytics platform while solving complex migration and data quality challenges. If you're an Analytics Engineer with strong dbt experience and enjoy getting hands-on with data transformation, migration and modelling, I'd be keen to speak with you.
Locations
Analytics Engineer (DBT) in Cheshire, Warrington employer: Morgan McKinley
Join a forward-thinking technology-led organisation that values innovation and collaboration, offering a fully remote work environment across the UK. As an Analytics Engineer, you'll not only contribute to a significant transformation of the analytics platform but also enjoy a culture that prioritises employee growth and development, with opportunities to enhance your skills in modern data practices. With competitive daily rates and the chance to work on impactful projects, this role is perfect for those seeking meaningful and rewarding employment in the data field.
StudySmarter Expert Advice🤫
We think this is how you could land Analytics Engineer (DBT) in Cheshire, Warrington
✨Showcase Your Skills with a Public Portfolio
As a freelancer in data science, having a killer portfolio is essential. Showcase your projects on platforms like GitHub or create a personal website that details your work and techniques. This gives potential clients a clear picture of what you can do and helps you stand out from the competition.
✨Get Involved in Data Science Communities
Tap into online forums like Kaggle or Stack Overflow. Not only can you showcase your expertise, but you can also connect with other data scientists and potential clients. Plus, participating in competitions and discussions can elevate your profile in the field.
✨Leverage Local Networking Opportunities
Keep an eye out for local data science meetups or tech events in your area. These are golden opportunities to meet potential clients and collaborators face-to-face. Plus, who doesn't love a bit of networking over pizza and drinks?
✨Pitch Your Services Directly to Companies
Don't just wait for freelancing platforms to bring clients to you—be proactive! Research companies that could benefit from data science services and craft tailored pitches. Mention specific pain points you can address for them. Let’s get that freelance hustle going!
We think you need these skills to ace Analytics Engineer (DBT) in Cheshire, Warrington
Some tips for your application 🫡
Showcase Your Projects:When applying for a freelance data science role like Analytics Engineer (DBT) at Morgan McKinley, it’s crucial to highlight your projects. Include a portfolio that features at least two or three projects involving data analysis, machine learning, or visualisation. Make sure to describe the tools and methodologies you used, so we can see your skills in action!
Quantify Your Achievements:Freelance gigs, especially in data science, often ask for proven results. In your CV, include any relevant metrics or outcomes from your previous work. Did your analysis help reduce costs by a certain percentage? Or did your predictive model improve performance? Numbers speak volumes!
Introduce Your Style:Since freelancing is all about your individual style and approach, use your cover letter to share how you tackle data problems. This is your chance to let us know how you think, your creative problem-solving methods, and how you would approach a project at Morgan McKinley.
Be Real About Your Rates:When you send in your application, don’t forget to mention your freelance rates and availability. We appreciate clarity up front, and it helps us gauge if you fit within our budget and timeline. Being transparent in this aspect shows professionalism and readiness!
How to prepare for a job interview at Morgan McKinley
✨Show Off Your Data Wizardry
As a freelancer in data science, you'll want to present a portfolio that showcases your best projects. We should pull together examples where you tackled real problems with data analytics, machine learning models, or visualisations. It's all about demonstrating your skills in action!
✨Be Ready to Dive Deep into Technical Questions
Expect to encounter some technical grilling during the interview. Prepare to discuss statistical methods, algorithms, or maybe even tackle a live coding challenge. We should brush up on tools like Python, R, or SQL—those are key players in the data science field. Don't just know them; be ready to explain your thought process!
✨Help Them Understand Your Work Style
Freelance gigs often mean you'll be working independently, so we need to convey our self-motivation and time management skills. Be prepared to talk about how you’ve handled multiple projects or met tight deadlines before. Sharing your approach to client communication can also give them confidence in your ability to deliver remotely.
✨Pitch Your Value Proposition
When freelancing, it’s crucial to clearly articulate what makes you unique. We should highlight not just technical skills but also the business impact of our projects. Think of a couple of stories where your data insights drove decision-making—this can be a game changer in showing why they should choose you for their freelance needs!
