Data Analyst

Responsibilities

• Have a deep understanding of business needs, application functionality, underlying data processes, and data integration workflows.
• Build strong relationships to serve as the point of contact for IT developers, data teams, and business stakeholders.
• Initiate preliminary business requirements, assess needs, and implement appropriate solutions.
• Evaluate business processes by tracking, trending, and analyzing work processes.
• Troubleshoot issues, identify root causes, and recommend solutions to management.
• Reconcile client accounts related to enrollment and ID card activities by comparing client files to internal data sets.
• Analyze and summarize results for leadership, internal business partners, and external customers.
• Utilize SQL Server, Power Query, and Python to extract, transform, analyze, validate, and automate data processes and reporting activities.
• Develop and maintain queries, reports, dashboards, and data models to support operational analysis, decision-making, and performance monitoring.
• Research incident tickets and email inquiries, answer program and application functionality questions, and identify application defects and data issues.
• Track timely resolution by IT development teams.
• Participate in meetings and sprint planning sessions to ensure technical partners are progressing toward sprint goals and development milestones are on track.
• Assist in training staff or collaborate with trainers to implement new procedures with minimal business disruption.
• Respond to complex special requests that may include data analysis, research, investigation, evaluation, and documentation of findings.
• Develop and maintain work procedure manuals, process documentation, and technical reference materials.
• Serve as project lead for business initiatives that have a broad impact on processes, procedures, workflows, and system functionality.
• Perform other duties as assigned.

Qualifications

• Bachelor's degree in Business Administration, Information Systems, Computer Science, Data Analytics, or a related field preferred; or equivalent experience.
• Minimum of 3-4 years of relevant business analysis, data analysis, or operational experience required.
• Demonstrated experience working with Microsoft SQL Server, including writing, and troubleshooting SQL queries to analyze and validate data.
• Experience using Power Query for data extraction, transformation, automation, and reporting.
• Experience with Python for data analysis, data validation, process automation, and reporting is required/preferred.
• Proficient in Microsoft Office Suite, including advanced Excel functions, and SQL-based data analysis tools.
• Self-motivated, highly organized, and detail-oriented with strong analytical, critical thinking, and problem-solving skills.
• Ability to work in a fast-paced, multi-task environment with effective time management and project management skills.
• Excellent written and verbal communication, collaboration, and customer service skills to support business teams, technology partners, and stakeholders.
• Strong understanding of data structures, business processes, and system functionality within a production environment.
• Must have thorough technical knowledge of business systems, applications, and related data flows.
• Ability to independently manage projects, identify business opportunities, and implement solutions with minimal supervision.

Preferred Technical Skills

• SQL Server Management Studio (SSMS) T-SQL query development and data analysis
• Power Query and Power BI
• Python (Pandas, NumPy, data automation, reporting)
• Data reconciliation, data quality analysis, and root cause investigation
• Agile/Scrum project methodologies