Data Engineer (502)

About Amplify Amplify Partners, voted one of Washington’s 100 Best Places to Work 2019-2021, is a Pacific NW company focused on creating a new approach to consulting. We invest in our consultants through mentorship, advancement, and empowerment. We believe in complete transparency with our clients, even when transparency is hard. We bring our thought leadership to the table and execute with rigor to develop meaningful long-term partnerships with our clients. The Role Amplify is looking for a Marketing focused Data Engineer to join our Analytics team. In this role, you’ll build data pipelines and models primarily with newer technologies like Matillion, Snowflake & DBT. Knowledge of Fivetran or Rivery is a bonus. Regardless of the tools, you’ll work with a solution architect to devise modular code and metadata-driven processes that are easy to scale and easy to understand. Any given project will involve a mix of technical and non-technical stakeholders, so you’ll also communicate and document your work for a range of audiences.  You’ll allocate most of your time and energy on hands-on client work. However, if your ambitions include scoping projects, honing technical best practices, or developing new business, then we’ll ensure you have opportunities to test the waters.   You will help build state-of-the-art pipelines data models, and ML Models that are at the heart of the decision-making process. The successful candidate will bring an attention to detail along with modern engineering practices and help us build a high quality, modern data architecture at scale.    What makes you a great fit?  

• You’re an all-around data geek who finds satisfaction in solving data problems and creating orderly systems. 
• Familiarity with Google Analytics, Adobe Analytics, Marketo, Marketing Cloud, mobile data
• Output is for marketing leadership; ideal if the candidate has worked directly with marketing leaders
  
• You’ve spent years writing complex SQL queries on a daily basis and have mastered the art of turning plain-English business requirements into SQL. 
• You have your Snowpro Certification!
• You’ve built production data models from scratch following (or inspired by) a star schema.
• You have at least a working knowledge of DBT, Matillion and/or Snowflake, and are eager to dive deeper into additional technologies like Fivetran, Databricks, Synapse, and Data Factory  
• You aren’t necessarily a visualization expert, but you’ve spent enough time in reporting tools (like Power BI, Tableau, or Looker) to understand how they interact with data models. 
• You have a knowledge of marketing analytics and combining revenue to marketing campaigns from disparate data sources
• You’ve at least dabbled in a scripting language (including procedural SQL) and can share examples of tasks you’ve automated. 
• Your communication is clear and concise through every medium

SALARY AND BENEFIT HIGHLIGHTS   We consider a variety of factors when making compensation decisions. We share this to ensure transparency and set expectations for those considering opportunities with us.The beginning salary range for this role is $110,000 - $140,000.As you excel at Amplify, there is potential for salary increases and promotions. If you were to remain in this role, there is earning potential for this level of $160,000.

• PTO – 3 weeks (accrual based)
• 10 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
• 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.