| DWD Data Warehouse Architect, Indianapolis, IN (719691) at Indianapolis, Indiana, USA |
| Email: [email protected] |
| Hi Team, Please find full JD below and share suitable resumes. Data Warehouse Architect (719691) Start Date - 09/25/2023 End Date - 12/31/2024 Location -Indianapolis, IN 46204 Interview Type - Webcam only Pay Rate - $83.21/hr. Work Arrangement- Hybrid, Resources are currently working 100% remote, however resources who are in the Indianapolis area may be required to report to the office for various meetings or if alternative work schedules change Short Description: SR. level Data Warehouse Architect needed to work with the data team to establish multiple data assists to be built once the data warehouse environment is implemented and setup data schemas, bridging data and cleansing and staging data for business use. The first tactical step in that journey is the establishment of dashboards for the purpose of monitoring the health of the agencys unemployment system. The range of dashboards include visualization into business transactions (new and historical), the various business backlogs and outstanding workloads, employee performance and if possible, workload projections. DWD seeks an individual who can bring senior level experience necessary to setup the data schemas, the bridging of data from core systems as well as the cleansing and staging of data for business use (business analysis, visual aids and reporting). More importantly, DWD seeks an individual who can guide and educate an IT Data Team on effective designs and procedures using current industry standards and best practices. Essential Job Responsibilities: The essential functions of this role are as follows: Participate with a Product Owner (PO) and/or Business Analyst (BA) in gathering business requirements. Participate with a team of business stakeholders, junior Tableau developer(s), BA and PO in developing wireframes and other dashboard mockups. Provide guidance and experience to best practice in designing Data Lakes, Data Marts, and other data assets to be presented to the business. Develop data mappings, data flows and data cleansing procedures. Provide education and guidance to other data group members in effective data asset development. In general, act as a lead in effective data designs starting with data selection from core system, data transfer and cleansing, to final data presentation. Participate with other Data Analyst(s) as needed to define minimal viable data assets in support of the visual needs. Assist the PO in estimating scope and time as it relates to development of data transfers, cleansing and promotion, and as it relates to staffing level. Assist the PO and/or BA in doing Inspect & Adapt reviews with the business. Advice management as needed of any shortcomings with current tools and/or approaches related to the business initiatives. Requirements: Extensive knowledge of information systems design principles and new systems design techniques. Extensive knowledge of policies, standards, procedures, and techniques used for data application development. Ability to perform problem solving and analytical analysis on complex issues. A very strong understanding of system development using a lean agile approach. Extensive knowledge of both system and business applications and competent to work at the highest technical level of all phases of data applications systems analysis and developing activities. Willingness to train/educate other Data Analysts, Business Analysts and other data team members in effective data designs/approaches. Willingness to train/educate junior Data Analysts in effective data transfer and development. Experience in using a wide range of ETL tool Talend and Data Factory. Some experience in using the Tableau Studio tools is desired. Extensive knowledge of the most recent advancement in data transfer, cleansing and promotion. Ability to read and understand complicated technical instructions. Ability to manage multiple application development assignments and priorities. Ability to communicate effectively, both orally and in writing. The Data Warehouse Architect performs a broad range of activities within a state-of-the-art Information Technology area. Although most of the effort will center around building data assets from scratch, work involves using considerable judgment in selecting the most pertinent guidelines to follow and in-depth analysis of multiple variables to fit various circumstances of a medium to complex enterprise-wide system. Incumbent applies general Software Development Life Cycle (SDLC) principles and industry standards to accomplish agency automation goals. Competencies Acquiring Information Communicating Effectively Critical Thinking Delivering High Quality Work Testing and Troubleshooting Displaying Technical Expertise Adapting to Change Accepting Responsibility Training Others SQL Azure Synapse Data Factory Talend, Data Factory and other ETL tools Tableau Studio Jira App Dynamics Confluence System Development using Lean Agile Data Modelling Data Mapping Data Cleansing Schemes Require/Desire Skills Senior level Data Warehouse Design skills Required 5 Years Senior level SQL experience Required 5 Years Experience in using a wide range of ETL tool Talend and Data Factory. Required 5 Years A very strong understanding of system development using a lean agile approach. Required 5 Years Competent to work at the highest technical level of all phases of data applications systems Required 5 Years Extensive knowledge of the most recent advancement in data transfer, cleansing and promotion. Required 5 Years Extensive knowledge of information systems design principles and new systems design techniques. Required 3 Years Extensive knowledge of system and business applications Required 3 Years Willingness to train/educate other Data Analysts, Business Analysts and other data team members in effective data designs/approaches Required 3 Years Azure Synapse skills Required 2 Years Azure Data Factory Skills Required 2 Years Tableau Studio Skills Required 2 Years Question for Candidate Question 1 Time off for vacation or personal business must be approved by the resources DWD manager at least two weeks prior to taking requested time. We recognize that some absences cannot be planned for and those will be considered on a case-by-case basis. Absences for sick time does not require a two week notice however the resource will need to inform his/her direct manager in the event they are sick and need time off. Do you agree with this requirement Question 2 Resources are currently working 100% remote, however resources who are in the Indianapolis area may be required to report to the office for various meetings or if alternative work schedules change. Do you agree with this requirement Question 4 Resources are to be in their designated remote location/address Monday through Friday. Resources are restricted from taking State of Indiana equipment out of the country for any reason. If a need arises Resources are required to speak with their supervisor and be granted specific permission for a specified event. Your acknowledgement of this requirement is mandatory. Question 5 Please provide candidates email address. Question 6 Resource must be local to Indiana to be considered for this position. Please provide home address. Question 7 Resource must currently be local to Indiana. Please provide home address. Mohit Arya Associate - Recruitment Tel: (+1) 425-375-7232 2400 Meadowbrook Parkway, Duluth, GA 30096 www.innovasolutions.com Visit Us at 2023 Industry Events Click here to learn how we collect, use, and disclose personal information Listen to our latest technology podcast here If you do not wish to receive further communications like this, please send an e-mail to [email protected] to This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the named addressee, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. Although the company has taken reasonable precautions to ensure no viruses are present in this email, the company cannot accept responsibility for any loss or damage arising from the use of this email or attachments. Keywords: business analyst information technology purchase order Georgia |
| [email protected] View all |
| Mon Sep 11 19:06:00 UTC 2023 |