Senior Data Engineer
Remote · United States
Posted on Thursday, May 11, 2023
Imagine yourself here!
OpenGov is a mission driven fast-growth, Series D, venture backed startup (includes Andreessen Horowitz, Formation 8, and Emerson Collective). Our Board of Directors includes iconic Silicon Valley executives John Chambers (former Cisco Chairman and CEO) and Marc Andreessen (Time Magazine’s list of the 100 most influential people in the world).
OpenGov is the leader in modern cloud software for local governments and state agencies. We have surpassed 1,800+ governments (and growing fast!) using our products in our mission to power more effective and accountable government.
OpenGov is a 2023 Top Workplaces USA award winner and a Forbes 2022 America's Best Startup Employer!
The Senior Data Engineers primary responsibility will be to balance the health of our data platform with the development of new integrations, pipelines, and data models. In this role, you will also manage the production support and enhancement of our existing BI and Data Warehouse tech stack. This role will be expected to learn and support Enterprise Data processes and software practices to proactively manage platform processes and ensure the highest quality of data. Developing strong relationships with business partners in the GTM, G&A, and R&D organizations is essential to success in this role. Prior experience in Data Warehousing and Data Integration/ELT technologies, coupled with your ability to understand complex data models and flows, will enable the incumbent to excel in this role.
•Design and implement data solutions and related integrations with industry best practices
•Design and implement efficient ETL and ELT processes to manage the data flowing into and out of the Data Warehouse in accordance with data governance and security standards
•Monitor and maintain data pipelines and system integrations proactively to ensure high service availability. •Systems may include Salesforce, Jira, Intacct, Netsuite, Zuora, Mavenlink (PSA), Zendesk, Pendo, ProductBoard, MixMax, Gainsight, Gong (CI), and Marketo
•Help to define and improve our internal standards for style, maintainability, and best practices for a reliable data infrastructure
•Build and leverage internal and external partnerships across GTM, G&A and R&D organizations, turning business goals into technical solutions
•Assist in driving instrumentation and optimization of the data warehouse and systems integrations processes
•Ensure data accuracy by following standardized structures and practices for dissemination and communication with appropriate departments
•Comfortable breaking down complex data and integrations to technical and non-technical staff members
•Drive business stakeholder meetings to gather requirements and make system integration, pipeline and reporting/BI recommendations
•Conduct analysis and ongoing monitoring of available data, refinement, data and BI roadmap and feedback, scrubbing to improve existing data integrity
•Understand what good looks like and the change management required to get there
•Develop a deep understanding of the various business processes, data sets and data team deliverables
Requirements and Preferred Experience:
•Bachelor’s degree in Information Technology, Computer Sciences or related field (equivalent experience may be substituted for formal education)
•8+ years of experience in Business Systems, IT, Data Engineering or similar technical role
5+ years of experience in Data Engineering, Warehousing and Systems Integrations; 2+ years of experience with DBT
•Experience with Salesforce, Support Platforms (Zendesk or Service Cloud), Mixmax, Outreach or Salesloft, Gainsight, JIRA, Intacct or Netsuite, Zuora, Professional Services Platforms (Mavenlink, FinancialForce, etc.)
•Knowledge of enterprise SaaS applications and integrations
•Experience working with
•business intelligence tools and concepts (Domo, Tableau, Looker, etc.)
•data warehouses (Redshift or Snowflake)
•working with ETL and/or ELT tools (Snaplogic, Workato, and Fivetran)
•iPasS experience maintaining and building integrations (Mulesoft, Snaplogic, Dell Boomi, etc.)
•Demonstrated proficiency working with SQL, Python, GIT and CI/CD pipeline
•An “end-to-end” data owner who believes in owning the whole stack from data source to cleaning to dashboard and stakeholder communication
•Propensity and passion for problem solving, both conceptually and analytically, focused on optimizing strategy and process to continually provide valuable insights.
•Organized professional, with the ability to manage multiple projects for multiple stakeholders with varying specifications
•Ability to remain focused and flexible, working in a fast-paced environment with rapid change
•Strong process and documentation skills, with the ability to connect process gaps with data integrity needs and to manage across teams to refine workflows
•Strong written and verbal communication skills
•Experience working with SaaS applications built on AWS or Azure platforms is preferred
What makes OpenGov unique
» Leadership: CEO Zac Bookman (MPA from Harvard and JD from Yale) is truly a mission-driven CEO. He was named one of the 100 most Intriguing Entrepreneurs by Goldman Sachs, a Tech Pioneer by the World Economic Forum, and SF and Silicon Valley Business Times' 40 under 40 class of 2018!
» Funding: Over $250 million, Series D company, from top tier investors including Andreessen Horowitz, 8VC, Cox Enterprises, and Emerson Collective.
» Board of Directors: Includes iconic executives John Chambers (former Cisco Chairman and CEO), Marc Andreessen (Time Magazine’s list of the 100 most influential people in the world), Katherine August-deWilde (Vice Chair of First Republic Bank), and Amy Pressman (co-founder, former president, and a current board member of Medallia).
» Growth: Record breaking growth with 1,800+ governments (and counting) using our products. Click here to read more.
» Culture: Winner of 2023 Top Workplaces USA award, Winner of Forbes 2022 Best Startup Employers, 50 Best Workplaces award. Check out our Careers Video!
» Perks: 90% paid Medical/Dental/Vision premium for employees, fully paid Life and Short/Long term disability insurance, Unlimited PTO, Parental Leave policy, monthly fitness stipend, anniversary awards, and more!
» Product: Named to the GovTech 100 (seven consecutive years), we are the leader in cloud software for our nation's cities, counties, and state agencies.
» Mission Driven: We are a technology company with a passion for the mission. We're powering more effective and accountable government.
Come join us and make a positive social impact!
OpenGov is an equal opportunity employer. All applicants will be considered for employment without attention to race, color, religion, sex, sexual orientation, gender identity, national origin, veteran or disability status.