Description

Scope of Work
DCF is seeking a Senior-Level Lead Full Stack Developer with strong expertise in Tableau reporting and ETL development. The consultant will participate in all phases of the Software Development Life Cycle (SDLC) and support both existing .NET applications and the new SACWIS/CCWIS system.

The candidate will collaborate closely with the System Integrator (SI) to ensure:

Verification of deliverables

Knowledge transfer

Ongoing maintenance and support for assigned modules

Key responsibilities include Tableau report development, SSIS/ETL solutions, SOA integrations, and data architecture support.

Specific Services Required
Lead Developer Responsibilities
Highly organized, proactive, and self-directed

Strong ownership from requirements through implementation

Excellent analytical, abstract thinking, and problem-solving skills

Strong written and verbal communication skills

Technical Responsibilities
Develop and maintain Tableau reports.

Assist in database architecture design, including data marts, dictionaries, and logical/physical models.

Develop strategies for data acquisition, quality, and discrepancy resolution.

Support data migration and integration from legacy to modern platforms.

Develop and maintain complex T-SQL scripts, stored procedures, and triggers.

Access and integrate data from DB2, SQL Server, and other databases.

Design and implement ETL/ELT solutions for ingestion, cleansing, and distribution.

Apply data analytics best practices and near-real-time data solutions.

Coordinate with Business Analysts and end users to validate requirements.

Integrate external data sources with in-house systems.

Test, validate, and reconcile ETL data flows.

Design and implement data conversion strategies.

Optimize SSIS packages and SQL performance.

Design SSIS packages for FTP/SFTP file transfers.

Participate in all SDLC stages: requirements, mapping, extraction, loading, testing, troubleshooting, documentation, optimization, and maintenance.

Deploy Tableau reports to Tableau Server / integrated SharePoint Report Server.

Develop advanced Tableau reports including:

Dynamic grouping and sorting

Drill-down and summary reports

On-demand sub-reports

Key Skills

Education

Any Graduate