About ER CompWiz
A Chicago technology and data services firm, founded in June 2023.
Who we are
ER CompWiz works on projects where data volume is high and accuracy matters. That includes survey research, transportation, aviation and public health.
Our team has over 25 years of combined experience in data management, software and systems development, workflow automation, cloud infrastructure, digital platforms and project coordination. We match the people and skills to what each project needs, so a small engagement stays lean and a large one gets the depth it requires.
We’re certified as a minority- and woman-owned business by the State of Illinois, the City of Chicago and Cook County, and certified by WBENC and NMSDC.
How we work
Document everything
Procedures, database objects and quality checks are written down, so your team can maintain and audit the work after we hand it off.
Check before we deliver
QA/QC is built into every workflow. Data is checked for consistency and completeness before it goes into analysis or a report.
Keep data secure
We keep data environments organized and transfer files securely, especially for high-volume and sensitive datasets.
Our skills
Specialists on the team cover:
- Database programmingSQL Server, SSIS, stored procedures, MySQL and MongoDB
- ETL and data pipelinesAutomated extraction, transformation and loading
- Process automationPython, PowerShell, Bash and spreadsheet automation
- QA/QC oversightValidation workflows and documented quality standards
- Cloud and systemsMicrosoft Azure, Google Cloud, Linux and Windows deployment
- Project coordinationField operations, tracking, reporting and Agile delivery
Have a data problem or a bid that needs a data partner?
Tell us what you’re working on, and we’ll follow up.