Lead Data Engineer

About Us

We’re an award-winning innovative tech consultancy - a team of creative problem solvers. Since 1993 we’ve been finding better, more sustainable ways to solve complex technology problems for some of the world’s leading organizations and delivered solutions that millions of people use every day. 

In the last 30 years we won several awards, including our most recent inclusion in the Forbes World's Best Management Consulting Firms report.  

Operating from 26 locations across the world, we bring together teams of creative experts with diverse backgrounds and experiences, who enjoy working and learning in our collaborative and open culture and are committed to world-class delivery.  

We have an established presence in the United States for over ten years. With offices in New York City, Columbus, Ohio and Houston, Texas we offer a local touch with a global reach.     

We want to continue to grow and need people just like you! 

About the Role

As a Lead Data Engineer, you will be responsible for leading the development and implementation of data integration solutions for analytics. You will play a critical role in designing, building and managing data pipelines, ensuring data quality and driving the strategic direction of data initiatives. This role requires strong leadership skills, technical expertise and experience with Microsoft technology.

Key Responsibilities:

• Lead and manage a team of data engineers to deliver high-quality data integration solutions
• Design, develop and maintain robust data pipelines using Microsoft technologies (e.g., Azure Data Factory, SQL Server, Azure Databricks)
• Collaborate with stakeholders to understand data requirements and translate them into scalable and efficient data integration solutions
• Ensure data quality, integrity and security across all data integration processes
• Optimize and tune data integration workflows for performance and scalability
• Develop and implement best practices for data integration, including data modeling, ETL processes, and data warehousing
• Mentor and provide technical guidance to junior team members, fostering a culture of continuous learning and improvement
• Stay current with industry trends and emerging technologies to drive innovation in data integration and analytics
• Work closely with the analytics team to support data driven decision making and business insights

This role will be mainly based in Columbus, Ohio.

About You

You’ll bring extensive data engineering experience gained through a combination of industry and consulting roles. You will be comfortable developing and strengthening peer-to-peer level relationships at all levels with our clients.

Ideally, you will have as much of the following experience as possible:

• Extensive experience in data engineering, with a focus on data integration and analytics
• Proven experience leading and managing data engineering teams
• Expertise in Microsoft technologies including Azure Data Factory, SQL Server, Azure Databricks and Power BI
• Strong knowledge of data modeling, ETL processes and data warehousing concepts
• Proficiency in SQL, Python and other relevant programming languages
• Experience with cloud platforms, particularly Microsoft Azure
• Excellent problem-solving skills and ability to work in a fast-paced, dynamic environment
• Strong communication and interpersonal skills with the ability to collaborate effectively with cross-functional teams

Some of the Perks

• 20 days paid vacation per year and 12 BJSS holidays
• 5 paid sick days
• Competitive medical, dental and vision plans employer funded 80%
• 4 x salary Life and AD&D
• Commuter benefits
• 401K plan (BJSS will contribute 3% of salary into your 401K)
• An industry-leading referral scheme, with no limits on the number of referrals
• Our roles are not fully remote as we take pride in the tight knit communities we have created at our local offices. But we offer plenty of flexibility and you can split your time between the office, client site and WFH
• Training opportunities and incentives – we support professional certifications across engineering and non-engineering roles, including unlimited access to O’Reilly
• You will become part of a squad with people from different areas within the business who will help you grow at BJSS
• A collaborative and inspiring environment working alongside some of the best tech people in the industry
• We partner with Lifeworks to offer wellbeing support to our employees

Working Restrictions

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability or protected veteran status, or any other legally protected basis, in accordance with applicable law.

BJSS will only employ those who are legally authorized to work in the United States for this opening. We are unable to offer visa sponsorship.