Jr Data Migration & Reporting Analyst

at  Mortgage Automator

Jr. Data Migration & Reporting Analyst at MORTGAGE automator
Are you ready to be part of a game-changing force in the mortgage industry? At Mortgage Automator, we’re not just pushing boundaries; we’re redefining them. Our cutting-edge cloud-based loan management and conveyancing software is setting new standards, automating processes, and empowering our clients across four countries — the US, Canada, New Zealand, and Australia.

Why Join Us?

• Competitive Compensation and Benefits: Enjoy industry-leading wages, comprehensive health benefits, and generous vacation policies.
• Impactful Work: Your contributions will directly influence our strategic initiatives and leverage data to maintain our competitive edge.
• Innovative Environment: Stay at the forefront of technology as you work with the latest tools and techniques in data management and analytics.
• Industry Knowledge: Gain insights into the mortgage industry that can inform personal and professional decisions.
• Vibrant Culture: Join a team that values collaboration, coaching, and continuous learning, where professional relationships flourish.

Job Summary:
We’re seeking a meticulous and analytical Jr. Data Migration & Reporting Analyst to join our Data Solutions team. This role is essential to our data migration projects, involving data analysis, transformation, and report generation to support our clients’ decision-making.

Essential Functions:

• Reporting: Develop, maintain, and optimize reports using proprietary software, Excel, and SQL to meet client needs and provide valuable insights.
• Data Migration: Execute data migration processes, ensuring data accuracy and integrity as data moves from various systems to our platform.
• Data Mapping & Transformation: Design and implement data mapping plans, perform data cleaning, and ensure smooth data conversion based on business requirements.
• Data Validation: Conduct thorough post-migration validation and resolve discrepancies to uphold data quality and accuracy.
• Stakeholder Collaboration: Engage with clients and internal stakeholders to understand reporting needs and deliver data-driven solutions for enhanced data visibility and usability.
• Process Optimization: Identify and implement improvements to data migration and reporting processes for greater efficiency, accuracy, and scalability.

Qualifications & Experience:

• Strong intermediate skills in Excel/Google Sheets (e.g., VLOOKUP, SUMIFS, pivot tables, text formulas).
• Proficiency in Python for data manipulation and analysis.
• Familiarity with data structures and formats such as JSON and XML.
• Demonstrated analytical thinking, problem-solving skills, and attention to detail.
• Effective communicator, able to explain data concepts to non-technical stakeholders.
• Comfortable working independently in a fast-paced, multi-tasking environment.
• Understanding of SQL is a plus but not required
• Experience in Mortgage or Private lending industry preferred.

Ready to revolutionize the mortgage industry? Join us and be part of our journey to greater heights!
Position Status: Permanent
Schedule: Monday to Friday
Work Environment: Hybrid-Remote;
3 days in Office (Toronto) 2 days Work from Home

• Reporting: Develop, maintain, and optimize reports using proprietary software, Excel, and SQL to meet client needs and provide valuable insights.
• Data Migration: Execute data migration processes, ensuring data accuracy and integrity as data moves from various systems to our platform.
• Data Mapping & Transformation: Design and implement data mapping plans, perform data cleaning, and ensure smooth data conversion based on business requirements.
• Data Validation: Conduct thorough post-migration validation and resolve discrepancies to uphold data quality and accuracy.
• Stakeholder Collaboration: Engage with clients and internal stakeholders to understand reporting needs and deliver data-driven solutions for enhanced data visibility and usability.
• Process Optimization: Identify and implement improvements to data migration and reporting processes for greater efficiency, accuracy, and scalability