ETL Developer (Hybrid)

ETL DeveloperWashington DC Area/ HybridSummit Consulting, LLC, is a quantitative and qualitative analysis firm that uses economics, statistics, and data science to solve problems for our federal and private-sector clients. Our services in federal infrastructure finance, evidence-based program evaluation, program and business modernization, and enforcement analytics help make government effective and society just.We pride ourselves on maintaining a collaborative workplace built on diverse thought, learning, and trust. We are looking for a data engineer to build data integration solutions that help federal agencies analyze data more efficiently and run their agencies more effectively. We are committed to creating an environment that empowers people to do their best work!We currently have an opening for a ETL Developer! This position involves working with various clients to provide data-driven solutions that drive real change in both government and commercial non-profit missions.Apply to this position if you enjoy:Creating cloud-based solutions to facilitate the missions of critical government agencies and private-sector companiesCollaborating with a cross-functional team of business analysts, data scientists, and other engineersDeveloping solutions for customized software and data pipelines using modern cloud computing servicesCollaborating closely with project managers to design and execute development sprints, drive iterative progress, and effectively integrate client feedback into ongoing projects Requirements for this position include the following:5+ years of experience programming in Python and SQL4+ years of experience developing and maintaining database stored procedures, views, and functions4+ years of experience developing and maintaining efficient data pipelines, addressing data challenges such as inconsistency, quality issues, and complex transformations in Microsoft Azure (AWS also acceptable)4+ years of experience configuring and interfacing with cloud storage such as S3, EFS, and EBS3+ years of experience in database design and implementation3+ years of data warehousing experience with Redshift, Snowflake, etc.Experience using Airflow and DatabricksExperience using containerization toolsBachelor's degreeAbility to obtain a public trust clearanceWe offer a collaborative and rewarding work environment where we value your input, experience, and professional development. We do our best to match your education and talents to the work, and we provide you an integration partner to help you learn the ropes and become a productive team member. Our Washington, DC location, near the U.S. Capitol and the Chinatown metro, means you can easily access our offices using public transportation.If Summit selects you to move forward, you can expect to talk to our recruiting staff for an initial behavioral phone screen. That interview can lead to a secondary interview with staff members to discuss the technical aspects of your education and experience, your ability to work collaboratively to consult and provide client service, and the type of culture in which you like to work. If we select you for further consideration, be willing to submit to a background check.Summit strives to ensure that our career website is accessible to all, including individuals with disabilities. If you are a qualified individual with a disability or a disabled veteran, you have the right to request reasonable accommodation. Please email us at peopleops@summitllc.us you are unable or limited in your ability to use or access our website as a result of your disability.Summit is an equal opportunity employer, and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, or protected veteran or disability status.EEO is the law. Click to view information on your protections under Federal Law from discrimination.Summit Consulting, LLC