EIS ETL Data Analyst Modeler (Jobs in Chicago, IL)   Requirement id 73942 Job title Modeler Job location in Chicago, IL Skills required SQL, Performance Tuning, EIS, ETL Data Analyst Open Date 02-Oct-2018 Close Date Job type Contract to Hire Duration 5 Months Compensation DOE Status requirement not found Job interview type Face to Face interview Apply    Email Recruiter: coolsoft Job Description Modeler: SQL, Performance Tuning, EIS, ETL Data Analyst Candidate must be our own W2 Employee We should submit only GC,GC - EAD, L2-EAD,H4-EAD and Citizens Job Description : Position: Data Modeler/Analyst Looking for a Data Modeler / Analyst with the following skills: Must be proficient in SQL and experienced in developing and optimizing complex logic using PL/SQL packages and stored procedures. Must be able to navigate in Oracle, beyond basic SQL skills – analytic functions (lead, lag, dense rank, and other windowing functions) and hierarchical queries. Must know when to use a “snowflake” versus a “star” and not quote some esoteric line from latest Ralph Kimballs blog. Be able to effortlessly design data-level security that may (or may not) reflect the integrating source systems. Design an extensible Multi-dimension security which could use any combination of union or intersection, if needed Must be able to read and understand Oracle Query Plans and implement the correct choices for performance Must know which indexes to design (B-tree, Bitmap, Clustered join, functional, etc.) and composite partitioning choices on Very Large Tables based on the nature of data Must know all trade-offs in performance tuning between loads and reads. Must be able to tune SQL, apply hints, enforce other query plans by changing session or memory parameters in Oracle Must know when to use a materialized view versus a summary table and the concept of query rewrites Must speak the dialect of Oracle DBAs with ease, and take on Oracle DBA role if ever needed. Must be able to analyze data and their relationships in a foreign EIS system, understand the “grain” of data and which attributes they hang of, and then correctly define the grain in the target data mart Must be able to “visualize” a target data mart once presented with data from source systems. Know what the dimensions would be, what their attributes would be; what hierarchies would they have? Would they ragged? Must have client and stakeholder interaction abilities and working with Cross functional teams. Must be able to have a cogent conversation with data analysts, ETL, data architects and modelers if not do their job, if needed Requires strong SQL and PL/SQL knowledge together with strong Oracle index and tuning knowledge.   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 73942 while calling.   Other jobs in IL: Chicago (77), Deerfield (7), Des Plaines (2), Downers Grove (7), Downtown Chicago (5), DT Chicago (2), Elk Grove (3), Elk Grove Village (24), Elkgrove Village (1), Evanston (1), Lake Forest (1), Lincolnshire (4), Northbrook (3), Oak Brook (5), Oakbrook (1), Oakbrook Terrace (5), Round Lake (3), Schaumburg (4), South Barrington (1), Springfield (2), Vernon Hills (6), Warrenville (7), SQL job openings in Chicago, IL Jobs List Azure Data Factory Engineer - 73514 Create date: 31-Mar-2021 Candidate must be our W2 Employee. Job Description: Azure Data Factory Pipelines = 2+ years Azure Devops & Git repos setup, configuration. Working with various architects to setup, document & streamline Azure Data Factory pipelines & devops. Total experience in data space of 5+ years with SQL,.... (This job is for - Azure ETL Jobs in IL Chicago Engineer - (in Chicago, IL)) Data Architect - 73251 Create date: 23-Mar-2021 Candidate must be our W2 Employee. Candidate must be local: Yes Job Description: • Project Overview: AUM and Flows Reporting: The current AUM and Flows reporting process is generated by various independent systems throughout NTAM, and the goal of this new initiative is to create a consistent and unified reporting en.... (This job is for - Python API Jobs in IL Chicago Architect - (in Chicago, IL)) Database Administrator - 73112 Create date: 19-Mar-2021 Candidate must be our W2 Employee. Job Description: 1. Project Overview: Contractor will specifically be staffing Application Growth and Lifecycle , Oracle 11g to 19c upgrades. 2. Contractors Role: Performs data modeling, logical and physical database design based on a thorough knowledge of modeling techniques, the .... (This job is for - OracleDBMS Jobs in IL Chicago Administrator - (in Chicago, IL)) Datawarehouse Analyst - 71626 Create date: 05-Feb-2021 Candidate must be our W2 Employee. Job Description: Datawarehouse Contractors Role: The candidate will be involved in the design, architecture and development of Corporate Data Warehouse utilizing Oracle sql and pl/sql, data warehouse / ETL tools and Unix Scripts. You will leverage past experience with bu.... (This job is for - Oracle Jobs in IL Chicago Analyst - (in Chicago, IL)) Systems Analyst - 64688 Create date: 06-Jul-2020 Candidate must be our W2 Employee. We should submit only GC,GC - EAD, L2-EAD,H4-EAD and Citizens. Job Description : THIS POSITION WILL SIT IN SALISBURY, NC Position Summary Plays a critical role in the design, development, and roll-out of the Data & Analytics Platform, along with partnering with team memb.... (This job is for - Azure Jobs in IL Chicago Analyst - (in Chicago, IL))    SQL job openings in other states Jobs List Data Warehouse Developer III - 148727 Create date: 22-Sep-2025 Start date : 10/20/2025 End Date : 06/30/2026 Submission deadline : 9/24/2025 4:00:00 PM Client Info : ETF Note: * interviews will be on 9/12 & 9/15. PLEASE NOTE: A real-time screenshot photo of the candidate MUST be uploaded to the interview page in order to accept an interview request. .... (This job is for - Tableau Alteryx Jobs in WI Madison Developer - (in Madison, WI)) TAX - Programmer/Analyst For VFACT (766532) Create date: 15-Jul-2025 Start date : 07/28/2025 End Date : 05/29/2026 Submission deadline : 07/21/2025 Client Info : TAX Note: * Agency Interview Type : Both Web Cam and In Person Interview * Hybrid * Pls note: Initial interviews will be Virtual but manager reserves the option to set up a follow.... (This job is for - job Jobs in VA Richmond Analyst - (in Richmond, VA)) DOH - IT Consultant 2 (WIC Data Analyst) (766546) Create date: 24-Jun-2025 Start date : 07/01/2025 End Date : 06/30/2026 Submission deadline : 06/27/2025 Client Info : DOH Note: * Hybrid * The candidate must have senior data analysis experience Description : Experience collecting and managing WIC data as found in the State .... (This job is for - Queries Jobs in OH Columbus Analyst - (in Columbus, OH)) Project Manager Expert - 64181 Create date: 30-May-2025 Start date : 06/30/2025 End Date : 05/30/2027 Submission deadline : 06/12/2025 Client Info : NeDHHS Note: * Candidates can work remotely. Description : Seeking a highly skilled Analyst to facilitate the transition and takeover of a Medicaid Data Warehouse (MDW). The re.... (This job is for - job Jobs in NE Lincoln Manager - (in Lincoln, NE)) Testing Technician II - 142926 - Rebid Create date: 20-May-2025 Start date : 07/01/2025 End Date : 06/30/2026 Submission deadline : 5/22/2025 4:00:00 PM Client Info : Elections Commission Note: * Interview Process: Teams with video on, 1-2 rounds * Duration: 6/30/26, likely to extend * Onsite or Remote? Candidates MUST be WI r.... (This job is for - Documentation Jobs in WI Madison Consultant - (in Madison, WI))    SQL job openings in IL Jobs List C Developer - 63426 Create date: 20-May-2020 Note :Sitting onsite in Peoria is preferred, but if candidates are unwilling to relocate from Chicago to Peoria then they can sit onsite in Chicago. Job Description : C# Developer Enterprise Digital Client Peoria, IL OR Chicago, IL Loop 12 Month Contract + Extensions • Modify existin.... (This job is for - Oracle Jobs in IL Peoria Developer - (in Peoria, IL)) Systems Engineer - 62371 Create date: 16-Apr-2020 Candidate must be local : Yes Candidate must be our W2 Employee. We should submit only GC,GC - EAD, L2-EAD,H4-EAD and Citizens. Job Description : POSITION SUMMARY Data Management System Engineering team to participate in new product development of data management solutions for medical devices. Displays s.... (This job is for - HTTP Jobs in IL LakeZurich Engineer - (in LAKE ZURICH, IL)) IT Consultant - 57404 Create date: 07-Jan-2020 Candidate must be our W2 Employee. We should submit only GC,GC - EAD, L2-EAD,H4-EAD and Citizens. Job Description : ***Remote work opportunity*** JOB TITLE: Monitoring Application Development Consultant GENERAL RESPONSIBILITIES: Responsible for designing, implementing, and providi.... (This job is for - Unix Linux Jobs in IL Waukegan Consultant - (in WAUKEGAN, IL)) Data Analyst - 45536 Create date: 03-Apr-2019 Candidate must be your W2 Employee. We should submitt only GC, GC EAD, L2 EAD, H4 EAD and Citizen. Job Description : Job Summary The Data Analyst is responsible for working with the Companys Data Architect and IT Management to achieve corporate goals and objectives. T.... (This job is for - SSISETL Jobs in IL Peoria Analyst - (in Peoria, IL)) Reporting Developer Tableau - 42727 Create date: 25-Jan-2019 Candidate must be our own W2 Employee Note: onsite interview highly preferred, will consider local candidates first Job Description : Site: IL-SCHAUMBURG-1600 MCCONNOR PARKWAY-60173 (IL043) Work Location: 1600 MCCONNOR PARKWAY Schaumburg Illinois USA 60173 What is the specif.... (This job is for - TableauAnalysis Jobs in IL Schaumburg Developer - (in Schaumburg, IL)) (Modeler: SQL, Performance Tuning, EIS, ETL Data Analyst in Chicago, IL)

Featured Jobs GitHub DB2 Developer (Jobs in Madison, Wisconsin) Microsoft Active Directory Hardware Consultant (Jobs in Madison, Wisconsi Frameworks Agile Analyst (Jobs in Lansing, Michigan) SQL T Analyst (Jobs in Richmond, Virginia) IIS Engineer (Jobs in Madison, Wisconsin) Cobol Oracle Consultant (Jobs in Blythewood, South Carolina) Help Consultant (Jobs in Columbia, South Carolina) Business Analyst Project Manager (Jobs in Madison, Wisconsin) MuleSoft ESB Consultant (Jobs in Colombus, Ohio) Architect (Jobs in Atlanta, Georgia)