Data Engineer

Role & responsibilities

• 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.

Preferred candidate profile

• 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.