Technical Analyst - Data Migration
First Due
IT
United States · Remote
USD 90k-90k / year
About First Due
First Due’s mission is to prevent first responder injury or death by providing fire and EMS agencies with transformative, end-to-end software solutions that empower them to run safer, smarter, and more effective operations.
Job Title: Technical Analyst - Data Migration
Location: Remote - US Only
Country: United States
Department: Professional Services
Reports To: Senior Manager, Data Migrations
Position Type: Full-Time
Salary: $90,000
Job Summary:
Technical Services Analysts facilitate the migration of data from legacy systems into a client’s site during the implementation phase by working in close coordination with the client, implementation team, and database team. As a Technical Analyst, you will take responsibility for identifying business requirements related to data migration efforts, gathering information and resources related to the implementation, and testing/verifying the integrity of deployed data within the First Due system. Throughout the process, clear and concise documentation should allow all members of the team to track progress and estimated completion of each assigned task.
Key Responsibilities:
- Coordinate with client and implementation team to identify data migration requirements
- Analyze limitations/gaps between legacy client systems and First Due data fields
- Import legacy data provided by clients from a variety of sources (SQL backup files, CSV spreadsheets, TXT files, XML files)
- Restore SQL backup databases to pull legacy data from tables
- Maintain communication with all stakeholders internal and external
- Serve as a technical resource internally and with clients
- Provide guidance to the database team
Qualifications:
- Experience explaining technical processes in simple terms
- Experience in writing SQL statements from scratch
- Experience with authoring SQL queries that pull from multiple tables
- Basic to intermediate understanding of structured data
- Basic to intermediate understanding of relational data structures (databases)
- Basic to intermediate proficiency with Microsoft Excel
- Basic to intermediate understanding of delimited data files, structured data files, and file transport methods
- Demonstrable organizational and time management skills
Preferred Qualifications:
- Some knowledge of the Fire/EMS industry (nice to have)
- Basic to intermediate understanding of GIS components (nice to have)
For US-based Roles
All applicants must be authorized to work for any US employer in the United States. Locality Media LLC is unable to sponsor or transition sponsorship ownership of employment visas at this time. Hiring is contingent upon candidates successfully passing a criminal background check. As part of the I-9 verification of authorization to work in the US, Locality Media participates in E-Verify.
Physical Demands and Work Environment
This role is fully remote with minimal travel expectations at this time. Reasonable accommodation may be made to enable qualified employees and applicants to perform the essential functions as outlined above. If you require an accommodation during the interview process, please reach out to people@firstdue.com.
Working at First Due
First Due offers a comprehensive compensation and benefits package for eligible employees, including competitive pay, medical, dental, and vision coverage, FSA/HSA, 401(k), flexible PTO, a fully remote workplace, a technology stipend, opportunities for advancement, and other benefits and perks that sets our team apart. Visit www.firstdue.com to learn more.
If you are a resident of a state requiring wage transparency, please reach out to people@firstdue.com for a reasonable estimate of annual base compensation and any eligible incentive compensation. The actual compensation offered to successful candidates for roles may be higher or lower, based on non-discriminatory criteria including but not limited to relevant professional experience, geographic location, knowledge, skills, and abilities. This range will be reviewed on a regular basis.
First Due is an equal opportunity employer. We do not discriminate in any aspect of employment on the basis of race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, or disability status, or any other protected status or class. We are committed to promoting an environment of respect, acceptance, diversity and inclusivity, and equal opportunity. Discrimination and harassment of any type in any form will not be tolerated.
When you apply for a role at Locality Media, LLC d/b/a First Due, we collect personal information such as identifiers (e.g., name, email, phone number), professional and employment information, education information, and information you provide in your application materials. We use this information to evaluate your candidacy, communicate with you, and manage our recruiting process. We may share this information with our service providers who assist with recruiting and background screening. We do not sell or share applicant personal information for cross-context behavioral advertising. We retain applicant information in accordance with our data retention policies. California residents have rights under the California Consumer Privacy Act (CCPA), as amended by the CPRA. For more information, please review our Candidate Privacy here.