Data Analyst
- Location
- Chicago, IL · On-site
- Job type
- Full-time
- Level
- Mid-level
- Experience
- 5+ years
- Listed
- Yesterday
Skills & highlights for this role
- SQL
- data warehousing
- ETL data validation
- data mapping
- ERD modeling
Also useful
- Erwin
How well does your resume fit this job?
Upload your resume to see your score for this Ask IT consulting role, what matches, what's missing, and your best other matches.
Scored on our server and not saved there. The file stays in this browser so you don't have to upload it again after you sign up.
About the role
- Data Warehouse Experience 5 to 7 years
- SQL used in a technical setting minimum 5 years
- Experience in modeling transactional databases and data warehouses using tools like Erwin and in performing data mapping and involved in receiving data feed from updated data sources.
- Collaborate with ETL Architects and created the DMD (Data Mapping Document) to specify the data mapping from various data base sources to the target database.
- Conduct data analysis, data profiling on candidate data sources.
- Strong SQL experience: Experience in conducting ETL data validation and data integrity tests on the database using SQL queries.
- Experience creating business requirements for data migration from source applications to Enterprise Repositories using Mapping documents, Source to Target Transformation Documents.
- Experience with data modeling, Entity Relationship Diagrams (ERDs), process modeling and Data Flow Diagrams (DFDs).
- Experience in feasibility studies, document generation, conducting Joint Requirement Planning (JRP), Joint Application Development (JAD) sessions for requirements gathering, analysis, design through interviews, workshops with user(s), Subject Matter Experts (SME's), and business stakeholders.
- Requires excellent analytical skills to understand the business and functional requirements and to translate them to system requirement specifications.
- Experience in developing functional specifications for business process refinement, re-engineering, business process modeling, business intelligence and automation.
- Experience in creating use cases, test cases, test plans, wireframe diagrams, sequence diagrams, class and object diagrams, activity diagrams, collaboration diagrams using MS Word and Visio.
- Experience in conducting GAP analysis, Strength Weakness Opportunities Threats (SWOT) analysis, risk analysis and mitigation plan, cost benefit analysis and Return On Investment (ROI) analysis.
- Experience working on the testing lifecycle, understood various kinds of testing which include Black Box, Gray Box, White Box, Unit testing, Parallel testing, Usability testing, Performance, Load and Stress testing.
- Experience conducting User Accepting Testing (UAT) with users and stakeholders
- Expert level, analytical, proven organizational and problem solving skills, effective verbal and written technical communication skills.
Proven Business Analyst experience working with business customers for requirements gathering
About the Company
Additional Information
Ask IT Consulting Inc.| 33 Peachtree St., Suite 100 |Holtsville, NY 11742
Website:
Equal opportunity and legal notices
ASK IT consulting is an equal opportunity employer, which is a global staffing, consulting and technology solutions company, offering industry-specific solutions to fortune 500 clients and worldwide corporations. We have openings for Business Systems/Data Analyst for one of our client at Richardson, TX or Chicago, IL
From Ask IT consulting's careers page, first listed on Rolev.ai on November 20, 2026. Rolev.ai is not the employer.
How Rolev.ai helps with this application
Rolev.ai is a job search and application tool for US job seekers. For this Data Analyst role at Ask IT consulting, it shows how your resume fits, tailors your resume to the posting, and prepares the application for you to review.
See how you fit
Openings from employer career sites are ranked against your whole resume—and searchable inside Claude, ChatGPT, and Cursor via Rolev.ai MCP.
Tailor without inventing
Every change to your resume is checked against your original. New experience goes in only with your yes—zero fabricated claims.
Draft the full kit
Tailored and Full Match resumes, role-specific cover letters, and answers to employer screening questions are prepared in seconds.
1-Click Extension Autofill
The Chrome extension fills the employer's Greenhouse, Workday, Lever, or Ashby form in 1 click. You review it and press Submit.
Similar roles
All Data Analyst jobs- Data Analyst Staff F 35 Level 4 Fort WorthLockheed Martin · Fort Worth, TX · $105k – $195k/yr
- Experienced Feasibility Informatics AnalystMedpace · Cincinnati, OH
- Data Analyst (Entry Level)Aston Carter · Hatfield, PA
- Digital Business Data AnalystFive Guys · Alexandria, VA
- Data AnalystTEKsystems · Fairfield, CA
- Senior Sales Enablement Data & AI AnalystStandard Industries · Parsippany, NJ
Common questions
Where is the Data Analyst job at Ask IT consulting located?
This Data Analyst position at Ask IT consulting is located in Chicago, IL (On-site). Always check Ask IT consulting's application page for specific state eligibility or relocation policies.
What qualifications are required for Data Analyst at Ask IT consulting?
For the Data Analyst role, Ask IT consulting highlights 5+ years of relevant experience; experience with SQL, data warehousing, ETL data validation, data mapping, ERD modeling. Rolev.ai can score your existing resume against these requirements and show any skill gaps before you apply.
How do I apply for the Data Analyst position at Ask IT consulting?
This listing links directly to Ask IT consulting's SmartRecruiters application page. You can apply directly on Ask IT consulting's site, or use Rolev.ai to check your resume fit, generate a zero-hallucination tailored resume and cover letter for this posting, and autofill the SmartRecruiters application form in 1 click with the Rolev.ai Chrome extension. You always review the form and press Submit yourself.