Data Warehouse Developer

3 weeks ago


Madison, United States IO Datasphere Full time

**If you are interested in this position:**

Download the skills matrix using the button below and fill it out.

Email us and attach the **completed skills form** and your **most recent resume** to us at:

jobs@iodatasphere.com

Please include '**7988WI Skills Form**' and your name in the subject line.

Position Data Warehouse Developer Location Madison, WI **Description:**

Our client is looking for a Data Warehouse Developer to be responsible for assisting in ETL design, development, testing, maintenance, metadata, and implementation of data warehouse initiatives. This is a Career-Development position within field. Requires moderate skill sets and developing proficiency within discipline.

**Tasks**

* Understand user requirements and implement solutions that ensure requirements can be achieved through high quality deliverables.

* Candidate will develop ETL mapping specifications for loading information into the data warehouse and for ensuring reliability of information loaded

* Seek continuous improvement in performance & tuning of data warehouse and ensure security of data. Works with other IT technical teams and Business users to understand requirements and recommend & implement solutions.

* Design, develop, and maintain relational databases for data storage and data mining.

* Perform data warehouse design and testing, including data design, database architecture, metadata, and repository creation.

* Develop processes and procedures for entering information into data warehousing systems and for ensuring reliability of information entered.

* Conducts tasks and assignments as directed.

**Ideal candidate will have**

* Knowledge in data warehouse best practice standards

* Moderate skills working with relational and dimensional data models

* Moderate skills working with slowly changing dimensions

* Strong verbal and written communication skills, including facilitation of meetings with customers and technical staff

* Knowledge and skills in the project development life cycle process (i.e., planning, analysis, design, coding, testing, implementation, support)

* Demonstrated knowledge and skills in requirements gathering

* Effective interpersonal relations skills, ability to effectively collaborate with others and work as part of a team

* Skills in navigating a large organization in order to accomplish results

* Ability to initiate and follow through on complex projects of both short- and long-term duration

* Excellent organizational and time management skills.

* Excellent analytical and problem-solving skills

* Ability to work independently, assume responsibility for job development and training, researching and resolving questions and problems, requesting supervisor input and keeping supervisor informed

* Proficiency with MS Office suite, MS Visio, and MS Outlook

* Excellent organization, analytical and communication skills

**Skills Required**

* 4-5 years - Experience in data warehousing process design, development, performance & tuning using the Informatica data warehousing tool suite

* Developing skills in the architecture of data warehouse and data integration strategies and solutions

* Knowledge in relational database technologies, e.g. Oracle, DB2, SQL Server

* Strong data management and data analysis using SQL

* 2 years - Expertise in implementation of large, complicated models and processes

* 3 years - Experience in technical writing and documentation

* 3+ years - Develop design specifications

* 4+ years - Experience in data warehouse design and development

* 4+ years - Experience in requirements gathering for data warehouse

* 4+ years - Experience in Data Warehouse Performance tuning

* 4+ years - Informatica

* 2 years - DB2

* 2+ years - Knowledge of Kimball data warehouse design principals

* 3+ years - Ability to navigate and query a relational database (Oracle) to develop reports

* 3+ years - Business Objects or other BI tools

* 3+ years - Respond to customer requests (verbally and in writing)

* 3+ years - Develop Test Plans, Test Cases, and Test Procedures

* 3+ years - Identify defects

* 3+ years - Ability to develop and implement quality assurance processes and procedures including test/use cases

* 4+ years - Data analysis

* 2+ years - Demonstrated experience in the design and utilization of performance measures and reports

* 2+ years - Dashboarding/Business Objects Xcelsius

* 3+ years - In-depth knowledge of system development life cycle deliverables for each phase of development

**Skills Desired**

