| Data Architect (with Strong SQL Exp)- Olympia, WA || 100 % remote at Olympia, Washington, USA |
| Email: [email protected] |
| From: Tanul, 3b staffing [email protected] Reply to: [email protected] Data Architect (with Strong SQL Exp) One visit to Washington Only USC or GC Work is remote, but the consultant must be available to pick up equipment on-site in Olympia, WA. We need to submit and hire this contract ASAP, so your timely response is appreciated. Responsibilities of the Data Architect/Developer will include the following deliverables, in no particular order: Deliverable #1 Contractor will work with ALTSA Data Services staff to architect and implement cloud technologies, such as designing and setting up a Power BI environment for the organization. Contractor will need to be familiar with Azure data-related constructs and tools. Contractor will need to be proficient in middle-tier scripting languages, such as Power Shell and Python. Work includes: Analyze current state of ALTSAs on-prem system and gather requirements. Analyze current system. Assess need. Work with Data Services team to understand purpose and processes. Gather requirements. Architect solution Work with Data Services team and business stakeholders to architect solution. Implement solution. Solutions will be developed using an agreed upon, maintainable framework. Test solution Work with Data Services team and business stakeholders to test solution. Document processes. Provide knowledge transfer as needed. Deliverable #2 Contractor will work with ALTSA Data Services staff to architect and implement an on-prem data infrastructure and reporting solution for One Washingtons new FDM data model. The solution will consist of staging tables, star schemas, and cubes feeding canned and self-service reports, which currently source data from the AFRS data model along with other conformed areas of ALTSA/DDA business. Contractor will need to be proficient in on-prem data constructs and tools, such as Transact SQL, SSAS, SSIS, and SSRS. Work includes: Analyze current state of ALTSAs systems and gather requirements. Analyze current systems. Assess need. Work with Data Services team to understand purpose and processes. Gather requirements. Architect solution Work with Data Services team and business stakeholders to architect solution. Implement solution. Solutions will be developed using an agreed upon, maintainable framework. Test solution Work with Data Services team and business stakeholders to test solution. Document processes. Provide knowledge transfer as needed. Deliverable #3 - Address team technical debt within Data Services canned and self-service reporting infrastructure. Examples include rearchitecting/speeding up slow reporting systems, refactoring SSAS solutions, rearchitecting/refactoring slow data loading systems, etc. For all assigned work products, work includes: Analyze current system, assess need, and gather requirements. Design solution. Review designed solution with Data Services staff. Implement Test solution. Document processes. Provide knowledge transfer as needed. Deliverable #4 Create/refactor Power BI, and SSRS reports. For each assigned work product, work includes: Analyze current state and gather requirements. Design solution. Create/refactor Power BI or SSRS report as assigned. Test to ensure correctness of solution. Document processes. Provide knowledge transfer as needed. Deliverable #5 Create/refactor ETL processes. For each assigned work product, work includes: Analyze current state and gather requirements. Design solution Create/refactor SSIS package as assigned. Test to ensure correctness of solution. Document processes. Provide knowledge transfer as needed. For all development work related to the above three deliverables, the following responsibilities are expected: Work activities are to be performed in coordination with the Data Services Team. Work will be overseen and tracked in Data Services DevOps environment. All work products will be designed, implemented, and maintained in an efficient, reusable, and reliable manner using ALTSA standards. Work will be coordinated with and overseen by Data Services to ensure expectations are met for timeliness and quality of provided solutions. The SQL Developers hours will be associated with relevant work products and be billed accordingly. The Contractor will work remotely over a VPN connection using a State-issued laptop to perform work relevant to this contract. The Contractor will be required to pick up the laptop from ALTSA Help Desk staff at the start of the contract and return it at the cessation of the contract. Help Desk is located at Blake East Office Park Building located at 4500 10th Ave SE, Lacey, Washington. Please arrange pick up and drop off with Raul Black or his successor. Keywords: business intelligence information technology green card Washington Data Architect (with Strong SQL Exp)- Olympia, WA || 100 % remote [email protected] |
| [email protected] View all |
| Mon Jun 10 21:57:00 UTC 2024 |