Job Closed
This listing is no longer active.
End-to-end software for Fire & EMS agencies - built to run your entire operation in one place.
Technical Analyst - Data Migration
Location
United States
Posted
31 days ago
Salary
$90K / year
Seniority
Mid Level
Job Description
Technical Analyst - Data Migration
First Due
Role Description 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 - Testing/verifying the integrity of deployed data within the First Due system - Providing clear and concise documentation 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) Requirements - 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 . Benefits - Competitive pay - Medical, dental, and vision coverage - FSA/HSA - 401(k) - Flexible PTO - A fully remote workplace - A technology stipend - Opportunities for advancement - Other benefits and perks that set our team apart Company Description 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.
Related Guides
Related Categories
Related Job Pages
More Data Analyst Jobs
Operations Data Analyst
GDKN Corp.The staffing solutions division of GDKN is a leading provider of end-to-end solutions in the temporary staffing space. With companies across the globe laying critical emphasis on their human resources management, demand for temporary staffing is rapidly growing because it improves focus on core/critical activities and can be adapted to the seasonal nature of business, addresses business uncertainties and the demand for rapid growth. In short, temporary staffing creates a very nimble human capital platform which allows organizations to maximize their productivity and flexibility at all times. GDKN is one of the very few minority business enterprises in North America that has the status of Preferred vendor with world’s largest corporations in various industries including: Electric Gas Telephone Utilities Manufacturing Defense Banking/Financial Information Technology Healthcare/Pharmaceutical
Role Description A fast-moving organization is seeking 3 Operations Data Analysts to support a high-impact, short-term data initiative. This project will focus on analyzing operational data, improving reporting accuracy, and generating insights that drive better decision-making. This is an excellent opportunity for early-career professionals or recent graduates to gain hands-on experience in a real-world business environment while working alongside a collaborative and fast-paced team. Key Responsibilities - Analyze operational datasets to identify trends, inconsistencies, and actionable insights - Clean, organize, and validate data to ensure accuracy and reliability - Build and maintain reports using Excel to support business operations - Collaborate with cross-functional teams to understand data needs and deliver insights - Assist in improving data processes and reporting workflows Qualifications - Strong proficiency in Microsoft Excel (required) - High level of attention to detail and analytical thinking - Ability to work independently in a remote, fast-paced environment - Strong written and verbal communication skills in English - Bachelor’s degree (or currently pursuing) in a related field preferred Requirements - Exposure to data analysis, reporting, or operations-related work (nice to have) - Experience with large datasets or basic data cleaning techniques (nice to have) Benefits - Gain hands-on experience on a real business-critical project - Build practical data analytics skills in a short timeframe - Work with a collaborative and fast-paced team environment Company Description The staffing solutions division of GDKN is a leading provider of end-to-end solutions in the temporary staffing space. With companies across the globe laying critical emphasis on their human resources management, demand for temporary staffing is rapidly growing because it improves focus on core/critical activities and can be adapted to the seasonal nature of business, addresses business uncertainties and the demand for rapid growth. In short, temporary staffing creates a very nimble human capital platform which allows organizations to maximize their productivity and flexibility at all times. - GDKN is one of the very few minority business enterprises in North America that has the status of Preferred vendor with world’s largest corporations in various industries including: - Electric - Gas - Telephone Utilities - Manufacturing - Defense - Banking/Financial - Information Technology - Healthcare/Pharmaceutical
• Lead the identification and analysis of business requirements within the BI context to develop strategic insights. • Design data models that effectively transform raw data into actionable insights. • Use advanced Power BI capabilities to build dynamic dashboards and interactive visual reports. • Define and implement key performance indicators (KPIs) with clear targets, ensuring regular monitoring and analysis. • Translate business needs into comprehensive technical specifications and establish realistic project timelines. • Develop, test, and deploy complex Power BI scripts, performing in-depth analyses to improve data interpretation. • Proficiently write and execute DAX queries and functions within Power BI to extract meaningful insights. • Produce clear and comprehensive charts and data documentation describing algorithms, parameters, models, and relationships. • Make technical adjustments to existing BI systems to improve overall performance. • Apply advanced filtering and visualization techniques in Power BI to enhance data understanding. • Analyze current ETL processes and design and implement new systems to streamline data processing.
• Lead the identification and analysis of business requirements within the BI context to develop strategic insights. • Formulate data models that effectively transform raw data into actionable insights. • Utilize advanced features of Power BI to create dynamic dashboards and interactive visual reports. • Define and implement key performance indicators (KPIs) with specific objectives, ensuring their regular tracking and analysis. • Translate business needs into comprehensive technical specifications and establish realistic timetables for project completion. • Develop, test, and deploy complex Power BI scripts, conducting efficient deep analysis to enhance data interpretation. • Proficiently run DAX queries and functions within Power BI to extract meaningful insights. • Create clear and comprehensive charts and data documentation explaining algorithms, parameters, models, and relationships. • Make technological adjustments to existing BI systems to improve overall performance. • Utilize advanced filtering and visualization techniques in Power BI to enhance data understanding. • Analyze current ETL procedures and design and implement new systems to streamline data processing.
• Administer and develop the Sigma BI platform across the organization • Partner with stakeholders to understand reporting needs and translate them into scalable dashboard solutions • Plan and prioritize the reporting roadmap in collaboration with the Director of Analytics • Drive internal adoption; communicate platform capabilities, train users, and market BI as a resource • Ensure consistent KPI definitions, data accuracy, and documentation across all reporting • Own and maintain PDF-based lender reports including reconciliation, performance, and compliance call reports • Support the long-term buildout of embedded lender reporting within the Sigma platform • Collaborate with external partners and lenders on reporting requirements and delivery • Lead the migration of existing PowerBI and SSRS reports into Sigma • Prioritize migration backlog in partnership with stakeholders and the analytics team • Maintain documentation of migrated vs. outstanding reporting inventory • Ramp on LendKey’s Taktile decisioning platform through structured knowledge transfer • Progressively own maintenance of existing flows and support new flow development • Write and optimize complex SQL queries in Databricks to support reporting and analysis • Collaborate on ETL improvements and data pipeline reliability