* State of Wisconsin Privacy Regulations



  • Madison, United States Focused HR Solutions Remote Work Freelance Full time $65

    Our direct client has an opening for a Data Warehouse Developer rec 89341    This position is for 8 months with the option of extension and is located in Madison WI  WE CAN WORK CORP TO CORP OR W2. If you are interested, please submit the following:YOUR CURRENT RESUME YOUR HOURLY RATE   Qualifications:7-Year Standard Background Check run internally by...

  • Data Management

    2 weeks ago


    Madison, United States Vision It US Full time

    Job DescriptionJob DescriptionCandidates MUST be WI residents or willing to relocate to WI at their own expense prior to starting. This position can work 100% remotely (within the state of WI). Job Description:We have an immediate opening at the Department of Employee Trust Funds (ETF) for a strong Data Engineer to participate in our Data Management Program....


  • Madison, United States Intellifusion Company Inc Full time

    PMP Data warehouse Project Manager Madison, WI Home / DevOps / PMP Data warehouse Project Manager Madison, WI PMP Data warehouse Project Manager Madison, WI Apply By: 7/5/2021 PMP Data warehouse Project Manager Madison, WI Candidate will be expected to work at Madison WI location in accordance to "Safer At Home" guidelines We are looking for project managers...


  • Madison, United States Tanson Corp Full time

    Job DescriptionJob DescriptionDescription:This is a REPOST. Please do not submit the same candidates. This repost is open to nationwide candidates and does not require relocation to WI. Candidates MUST have Alteryx experience related to ETL, not just Alteryx experience based in data prep. The manager is also looking for candidates with strong and recent SQL...


  • Madison, United States US Foods Full time

    ESSENTIAL DUTIES AND RESPONSIBILITIES • Achieve all safety, service, and cost targets in the warehouse. Lead with a safety mindset that ensures that every US Foods associate remains injury free, always. Champion safety procedures, processes and training to create and maintain a safety-first culture in the warehouse. • Oversee and develop Warehouse...

  • Warehouse Lead

    1 week ago


    Madison, United States Southeast Unloading Full time

    Job DescriptionJob DescriptionStarting pay $21/hr plus percentage paySoutheast Unloading is looking for a self-directed, customer service-driven leader to be an unloader/warehouse lead. The ideal candidate will plan, direct, and coordinate the daily operations and unloading of trucks in a warehouse owned by our customer. Food or grocery warehouse experience...


  • Madison, United States Placon Full time

    Nights position- 6pm-6am (two days on, two days off etc.) The Warehouse Specialist is responsible for maintaining daily warehouse activities regarding the flow of raw materials and finished goods under the direction of the Supervisor. Other accountabilities include performing all related warehouse duties and leading the Warehouse Associates. The Specialist...

  • Warehouse Specialist

    2 weeks ago


    Madison, United States Placon Corporation Full time

    Job DescriptionJob DescriptionNights position- 6pm-6am (two days on, two days off etc.)The Warehouse Specialist is responsible for maintaining daily warehouse activities regarding the flow of raw materials and finished goods under the direction of the Supervisor. Other accountabilities include performing all related warehouse duties and leading the Warehouse...

  • Warehouse Lead

    1 day ago


    Madison, United States Southeast Unloading Full time

    Job DescriptionJob DescriptionStarting pay $21/hr. Immediate pay raise to $23-$26/hr after training is completed.Southeast Unloading is looking for a self-directed, customer service-driven leader to be an unloader/warehouse lead. The ideal candidate will plan, direct, and coordinate the daily operations and unloading of trucks in a warehouse owned by our...

  • Warehouse Supervisor

    4 weeks ago


    Fort Madison, United States Ethical Search Professionals Full time

    Location Fort Madison, IA No Remote We are looking for a **Warehouse Supervisor** to join a very large liquids processing/packaging facility in Southeast Iowa. If you enjoy leading in a fast-paced and high-energy manufacturing environment, then you will fit in well as the **Warehouse Supervisor** at this site. On a day-to-day basis you will be responsible...

  • Data Engineer

    5 days ago


    Madison, United States Wisconsin Collaborative for Healthcare Quality Full time

    The Opportunity Are you passionate about leveraging data to drive innovation and create impactful solutions? M3 is seeking a skilled Applied Intelligence Data Engineer to play a pivotal role in our journey towards data excellence. As an Applied Intelligence Data Engineer, you will be at the forefront of developing, optimizing, and maintaining our data...


  • Madison, United States Madison Metropolitan School District Full time

    **Doyle - Dashboard & Report Developer - 1.0 FTE (40 hpw)** **Technical Services** **Doyle Administration Building** $39.02 - 39.02 Hourly Wage **Position Summary**: **Responsibilities**: - Coordinate with the Data Warehouse/Dashboard Supervisor to migrate dashboard and warehouse tools from legacy systems (e.g. Data Dashboard 1.0, self-hosted Unified...

  • Warehouse Manager

    6 days ago


    Madison, United States Nextek Inc Full time

    ** Nextek, Inc.** ** Warehouse Manager** Madison, AL 35758 Nextek, Inc is a niche market, technology-driven Electronics Manufacturing Services (EMS) company, founded in 1995. We offer precision electronic assembly and engineering services to customers with needs-driven, non-commodity products. We partner with companies who have unique product needs and who...


  • Madison, United States Katalyst Healthcares and Life Sciences Full time

    Responsibilities: The essential duties of the Warehouse Spore Placer are the following: Exercise Safe lifting techniques when bending, lifting, and turning. ccept materials from other C.R. Bard divisions / departments for ethylene oxide sterilization. Verify the catalog numbers, lot numbers, quantities and expiration date as applicable and detailed...


  • Madison, United States Focused HR Solutions Full time $65 - $85

    PLEASE SEND RATES AND RESUME TO ZIPFHR@FHR-SOLUTIONS.COMThis position can be remote and coming into the office in Madison, WI as needed, hybrid or fully in office. The contractor does not need to live in Madison area but may need to come into office at times.  Our direct client has an opening for a Data Architect position # 88022. This position is for 12+...

  • GCP Lead Developer

    2 weeks ago


    Madison, United States Infosys Full time

    Infosys is seeking an Google Cloud(GCP), Python, GitHub Technology Lead. The position will primarily be responsible interface with key stakeholders and apply your technical proficiency across different stages of the Software Development Life Cycle including Requirements Elicitation and Design. You will play an important role in creating the high-level design...

  • GCP Lead Developer

    2 weeks ago


    Madison, United States Infosys Full time

    Infosys is seeking an Google Cloud(GCP), Python, GitHub Technology Lead. The position will primarily be responsible interface with key stakeholders and apply your technical proficiency across different stages of the Software Development Life Cycle including Requirements Elicitation and Design. You will play an important role in creating the high-level design...

  • GCP Lead Developer

    2 weeks ago


    Madison, United States Infosys Full time

    Infosys is seeking an Google Cloud(GCP), Python, GitHub Technology Lead. The position will primarily be responsible interface with key stakeholders and apply your technical proficiency across different stages of the Software Development Life Cycle including Requirements Elicitation and Design. You will play an important role in creating the high-level design...


  • Madison, United States Brunsell Lumber Full time

    Warehouse Assistant/Shop Technician - Window DepartmentSince 1938, Brunsell Lumber & Millwork has been the Madison area's leading name in building material supply and the first choice of professional builders and remodelers demanding quality, craftsmanship and the highest level of customer service. We are committed to hiring and developing talented...

  • Data Scientist

    8 hours ago


    Madison, United States Rural Mutual Insurance Full time

    Description We are looking for a Data Scientist who will support our product, sales, leadership, and marketing teams with insights gained from analyzing company data. The ideal candidate is adept at using large data sets to find opportunities for product and process optimization and using models to test the effectiveness of different courses of action. They...