Data Warehouse & SQL Analyst (ETL)

Ask IT consulting; Chicago (IL); On-site; USD 85,000 - 120,000; Full time

Job summary

ASK IT consulting is seeking a Business Systems/Data Analyst for a client project in Chicago, IL. The role focuses on data warehouse expertise, SQL development, and data modeling to support enterprise data initiatives.

You will collaborate with ETL architects, perform data validation, and translate business needs into system requirements. Strong communication with stakeholders is essential, including documenting mappings and requirements.

Qualifications

• 5–7 years of Data Warehouse experience.
• Minimum 5 years of SQL used in a technical setting.
• Experience modeling transactional databases and data warehouses.
• Experience with data modeling, ER diagrams (ERDs), and data flow diagrams (DFDs).
• Experience creating data mappings and data migration requirements.
• Experience coordinating testing life cycle including UAT.

Responsibilities

• Collaborate with ETL Architects and specify data mapping via Data Mapping Documents.
• Lead data validation and integrity testing using SQL queries.
• Develop and refine functional specs for data migration and BI automation.
• Create use cases, test plans, and design artifacts with MS Word and Visio.
• Gather requirements with stakeholders and SMEs through JRP/JAD sessions.

Skills

Data Warehouse

SQL

Data Modeling

ETL

Requirements Gathering

UAT

Tools

ERWin

MS Word

Visio

Job description

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

Job Description

• 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.
• 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 Information

Website: http://www.askitc.com/

By clicking the link above or any third-party link within this posting, you are leaving this site and going to a third-party website where the third-party website's terms and privacy policy apply