Status: Part-Time/ Remote (U.S. Based Preferred) - USA Citizen
Duration: Mid-March 2026 - Early May 2026 (6-8 weeks, Flexible hours around Class)
Summary: Assurety Consulting & Solutions is an independent, Smithsonian-recognized technology company with 22+ years of legacy in the U.S. postal and mailing ecosystem, building production systems and data standards that remain in use today. We operate in two complementary verticals: (1) Product platforms—enterprise software and analytics solutions we build, operate, and continuously invest in; and (2) Services—professional and consulting engagements where we deliver domain expertise, requirements, and implementation support to help clients modernize regulated, mission-critical operations. This blend of product engineering and services execution—backed by ISO 27001 governance—lets Assurety move from requirements to working software quickly while maintaining reliability, scalability, and auditability.
Why Intern at Assurety: Interns at Assurety work on real, production-grade analytics products used by enterprise and public-sector clients. You will gain hands-on experience with data engineering, analytics, and BI workflows, collaborate directly with senior engineers and analysts, and see how requirements move from discussion to implementation. Assurety offers a fast-moving, high-ownership environment where interns are trusted with meaningful technical work and have a direct impact on active products.
About the Role: We are seeking a highly technical undergraduate intern to support two analytics products—TrackingAnalytics and ProspectingAnalytics—during an active development and demo phase. This role is hands-on and engineering-oriented, focused on preparing analytics-ready data, defining schemas, supporting Power BI datasets and dashboards, and assisting with requirements-related work.
Core Responsibilities
Data Discovery & Requirements Support
- Assist with data discovery by inventorying datasets, identifying gaps, and documenting assumptions and definitions.
- Support requirements work by translating discussions into structured artifacts such as field definitions and acceptance criteria.
- Help prioritize must-have versus nice-to-have data and reporting needs.
Data Cleaning, Normalization & Preparation
- Clean and standardize datasets (deduplication, missing values, format normalization).
- Normalize data and define reliable join keys for analytics and BI use cases.
- Perform basic data quality checks and document results.
ERD & Schema Development
- Draft and maintain Entity Relationship Diagrams (ERDs).
- Assist with schema design documentation, including table grain, relationships, and keys.
Power BI Dataset & Dashboard Support
- Prepare datasets for Power BI consumption.
- Assist with building and refining Power BI visuals and reports.
- QA dashboards to ensure accuracy and correct filtering behavior.
Required Qualifications
- Currently enrolled undergraduate student in Computer Science, Data Science, Engineering, MIS, Statistics, or related field.
- Strong working knowledge of SQL.
- Experience using Python for data analysis (pandas or similar).
- Understanding of relational data modeling concepts.
- Strong documentation and communication skills.
Preferred Qualifications
- Experience with Power BI.
- Familiarity with data warehouse or dimensional modeling concepts.
- Experience performing data validation or profiling.
|
Click here for technical assistance.