Design, model, and validate data warehouses and transactional databases. Perform data mapping, profiling, ETL validation, and create source-to-target documentation. Gather business requirements via JAD/JRP, produce functional specifications, diagrams, test plans, and lead UAT and testing lifecycle activities.
Company 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.
- 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/
Similar Jobs
Automotive • Professional Services • Software • Consulting • Energy • Chemical • Renewable Energy
Build enterprise financial and operational reporting capabilities, including executive dashboards, KPI frameworks, scorecards, self-service analytics, and trusted reporting datasets. Analyze complex data to identify trends and performance drivers, standardize metrics, improve data quality and automation, and partner with Finance, IT, and business leaders. Present actionable insights, support governance, document reporting methodologies, and coach analysts and stakeholders.
Top Skills:
Data ModelingEpmErpExcelMicrosoft Power BiSQL
Fintech • Software • Financial Services
Owns fraud and market-abuse detection models, rules, and partner-facing surveillance reporting across trading data. Investigates wash trading, collusion, hedging, reverse trading, and other suspicious activity; calibrates thresholds, validates false positives, maintains data quality, and produces evidence-based findings. Requires strong SQL, cloud data warehouse experience, futures and derivatives knowledge, anomaly detection expertise, and the ability to communicate findings to partners and executives.
Top Skills:
AthenaBigQueryPythonSQL
Fintech
Analyze exchange datasets across equities, FX, options, and futures; develop liquidity and order-book metrics; and create commercial, client-ready data products. Apply statistical and machine learning methods to identify patterns, anomalies, and predictive signals. Partner with engineering, sales, marketing, internal teams, and clients on data ingestion, normalization, cloud distribution, product specifications, competitive analysis, and market-data commercialization.
Top Skills:
AWSAws MarketplaceAzureDistributed Computing FrameworksGCPMachine LearningMarket Data ApisPythonReal-Time Data ProcessingSnowflakeSQL
What you need to know about the Chicago Tech Scene
With vibrant neighborhoods, great food and more affordable housing than either coast, Chicago might be the most liveable major tech hub. It is the birthplace of modern commodities and futures trading, a national hub for logistics and commerce, and home to the American Medical Association and the American Bar Association. This diverse blend of industry influences has helped Chicago emerge as a major player in verticals like fintech, biotechnology, legal tech, e-commerce and logistics technology. It’s also a major hiring center for tech companies on both coasts.
Key Facts About Chicago Tech
- Number of Tech Workers: 245,800; 5.2% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: McDonald’s, John Deere, Boeing, Morningstar
- Key Industries: Artificial intelligence, biotechnology, fintech, software, logistics technology
- Funding Landscape: $2.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Pritzker Group Venture Capital, Arch Venture Partners, MATH Venture Partners, Jump Capital, Hyde Park Venture Partners
- Research Centers and Universities: Northwestern University, University of Chicago, University of Illinois Urbana-Champaign, Illinois Institute of Technology, Argonne National Laboratory, Fermi National Accelerator Laboratory
