About Inroads: Inroads applies data, analytics, technology, research, and content development to co-create services and programs that are personalized, relevant, and engaging for the communities who rely on them. Our deep understanding of digital services, policy implementation, and ways communities consume information allows us to seamlessly integrate with organizations and public sector teams to revolutionize the ways they deliver complex services at scale.
About the role: As a Data Engineer II, you will play a critical role in our database upgrade roadmap, in support of our work for Healthcare.gov. The Data Engineer II will work with complex and nuanced data pipelines and will be responsible for the continuous development, review, and documentation of data wrangling and pipeline solutions.You should have experience working in a rapid development team in the past in which you were responsible for significant contributions to client data pipeline solutions.
In this position you will: - Develop, test, and operationalize the data pipelines that power our analytics
- Provide visibility into data transformations by designing and implementing data tests throughout existing pipelines.
- Extract business logic (ETL/ELT, metrics, metadata) from current data systems into portable cloud-agnostic layers.
- Analyze, build, and deploy data models, including relational models for data warehousing.
- Plan and maintain data architectures that are aligned with business requirements.
- Produce scalable, replicable code and engineering solutions that help automate repetitive data management tasks.
- Work closely with data analysts to understand, identify and effectively respond to their specific needs.
- Work as part of a team to maintain a well documented, consistent codebase.
What we are seeking: - 5+ years of work experience working with data-driven decision-making
- Expertise with developing Python scripts and SQL queries
- Experience using Jinja to templatize SQL
- Experience with developing DAGs using Airflow
- Expertise with developing and optimizing SQL queries for Snowflake
- Clear understanding of micro-paritioning and data clustering in Snowflake
- Experience using AWS technologies like S3 storage and EKS
- Experience working with production grade data warehouses using SQL queries and scripting languages (e.g., Python, R).
- Experience with SQL transformation tools like dbt.
- Strong background in database design and data modeling.
- Additional skills we like to see include experience with Snowflake, implementing a modern data stack, and contributing to large scale data migration efforts.
- Effective communication skills when working with team members of varied backgrounds, roles, and functions.
- Ability to manage your individual priorities and comfortably context-switch between active development, client discussion, and issue response.
- Leadership competencies in the following: empathy, active listening, coaching/feedback, integrity, decisiveness, and problem solving and/or experience as a people manager, mentor, or thought partner to your teammates.
- Passion in applying your skills to our social mission to problem-solve and collaborate within a cross-functional, client-facing team environment.
- The ability to successfully attain and maintain a Federal Public Trust background investigation that our government clients require; this includes a requirement that the individual has U.S. Citizenship or U.S. residency for three of the past five years.
Who you are: - You draw conclusions from data with ease and comfortably relay your point-of-view - particularly when you need to interrogate insights with your team or clarify unknown factors with clients and stakeholders.
- You make connections between the big picture and operational needs, and drive reconciliation of the two.
- You often think about how complex systems can be improved - and are willing to roll up your sleeves to do something about it.
- You have a track record of successfully collaborating with internal and external stakeholders by translating their needs into code.
What We Offer: Inroads offers a friendly work environment and competitive compensation and benefits package including:
- Salary: $95,000 - $115,000
- Premier health insurance plan
- 401K matching
- Unlimited vacation leave
- Paid sick, personal, and volunteer leave
- 13 paid holidays
- 15 weeks paid parental leave
- Professional development stipend & tuition reimbursement
- Employee Assistance Program (EAP)
- Supportive & collaborative culture
- Flexible working hours
- Remote friendly (within the U.S.)
The salary range for candidates who meet the minimum posted qualifications reflects the Company's good faith understanding and belief as to the wage range, and is accurate as of the date of this job posting.
To protect the health and safety of our workforce, as a company policy, Inroads strongly encourages all employees to be fully vaccinated against COVID-19 prior to beginning employment, and may ask employees to provide proof of COVID vaccination upon request, in each case unless the employee has an approved request for medical or religious accommodation or exemption, or except where prohibited by law. Inroads will evaluate requests for reasonable accommodations for applicants unable to be vaccinated due to a religious belief, disability, pregnancy, or on an individualized basis in accordance with applicable laws. Inroads adheres to all federal, state and local COVID-19 vaccination regulations.
At Inroads, we celebrate, support and thrive on differences. Not only do they benefit our services, products, and community, but most importantly, they are to the benefit of our team. Qualified people of all races, ethnicities, ages, sex, genders, sexual orientations, national origins, gender identities, marital status, religions, veterans statuses, disabilities and any other protected classes are strongly encouraged to apply. Inroads endeavors to make reasonable accommodations for qualified applicants with a disability unless the accommodation would impose an undue hardship on the operation of our business. If an applicant believes they require such assistance to complete the application or to participate in an interview, or has any questions or concerns, they should contact the Director, People Operations. Inroads participates in E-verify. EEO is the Law.
Collection of Personal Information Notice: As you are likely aware, by submitting your job application, you are submitting personal information to our company. We collect various categories of personal information, including identifiers, protected classifications, professional or employment related information and sensitive personal information. We may retain and use this information for up to three years, in order to come to a decision on whether or not you are a good fit for our company. We may also retain or use some of this information to comply with any requirements under law, or for purposes of defending ourselves in any litigation. We do not use this information for any other purpose, or share it with third parties, unless you become an employee. To learn more, or to see our full Notice to Job Applicants, please click here.