data warehouse developer ii.

job summary: 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. Data is one of our most valuable assets and we strive to become a more data-literate and data-driven organization. This position will work on a small, collaborative team that uses agile practices to deliver value to our business partners.  location: MADISON, Wisconsin job type: Contract salary: $51.66 - 56.66 per hour work hours: 8am to 5pm education: Bachelors   responsibilities: Gathering requirements and developing technical specifications for ETL - 6 yearsUsing ETL tools to design ETL jobs (ETL 6 years, preferably 2 years of with Alteryx)Developing various types of data loads (e.g. incremental, history/full, survivorship rules) - 6 yearsImplementing change data capture (CDC) - 4 yearsTesting and debugging ETL - 6 yearsDeveloping complex SQL - 6 yearsETL job scheduling - 2 yearsLoading data warehouses using ETL tools - 2 yearsManagement of multiple ETL toolsExperience with data quality tools and frameworksUsing source code version control software Mentoring to others on ETL developmentManaging multiple, concurrent projects and tasksHaving strong interpersonal skills including communication, mentoring, collaborating, and team building ETF Technologies AlteryxSSISSSRSSQL ServerTableauSemarchyGit & github   qualifications: Experience level: ExperiencedMinimum 5 years of experienceEducation: Bachelors  skills: Data Warehouse Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status. For certain assignments, Covid-19 vaccination and/or testing may be required by Randstad's client or applicable federal mandate, subject to approved medical or religious accommodations. Carefully review the job posting for details on vaccine/testing requirements or ask your Randstad representative for more information.

job summary: The candidate will be responsible for ETL design, development, testing, maintenance, metadata, and implementation of data warehouse initiatives. Understand user requirements, and implement solutions that ensure requirements can be achieved through high quality deliverables. 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. Monitor technological advancements to ensure that solutions are continuously improved, supported, and aligned with industry and company standards. Conducts highly complex work critical to the organization. Works with other IT technical teams and Business users to understand requirements and recommend/ implement solutions. Works with moderate supervision with latitude for independent judgment. Assist less experienced peers by providing technical guidance. Requires advanced skill sets and developing proficiency within discipline. Typically requires 6 - 9 years' experience or equivalent education.   location: MADISON, Wisconsin job type: Contract salary: $46.33 - 51.33 per hour work hours: 8am to 5pm education: Bachelors   responsibilities: Demonstrated skills in establishing data warehouse best practice standards strong skills working with relational and dimensional data models strong skills working with slowly changing dimensions strong data management and data analysis using SQL strong verbal and written communication skills, including facilitation of meetings with customers and technical staff 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 Ability to complete projects of substantial depth and complexity, and work with customers at many levels in the organization   qualifications: Experience level: ExperiencedMinimum 5 years of experienceEducation: Bachelors  skills: Data WarehouseETL Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status. For certain assignments, Covid-19 vaccination and/or testing may be required by Randstad's client or applicable federal mandate, subject to approved medical or religious accommodations. Carefully review the job posting for details on vaccine/testing requirements or ask your Randstad representative for more information.

job summary: Our client in Wisconsin is looking for a Senior Software Developer for a 100% remote contract-to-hire opportunity. Desired Skill Set: Bachelor's degree or equivalent work experience6+ years experience with the following technologies:Web Apps: .Net Core, C#, VB.NetWeb Services: API Connect, .Net Core/C#, Web ServicesIdeal candidate will have Azure DevOps experience. Agile Knowledge/Experience is a must have.   location: Madison, Wisconsin job type: Contract salary: $50 - 63 per hour work hours: 8am to 4pm education: Bachelors   responsibilities: Analyzes the needs of a business area's acceptance criteria, striving for the development of efficient, dependable, maintainable applications logic to support the business need. This analysis and design is usually done under the general direction of Information Technology management and/or expert level professional staff including Applications Analyst/Designers.Designs, interprets and/or refines the acceptance criteria, and generating value add documentation. Tests and debugs production programs and programs under development, particularly more complex modules, to isolate and eliminate problems that could be very costly in adverse public relations, lost productivity within the Company, wasted resources, etc. This may require working directly with other technical staff and business departments in identifying problems and modificationsDesigns and codes the program logic necessary to meet the application needs of complex systems and/or multiple systems. Program design must be consistent with the specifications, standards, and existing programs to enable effective maintenance of the system. Code must be developed in a manner that is straightforward, clear and consistent with existing programs within the system and in compliance with the Systems Development Life Cycle (SDLC). The incumbent will demonstrate leadership in the use of the SDLC.Resolves production problems that create system outages, determines underlying cause of outage and addresses it to prevent future occurrences. Implements program logic, documentation, and procedural changes on schedule and according to an established implementation plan.Works with others to increase availability and performance of production systems. Serves as an internal technical consultant regarding the coding, testing, debugging, and installation of application logic, as well as looks for ways to improve processes. Identifies and takes action on business continuous improvement initiatives. Leads by example when demonstrating customer focus, which includes providing service to clients that meets or exceeds expectations. Continually evaluates work processes by looking for ways to eliminate nonessential tasks and improving quality. Contributes positively to the team by performing daily work in a professional manner and treating co-workers as clients. Makes decisions that increase customer satisfaction and develops/maintains business-specific knowledge. Mentors and provides guidance to less experienced programmers.   qualifications: Experience level: ExperiencedMinimum 5 years of experienceEducation: Bachelors  skills: .NET Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status. For certain assignments, Covid-19 vaccination and/or testing may be required by Randstad's client or applicable federal mandate, subject to approved medical or religious accommodations. Carefully review the job posting for details on vaccine/testing requirements or ask your Randstad representative for more information.