| Job Title: Azure Data Warehouse Developer at Harrisburg, Pennsylvania, USA |
| Email: [email protected] |
| From: saloni chaurasia, tekinspirations [email protected] Reply to: [email protected] Hi, I Hope you are doing great. Please find below position if you have any matching candidate as per requirement. Please send me updated resume with candidate information. Job Title: Azure Data Warehouse Developer Location: Harrisburg, PA ( Remote ) - _ Need Candidates Local to PA or nearby states only as there is occasional travel for Meetings Duration: 6+ Months MS Teams Interview The resource will be required to report on-site to pick up equipment on first day. Also my be required to report on-site periodically for meetings. Do you accept this requirement CONTRACTOR SKILLS AND EXPERIENCE REQUIREMENTS REQUIRED SKILLS: - The Architect has the ability to design, develop, and implement data and ETL application infrastructure in Azure to provide reliable and scalable applications and systems to meet the organizations objectives and requirements. - The Architect is familiar with a variety of the application technologies, environments, concepts, methodologies, practices, and procedures. - Candidate must have significant, hands-on technical experience and expertise with data lakes, data bricks, Azure data factory pipelines, Spark, and Python. - Significant, hands-on technical experience and expertise with leading the design, implementation and maintenance of business intelligence and data warehouse solutions, with expertise in using the SQL Server and Azure. - Producing ETL/ELT using SQL Server Integration Services and other tools. - Experience with SQL Server, T-SQL, scripts, queries. - Experience with data formatting, capture, search, retrieval, extraction, classification, and information filtering techniques. - Experience with data mining architectures, modeling standards, reporting and data analysis methodologies. - Experience with data engineering, database file systems optimization, APIs, and analytics as a service. - Analyzing and translating business requirements and use cases into optimized designs and developing sound solutions. - Advanced knowledge of relational databases, dimensional databases, entity relationships, data warehousing, facts, dimensions, and star schema concepts and terminology. - Ability to balance work between multiple projects and possess good organizational skills, with minimal or no direct supervision. - Ability to work and communicate collaboratively and effectively with colleagues, and as a member of a team. - Ability to present complex technical concepts and data to a varied audience effectively. - More than 12 years of relevant experience. - 4-year college degree in computer science or related field with advanced study preferred. PREFERRED EXPERIENCE: - Experience working in the public health or healthcare industry with various health data sets. Fill the skill matrix below: Skill Required/Desired Amount Candidate's No. of years of experience 4-year college degree in computer science or related field Required Years of relevant experience Required 12 Experience and expertise with data lakes, data bricks, Azure data factory pipelines, Spark, and Python. Required 12 Experience with leading the design, implementation and maintenance of business intelligence and data warehouse solutions using Azure and SQL Server Required 12 Producing ETL/ELT using SQL Server Integration Services and other tools. Required 12 Experience with SQL Server, T-SQL, scripts, queries. Required 12 Experience with data formatting, capture, search, retrieval, extraction, classification, and information filtering techniques. Required 12 Experience with data mining architectures, modeling standards, reporting and data analysis methodologies Required 12 Experience with data engineering, database file systems optimization, APIs, and analytics as a service. Required 12 Advanced knowledge of relational databases Required 12 Experience working in the public health or healthcare industry with various health data sets. Highly desired 12 ADDITIONAL : ISSUING OFFICE - This request is issued from the Commonwealth of Pennsylvania Office of Administrations Office of Information Technology (OA/OIT). - The position will have a reporting relationship to the Health and Human Service Delivery Center (HHSDC) within the OA/OIT supporting the Pennsylvania Department of Health (DOH), Department of Drug and Alcohol Programs (DDAP), and the Bureau of Epidemiology. BACKGROUND/PROBLEM STATEMENT - The COVID-19 pandemic is affecting all Pennsylvanians and data is a critical part to DOHs response to the pandemic. - In response, DOH leadership has formed a Data Modernization Initiative, with the vision that all public health policies and interventions are driven by data, and the mission to provide all internal and external public health decision makers with accessible, timely, reliable, and meaningful data to drive policies and interventions. - The Enterprise Data Warehouse (EDW) is responding to DOHs need for centralized data and state of the art data analysis services by modernizing its data portfolio, and statistical analysis capabilities, aimed at improving public health surveillance, interventions, outcomes, and research. - There is an elevated need for the design, development, implementation, and maintenance of data warehouse solutions for the Bureau of Epidemiology and the EDW. - This position will support both the existing business and reporting requirements of individual DOH / DDAP systems and program areas, and the construction of a modern data warehouse that will serve DOH / DDAP from an enterprise perspective. INCURRING COSTS - The PA Department of Health is not responsible for any costs or expenses incurred by the contractor for parking. RESOURCES - The contractor will be permitted to work from home, but office space for the contractor will be provided as needed. - In addition, DOH will supply all necessary hardware and software for daily use that are needed to complete assigned work items. OBJECTIVES OF ENGAGEMENT - The primary objective of this engagement is for the selected candidate to serve as the data warehouse developer supporting the analysis and reporting needs of the DOH / DDAP, and the design and construction of a modern EDW in Azure. OPERATIONAL REQUIREMENTS - The Architect is a senior level resource with advanced, specialized knowledge and experience in data warehousing, database, and programming concepts and technology. - The selected contractor must have proven experience in the development, maintenance, testing, and maintenance of Azure production systems and projects. - This position designs, develops, tests, and implements data lakes, databases, extract-load-transform programs, applications, and reports. - This position will work with business analysts, application developers, DBAs, network, and system staff to achieve project objectives - delivery dates, cost objectives, quality objectives, and program area customer satisfaction objectives. The contractor will be required to: - Manage assignments and track progress against agreed upon timelines. - Plan, organize, prioritize, and manage work efforts, coordinating with the EDW and other teams. - Participate in status reviews, process reviews, deliverable reviews, and software quality assurance work product reviews with the appropriate stakeholders. - Participate in business and technical requirements gathering. - Perform research on potential solutions and provide recommendations to the EDW and DOH. - Develop and implement solutions that meet business and technical requirements. - Participate in testing of implemented solution(s). - Build and maintain relationships with key stakeholders and customer representatives. - Give presentations for the EDW, other DOH offices, and agencies involved with this project. - Develops and maintains processes and procedural documentation. - Ensure project compliance with relative federal and commonwealth standards and procedures. - Conduct training and transfer of knowledge sessions for system and code maintenance. - Complete weekly timesheet reporting in PeopleFluent/VectorVMS by COB each Friday. - Complete weekly project status updates in Daptiv if necessary. This will be dependent on a project being entered in Daptiv. - Provide weekly personal status reporting by COB Friday submitted on SharePoint. - Utilize a SharePoint site for project and operational documentation; review existing documentation. Regards, Saloni Chaurasia { Technical Recruiter } TEK Inspirations LLC Pvt. Ltd. | 13573 Tabasco Cat Trail, Frisco, TX 75035, United States E-Mail: [email protected] Keywords: microsoft Pennsylvania Texas |
| [email protected] View all |
| Fri Jan 05 20:08:00 UTC 2024 |