Talent.com
System Analyst

System Analyst

Techcliff GroupUnited States
1 day ago
Job type
  • Full-time
  • Quick Apply
Job description

Essential Job Duties

  • SSIS / ETL ( 50%)
  • Design, develop, and maintain automated ETL solutions with Microsoft SSIS (project / deployment model, configurations, parameterization, robust error handling and logging).
  • Orchestrate data movement between SQL Server, Oracle, and Snowflake; where appropriate, integrate Azure Data Factory / Informatica and file automation (e.g., GoAnywhere / MuleSoft).
  • Implement CDC / incremental patterns; tune performance via staging / partitioning, set-based SQL, and workload scheduling to meet SLAs.
  • Follow change management and code migration processes (Azure DevOps / Git); promote from Dev Test / QA Prod with auditable approvals.
  • Troubleshoot build / run failures; create runbooks; monitor and optimize ETL runtimes and job dependencies.
  • System Analyst ( 50%)
  • Elicit and document data & reporting requirements (KPIs, filters, delivery cadence) and translate into functional / data specifications.
  • Produce and maintain S2T mappings, business rules, data dictionaries, and lineage / flow diagrams (current future state) spanning staging, integration, and presentation / reporting layers.
  • Define and execute data quality and reconciliation controls (row counts, checksums / hashes, referential integrity, threshold / exception reports); validate loads back to sources (SQL Server / Oracle / mainframe).

