Senior Data Analyst

Hi All • • • Greetings from My3tech • • • Role: Data Analyst Location: Hybrid(Austin, TX) Duration : 6+ Months DESCRIPTION OF SERVICES: We are seeking a Data Analyst to support our Strategic Data Architect in conducting comprehensive assessments and analysis of our current case management system ecosystem. This role will perform detailed data discovery, analysis, and documentation to establish the foundation for vendor scoping and selection for our large-scale modernization initiative. The Data Analyst will work closely with the Strategic Data Architect, IT teams, and business stakeholders to evaluate existing data assets, identify gaps, and define requirements that will inform vendor statements of work. Key Responsibilities • Conduct comprehensive data inventory and assessment of the current case management system, cataloging data sources, formats, volumes, quality, and dependencies across all connected systems. • Perform data profiling and quality analysis to identify data inconsistencies, duplications, missing values, and cleansing requirements that will inform migration strategies. • Document current data flows and integration points, mapping how data moves between systems, databases, and external partners to understand complexity and interdependencies. • Analyze business requirements and data usage patterns by interviewing stakeholders and reviewing current reporting, analytics, and operational processes to define future state needs. • Assess compliance and security requirements by reviewing current PII/PHI handling, data classification, and regulatory adherence to establish baseline requirements for vendors. • Evaluate current technical infrastructure and capabilities, documenting existing platforms, tools, databases, and integration technologies to inform modernization planning. • Prepare detailed assessment reports and gap analyses that clearly articulate current state, desired future state, risks, and complexity factors for vendor evaluation. • Support vendor scoping activities by translating technical findings into business requirements, participating in vendor meetings, and helping evaluate proposed solutions against assessment findings. • Create data dictionaries and documentation of critical business entities, relationships, and definitions to ensure consistent understanding across all stakeholders and vendors. • Collaborate with the Strategic Data Architect to prioritize data conversion and migration activities based on business criticality, technical complexity, and risk assessment. • Data Discovery & Profiling – Expertise in using tools and techniques to analyze data quality, completeness, and structure across diverse systems and formats. • Business Requirements Analysis – Strong ability to gather, document, and translate business needs into technical specifications and vendor requirements. • Database Analysis & SQL – Advanced SQL skills for querying complex databases, analyzing data patterns, and documenting existing data structures and relationships. • Data Mapping & Documentation – Experience creating comprehensive data flow diagrams, entity relationship models, and technical documentation for complex systems. • Healthcare Data Standards – Knowledge of healthcare data formats (HL7, FHIR, CCDA) and understanding of PII/PHI compliance requirements in case management contexts. • Legacy System Analysis – Experience working with older database systems, mainframes, and understanding migration challenges from legacy to modern platforms. • Stakeholder Interview & Facilitation – Strong communication skills for conducting requirements gathering sessions and translating business processes into technical documentation. • Data Quality Assessment – Ability to identify data quality issues, estimate cleansing efforts, and recommend data improvement strategies for migration planning. • Reporting & Analytics Understanding – Experience analyzing existing reporting structures, dashboards, and analytics to understand current data consumption patterns. • Vendor Collaboration & Scoping – Experience supporting vendor selection processes, writing RFP requirements, and evaluating technical proposals against business needs. 10 Key Skills Needed 1. Data Discovery & Profiling – Expertise in using tools and techniques to analyze data quality, completeness, and structure across diverse systems and formats. 1. Business Requirements Analysis – Strong ability to gather, document, and translate business needs into technical specifications and vendor requirements. 1. Database Analysis & SQL – Advanced SQL skills for querying complex databases, analyzing data patterns, and documenting existing data structures and relationships. 1. Data Mapping & Documentation – Experience creating comprehensive data flow diagrams, entity relationship models, and technical documentation for complex systems. 1. Healthcare Data Standards – Knowledge of healthcare data formats (HL7, FHIR, CCDA) and understanding of PII/PHI compliance requirements in case management contexts. 1. Legacy System Analysis – Experience working with older database systems, mainframes, and understanding migration challenges from legacy to modern platforms. 1. Stakeholder Interview & Facilitation – Strong communication skills for conducting requirements gathering sessions and translating business processes into technical documentation. 1. Data Quality Assessment – Ability to identify data quality issues, estimate cleansing efforts, and recommend data improvement strategies for migration planning. 1. Reporting & Analytics Understanding – Experience analyzing existing reporting structures, dashboards, and analytics to understand current data consumption patterns. 1. Vendor Collaboration & Scoping – Experience supporting vendor selection processes, writing RFP requirements, and evaluating technical proposals against business needs.