| datawarehouse architect 3 15+ yr Exp candidates only at Remote, Remote, USA |
| Email: [email protected] |
|
http://bit.ly/4ey8w48 https://jobs.nvoids.com/job_details.jsp?id=409501&uid= From: Rosalin, GLOBAL IT FAMILY LLC [email protected] Reply to: [email protected] Posting title: Lansing, MI - IT - DTMB - Agency Services - CEPI - Data Warehouse Architect 3 Posting ID: 120082 Title: Data Warehouse Architect 3 Projected Start Date: 08/14/2023 Projected End Date/Duration: 12 Months from projected start date Address: 702 W Kalamazoo St Lansing, MI 48911 C2C Please ensure you attach the MI Cover Sheet (attached), Hybrid work agreement (attached), a valid Right to Represent, and the candidate's resume with full legal first name, and last name. Withdrawn candidates will not be permitted to be replaced. If you would like to use a sub vendor, only 1 level deep, please use Formstack link: Please see new Interview Verification Process (directions attached); If you receive an interview request you must upload a "live" screenshot of your candidate prior to the interview. A vendor representative must be present at the beginning of the interview to introduce the candidate to the manager. The State of Michigan is looking for: Data Warehouse Architect 3 Top Skills & Years of Experience: Azure Database services SQL Data Modeling/structure Data Migration to Cloud 8+ years of experience Bachelor's degree required Clear and concise written and verbal communication is crucial to success and productivity in this role. Will close submissions on: 7/19/23 at 10am EST Interview Process: Virtual Interview via MS Teams video. Please use laptop and be prepared so share screen if asked. Duration: 1 year with possible extension Hybrid: Local candidates strongly preferred, or non-local candidates who are willing to relocate at their own expense from acceptance with no delays. NO REMOTE ONLY OPTION. Will need to be onsite from day 1, two days a week. Resource will be working a hybrid schedule. - Candidates must be in office on Wednesdays and Thursdays. Full Job Description Attached Position Description CEPI Data Warehouse Architect 3 Designs, implements and supports data warehousing. Implements business rules via stored procedures, middleware, or other technologies. Defines user interfaces and functional specifications. Responsible for verifying accuracy of data, and the maintenance and support of the data warehouse. Knowledge of data warehouse end-to-end implementation processes, from business requirement logical modeling, physical database design, ETL, end-user tools, database, SQL, performance tuning. Demonstrated problem resolution skills with team of persons, and strong leadership with implementation team. Experience in data warehouse design and data modeling (both relational and dimensional) and development and maintenance of multi-dimensional data models. Development experience in implementation of data warehousing utilizing RDBMS. Understanding of data warehouse Metadata concepts, tools and different data warehouse methodologies. Expertise in SQL and proficiency in database tuning techniques. Responsible for the ongoing architecture and design of the data warehouse, data mart, and reporting environments. Develop strategies for flexibility and scalability, and define the future technical architecture direction for the business intelligence reporting physical environment. Relies on experience and judgment to plan and accomplish goals, independently performs a variety of complicated tasks, a wide degree of creativity and latitude is expected. Responsible for proper selection of appropriate hardware, software, tools and system lifecycle techniques for the different components of the end-to-end data warehouse architecture including ETL, metadata, data profiling software, database platform, performance monitoring, reporting and analytic tools. Defining and documenting the technical architecture of the data warehouse, including the physical components and their functionality. Setting or enforcing standards and overall architecture for data warehouse systems. Monitoring the data warehousing industry and assisting in establishing the organization's data warehousing strategy and section of strategic warehousing tools and techniques. Ensuring compatibility of the different components of the DW architecture and ensuring alignment with broader IT strategies and goals. Ability to educate the project teams on the standards and architecture of each component of the data warehouse architecture. Very strong written and oral communication skills, including some presentation skills. Years of experience: 8 or more years of experience in the field Roles and Responsibilities: 1. Participates in designing, developing and refining the State of Michigan Azure database services to ensure that it is secure, reliable, and robust. Implements changes to the Azure environment to increase performance and efficiencies. 2. Develops and implements detection and disaster recovery activities to test Azure services; participates in detecting, investigating, documenting, and reporting actual or potential Azure environment security violations, intrusions, failures,performance or other issues. 3. Designs Azure data migration backbone infrastructure, to provide reliable, optimized, high performance cloud services. 4. Design CEDS (Common Education Data Standard) complaint database and data structure in Azure environment. 5. Evaluates security products and tests security systems performance; assists in planning, implementing, and testing disaster recovery procedures; participates in making formal risk assessments related to the State of Michigan Azure environment. Required: TSQL: 10+ Years Power: 6+ Years Azure DevOps: 6+ Years Scrum: 6+ Years Thanks & Regards, Rosalin Palo Global IT Family Direct +1 518 739 7387 Email: [email protected] www.globalitfamily.com Keywords: information technology microsoft Idaho Michigan http://bit.ly/4ey8w48 https://jobs.nvoids.com/job_details.jsp?id=409501&uid= |
| [email protected] View All |
| 08:38 PM 14-Jul-23 |