Azure Data Warehouse Developer

Job Summary:

Position: Azure Data Warehouse Developer (public health or healthcare industry experience is preferred)

Location: Harrisburg, PA

Duration: 6+ Months

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.

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 organization’s 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.
• Candidate must have significant, hands-on technical experience and expertise with data lakes, data bricks, Azure data factory pipelines, Spark, and Python.
• 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, API’s, 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.

Required/Desired Skills:

• 4-year college degree in computer science or related field
• 12 Years of relevant experience
• Experience and expertise with data lakes, data bricks, Azure data factory pipelines, Spark, and Python.
• Experience and expertise with data lakes, data bricks, Azure data factory pipelines, Spark, and Python.
• Experience with leading the design, implementation and maintenance of business intelligence and data warehouse solutions using Azure and SQL Server
• 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, API’s, and analytics as a service.
• Advanced knowledge of relational databases
• Experience working in the public health or healthcare industry with various health data sets.

Skills

• data lakes, data bricks, Azure data factory pipelines, Spark, Python, Azure, SQL Server, business intelligence, data warehouse, ETL/ELT, T-SQL, scripts, queries, data formatting, capture, search, retrieval, extraction, classification, data mining architectures, modeling standards, reporting, data engineering,database file systems optimization, API