Lead Implementation Consultant (SQL + Data Warehousing)

  • Acquia
  • Remote, OR 97458, USA
  • 04 Oct, 2022

Job Description

Acquia is the open-source digital experience company. Acquia empowers the world’s most ambitious brands to create digital customer experiences that matter. With open source Drupal at its core, the Acquia Digital Experience Platform (DXP) enables marketers, developers, and IT operations teams at thousands of global organizations to rapidly compose and deploy digital products and services that engage customers, enhance conversions, and help businesses stand out. We provide the world's most ambitious brands with technology that allows them to embrace innovation and create customer moments that matter. At Acquia, we believe in the power of community and collaboration - giving our customers the freedom to build tomorrow on their terms.

Headquartered in the U.S., Acquia has been named a top software company by The Software Report, rated a leader by the analyst community, and named a top place to work by the Boston Globe and the Boston Business Journal. We are Acquia. We are building for the future and we want you to be a part of it!

About the job

In the Acquia CDP Professional Services team, our job is to design, configure, and deploy the most powerful CDP solutions that the Acquia Platform can offer. We are looking for someone who loves data and working with clients to translate requirements into product technical solutions.

As a Lead Implementation Consultant, you manage all technical aspects of new implementations and revisions for clients, and drive them towards value realization. Be ready to hit the ground running with your leadership, strong analysis skill, technical acumen, creative and critical thinking, and passion for fast-paced problem solving.

Key responsibilities

  • Lead and mentor Implementation Consultants in implementing solutions with the Acquia CDP
  • Lead complex Acquia CDP implementation projects for our customers, including discovery and project planning.
  • Work in close partnership with Acquia project and customer success managers to lead customer engagements, regularly taking the lead on customer communications.
  • Collaborate closely with project management to create and adjust project requirements and timelines.
  • Drive clients towards maximum value realization with the Acquia CDP Platform.
  • Understand and translate the client's marketing and business use cases to design solutions suitable to their needs.
  • Work with client technical and business team members to gather requirements, map solutions, make recommendations, and craft the CDP solution.
  • Deliver technical specifications, documentation, and functional software solutions based on customer requirements.
  • Collaborate with Acquia product and engineering teams on solutions to novel customer requirements.
  • Engage subject matter experts and other team members for support as needed.
  • Communicate clearly and regularly with project stakeholders regarding project status and risks.
  • Lead the entire development lifecycle with a team of engineers.
  • Develop a deep understanding of customers' data to ensure it can be integrated successfully into Acquia's big data platform.
  • Define and coach others in Acquia CDP best practices.
  • Participate in continuous iterative improvement of the Acquia CDP product based on customer feedback.

Key requirements

  • 8-12 yrs of Strong SQL language experience with optimization techniques (window functions, case statements, joins, etc.)
  • Hands-on E2E product delivery along with client handling experience
  • Experience with drawing meaningful conclusions from large sets & variety of data
  • Experience with Hadoop, Hive QL, Impala, along with a solid understanding of data warehousing and business intelligence
  • Relational Database Management System Data Architecture
  • Strong analytical and critical problem solving skills with attention to detail
  • Excellent written and verbal communication skills tailored to an audience of professionals, management and staff with a broad range of technical skills
  • Ability to learn about new platforms and technologies unique to client environments
  • Ability to translate business requirements to product solutions
  • Ability to lead design technical solutions and solve blockers during development for large clients

Nice To Have

  • Experience with bash scripting
  • Working knowledge of email service providers (e.g. Silverpop, ExactTarget, Responsys)
  • Experience with operational data systems (SAP, NetSuite, Magento)
  • Experience from the product industry and have built accelerators/automation tools
  • Experience with Python (particularly Pandas, NumPy)
  • Experience with Machine Learning
  • Experience in web technologies (e.g. HTML, CSS, JavaScript)
  • Experience in web analytics (e.g. Google Analytics, CoreMetrics, SiteCatalyst)
  • Bachelor or Masters Degree in an engineering or analytical field

You'll be successful in this role if you have

  • Relentless drive to help clients be successful.
  • Proven leadership skills.
  • Commitment to delivering high-quality software on time.
  • Ability to work within timelines and technical constraints.
  • Desire to learn and adapt to new applications and frameworks, and eager to work on exciting and innovative technologies.
  • Strong interpersonal and communication skills.
  • Skilled at collaborating with team members and partners in a matrixed environment.
  • Flexible and able to deal with shifting priorities while clearly communicating the impact of change to your team.
  • Exceptional organizational skills and the ability to manage multiple simultaneous projects at varying stages

Acquia is proud to provide best-in-class benefits offerings to our employees and their families in maintaining both a healthy body and a healthy mind. Core Benefits include: competitive healthcare coverage, wellness programs, take it when you need it time off, parental leave, recognition programs, and much more!

Acquia is an equal opportunity (EEO) employer. We hire without regard to age, color, disability, gender (including gender identity), marital status, national origin, race, religion, sex, sexual orientation, veteran status, or any other status protected by applicable law.

Interested residents of Colorado may contact NA-recruiting@acquia.com as it relates to regulation C.R.S. § 8-5-201. Information regarding benefits are linked here.