data warehouse developer

job summary: This position is responsible for providing technical expertise and services regarding Power BI report maintenance, creation, and SQL query development for the Department, including providing detailed testing for work of others on the team. Reports would include but not be limited to data collected through enterprise applications such as the WISEid, WISEdata, the Wisconsin State Assessment System, and data reported in WISEdash. The position may also be responsible for fulfilling other state and federal data reporting requirements. The person in this position is responsible for peer testing of the work of their teammates including other ETL developers and dashboard developers. Objectives, priorities, and deadlines are established in consultation with the user, director and division leadership and discussed biweekly during Agile/Scrum sprint retrospective and planning sessions.   location: MADISON, Wisconsin job type: Contract salary: $40.27 - 45.27 per hour work hours: 8am to 5pm education: Bachelors   responsibilities: Create new Power BI reports for internal or external use.Amend existing Power BI reports, including SQL queries, visuals or DAX.Fulfill adhoc data requests from external or internal requesters.Peer testing of ETL tables, data views, Power BI reports, SQL queries, test scripts, etc.Provide recommendations and solutions for the creation of new reporting solutions.Support and troubleshoot scheduled Power BI Service report updates.Gather and analyze end user requirements for new or existing reports.Complete functional & technical specifications to load data from disparate source systems into Power BI in instances where the data does not belong in the data warehouse.Knowledge about the scrum methodologies and agile practicesWork with MS SQL Server 2019+ and Oracle databasesCreate operational processes including test cases & user documentationUsing TFS (Visual Studio/Azure Dev Ops) and Sharepoint for source code control, project related document sharing and team collaboration.Create Change Management tickets as required.Willingness to learn new technologies that will assist the team.Other duties as assigned relating to the data warehouse project. Required qualifications: Expert knowledge and use of SQLExpert knowledge and experience creating Power BI reports (data modelling, data visualization, DAX)Experience in data preparation and data warehousing projects Preferred qualifications: Experience with K-12 education data sectorKnowledge and use of Microsoft SSIS or similar Microsoft BI stack tools (SSRS, SSAS)Familiarity with scripting and programmingExperience or knowledge of working on an Agile/Scrum team (able to work well in a team, but also highly self-motivated and solid communication skills) Candidate Qualities: Organized, self-motivated, independent worker needing limited managerial oversight.Team player who can communicate clearly and thoroughly.Enthusiastic in learning new technologies with excellent problem solving and analytical skills.Very good communication and interpersonal skills and has the ability to work independently as well as in a team environment.   qualifications: Experience level: ExperiencedMinimum 5 years of experienceEducation: Bachelors  skills: SSISSSRSAgileScrum SQLPower BI 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.At Randstad Digital, we welcome people of all abilities and want to ensure that our hiring and interview process meets the needs of all applicants. If you require a reasonable accommodation to make your application or interview experience a great one, please contact HRsupport@randstadusa.com. Pay offered to a successful candidate will be based on several factors including the candidate's education, work experience, work location, specific job duties, certifications, etc. In addition, Randstad Digital offers a comprehensive benefits package, including health, an incentive and recognition program, and 401K contribution (all benefits are based on eligibility). Applications accepted on ongoing basis until filled.

job summary: Randstad is partnering with a firm to find a contract developer. The ideal candidate will have a foundation in data analytics with specialized skills in Cognos Analytics, extensive experience with ETL (Extract, Transform, Load) processes, and proficiency in Python, scripting, and PowerShell. This role involves working closely with the data analytics team to develop and implement data models, perform complex data analysis, and create actionable insights to drive strategic decisions.   location: Philadelphia, Pennsylvania job type: Contract salary: $75 - 77 per hour work hours: 8am to 5pm education: Bachelors   responsibilities: -Maintain and enhance the Data Protection Business Intelligence tool - Develop and maintain advanced reporting, analytics, dashboards, and other BI solutions using Cognos Analytics. - Design, implement, and automate ETL processes with source data coming from DBs (SQL and Oracle),CSV files and Splunk to enhance the data warehouse's reliability and efficiency. - Integrate new data feeds into the DPBI tool, ensuring seamless data flow and enhanced reporting capabilities. - Utilize Python for data analysis, modeling, automation tasks, and integration activities to support data-driven decision-making across the organization. - Write and maintain scripts in Python and PowerShell to automate data processing, workflow tasks, and support data protection related control enhancements. - Collaborate with cross-functional teams to understand data needs, gather requirements, and deliver scalable data solutions. - Ensure data accuracy and integrity by implementing quality controls and validation processes. - Stay up-to-date with the latest technologies and methodologies in data science, machine learning, analytics, and data protection. - Contribute to the development of best practices for data management, data governance, analytics, and data protection within the organization. -Assist in the evaluation and implementation of products and/or procedures to enhance security. - Review requests for new systems or changes to existing systems and evaluate the impact to security. - Deploy and monitor additional security products and tools or enhancements to existing tools. - Monitor daily reports to ensure the effectiveness of new and existing security technology.   qualifications: Experience level: ExperiencedMinimum 5 years of experienceEducation: Bachelors (required)  skills: Cognos 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.At Randstad Digital, we welcome people of all abilities and want to ensure that our hiring and interview process meets the needs of all applicants. If you require a reasonable accommodation to make your application or interview experience a great one, please contact HRsupport@randstadusa.com. Pay offered to a successful candidate will be based on several factors including the candidate's education, work experience, work location, specific job duties, certifications, etc. In addition, Randstad Digital offers a comprehensive benefits package, including health, an incentive and recognition program, and 401K contribution (all benefits are based on eligibility). Applications accepted on ongoing basis until filled.

