SSIS ETL SSRS Logic And Analysis Tools & Methods Analyst (Jobs in Madison, WI)   Requirement id 51541 Job title Analyst Job location in Madison, WI Skills required SQL, SSIS, ETL, SSRS Logic And Analysis Tools & Methods Open Date 12-Feb-2016 Close Date Job type Not specified Duration 12 Months Compensation DOE Status requirement --- Job interview type --- Apply    Email Recruiter: coolsoft Job Description Analyst: SQL, SSIS, ETL, SSRS Logic And Analysis Tools & Methods Note: Start date : 3/7/2016 End date : 2/28/2017 Submission deadline: 2/18/2016 Description: SQL Server Tools Enterprise Manager, SQL Profiler, Query Analyzer, SQL Server Management Studio, DTS, SSIS, SSRS, SSAS, Sharepoint. Database MS SQL Server 2008 R2, SQLCMD, Microsoft Office 2010/2007/2003, MS-Access. Operating System Windows XP/NT/2000/2003/2008, DOS Tools Erwin Data Modeler, MS Visio, SAS/Access, Crystal Reports 8.5,10,XI,R2, Business Objects, Microsoft office 2003/2007 Experience • Expertise in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) with good knowledge on SQL Server Analysis Services (SSAS). • Experienced in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports: Drill Down, Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub-Reports. • Experienced in developing, monitoring, extracting and transforming data using DTS/SSIS, Import Export Wizard, and Bulk Insert. • Excellence in high level design of ETL DTS packages & SSIS packages for integrating data using OLE DB connection from heterogeneous sources like (Excel, CSV, Oracle, flat file, text format data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and union all. • Experienced in developing reports on SSRS on SQL Server (2000/2005/2008). Sound experience and understanding of SSAS, OLAP cube and architecture. • Experienced in writing expressions in SSRS and Expert in fine tuning the reports. Experience in creating many Drill Through and Drill Down reports using SSRS. • Excellent knowledge in creating databases, tables, stored procedures, DDL/DML triggers, views, user defined data types, functions, cursors and indexes using T-SQL. • Significant ability to create and manage various database objects like tables and views. • Worked extensively on ETL process using SSIS package. • Experienced in data conversion and data migration using SSIS and DTS services across different databases like Oracle, MS access and flat files. • Experienced in using T-SQL in SQL Server 2008 platforms. • Experienced in Performance Tuning and Query Optimization. • Designed dashboards, scorecards and reports using multiple KPIs, OLAP charts and SSRS reports with PPS. • Transformed data from one server to other servers using tools like Bulk Copy Program (BCP),Data Transformation Services (DTS) and SQL Server Integration Services (SSIS) • Experienced in maintenance and administration of SSIS by creating jobs, alerts, SQL Mail Agent, and schedule DTS/SSIS Packages. • Experienced in SQL Server DTS and SSIS (Integration Service) package design, constructing, and deployment • Experienced in creating packages to transfer data between ORACLE, MS ACCESS and FLAT FILES to SQL SERVER using DTS/SSIS. • Expert in creating Parameterized Reports. • Hands on experience in creating Star Schema and SnowFlake schemas. • Excellent analytical, communication and interpersonal skills. Proficient in technical writing and presentations and a good team player. • Ability to work independently or as part of a team to accomplish critical business objectives and to make decisions under pressure.   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 51541 while calling.   Other jobs in WI: De Pere (2), Green Bay (8), Kenosha (2), Madidson (1), Madison (36), Menomonee Falls (19), Milwaukee (59), Sun Prarie (1), Unknown (2), Waukesha (2), SQL job openings in Madison, WI 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)) 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)) Data Warehouse Developer I -136603 Create date: 23-Oct-2024 No of Submissions : 1 start date : 11/18/2024 End date : 06/30/2025 submission deadline : 10/25 at 4 CST. client info : DPI Note: * Interview Process: Via Teams * Duration: Till June 30, 2025, with possibility of extension * Onsite or Remote: Candidate must.... (This job is for - Data Warehousing Jobs in WI Madison Developer - (in Madison, WI)) Business Analyst/ Consultant-IV - RFS 132434 Create date: 08-Jul-2024 No of Submissions : 2 Start date : 08/12/2024 End Date :06/30/2025 Submission deadline : 07/12/2024by 8:00 A.M. CST Client Info : Madison, WI - IT -ETF-DTSDS -DataManagement- Wisconsin Department of Employee Trust Funds (ETF) Note: * Interview Process: * Remote via MS Te.... (This job is for - Stakeholders Jobs in WI Madison Consultant - (in Madison, WI)) Data Warehouse Developer III - 130610 Create date: 20-May-2024 Bid Limit Per Vendor : 1 Start date : 07/01/2024 End Date : 06/30/2025 Submission deadline : 5/22 at 4:00 PM CST. Client Info : DCF Note : INTERVIEW NOTES: • Phone and web based interviews will be acceptable. • However, an in--person interview may be required. job Jobs in WI Madison Developer - (in Madison, WI))    SQL job openings in other states Jobs List 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)) System Administrator - 9216402 Create date: 21-Mar-2025 Start Date :4/1/2025 End Date :06/30/2025 Submission Deadline :3/26/2025 Client Info: CO OIT Note: * Remote Position * Candidate must be Local Description : A DMV check will also need to be completed with the standard background check by the.... (This job is for - Python DNS Jobs in CO Denver Administrator - (in Denver, CO)) System Administrator - 9216393 Create date: 21-Mar-2025 Start Date :04/01/2025 End Date :06/30/2025 Submission Deadline :03/26/2025 Client Info : CO OIT Note: * Remote Position * Candidate must be Local Description : A DMV check will also need to be completed with the standard background check by the s.... (This job is for - DNS Jobs in CO Denver Administrator - (in Denver, CO))    SQL job openings in WI Jobs List Systems Analyst I - 141076 Create date: 19-Mar-2025 Start date : 04/21/2025 End Date : 12/31/2025 Submission deadline : 3/25/2025 4:00:00 PM Client Info : Outagamie County Note: * Interview Process: An in-person interview is preferred with the candidate. Zoom interview can be arranged. * Duration of the Contract: Until 12/31/2.... (This job is for - EHR Jobs in WI Appleton Analyst - (in Appleton, WI)) Data Modeler - 70417 Create date: 22-Dec-2020 Job Description: Data Modeler / “Data Wizard”. Strong SQL reporting and development, PowerBI a plus. Building complex views, “gear head.” Snowflake schemas / Strong ETL experience. Develop database models and support documentation in order to meet business requirements for reporting and analytic databases. Analy.... (This job is for - Development Jobs in WI Milwaukee Modeler - (in Milwaukee, WI)) Data Engineer - 69497 Create date: 19-Nov-2020 Candidate must be our W2 Employee. We should submit only GC,GC - EAD, L2-EAD,H4-EAD and Citizens. Job Description : CONTRACT - TO - HIRE BIG QUERY Data Engineer Project: Working with their IT Supply Chain team to create reporting across all their channels for the business. Day to Day: Working w.... (This job is for - job Jobs in WI MenomoneeFalls Engineer - (in Menomonee Falls, WI)) Machine Learning Engineer - 64593 Create date: 01-Jul-2020 Candidate must be our W2 Employee. Job Description : Our GREAT Client in the Greater Milwaukee Area is looking for a talented Machine Learning Engineer to join their team. Project: Demand Forecasting- The objective is to be able to better forecast inventory needs across channels and locations using well-established .... (This job is for - PythonJupyter Jobs in WI MenomoneeFalls Engineer - (in Menomonee Falls, WI)) Programmer-Analyst - 3 - 63520 Create date: 22-May-2020 Candidate must be our W2 Employee. Candidate must be local : Yes Job Description : This client is working toward modernizing legacy COBOL applications to a current web framework. This candidate will work closely with our COBOL application developer to ensure business requirements and functionality are ma.... (This job is for - MVCCoding Jobs in WI Milwaukee Analyst - (in Milwaukee, WI)) (Analyst: SQL, SSIS, ETL, SSRS Logic And Analysis Tools & Methods in Madison, WI)

Featured Jobs Troubleshooting Written Engineer (Jobs in Des Moines, Iowa) RDBMS Written Administrator (Jobs in ATLANTA, Georgia) NIST Cybersecurity SIEM Analyst (Jobs in Madison, Wisconsin) SIEM C/C++ Python Analyst (Jobs in Columbia, South Carolina) QA Testing SSIS Developer (Jobs in Richmond, Virginia) RHEL Python Analyst (Jobs in Jackson, Mississippi) HTML Developer (Jobs in Madison, Wisconsin) Figma Visio Engineer (Jobs in Lansing, Michigan) COTS SASS Communication Analyst (Jobs in Henrico, Virginia) IBM Active Consultant (Jobs in Des Moines, Iowa)