Lead Data Engineer

Company Overview

Accordion is a global private equity-focused financial consulting firm specializing in driving value creation through services rooted in Data & Analytics and powered by technology.

Accordion works at the intersection of Private Equity sponsors and portfolio companies’ management teams across every stage of the investment lifecycle. We provide hands-on, execution-oriented support, driving value through the office of the CFO by building data and analytics capabilities and identifying and implementing strategicwork, rooted in data and analytics.

Accordion is headquartered in New York City with 10 officesworldwide. Join us and make your mark on our company.

Accordion's Data & Analytics (D&A) practice in India delivers cutting-edge, intelligent solutions to a global clientele, leveraging a blend of domain knowledge, sophisticated technology tools,and deep analytics capabilities to tackle complex business challenges.

We partner with Private Equity clients and their Portfolio Companies across diverse sectors, including Retail, CPG, Healthcare, Media & Entertainment, Technology, and Logistics.

D&A team members deliver data and analytical solutions designed to streamline reporting capabilities and enhance business insights across vast and complex data sets ranging from Sales, Operations, Marketing, Pricing, Customer Strategies, and more.

Working at Accordion in India means joining 800+ analytics, data science, finance, and technology experts in a high-growth, agile, and entrepreneurial environment to transform how portfolio companies drive value. It also means making your mark on Accordion’s future—by embracing a culture rooted in collaboration and a firm-wide commitment to building something great, together.

Join us and experience a better way to work!

Location:

Role Overview:

The Lead Data Engineer at Accordion is responsible for the design, development, configuration, deployment, and maintenance of the core technology stack. This role demands deep expertise across tools and technologies within the data domain to design and implement scalable, robust solutions that address both current and future client requirements at optimal cost.

The Lead Data Engineer will evaluate existing architectures and recommend enhancements to improve system performance across on-premises and cloud-based environments. A successful candidate will demonstrate strong business knowledge and be well-versed in a wide range of tools, techniques, and best practices in Business Intelligence and Data Warehousing. The role also requires strong organizational skills, critical thinking, and the ability to communicate effectively with cross-functional stakeholders.

What You will do:

• Partner with clients to understand their business needs and create comprehensive business requirements.
• Develop end-to-end Business Intelligence frameworks, recommending the right architecture (on-premises or cloud-based) and analytics solutions.
• Collaborate with business and technology teams to guide solution development and ensure successful implementation.
• Work closely with business teams to define KPIs and metrics aligned with organizational goals.
• Partner with Project Managers to develop and execute project plans, ensuring timely delivery within the set schedule.
• Create standard reports and functional dashboards based on business requirements to provide actionable insights.
• Conduct training sessions and knowledge transfer programs for junior developers, recommending improvements to enhance reporting solutions.
• Stay curious and proactive in learning new tools and technologies to offer forward-thinking solutions for clients.

Ideally, you have:

• An undergraduate degree (B.E/B.Tech.) from a tier-1 or tier-2 institution.
• Over 5 years of relevant experience in the data and analytics domain.
• Hands-on expertise with SQL Server, including SSIS, SSAS, and SSRS.
• Strong understanding of relational databases such as SQL Server, MySQL, or Oracle, and experience with at least one modern data warehouse platform like Azure Synapse, AWS Redshift, Google BigQuery, or Snowflake.
• Experience working with leading BI tools such as Power BI, Tableau, Qlik, DOMO, or Looker.
• A solid understanding of cloud platforms—either Azure or AWS—with familiarity in tools like Azure Data Factory, SQL Database, DevOps, Logic Apps, Analysis Services, or AWS Glue, Redshift, RDS, Quick Sight.
• A demonstrated ability to take initiative and drive innovation.
• An analytical mindset and a strong problem-solving orientation.