[Remote] Developer/Programmer Analyst
Note: The job is a remote job and is open to candidates in USA. Largeton Group is seeking a Developer/Programmer Analyst, Level 3 to support the transition of reporting and data extraction from legacy Mainframe IMS systems to a modern Snowflake cloud data-lake environment. The role focuses on data integration, ETL/ELT pipeline development, Power BI reporting, data validation, technical documentation, and production support.
Responsibilities
- Support transition of reporting and data extraction from legacy Mainframe IMS systems to modern cloud/data-lake (Snowflake) environment
- Bridge legacy systems with current cloud/data platforms
- Ensure data accuracy, reliability, and availability for business intelligence (BI) needs
- Reverse engineer mainframe-based data extracts and reports
- Integrate legacy data into Snowflake
- Support analytics and reporting via Power BI
- Work with stakeholders to gather and document data/reporting requirements
- Design and implement ETL/ELT pipelines to Snowflake
- Translate business needs into technical specifications
- Collaborate with data engineers and architects for data modeling, schema design, and transformation logic
- Validate and reconcile data across Mainframe, Lonestar, Open Systems, and Snowflake
- Develop data conversion and system implementation plans
- Design and maintain database schemas
- Support and enhance Power BI datasets, semantic models, and dashboards
- Troubleshoot data pipeline issues from extraction to reporting
- Document technical processes, data flows, and system dependencies
- Participate in code reviews, testing, documentation, and production support
- Provide technical guidance for report and data pipeline development
Skills
- 6+ years with Snowflake (SQL, data loading, transformations, performance tuning)
- 6+ years with ETL/ELT concepts, data pipelines, and data integration
- 4+ years building and supporting Power BI reports and data models
- 4+ years gathering/documenting requirements for data/reporting solutions
- 5+ years analyzing data flows and troubleshooting across multiple systems
- 4+ years in enterprise information management, relational databases, and metadata management
- 2+ years in fast-paced environments, meeting deadlines, complex analysis, and issue resolution
- 2+ years strong interpersonal skills (negotiation, conflict resolution, stakeholder management)
- 3+ years with data integration tools (Informatica, Matillion, Azure Data Factory, or similar)
- Knowledge of laws/regulations for PII, data management, and data governance
- Bachelor s degree in Data Processing, Computer Science, Business Administration, or related field
Benefits
- 100% Remote / Work-from-Home
Company Overview
Company H1B Sponsorship