ABOUT THE COMPANY
Amplify Consulting Partners is a data-first consulting company trusted by Fortune 500 businesses to deliver high-impact professional services across the technology ecosystem—from data engineering and visual analytics to data-driven marketing and program management.
We build and empower high-performing people by promoting growth and connection across our company culture. We don't just hang core values on the wall, we make every decision with them in mind—developing trusted, long-term relationships on a foundation of transparency and accountability.
DEI STATEMENT
We hold ourselves accountable for creating an authentic workplace where every person feels heard and experiences a sense of belonging.
We believe that organizations can be an instrument for positive human impact when they champion a diverse, inclusive, and equitable environment. We do this at Amplify by enacting programs and policies that promote DEI—and with humility, if we miss the mark, we rigorously amend our practices to better achieve our targeted outcomes.
Simply put, we turn our words into action.
ABOUT THE POSITION
-
Enhance the Marketing Operations Data & Integration team’s ability to enable non-technical marketers to independently create a wider variety of email audiences, by gaining understanding of the data available in the data lake and designing logic and repositories that can feed a UI (to be implemented by the team’s engineers).
Write queries to create email audiences based on marketers’ criteria, when those criteria are not yet served by existing self-serve tools.
-
Able to use SQL to query large data sets (100 million + rows). Good if familiar with any SQL flavor and able to independently read documentation. (Client uses Presto/Trino SQL.)
-
Strong in set logic concepts: Knows the effects of choosing different kinds of joins, parenthesis placement
-
Able to independently understand a lot about data tables with little to no documentation and no integrity constraints, by using SQL to profile the data and determine unique identifiers, relationships, etc.
-
Able to write (and knows when to use) case statements and window functions. Array functions and lamda functions are also occasionally helpful.
-
Proactive and resourceful. Takes initiative to reach out for information, collaborative input, and access, but does not require exact instructions to perform work.
-
Familiar with analytic database concepts, like why denormalized tables are sometimes preferable to 3NF.
-
Able to document own or others’ work with comments or diagrams.
-
Able to courteously communicate about request prioritization to competing stakeholders, and to coordinate harmoniously with a team.
-
Able to work with a variety of people and translate their business requests into queries.
-
Has sense of urgency balanced by desire to deliver high-quality results.
-
Will be using G-Suite (mostly Docs, Sheets, Calendar, and Gmail, with access to Colaboratory, Data Studio, Forms, Slides).
-
Knowledge of Marketo, Salesforce, Jira, Asana, or Confluence is helpful but not required.
- Partner with business/domain experts to understand the questions they have on their data
- Leverage modern BI tools (Tableau, Power BI, etc) to extract and manipulate data from a variety of diverse sources
- Perform analysis on datasets to understand data structure and possible metrics/visuals to answer business questions
- Present alternative ways for clients to visualize and consume their data
- Work as part of a larger visual analytics team partaking in collaboration and assisting others when needed
- Research advanced analytics/visualization capabilities to improve client understanding of data insights
Please note that we unfortunately cannot provide sponsorship at this time.
SALARY AND BENEFIT HIGHLIGHTS
At Amplify we take a holistic approach to total rewards in order to invest in the satisfaction and success of our employees both now and in the future. We consider the whole person and want to support our employees in living full lives both personally and professionally. The following is an overview of what you’ll get as a member of our team.
Salary Range: We are committed to equitable and fair pay practices. For this role, the base salary pay range is $90,000 - $120,000 a year. We consider a variety of factors when making compensation decisions and generally do not hire employees at the highest point of the pay range. We share this to ensure transparency, expectation-setting and education for candidates considering opportunities with us.
-
100% remote work option
-
Flexible time off (time to recharge when you need it!)
-
11 observed holidays
-
Medical/dental/vision – employee is covered at 100%, dependents are subsidized
-
Parental leave, short-term disability, long-term disability, and life insurance options
-
401k program and Amplify matching up to 3%
-
‘Amplify You’ program – $1,000 annually for your own development or investment in well-being after one year
-
Student loan payback program
-
Mentorship and training opportunities
-
Business and employee referral bonus opportunities
OUR HIRING PRACTICES
At Amplify, all qualified applicants will receive consideration for employment without regard to age, race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran. We are committed to creating a diverse and welcoming workplace that includes all employees with diverse backgrounds and experiences. We believe it enables us to better meet our mission and values while serving clients throughout our communities. People of color, women, LGBTQIA+, veterans, and persons with disabilities are encouraged to apply. Qualified applicants with criminal histories will be considered for employment in a manner consistent with all federal state and local ordinances. Amplify is committed to offering reasonable accommodation to job applicants with disabilities. If you need assistance or accommodation due to a disability, please contact us at HR@amplifycp.com.
