Senior Associate, Analytics

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 Senior Associate, Analytics, you will work with a team of analysts, data scientists, and engineers to deliver on a federal contract that ensures millions of Americans have the information they need to get access to affordable healthcare. This role will play an instrumental role supporting a team to create robust data models, troubleshoot issues, improve documentation, ensure data quality, and manage data automation. You will have a key role in managing a data platform that supports web applications via APIs as well as analytics workflows built by data analysts and data scientists. Your track record should reflect domain knowledge in data analysis, data modeling and ingestion, including experience adapting to changing technologies, business logic, and client priorities. This program aims to increase access to quality healthcare by supporting public outreach campaigns for Healthcare.gov. The Senior Associate, Analytics role sits within our Analytics and Data Science team, responsible for transforming raw data into clean, well‑modeled datasets and interpreting our data into actionable business insights. Positioned between data engineering and data analysis, this role utilizes SQL and dbt to build robust data pipelines, implement data quality testing, and maintain the foundational data models used for reporting and data science. In This Position You Will Create SQL-based data models in dbt. This includes working with data engineers, data scientists, and data analysts both to refactor legacy code, and to build new data transformations that meet business requirements for clients and consumers. Collaborate with analytics, product, and domain stakeholders to translate business needs into well‑modeled datasets. Work closely with Data Engineers to transition analytical logic into optimized warehouse queries, learning about database performance tuning and data warehouse architecture (e.g., Snowflake) on the job. Implement data quality checks (dbt tests, sources, freshness) and contribute to monitoring data reliability. Maintain clear documentation for datasets, lineage, and transformation logic. Query the data warehouse using SQL to answer urgent business questions, identify trends, and provide data‑backed recommendations to cross‑functional stakeholders. Design, build, and maintain dashboards and reports (using Report‑as‑Code, Positron, and Tableau) to track key business metrics and performance indicators. Gain a deep understanding of the Affordable Care Act (ACA) and its regulatory frameworks, learning how policy mandates, marketplace changes, and compliance rules directly impact enrollment behavior and messaging to consumers. Investigate data discrepancies to identify patterns and find solutions. Collaborate with engineers, data analysts, data scientists, program managers, and external stakeholders to troubleshoot problems and proactively create solutions. Take ownership of task areas and strive to independently resolve challenges in order to deliver accurate products on short deadlines. Complete such other reasonable tasks as may be assigned by management. What We Are Seeking 2+ years of applied experience working with structured/unstructured data. An undergraduate degree or higher in a quantitative field or equivalent technical training. Strong understanding of how to manipulate data using dbt, SQL, and Python. Experience optimizing data models for query efficiency. Ability to deeply research both the business logic of ingested data as well as the business logic needed to build derivative data products. Comfort with performing independent discovery. Interest in investigating problems, solving puzzles, and finding patterns in complex data, as well as proposing solutions that improve both technical performance and end user satisfaction. Comfort working independently to drive portions of larger projects, using organizational objectives and sound judgment to guide your work. Experience working in an Agile work environment, reviewing others’ work, and a strong grasp of version control (i.e., git). Passion in applying your skills to our social mission to solve problems and collaborate within a cross‑functional team environment. The ability to successfully attain and maintain a Federal Public Trust security clearance, as required by our government clients; this includes a background investigation and a requirement that the individual has U.S. Citizenship or U.S. residency for three of the past five years (36 of the past 60 months). Resumes should specify residency information for the past 5 years of experience. You May Also Have Experience Experience working with Medicare, Medicaid, or Marketplace data and systems Experience working with workflow execution engines, such as Airflow. Navigating cloud data environments like Snowflake, Google BigQuery, or AWS Redshift. Familiarity with R for basic data manipulation, automation, or statistical analysis. What We Offer Salary: $75,000 Premier health, dental, and vision insurance plans 401K matching Unlimited paid time off Paid personal and volunteer leave 13 paid holidays 15 weeks paid parental leave Professional development stipend & tuition reimbursement Macbook Pro laptop & tech accessories Bring Your Own Device (BYOD) stipend for mobile device Employee Assistance Program (EAP) Supportive & collaborative culture Flexible working hours Pre‑tax transportation options for commuting to our office in Washington, DC Lunches and snacks 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. #J-18808-Ljbffr Inroads