They are looking for someone who is highly proficient in writing and optimizing complex SQL queries, stored procedures, and views for deep data exploration and profiling across large datasets and can lead validation efforts comparing legacy and new data environments, including ETL optimization and data warehouse performance tuning.
Personality and communication skills are a must!
1. Team Collaboration & Communication
- Active Team Participation : The developer is expected to be a true team player-someone who regularly collaborates, shares work for feedback, and participates in group problem-solving. The team values open communication, early identification of blockers, and a willingness to ask for help or input when needed.
- Knowledge Sharing : Team members are encouraged to independently research new tools or features (e.g., Microsoft white papers), validate their findings, and then share insights and best practices with the group. This ensures the team stays current and aligned.
- Proactive Feedback Loop : There is an emphasis on two-way feedback-consultants should both seek and provide constructive feedback, and communicate challenges early to avoid surprises.
2. Business Interaction & Soft Skills
Bridging Technical and Business Needs : The role sits at the intersection of technical development and business engagement. The developer will interact directly with reporting analysts, managers, and occasionally directors-not just with project managers or business analysts. The ability to translate business requirements into technical solutions and vice versa is critical.Consultative Mindset : Success in this role requires guiding business users through the analytics process-from requirements gathering, through solution design, to delivery and support. The developer should be comfortable coaching, eliciting needs, and helping users understand data structures and reporting options.Adaptability & Learning : JM Family values candidates who are quick learners and active learners-those who can pick up new concepts, tools, or approaches rapidly and apply them effectively. The ability to adapt to changing requirements and iterate quickly is essential.3. Independence & Initiative
Balanced Autonomy : While teamwork is crucial, the developer should also be able to work independently-taking initiative, driving tasks forward, and not relying solely on others for direction.Ownership & Accountability : The team expects transparency regarding progress and challenges. Consultants should communicate early if they are stuck or need support, rather than waiting until deadlines are missed.4. Cultural Fit
Collaborative Culture : JM Family's Data team operates in a highly collaborative, iterative environment. The right fit is someone who thrives in a setting where ideas are openly discussed, best practices are developed collectively, and everyone is empowered to contribute.Continuous Improvement : There is an openness to new ideas and approaches, provided they are communicated and vetted with the team.Key Takeaway :
The ideal Data Validation Analyst for JM Family is not just a technical expert, but a strong communicator, collaborator, and active learner-someone who can bridge the gap between business and IT, work well with diverse stakeholders, and contribute to a positive, high-performing team culture.
Data Validation Analyst
Department Overview
The SET DRIVE team is responsible for guiding the SET Business through a large technology transformation effort. Our goal is to move the organization off the legacy technology platform in favor of a cloud-delivered Microsoft-centric ERP solution. The DRIVE Data team manages all phases of data across the project, including creation at source systems, movement through our integration platform, and reporting from our Data Lake.
Position Overview
The Data Validation Analyst will play a critical role in the next phase of the DRIVE Data efforts, focusing on validating the new Datawarehouse against legacy warehouse data. This role will leverage advanced SQL skills to query, compare, and reconcile data across both environments, research discrepancies, and document solutions. The analyst will also evaluate and implement automation tools to streamline validation processes, ensuring data integrity and supporting the transition to new systems.
Position Responsibilities
Design and execute data validation scripts to compare legacy and new Datawarehouse environmentsDevelop and run SQL queries to identify, research, and resolve data discrepanciesDocument validation processes, findings, and solutions for ongoing reference and governanceEvaluate, recommend, and implement automation tools to enhance validation efficiencyCollaborate with Business and IT Partners to ensure alignment on validation requirements and solutionsCapture and report on key metrics related to data quality and validation progressTroubleshoot data issues using SQL and reporting toolsProvide input to data migration and integration projects to ensure data accuracyInteract with various teams and partners to ensure alignment on all above activitiesPosition Qualifications
Strong verbal and written communication skillsExcellent analytical and problem-solving abilities3-5 years' experience with SQL, including complex queries and data reconciliationDemonstrated experience in data validation, data quality assessment, or data migration projectsExperience with automation tools for data validation (e.g., ETL testing, data comparison software) a plusExperience modeling data and / or data governanceExperience with Agile Methodology a plusUnderstanding of Vehicle Processing or Servicing environment a plusUnderstanding of Automotive Industry a plus