Data Visualization Developer For Data Warehousing Project: 12+ Months Remote Project (EST Time Zone): W2 Candidates ONLY: $ 84/hr W2 Contract

Remote 100%
Mon -Fri 8am-5pm. Must be able to work EST standard hours. Could be occasional after-hours/weekend support. Will be coordinated as-needed.

SCOPE OF THE PROJECT:

Candidates should be self-motivated, team-oriented, work under limited supervision, and respond to priority tasks. Candidates must be able to independently research and design processes, create specifications, develop, lead testing, perform code reviews, actively engage with the team and stakeholders, attend meetings, provide guidance, and respond promptly.

A Senior Data Visualizations Developer is needed to support the Client Data Warehousing project. This need includes requirements gathering with customers, providing technical advice, time and effort estimates, and project documentation including status reporting. Expected work includes process development and automation, ETL solutions, advanced querying, stored procedure creation, parsing various data formats including xml and HL7, SSIS development and debugging, and report and dashboard development. The developer will help with testing, validations, user acceptance testing, deployment, and post implementation support. Continued support will consist of modifications to include new data elements. Ensure systems are following industry best practices to ensure strategic initiatives and compliance with federal and state regulatory laws and ensure business continuity. The candidate may also provide proactive monitoring processes for immediate identification and resolution of data processing issues.

This position will be a part of the Team responsible for data warehousing, dashboards and reporting, and GIS projects.

DAILY DUTIES / RESPONSIBILITIES:
The candidate will work closely with members of the Data Visualizations, Systems Integration, and Database Administration teams. The candidate should be self-motivated and team-oriented, work under limited supervision, and respond to priority tasks. The candidate must be able to independently research and design processes, create specifications and data flows, develop ETL processes, make stored procedures, advanced queries, reports, and dashboards, assist with validations, actively engage with the Team and stakeholders, attend meetings, provide guidance, and respond promptly.
Participate in a team comprised of client and solution implementation staff for Data Warehousing and Visualization planning, design, configuration, process development, SSIS and script coding, automation of data flows, and transition of functionality into the client s M. S. SQL Server (2016+) Data Warehouse and M. S. Power B. I. Platform. Will coordinate with the assigned IT Section Manager and Team Lead on daily assignments/tasks. Will coordinate and collaborate with contract and vendor staff, existing client staff, and other I. T. professionals working with the Office of Information Technology. Ensure assignments are completed accurately and on time, assist with problem resolution, mitigate issues, provide solutions, communicate, and escalate as needed to management, and report progress to the manager.
Will advise staff on code conversions, database and query design, optimization, process improvements and automation, validations, reporting, and dashboard creation. Work with vendors and staff on deliverables, debugging, and converting of current processes to SSIS and PowerBI. This includes rewriting existing SAS solutions to conform to best practices and updated coding standards and improving efficiency, performance, and maintenance.
Specific duties and responsibilities will include but are not limited to the following:

Prepare and maintain process documentation, data flows, and diagrams for assigned processes (new and existing).
Work with end users to perform gap analysis, gather and document functional requirements, and create necessary processes
Assist with project and time management including estimates and status reporting
Ability to plan, organize, review, and implement associated project milestones to completion.
Process Development, Process Automation, and ETL Solutions
SQL stored procedure creation, advanced query design, debugging, and optimization (MS T-SQL)
Rewriting of SAS code into SSIS Packages and Power B.I.; SSIS Debugging, Rewriting and optimization of remaining SAS code and queries as needed.
Report and Dashboard Development
Help format and automate data uploads into the Data Warehouse and Disease Surveillance Systems like CDC SAMS / EHARS and Conduent Maven
Parsing of multiple data formats including HL7, XML, and CSV
Monitor production processing to ensure proper data flow and response times
Help to perform and automate daily maintenance processes
Debug, troubleshoot, and optimize new and existing processes.
Resolve processing issues.
Support related server, database, software upgrades, and new environment configuration
Ensure maximum system uptime for critical components to ensure business continuity.
Assist with data and database migrations and related changes, testing, and validation
Advise the Team on best practice and techniques. Mentor team and staff on advanced topics.
Modification / rewrite of existing processes and creation of new processes to be compliant with client security requirements and following industry best standards

The candidate will work closely with the Data Visualizations Section Manager and Project Manager to identify, prioritize, and schedule workload and implementation to I. T. standards and procedures. The candidate will also work closely with customers and subject matter experts on process design, migration to the platforms, and testing.

This will also include compliance with client security policy/procedures and integrating systems when possible to streamline staff workflows, user security, data analytics, and reporting.

REQUIRED SKILLS (RANK IN ORDER OF IMPORTANCE):
1. MS T-SQL (STORED PROCEDURES, ADVANCED QUERIES, OPTIMIZATION)
2. ETL PROCESS DEVELOPMENT
3. SQL SERVER INTEGRATION SERVICES (SSIS)
4. POWER BI, REPORT, & DASHBOARD DEVELOPMENT
5. DATA WAREHOUSING & RELATIONAL DATABASES
6. HL7 (V 2.3.1 – 2.5.1; ORU MESSAGES)
7. XML
8. MS SQL SERVER 2016+
9. EXPERIENCE WITH SECURITY AND DATA CLASSIFICATION RELATED TO CDC, HIPAA, CJIS, PHI, PII
10. ABILITY TO DEAL EFFECTIVELY WITH THE NEEDS OF TECHNICAL PEERS, TECHNICAL AND USER MANAGEMENT, USERS, VENDORS, AND STAFF MEMBERS, AND TO COMMUNICATE CLEARLY AND EFFECTIVELY IN SPOKEN AND WRITTEN FORM

PREFERRED SKILLS (RANK IN ORDER OF IMPORTANCE):
1. SOLID BACKGROUND IN DATA INTEGRATION, STAGING, QUALITY AND DISTRIBUTION
2. ABILITY TO MANAGE LARGE DATA SETS (1 TB+)
3. REQUIREMENTS GATHERING & DOCUMENTATION
4. PUBLIC HEALTH / DISEASE SURVEILLANCE SYSTEMS
5. SAS
6. LOINC / SNOMED
7. PYTHON
8. R & RSTUDIO
9. EXCELLENT WRITTEN, ORAL, AND INTERPERSONAL COMMUNICATION SKILLS

REQUIRED EDUCATION: Bachelor’s or Master’s Degree in a relevant field of work or equivalent work experience.