
Open since Jun 2014
Data Analyst
AI Summary
Business Systems/Data Analyst with 5-7 years of data warehouse experience, SQL, and data modeling. Collaborates with ETL architects, creates data mapping documents, conducts data analysis and profiling, and supports requirements gathering, testing, and business process refinement.
About this role
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
- 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
## Additional InformationAsk IT Consulting Inc.| 33 Peachtree St., Suite 100 |Holtsville, NY 11742
Website: http://www.askitc.com/
Skills
Explore related jobs
More jobs at Ask IT consulting
Similar Data Mapping jobs
- S
DO178B, HSIT, SSIT, Black box testingSQUIRCLE IT CONSULTING SERVICES PVT. LTD · Bengaluru, KA - B
Entry Level QA Jobs White BOX Testing/ Black BOX TestingBeta Soft System Inc. · Fremont, CA - U
QA with Black Box Testing----------------Need GC,USC,OPT,EAD------------------------Need LocalsUSM · Cape Maclear, Southern Region - G
Software Development EngineerGlobal Channel Management, Inc. · Cambridge, MA - G
Senior Systems Engineer - Cryptographic SystemsGeneral Dynamics Mission Systems · Dedham, MA - G
Senior Systems Engineer - Cryptographic SystemsGeneral Dynamics Mission Systems, Inc · Dedham, MA
Jobs in Chicago
- SPart-Time Cook (Interim Housing Shelter)Sarahs Circle · Chicago, Illinois
- N
HR Generalist- Employee Relations & TalentNight Ministry · Chicago, Illinois - G
General Dental AssistantGreat Lakes Dental Partners · Chicago, Illinois - E
Fitness AttendantEast Bank Club · Chicago, IL - CStrategic Accounts Sales ExecutiveConfidential Se · Chicago, Illinois
- R
Maintenance ManagerRPM Living · Chicago, IL
Browse these categories
Market data for this role
All reports →- SeriesRole reportsOne role family at a time: how many openings, what changed this week, who is hiring, what it pays.
- SeriesSalary reportsWhat employers publish in job postings, by level and workplace. Not self-reported pay.
- Market overviewState of tech hiring, September 2026: up 4.8%Tech hiring rose 4.8% month over month in September 2026, with 411,122 new listings. Customer support and account executive roles led the growth.