job summary: Job Description: A great opportunity to work with the GT&O Technology ADS. Tech ADS is a modern data architecture platform transforming how GT&O manages its data.The goal of Tech ADS is to provide an integrated, controlled, ADS to house the data that is used to run and manage GT&O. The selected candidate will be an individual contributor responsible for development of the Technology ADS Data Warehouse.Candidate will be a member of a small team of developers and data analysts who support development of the Tech ADS.Candidate will be responsible for a wide range of programming tasks and technologies including Hadoop, Exadata, Python, Kafka, etc. Candidate will be involved in design, code, test and level 2/3 support of the data warehouse. In addition to development, the candidate will be responsible for partnering with the business to ensure requirements are met and with other functional areas of technology (QA, Production Support) to ensure effective implementation. Team uses an Agile development process. Requirements: Requires 7+ years of development experience Experience working with big data and eco system (e.g. Hadoop, Hive, pySpark, HBase, Sqoop, Impala, Kafka, Flume, Oozie, MapReduce, S3 etc.) Experience with high level programming languages (Python, Java, etc) Experience working with database systems (e.g. Exadata, NoSQL, Cassandra, Neo4j, etc.) Experience working as part of an Agile team and using Agile SDLC tools (Jira, etc.) Ability to partner with other functional areas to ensure execution of development, design, coding, testing, debugging and documenting application Ability to develop awareness of business function for which application is being designed in order to drive out detailed requirements and form effective partnerships Analytical ability, independent problem solving, and good communication skills Demonstrated ability to learn new technologies and deliver in a fast paced agile environment Years of experience required: 7+ years Top 3 required IT/Technical skill-sets: Hadoop, Hive, PySpark   location: Charlotte, North Carolina job type: Contract salary: $60 - 70 per hour work hours: 9am to 5pm education: Bachelors   responsibilities: Position Summary This is a great opportunity to work with the GT&O Technology ADS. Tech ADS is a modern data architecture platform transforming how GT&O manages its data. The goal of Tech ADS is to provide an integrated, controlled, ADS to house the data that is used to run and manage GT&O. The selected candidate will be an individual contributor responsible for development of the Technology ADS Data Warehouse. Candidate will be a member of a small team of developers and data analysts who support development of the Tech ADS. Candidate will be responsible for a wide range of programming tasks and technologies including Hadoop, Exadata, Python, Sqoop,Spark, hive, etc. Candidate will be involved in design, code, test and level 2/3 support of the data warehouse. In addition to development, the candidate will be responsible for partnering with the business to ensure requirements are met and with other functional areas of technology (QA, Production Support) to ensure effective implementation. Primary Skill Hadoop Secondary Skill Python Tertiary Skill Required Skills - Requires 7+ years of development experience - Experience working with big data and eco system (e.g. Hadoop, Hive, pySpark, Sqoop, Impala, etc.) - Experience with high level programming languages (Python, Perl, Java, etc) - Experience working with database systems (e.g. Exadata, etc.) - Experience working as part of an Agile team and using Agile SDLC tools (Jira, etc.) - Ability to partner with other functional areas to ensure execution of development, design, coding, testing, debugging and documenting application - Ability to develop awareness of business function for which application is being designed in order to drive out detailed requirements and form effective partnerships - strong analytical ability, independent problem solving, and good communication skills - Demonstrated ability to learn new technologies and deliver in a fast paced agile environment - Expert knowledge and experience in software development methodologies and industry practices - Expert understanding and experience with building and deploying enterprise applications - Ability to work in a matrix environment with minimal supervision - Excellent written, verbal and diagramming skills. Expertise in using PowerPoint and clearly articulating findings/presenting solutions - Should be able to lead the team , guide other developers , help with design and write/edit frameworks scripts Desired Skills Spark, hive, impala, sqoop, oracle/sql   qualifications: Experience level: ExperiencedMinimum 5 years of experienceEducation: Bachelors  skills: Hadoop 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.At Randstad Digital, we welcome people of all abilities and want to ensure that our hiring and interview process meets the needs of all applicants. If you require a reasonable accommodation to make your application or interview experience a great one, please contact HRsupport@randstadusa.com. Pay offered to a successful candidate will be based on several factors including the candidate's education, work experience, work location, specific job duties, certifications, etc. In addition, Randstad Digital offers a comprehensive benefits package, including health, an incentive and recognition program, and 401K contribution (all benefits are based on eligibility). Applications accepted on ongoing basis until filled.