REQUIRED SKILLS

  • 6+Yrs of experience working in a medium to large information technology environment to include ever-increasing responsibility for development, design, and / or deployment actions.
  • 3+Yrs of knowledge and skill using Microsoft SQL Server Integration Services (SSIS)
  • 3+Yrs of knowledge and skill using Microsoft Azure DevOps and Git required, with emphasis on deployment, version control and project tracking
  • 5+Yrs of skill with Microsoft Office tools, particularly with Word, Excel, PowerPoint, Visio, and SharePoint
  • 3+Yrs of hands-on experience in RBDMS (Risk Based Data Management) platform
  • 2+Yrs of knowledge and at least 2 years of experience with Oracle databases with some of that experience being Oracle version 12c
  • 2+Yrs of knowledge and skill using Microsoft SQL Server
  • 2+Yrs of knowledge and skill using Microsoft Azure Cloud database services
  • 2+Yrs of knowledge of database object migration / validation tools
  • 2+Yrs of knowledge and understanding of ETL development, monitoring, batch and / or data processing in an automated scheduled environment
  • 2+Yrs of knowledge of database structures and theories
  • 2+Yrs of knowledge of enterprise information management processes and methodologies, relational database management systems, and metadata management
  • 2+Yrs of knowledge of local, state, and federal laws and regulations (PII) relevant to data management and data governance
  • 2+Yrs of general knowledge of technology across all network layers and computer platforms
  • 2+Yrs of knowledge and experience with the Software Development Life Cycle (SDLC) and project plan understanding.
  • 2+Yrs of excellent written and verbal communication skills, including the ability to present and communicate complex technical information (including on-the-job training) clearly and concisely, both orally and in writing, to diverse audiences which includes coworkers, project team members, and IT management.
  • 2+Yrs of experience in working in fast-paced and ever-changing environments; achieving project's deliverables and deadlines; exercising sound judgment in making critical decisions; analyzing complex information and developing plans to address identified issues.
  • 2+Yrs of 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.

    • PREFERRED SKILLS

  • 5+Yrs of preferred ETL development and data warehouse monitoring
  • 5+Yrs of preferred development using Oracle or Microsoft SQL Server, SQL, systems analysis, systems design, other relevant information technology experience
  • 5+Yrs of preferred development experience using Microsoft SQL Server Integration Services (SSIS)
  • 5+Yrs of preferred development experience using Microsoft Azure Cloud databases
  • 5+Yrs of preferred experience utilizing Microsoft Azure DevOps and Git
  • 2+Yrs of preferred general knowledge of Informatica or similar ETL tool.
  • 2+Yrs of preferred knowledge of master data, metadata, reference data, data warehousing, and business intelligence principles and process, including technical architecture
  • 2+Yrs of preferred experience in data focused projects, like moving from Legacy to newer systems.
  • Graduation from an accredited four-year college or university with major coursework in data processing, computer science, business administration, or a related field.
    • Create a job alert for this search

    System Analyst • United States

    Related jobs
    • Promoted
    Remote Side Hustle Developer

    Remote Side Hustle Developer

    Finance BuzzNowata, Oklahoma, US
    Remote
    Full-time +1
    This position is for individuals who want to develop a side income stream while still working full time.You will test different small-scale remote opportunities, learn what works, and grow what pro...Show moreLast updated: 2 days ago
    • Promoted
    Cyber Warfare Technician

    Cyber Warfare Technician

    NavyIndependence, KS, United States
    Full-time
    ABOUT Enlisted Sailors in the Navy Cryptology community analyze encrypted electronic communications, jam enemy radar signals, decipher information in foreign languages, and maintain state-of-the-ar...Show moreLast updated: 30+ days ago
    Systems Administrator

    Systems Administrator

    The Green Technology Group(Multiple States), US
    Full-time
    Quick Apply
    System Administrator Location : .Remote with 25% travel Department : Contract Delivery Type : Full Time Minimum Experience : 3-5 years in operations and maintenance of systems and netw...Show moreLast updated: 30+ days ago
    IT EUX Engineer L2 - 100% Remote US Only

    IT EUX Engineer L2 - 100% Remote US Only

    Blue MantisUnited States, US
    Remote
    Full-time
    Quick Apply
    The EUX Engineer L2 position offers support to Managed Services contract clients, handling first-level ticket support and serving as the escalation point for more complex issues.Additionally, this ...Show moreLast updated: 15 days ago
    • New!
    Application Analyst

    Application Analyst

    Tror AI for everyoneUnited States
    Full-time
    Quick Apply
    Application Analyst Duration : 6 9 Months Location : Remote ...Show moreLast updated: 19 hours ago
    • Promoted
    • New!
    Integration Technician - Lithia Springs

    Integration Technician - Lithia Springs

    JobotUS
    Full-time
    Wanted : Traveling Integration Technician Out of Our Lithia Springs Office - 80% Traveling is Required!.This Jobot Job is hosted by : Stephen Niedringhaus. Are you a fit? Easy Apply now by clicking th...Show moreLast updated: 21 hours ago
    • Promoted
    • New!
    Integration Technician – Las Vegas

    Integration Technician – Las Vegas

    JobotUS
    Full-time
    Wanted : Traveling Integration Technician Out of Our Las Vegas Office - 80% Traveling is Required!.This Jobot Job is hosted by : Stephen Niedringhaus. Are you a fit? Easy Apply now by clicking the "Ap...Show moreLast updated: 21 hours ago
    • Promoted
    Information Systems Technician

    Information Systems Technician

    NavyBarnsdall, OK, United States
    Full-time
    ABOUT Effective, secure communication in the cyber domain is essential to the everyday operations of military intelligence in America’s Navy. Information Professionals who oversee the seamless opera...Show moreLast updated: 13 days ago
    Salesforce & Systems Administrator

    Salesforce & Systems Administrator

    OneImagingUS
    Remote
    Full-time
    Quick Apply
    Radiology is the second most used healthcare service, used by over 51% of the workforce annually.Despite the critical role of radiology in healthcare, the process for undergoing a medical imaging e...Show moreLast updated: 30+ days ago
    Windows Systems Administrator

    Windows Systems Administrator

    Trinity ES LLCUS
    Full-time
    Quick Apply
    The selected individual will be responsible to support the Framework Services / Platform and Security scrum team, performing operations / maintenance of program Window systems software and associat...Show moreLast updated: 19 days ago
    • Promoted
    • New!
    IT Administrator

    IT Administrator

    JobotUS
    Full-time
    This Jobot Job is hosted by : Amber Wood.Are you a fit? Easy Apply now by clicking the "Apply" button and sending us your resume. Salary : $85,000 - $115,000 per year.We are seeking an IT Administ...Show moreLast updated: 21 hours ago
    • Promoted
    IT Implementation Specialist

    IT Implementation Specialist

    JobotUS
    Full-time
    Top-Ranked Law Firm with Offices Nationwide.This Jobot Job is hosted by : Davis Greinke.Are you a fit? Easy Apply now by clicking the "Apply" button and sending us your resume.Salary : $80,000 - ...Show moreLast updated: 12 days ago
    • Promoted
    IT Professional

    IT Professional

    NavyCherryvale, KS, United States
    Full-time
    ABOUT Effective, secure communication in the cyber domain is essential to the everyday operations of military intelligence in America’s Navy. Information Professionals who oversee the seamless opera...Show moreLast updated: 13 days ago
    System Analyst (Remote - US)

    System Analyst (Remote - US)

    JobgetherUS
    Remote
    Full-time
    Quick Apply
    This position is posted by Jobgether on behalf of a partner company.We are currently looking for a.The System Analyst will play a key role in designing, implementing, and optimizing technology solu...Show moreLast updated: 2 days ago
    System Analyst 3 (Remote - US)

    System Analyst 3 (Remote - US)

    JobgetherUS
    Remote
    Full-time
    Quick Apply
    This position is posted by Jobgether on behalf of a partner company.We are currently looking for a System Analyst 3 in the United States. As a System Analyst 3, you will play a pivotal role in bridg...Show moreLast updated: 8 days ago
    • Promoted
    BAS Systems Specialist

    BAS Systems Specialist

    JobotUS
    Permanent
    Reputable firm in NJ seeking Workers Compensation Attorney.This Jobot Job is hosted by : Kris Leishman.Are you a fit? Easy Apply now by clicking the "Apply" button and sending us your resume.Sal...Show moreLast updated: 26 days ago
    • Promoted
    Senior Systems Administrator (Linux)

    Senior Systems Administrator (Linux)

    Alaka`ina Foundation Family of CompaniesUS
    Full-time
    The Alaka`ina Foundation Family of Companies (FOCs) is looking for a Senior Linux Systems Administrator Range Network.The position will support our government customer located in Kekaha, Hawai'i.Ap...Show moreLast updated: 14 days ago
    Systems Analyst (Remote - US)

    Systems Analyst (Remote - US)

    JobgetherUS
    Remote
    Full-time
    Quick Apply
    This position is posted by Jobgether on behalf of a partner company.We are currently looking for a Systems Analyst in the United States. As a Systems Analyst, you will play a critical role in evalua...Show moreLast updated: 20 days ago