Lead Data Engineer

About UsWe'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 RoleAs 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 solutionsDesign, 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 solutionsEnsure data quality, integrity and security across all data integration processesOptimize and tune data integration workflows for performance and scalabilityDevelop and implement best practices for data integration, including data modeling, ETL processes, and data warehousingMentor and provide technical guidance to junior team members, fostering a culture of continuous learning and improvementStay current with industry trends and emerging technologies to drive innovation in data integration and analyticsWork closely with the analytics team to support data driven decision making and business insightsThis role will be mainly based in Columbus, Ohio.About YouYou'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 analyticsProven experience leading and managing data engineering teamsExpertise in Microsoft technologies including Azure Data Factory, SQL Server, Azure Databricks and Power BIStrong knowledge of data modeling, ETL processes and data warehousing conceptsProficiency in SQL, Python and other relevant programming languagesExperience with cloud platforms, particularly Microsoft AzureExcellent problem-solving skills and ability to work in a fast-paced, dynamic environmentStrong communication and interpersonal skills with the ability to collaborate effectively with cross-functional teamsSome of the Perks20 days paid vacation per year and 12 BJSS holidays5 paid sick daysCompetitive medical, dental and vision plans employer funded 80%4 x salary Life and AD&DCommuter benefits401K plan (BJSS will contribute 3% of salary into your 401K)An industry-leading referral scheme, with no limits on the number of referralsOur 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 WFHTraining opportunities and incentives - we support professional certifications across engineering and non-engineering roles, including unlimited access to O'ReillyYou will become part of a squad with people from different areas within the business who will help you grow at BJSSA collaborative and inspiring environment working alongside some of the best tech people in the industryWe partner with Lifeworks to offer wellbeing support to our employeesWorking RestrictionsAll 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.