Krasan Consulting Services is hiring: Senior Conversion Data Analyst in Springfi

Direct message the job poster from Krasan Consulting Services

Technical Recruiter @ Krasan Consulting Services

Senior Conversion Data Analyst Job Description:

Position Description: The Senior Conversion Data Analyst will lead efforts in data profiling, ensuring a thorough understanding of source and target data structures. The role emphasizes defining and validating data conversion technical requirements, while implementing robust data quality frameworks to maintain accuracy and consistency throughout the conversion process. With strong analytical and communication skills, the analyst will collaborate across technical and business teams to ensure seamless execution of data migration initiatives, supporting organizational goals through high-integrity, data-driven decision-making.

Essential Duties and Responsibilities :

• Data Profiling & Analysis: Conduct in-depth data analysis to identify trends and patterns to guide data cleanup and improve data quality & governance.
• Source-Target Mapping: translate legacy data structures to future-state data model, producing clear & traceable documentation of data conversion requirements inclusive of any gaps or model inconsistencies.
• Stakeholder Communication: Translate complex technical and analytical concepts into simple, actionable insights for business stakeholders. Provide regular updates, reports, and presentations to ensure alignment.
• Agile Delivery: Actively participate in Agile ceremonies, contributing to backlog refinement, sprint planning, and iteration reviews. Partner with Product Owners, Scrum Masters, and technical teams to deliver high-quality solutions on time.
• Technical & Functional Collaboration: Engage in discussions with data engineers, architects, and business users to ensure accurate understanding of both functional requirements and underlying technical components.
• Process & Data Quality Improvement: Recommend and implement improvements in data quality, governance, and operational processes to enhance data reliability and usability.
• Highly skilled in leveraging advanced Excel capabilities such as Power Pivot, Power Query, DAX, dynamic arrays, and VBA to build prototype data models, profile & document data models, automate complex workflows, and deliver actionable insights, guide data cleanup activities or inform process changes to enable ongoing data activity.
• Documentation & Knowledge Sharing: Maintain detailed documentation of data profiling exercises, translate business requirements to technical requirements enabling developers to build ETL pipelines, and prepare presentations for recommended improvements.

Optional

Experience and Education Requirements

• Bachelor’s degree in computer science, Statistics, Business Analytics or related field (master’s preferred).
• Minimum of 8+ years as a Business Analyst on projects of similar size and complexity, with significant experience in data-centric and analytics-driven initiatives.
• Proven experience with relational databases (SQL Server, PostgreSQL, Oracle) and data querying techniques.
• Experience working with large, complex datasets in a cloud-based or on-premises environment.
• Experience with Legacy System Migration
• Familiarity with DW concepts (Required)
• Familiarity with Azure technologies, Informatica are advantageous (ADF, Synapse, Databricks)
• Advanced Excel skills are required.

Knowledge, Skills, and Abilities

• ØAgile Expertise: Extensive experience working within Agile frameworks, including writing user stories and defining acceptance criteria.
• ØData Conversion Projects: Proven experience leading or supporting large-scale data conversion, migration, or transformation projects.
• ØKnowledge & Experience converting IMS/DB2 Data Structures to SQL:
• o BM IMS/DB2 Data structures
• ØAdvanced SQL Proficiency: Expertise in SQL for data extraction, joins, aggregations, and performance tuning.
• ØAdvanced Excel & BI Tools: Advanced expertise in Excel (complex formulas, pivot tables, macros) and/or BI tools.
• ØData Governance: Experience with data governance, data quality frameworks, and metadata management is advantageous.
• ØAnalytical & Problem-Solving Skills: Exceptional critical thinking and problem-solving capabilities, with a focus on delivering actionable insights.
• ØCommunication Skills: Outstanding written and verbal communication skills, with the ability to simplify complex technical concepts for diverse audiences.
• ØOrganization & Independence: Highly organized, detail-oriented, and capable of managing multiple priorities independently in fast-paced environments.

Seniority level

• Mid-Senior level

Employment type

• Full-time

Job function

• Information Technology

Industries

• IT Services and IT Consulting

Referrals increase your chances of interviewing at Krasan Consulting Services by 2x

Sign in to set job alerts for “Data Analyst” roles.

Springfield, IL $46,988.00-$112,200.00 2 weeks ago