This description is a summary of our understanding of the job description. Click on 'Apply' button to find out more.

Role Description

The Data Engineer III is responsible for consistently designing, developing, and operationalizing data analysis and visualizations for the Granicus platform and internal reporting. This experienced role will make key architectural decisions about the development of the Granicus data stack, write maintainable code, and debug production issues across the data ecosystem. This new resource will be key in alleviating the reporting and import/export backlog.

• AWS Expertise: Design, implement, and optimize data solutions leveraging AWS services (Lambda, Glue, S3, Redshift, Step Functions, Kinesis) for seamless data ingestion, transformation, storage, and real-time processing.
• Data Pipelines and ETL: Develop robust ETL processes, ensuring accurate and timely data movement across platforms.
• Stream Processing: Design and implement real-time streaming solutions to handle high-velocity data flows for timely insights.
• Python and Pandas Mastery: Employ Python and Pandas for advanced data cleaning, manipulation, and analysis.
• Data Warehousing and Modeling: Architect and maintain optimized data warehouses and data lakes, along with designing and implementing effective data models for efficient querying and analysis.
• Query Optimization: Proactively tune query performance and data models to deliver fast and reliable data access.
• Consistently design, develop, and operationalize data analysis and visualizations for the Granicus platform and internal reporting that is well-tested and stable.
• Make key architectural decisions about the development of the Granicus data stack.
• Write concise, legible, and maintainable code in support of data analysis and reporting.
• Debug production issues across the data ecosystem.
• Collaborate effectively in a remote team setting, communicating proactively and demonstrating a strong sense of ownership.

Qualifications

• 4+ years of experience in designing, implementing, and providing production support for highly reliable and scalable data systems, ideally with some of that experience at an early-stage startup.
• Expert level experience in SQL and data lake architectures.
• Strong working knowledge and experience developing in SQL, Typescript, and Python.
• 3+ years of experience maintaining and developing data visualizations and reporting in Snowflake, including cost management and performance tuning.
• A desire to craft great data analysis and reports that meet our customers’ and internal business needs.
• The ability to work collaboratively in a remote team setting by communicating proactively and demonstrating a strong sense of ownership.
• The ability to show empathy towards your coworkers and our customers.

Requirements

• Responsible for Granicus information security by appropriately preserving the Confidentiality, Integrity, and Availability (CIA) of Granicus information assets in accordance with the company's information security program.
• Responsible for ensuring the data privacy of our employees and customers, their data, as well as taking all required privacy training in a timely manner, in accordance with company policies.

Benefits

• We are a remote-first company with a globally distributed workforce across the United States, Canada, United Kingdom, India, Armenia, Australia, and New Zealand.
• At Granicus, we are building a transparent, inclusive, and safe space for everyone who wants to be a part of our journey.
• A few culture highlights include – Employee Resource Groups to encourage diverse voices.
• Coffee with Mark sessions – Our employees get to interact with our CEO on very important and sometimes difficult issues ranging from mental health to work-life balance and current affairs.
• Microsoft Teams communities focused on wellness, art, furbabies, family, parenting, and more.
• We bring in special guests from time to time to discuss issues that impact our employee population.