Telework WFH – United States
I. DESCRIPTION OF SERVICES
This position will play a critical role in supporting the transition of reporting and data‑extract capabilities from legacy mainframe IMS systems to the future cloud or data‑lake environment. This position focuses heavily on reverse engineering Mainframe based data extracts and reports, integrating data into Snowflake, and supporting downstream analytics and reporting through Power BI. This role bridges legacy systems and modern cloud-based data platforms, ensuring data accuracy, reliability, and availability for business intelligence needs.
Job Description
Major responsibilities include participating in the detailed sessions with business stakeholders to understand reporting needs, data extract requirements, and downstream data consumption patterns. Develop reverse engineering data extracts documentation to support business reporting and extract needs. Design and implement ETL/ELT pipelines to move data into Snowflake using approved tools and frameworks. Translate business requirements into clear functional and technical specifications for developing the future self-service analytics.
Other responsibilities may include coordination and overseeing the analysis, designs, plans, diagrams, and verifying procedures for existing and proposed applications. Provides technical advice, assistance, and recommendations in matters related to reports’ development.
Essential Job Duties
II. CANDIDATE SKILLS AND QUALIFICATIONS
Minimum Requirements: Candidates that do not meet or exceed the minimum stated requirements (skills/experience) will be displayed to customers but may not be chosen for this opportunity. | ||
Years | Required/Preferred | Experience |
8+ | Required | Hands on experience with Snowflake (SQL, data loading, transformations, performance tuning). |
8+ | Required | Understanding of ETL/ELT concepts, data pipelines, and data integration patterns. |
4+ | Required | Experience building or supporting Power BI reports, datasets, and data models. Strong experience gathering and documenting requirements for reporting, data extracts, or data driven applications |
5+ | Required | Ability to analyze complex data flows and troubleshoot issues across multiple systems. |
4+ | Required | Knowledge of enterprise information management processes and methodologies, relational database management systems, and metadata management |
2+ | Preferred | Knowledge of local, state, and federal laws and regulations (PII) relevant to data management and data governance |
2+ | Required | Experience in working in fast-paced and ever-changing environments; achieving project delivery and deadlines; analyzing complex information and developing plans to address identified issues. |
2 | Required | Skill in interpersonal relationships, including the ability to work with people under pressure, negotiate among multiple parties, resolve conflicts, and establish and maintain effective working relationships with various levels of personnel. |
3+ | Preferred | Experience with Informatica, Matillion, Azure Data Factory, or similar data integration tools. |
- | Preferred | Graduation from an accredited four-year college or university with major coursework in data processing, computer science, business administration, or a related field. |
Note: Expected Start Date 04/01/2026 and End Date 08/31/2026. Position may be renewed up to 3 years. This position is Telework -Work From Home.
Normal business hours are Monday through Friday from 8:00 AM to 5:00 PM, excluding State holidays when the agency is closed. May be required to work outside the normal business hours on weekends, evenings and holidays, as requested.