ProfessionalServices - Exception Template

Data Analyst II

Position Purpose:
Integrates, conforms, profiles and maps data, and provides quality assurance oversight (data error detection and correction) on business processes where data is collected, stored, transformed, or used. Examines moderately complex data to optimize the efficiency and quality of the data being collected, resolves data quality problems, and collaborates with the business and ETL database developers to improve systems and database designs.

Education/Experience:
A Bachelor's degree in a quantitative or business field (e.g., statistics, mathematics, engineering, computer science) and requires 2 4 years of related experience.

Or equivalent experience acquired through accomplishments of applicable knowledge, duties, scope and skill reflective of the level of this position.

Technical Skills:
One or more of the following skills are desired.

Experience with Big Data; Data Processing
Experience with Data Manipulation; Data Mining
Experience with one or more of the following C# (Programming Language); Java (Programming Language); Programming Concepts; Programming Tools; Python (Programming Language); SQL (Programming Language)
Experience with Agile Software Development

Soft Skills:
Intermediate - Seeks to acquire knowledge in area of specialty
Intermediate - Ability to identify basic problems and procedural irregularities, collect data, establish facts, and draw valid conclusions
Intermediate - Ability to work independently

Responsibilities:

Interprets and analyzes data from multiple sources including claims, provider, member, and encounters data. Identifies and assesses the business impact of trends

Develops, executes, maintains, and troubleshoots moderately complex scripts and reports developed using SQL, Microsoft Excel, or other analytics tools

Identifies and performs root-cause analysis of data irregularities and presents findings and proposed solutions to leadership and/or customers

Manages multiple intermediate, variable tasks and data review processes with limited supervision within targeted timelines and thrives in a demanding, quickly changing environment

Provides business solution architecture and implementation validation

Engages in data profiling and source to target mapping.

Works on moderately complex data integration from disparate sources.

Applies expertise in quantitative analysis, data mining, and the presentation of data to see beyond the numbers and understands how customers interact with analytic products

Supports multiple functions and levels of the organization and effectively, both verbally and visually, communicates findings and insights to non-technical business partners

Engages with customers and business partners to gather requirements and validate results

Presents data-driven insights and recommendations to both internal and external stakeholders, soliciting and incorporating feedback when required
Performs other duties as assigned

Complies with all policies and standards

EEO:

Mindlance is an Equal Opportunity Employer and does not discriminate in employment on the basis of Minority/Gender/Disability/Religion/LGBTQI/Age/Veterans.

=======

Data Analyst II Position Purpose: Integrates, conforms, profiles and maps data, and provides quality assurance oversight (data error detection and correction) on business processes where data is collected, stored, transformed, or used. Examines moderately complex data to optimize the efficiency and quality of the data being collected, resolves data quality problems, and collaborates with the business and ETL database developers to improve systems and database designs. Education/Experience: A Bachelor's degree in a quantitative or business field (e.g., statistics, mathematics, engineering, computer science) and requires 2 4 years of related experience. Or equivalent experience acquired through accomplishments of applicable knowledge, duties, scope and skill reflective of the level of this position. Technical Skills: One or more of the following skills are desired. Experience with Big Data; Data Processing Experience with Data Manipulation; Data Mining Experience with one or more of the following C# (Programming Language); Java (Programming Language); Programming Concepts; Programming Tools; Python (Programming Language); SQL (Programming Language) Experience with Agile Software Development Soft Skills: Intermediate - Seeks to acquire knowledge in area of specialty Intermediate - Ability to identify basic problems and procedural irregularities, collect data, establish facts, and draw valid conclusions Intermediate - Ability to work independently Responsibilities: Interprets and analyzes data from multiple sources including claims, provider, member, and encounters data. Identifies and assesses the business impact of trends Develops, executes, maintains, and troubleshoots moderately complex scripts and reports developed using SQL, Microsoft Excel, or other analytics tools Identifies and performs root-cause analysis of data irregularities and presents findings and proposed solutions to leadership and/or customers Manages multiple intermediate, variable tasks and data review processes with limited supervision within targeted timelines and thrives in a demanding, quickly changing environment Provides business solution architecture and implementation validation Engages in data profiling and source to target mapping. Works on moderately complex data integration from disparate sources. Applies expertise in quantitative analysis, data mining, and the presentation of data to see beyond the numbers and understands how customers interact with analytic products Supports multiple functions and levels of the organization and effectively, both verbally and visually, communicates findings and insights to non-technical business partners Engages with customers and business partners to gather requirements and validate results Presents data-driven insights and recommendations to both internal and external stakeholders, soliciting and incorporating feedback when required Performs other duties as assigned Complies with all policies and standards
Story Behind the Need
What is the purpose of this team? What is driving this need? (ex. Backfill for FTE or CW, new project, business growth) Describe the surrounding team (team culture, work environment, etc.) & key projects. Do you have any additional upcoming hiring needs, or is this request part of a larger hiring initiative?		The team manages most inbound and outbound data feeds, including claims (EDW/RTR), encounters, eligibility, authorizations, member/provider communications automation, and enterprise MFT processes. This position is needed to support the conversion of 300+ MFT jobs from legacy ActiveBatch workflows to the Control-M standard, including tracking, updating, coordinating, and validating the migration effort. No additional upcoming hiring needs.
Typical Day in the Role
Walk me through the day-to-day responsibilities and a description of the project (Outside of the Workday JD). What are performance expectations/metrics? What makes this role unique?			The contractor will spend the majority of the day reviewing existing ActiveBatch (AB) MFT jobs, documenting current schedules/dependencies, updating AB job configurations to align with Control-M standards, and coordinating with internal Control-M and Data management teams to validate successful migration. Performance will be measured by the number of jobs accurately converted, quality of documentation, timely issue resolution, and successful validation with minimal production impact. This role is unique because it supports a high-volume, enterprise-standard migration effort across critical file transfer processes that support multiple operational data feeds.
Candidate Requirements
Education/Certification	Required: Bachelor s degree in Information Technology, Computer Science, Data Analytics, Business Information Systems, or related field				Preferred:
Licensure	Required: N/a				Preferred:
Years of experience required: 2-4yrs Disqualifiers: Additional qualities to look for: Highly organized, detail-oriented, and self-directed, with the ability to manage a high volume of migration tasks, track dependencies, communicate blockers, and follow through on validation steps with minimal oversight. Strong communication skills are important for coordinating with Control-M, Data Management, and business partners throughout the conversion effort.
Top 3 must-have hard skills stack-ranked by importance			1	Job scheduling/workload automation experience
			2	Technical documentation and dependency mapping for migration projects
			3	MFT/SFTP file transfer operations and troubleshooting
Candidate Review & Selection
Shortlisting process Candidate review & selection Interview information Onboard process and expectations			Projected Manager Candidate Review Date:			1-2 days post shortlisting
			Type of Interviews:			Teams
			Required Testing or Assessment (by Vendor):			NA
Next Steps
Do you have any upcoming PTO?			NA
Colleagues to cc/delegate			NA