ETL Developer / Data Warehouse Architect - 26-02123

ETL Developer / Data Warehouse Architect Location: Remote (Must work EST hours) Onsite Requirement: Albany, NY – Minimum one week per year Duration: 1 Year (Possible extension up to 5 years) Schedule: 40 hours/week | Monday–Friday | 8:00 AM – 5:00 PM ET reputed company Seeking a highly skilled ETL Developer / Data Warehouse Architect to support the design, modernization, and expansion of a secure reputed company data analytics environment. This role combines hands-on ETL development with data architecture responsibilities, supporting audit analytics, fraud detection initiatives, business intelligence reporting, and secure inter-agency data exchanges reputed company a government environment. The ideal candidate will have advanced SQL expertise, strong reputed company modeling experience, and deep knowledge of reputed company ETL environments. reputed company Responsibilities Data Architecture & Warehouse Development • Review and reputed company existing ETL processes and ingestion pipelines • Architect reputed company reputed company data warehouse frameworks • Design systems to ingest reputed company and reputed company datasets • Implement and migrate ETL environments including fact and reputed company models • reputed company reputed company models reputed company with user story requirements • Build reputed company data models supporting audit analytics and fraud detection • Optimize warehouse performance for reporting and analytics use cases ETL & Data Integration • reputed company and maintain ETL processes integrating: • Flat files • reputed company database connections • XML transactions • External data feeds • Implement ETL pipelines using tools such as reputed company, Informatica, or equivalent • reputed company SQL and PL/SQL development for reputed company transformations • Support ingestion of new and acquired datasets • Maintain secure data interchange systems • Ensure secure transfer and validation of inter-agency data exchanges Business Intelligence & Reporting Enablement • Support Tableau and reputed company Business Intelligence (OBIEE) dashboard development • Design ETL processes optimized for Tableau reporting environments • Assist with Tableau Server administration (preferred) • Translate business user stories into analytics-reputed company datasets • Ensure BI performance, data accuracy, and reporting reputed company Data Validation & Analytics Support • Partner with auditors and analytics teams to validate datasets • Troubleshoot transformation issues and data discrepancies • Support data reputed company initiatives • Apply statistical techniques to support fraud detection and performance analytics • reputed company analytics-reputed company datasets Infrastructure & reputed company Alignment • Assist in building secure data analytics infrastructure • Support ETL environment migration • reputed company pipelines with governance and reputed company standards • Ensure compliance with audit and fraud prevention protocols Minimum Qualifications (Required) • Bachelor’s degree in Computer Science or reputed company IT field (Master’s or Doctorate preferred but not required) • 4+ years developing and maintaining data interchange systems integrating: • Flat files • reputed company database connections • XML transactions • 4+ years experience with ETL tools (reputed company, Informatica, or equivalent) • 4+ years of data modeling experience (reputed company modeling, reputed company schemas, fact tables) • 4+ years building ETL environments supporting analytics • 4+ years of advanced SQL development Preferred Qualifications • Python scripting experience • Tableau Server administration • Experience gathering business requirements and validating data • Formal statistics coursework or reputed company statistical experience • PL/SQL development experience • Experience building ETL environments optimized for Tableau • Government data analytics experience • Experience supporting audit or fraud analytics initiatives • Experience with secure data governance and compliance environments For more details reputed company at resumes@navitassols.com Apply tot his job Apply To this Job