ETL Engineer
ETL Engineer
This job is no longer open
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 ERP software for our nation's cities, counties, and state agencies. We have surpassed 1,000+ governments (and growing fast!) using our products in our mission to power more effective and accountable government.
OpenGov is a 2021 Top Workplaces USA award winner!
OpenGov seeks to expand its proven Professional Services (PS) team with an experienced ETL Engineer to deliver quality integration processes for our customers. The PS team is focused on making our 2000+ government organizations wildly successful. This role will be responsible for turning technical integration designs into robust Extract-Transform-Load integration layer processes using industry-standard tools, languages and methods between OpenGov and third-party systems. The ETL Engineer will be a hands-on technologist who will understand data storage, modelling, architectural and testing concerns and will use this knowledge to deliver results that will delight our customers.
Responsibilities:
• Building reliable ETL (Extract-Transform-Load) processes to facilitate data transfers between homogeneous or heterogeneous source and target systems.
• Should have practical hands-on experience of ETL platform(s) such as Snaplogic (preferred), MuleSoft, Informatica, Talend, Pentaho
• Familiarity with industry standard ETL tools such as SQL, Scripting Language(s), Data modelling techniques, Relational and NoSQL Database engineering & configuration
• Should have at least two years of experience in coding in at least one programming language (Java & Python preferred)
• ETL Testing and Troubleshooting: after setting up the system, the ETL Engineer must test it to ensure that it is operating smoothly and fix any issues that may arise. Such system tests can be carried out by testing the unit Data Models, system performance test, uploading / downloading / querying speed tests, Data Flow Validations, etc.
• To build repeatable documentation assets to enable implementation teams to take advantage of pre-built assets
• To identify data storage requirements, determine the storage needs of the customer. A high-level view of the data situation is required to choose the best available options.
• Help develop a repository of ETL knowledge out of the on-going work with customers and utilize that to enhance the quality, speed, and productivity of the team.
Requirements and Preferred Experience:
• At least 3 years of experience in a role encompassing industry-standard ETL development techniques
• Proven experience with ETL and database technologies.
• An understanding of SaaS solutions and Cloud technologies.
• A detailed technical understanding of disparate data sources and targets
• Deep technical knowledge of data validation, cleansing, transformation, consolidation, de-duplication, aggregation, de-aggregation, enrichment
• Knowledge of data transactional requirements, business logic pertaining to commit and rollback cycles and how to implement to preserve the integrity of related data elements in financial and similar systems
• Experience with data analysis and profiling of source data while developing / building robust ETL processes
• An understanding of how to build ETL processes for scale and performance to meet promised SLAs
• To build ETL processes that apply to data migration and data integration scenarios, to know their key differences
• Proven expertise with scripting and basic programming, including Javascript, shell script, Python, Visual Basic and Cobol
• Ability to adapt to a rapidly changing product and respond strategically to customer needs.
• Strong interpersonal skills and a track record of building collaborative relationships.
• Strong organizational and multitasking skills with ability to manage multiple simultaneous projects
• Experience with API level testing
• Experience with Agile & Scrum methodologies
• Adeptness at writing actionable bug reports using software like Jira
• Proficiency at balancing multiple efforts simultaneously and meeting strict deadlines
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: $200 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,000+ governments (and counting) using our products and seven acquisitions in the past six years! Click here for read more.
» Culture: Winner of 2021 Top Workplaces USA award, Forbes 2021 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 (six consecutive years), we are the leader in cloud ERP 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.
This job is no longer open