• Dedicate ~60% of your time to the programming side: building our data platform, developing ETL processes, managing DAGs, and ensuring our data formation is robust and reliable. • Spend ~30% of your time as a Data Analyst, breaking down business questions from Sales, Marketing, Finance, and Product Managers into actionable data models straight into DAGs. • Work closely with all our relevant internal stakeholders to ensure they have the data they need to drive UpCloud’s growth. • Organize and take ownership of our in-house systems to make data more accessible and useful for every user in the company.

Role Description We are seeking a skilled Data Migration Specialist to play a critical role in integrating newly acquired businesses into our systems and driving data excellence across the organization. In this role, you will lead the migration, cleansing, and transformation of data from multiple CRM sources into our core PestPac platform — ensuring accuracy, consistency, and seamless business continuity. This is a unique opportunity to contribute to the backbone of our M&A success and help shape scalable data practices in an exciting environment. Responsibilities: - Coordinate the execution of cross-functional tasks from the M&A integration playbook, supporting multiple data migration projects simultaneously. - Analyze a variety of CRM systems to understand data structures, relationships, and anomalies. - Design data extraction and mapping schemas from legacy systems to Lookout CRM in order to support business and system requirements. - Develop repeatable migration processes, including extracting, transforming, and importing customer data. - Clean, standardize, and transform data to align with Lookout’s CRM configuration while identifying and resolving data quality issues. - Collaborate with technical and non-technical stakeholders to validate migrated data for accuracy, completeness, and integrity. - Document, track, & communicate progress of data mapping and migration activity. - Act as a liaison between internal teams and external parties during migration processes. Qualifications - 3 or more years’ experience in data migration within the pest control industry. - Experience with business operations (branch structure, service workflows, billing, scheduling, and customer management) to guide data mapping and ensure migrations reflect real-world processes. - Experience migrating CRM platforms, including systems such as PestPac, FieldRoutes, and Briostack, with a focus on maintaining data integrity, minimizing downtime, and ensuring seamless user adoption. - Experience with analyzing and transforming complex legacy datasets by developing and applying business-driven transformation rules, including complex formulas, reconciling legacy data structures, formats, and values with the data requirements of the target software. - Experience designing and executing migration pathways, including staging environments, parallel system testing, and post-migration support. Requirements - Project management experience (preferred). Benefits - Health care (medical, dental, vision, life insurance, disability). - 401K match (6%). - Paid time off. - Parental leave. - Financial planning services. - Continuous education. - Career growth opportunities: We believe in promoting from within. Company Description Lookout Pest Control is a dynamic, high-growth company with a strong focus on mergers and acquisitions, rapidly expanding our footprint across the industry. With over 40 years in the business, Lookout originated as a family-founded company, and we are proud to continue that reputation and culture today. - Reports directly to Director of Systems Migration. - Established company with a strong customer base and a track record of success with ambitious plans for growth. - We are an equal opportunity employer that complies with EEOC rules and regulations. - Committed to diversity, equity, and inclusion. - Our hiring decisions are based exclusively on merit, qualifications, and business needs.

• Design, build, and maintain scalable data pipelines across diverse environments • Integrate data from multiple internal and external sources into data warehouses or data lakes • Collaborate closely with Data Scientists, ML Engineers, and Developers to ensure data quality, structure, and availability • Monitor and improve data integrity, performance, and reliability • Build and optimize database schemas, data models, and documentation • Implement data governance, security best practices, and compliance standards

Role Description The Data Engineer is responsible for designing, building, and maintaining scalable data pipelines and modern data platform components that support enterprise analytics, reporting, and operational data needs. This role plays a key part in evolving the organization’s data architecture from legacy application databases to a modern cloud-based data warehouse built on a medallion architecture. The position requires strong technical expertise in SQL Server, cloud data platforms, and modern ELT practices while working closely with analytics, application development, and business teams to deliver reliable, well-governed data assets. The Data Engineer contributes to the design and implementation of a high-performance data ecosystem that supports advanced analytics, business intelligence, and data-driven decision making. How You’ll Drive Success - Data Pipeline Engineering - Design, develop, and maintain scalable data pipelines that ingest and transform data from enterprise platforms including NetSuite, Salesforce, HubSpot, and internally developed applications. - Develop efficient ELT workflows using modern integration tools such as Fivetran, Integrate.io, Azure Data Factory, or similar technologies to automate data ingestion and transformation. - Build and optimize SQL-based transformations and orchestration processes that support reliable and efficient movement of data across the organization’s data platform. - Data Warehouse Architecture and Development - Design and implement dimensional data models and curated datasets within a modern medallion architecture data warehouse environment. - Develop and maintain data layers supporting development, test, and production environments across cloud data platforms including Azure Data Lake, Snowflake, or equivalent platforms. - Implement scalable data structures and transformation frameworks using SQL, dbt, or similar tools to support high-performance analytics workloads. - Analytics and Business Intelligence Enablement - Develop and maintain analytical models including SQL Server Analysis Services (SSAS) cubes and semantic layers supporting enterprise reporting and analytical applications. - Collaborate with analytics and business intelligence teams to deliver optimized data models and datasets for visualization tools including Power BI and Tableau. - Ensure the accuracy, integrity, and availability of analytical data assets used across reporting and business intelligence environments. - Data DevOps, Governance, and Platform Operations - Implement and support database and data pipeline deployment processes using Visual Studio, Azure DevOps, Azure Git repositories, and Red Gate SQL Change Automation. - Monitor, troubleshoot, and optimize data platform performance, data pipeline reliability, and data quality across the enterprise data ecosystem. - Maintain clear documentation of data models, pipelines, architecture, and operational procedures to support maintainability and knowledge sharing. - Performs other duties as assigned. Qualifications - Bachelor’s degree in Computer Science, Information Systems, Data Engineering, Data Science, or a related technical discipline. Requirements - 4 - 5 years of experience in data engineering, database development, or enterprise data warehousing environments. - Demonstrated experience building and maintaining data pipelines and large-scale data integration processes. - Experience working with SQL Server, relational database technologies, and modern cloud data platforms. - Experience integrating and modeling data from SaaS business applications such as Salesforce, NetSuite, or HubSpot. - Experience supporting analytics platforms and business intelligence tools such as SSAS, Power BI, or Tableau. Preferred Skills - Strong SQL development and data modeling skills with the ability to analyze complex data structures and design scalable solutions. - Ability to work within a structured development lifecycle utilizing version control, CI/CD pipelines, and DevOps practices. - Ability to collaborate effectively with software engineers, analysts, and business stakeholders to deliver reliable and well-governed data solutions. - Proficiency with Microsoft Office (Word, Excel and PowerPoint) as well as calculator, telephone systems, company network and familiarity with CRM tools. - Proven time management skills and a track record of working in a team environment successfully supporting others. - Well-organized, attention to detail and able to multitask. - Strong communication skills, both written and verbal, with the ability to provide accurate and timely information in a succinct and easy to understand manner. - Problem solving and analysis skills.