PLANOLY is the industry-leading social marketing platform trusted by over 5 million users to visually plan, schedule and measure performance across Instagram and Pinterest. PLANOLY is beautifully crafted to be simple, clean and easy to use. PLANOLY believes firmly in inclusivity and is thrilled to pave the way for brands, businesses and individuals of all backgrounds to carry out their digital marketing strategies seamlessly. To learn more, visit www.planoly.com, or follow @PLANOLY on Instagram.

We are looking for a thoughtful, well-rounded Data Engineer to join our rapidly growing startup and work on building data management, data tools and data analytics services that help power business decisions. Our software platform that influencers, brands, agencies and marketing firms use daily gives us an incredibly rich and diverse dataset that we need to collect, transform, and analyze in order to improve effectiveness of our products as well as impact business decisions. You will have the opportunity to take a leading role in our engineering team and help solve some challenging problems in the social media marketing space. Passion for social products and building great software is a must.

Tools We Use

• Amazon Web Services
• Google Cloud
• Google BigQuery
• Google Data Studio
• dbt
• Python

What You Will Do

• Data Modeling / Architecting via designing data models and implementing appropriate abstractions for immediate requirements.
• Understanding data lineage and dependencies, and develop and maintain existing ETL processes.
• Work with leadership, product, engineering, and marketing to productize answers to business questions. Communicate results using reproducible analysis methods and data visualizations.
• Monitor the quality of data and information, report on results, identify, and recommend system application changes required to improve the quality of data in all applications.
• Manipulate and analyze complex data from multiple sources and design, develop and generate ad hoc and operational reports in support of other teams and objectives.
• Design and build scalable micro services hosted in AWS using Python3.7 and/or NodeJS TypeScript.
• Design, implement and manage data warehouse plans for our group of products.
• Support existing data data services and processes running in Production.
• Collaborate closely and autonomously with a small team of engineers, designers and cross-functional users to understand data needs.

Who You Are

• Bachelor’s degree in Computer Science or equivalent STEM field, or 4+ years of relevant work experience.
• Experience writing SQL queries and creating SQL based data models. Bonus: using dbt
• Experience communicating data analysis to business and peers, using data visualizations and reproducible analysis. 
• 3+ years of professional experience building scalable software.
• Ability to work on green field projects with relatively minimal guidance.
• Ability to collaborate with other engineers, QA, and non technical people.
• Strong foundation in database systems (relational and non-relational).
• Experience with data warehousing solutions (Redshift, Big Query, etc).
• Proficiency with Python (2+ years) and TS NodeJS (1+ years).
• Strong understanding of serverless micro service architecture in the cloud (AWS, GCP).
• Using version control (e.g. Git).

Bonus Skills and Experience

• Experience in Linux command line and writing shell scripts.
• Working knowledge of DevOps tools including Jenkins, Docker, etc.
• Experience with AWS technology: SES, SNS, SQS, EC2, Elasticache, KMS, S3, etc.

Who We Are

• We are digital marketing and social media experts. PLANOLY was built from a Brand and Influencer’s perspective so we understand how to enhance and streamline the workflow of a digital marketer.
• We’re a startup that is growing super fast and has been profitable since inception.
• We offer an open work environment where highly motivated team members take full ownership of the products and help steer the company.
• We have a People First mindset: The guiding principle of our mentality is that the key to success is working with, learning from, and developing exceptional people.
• We are a huge advocate of work-life balance, which is seen in our open vacation and work-from-any-coffee-shops policies.
• We’ll provide you with catered lunches, snacks, drinks, and regular team outings.

** This role is not eligible for an employment visa.**

U.S. Equal Employment Opportunity/Affirmative Action Information

PLANOLY is proud to be an equal opportunity employer and will consider all qualified individuals seeking employment without regards to race, color, creed, religion, gender, gender identity, national origin, citizenship, age, sex, marital status, ancestry, physical or mental disability, veteran status, sexual orientation, or any other protected classification.