Software Engineer II, Data

Summary

Join Juniper Square's growing Data Engineering Team as a Senior Data Engineer to build and evolve data and reporting experiences. You will design and implement sophisticated data models in SQL, collaborate with software engineers for scalable implementation, and document data models and architectural decisions. Responsibilities include assisting with governance and code reviews, learning the application data schema, and driving instrumentation for product usage reporting. This role requires a Bachelor's degree in Computer Science or equivalent experience, 3-5 years of ETL/ELT pipeline experience, strong Python skills, relational database experience (Postgresql preferred), cloud service experience (AWS RDS preferred), and BI/data visualization platform experience. Juniper Square offers various work arrangements, from fully remote to working in physical offices.

Requirements

• Bachelor's degree in Computer Science or equivalent work experience
• 3 to 5 years of experience contributing to ETL (Extraction Transform Load) or ELT (Extraction Load Transform) pipelines
• Strong command of Python and experience building production web applications using Python
• Experience with relational databases (Postgresql preferred), data modeling and database design
• Experience with cloud based services (AWS RDS preferred)
• Experience developing on (or administering) BI / data visualization platforms (ex. Looker, Tableau, PowerBI, Mode, Data Studio, Domo, QlikView etc.)
• You must be flexible and adaptable—you will be operating in a fast-paced startup environment

Responsibilities

• Design and implement sophisticated data models in SQL
• Work closely with the other Software Engineers to ensure sound, scalable implementation
• Document data models, architectural decisions and data dictionaries to enable collaboration, maintainability and usability of our analytics platforms and code
• Assist with governance, guidance, code reviews, and access controls so that we maintain consistency, quality, and business confidentiality as we scale analytics access across the company and to customers
• Learn our application data schema, develop a fluency in how to transform it to enhance customer’s decision-making with data
• Drive instrumentation and development of foundations for product usage reporting for internal users

Benefits

Juniper Square offers employees a variety of ways to work, ranging from a fully remote experience to working full-time in one of our physical offices