Public Safety Technical Consultant - Migrations

Ll Oefentherapie; United States; Remote; USD 60,000 - 100,000; Full time

Job summary

An innovative firm is seeking a Public Safety Technical Consultant to join their dynamic team. This role focuses on assisting clients with data migrations to cutting-edge public safety solutions, ensuring data integrity and accuracy throughout the process. You will collaborate with various stakeholders to develop tailored migration strategies and utilize your technical expertise to solve complex data challenges. If you are passionate about technology and eager to make a significant impact in public safety, this position offers a unique opportunity to contribute to transformative projects in a fast-paced environment.

Qualifications

• 2+ years of experience in data migration and public safety software.
• Proven ability to develop data migration strategies and documentation.

Responsibilities

• Collaborate with stakeholders to define data migration requirements.
• Monitor migration processes and troubleshoot issues during data transfer.

Skills

Data Migration

Data Analysis

Database Management

SQL

ETL Tools

Problem-Solving

Communication Skills

Education

Bachelor's Degree in Computer Science

Equivalent Work Experience

Tools

JIRA

PowerShell

Python

Job description

Who We Are:

The Oracle Local Government Global Industry Unit has launched a modern suite of public safety SaaS applications and hardware for the Local Government markets using cutting edge technologies. These are exciting times in our space - we are growing fast and delivering innovative solutions to public safety agencies.

Who You Are:

The Public Safety Technical Consultant is a key member of the Oracle Public Safety implementation team responsible for assisting customers in migrating historical data to the Oracle public safety solution. Part of this results-oriented role will include planning, executing, and validating data migrations, ensuring data integrity, accuracy, and consistency throughout the implementation. Candidates for this role should be excited about pushing the boundaries of traditional data migrations and adopting new technologies and tools to accomplish successful customer outcomes. This role requires the ability to adapt to change quickly, a drive for results, and a “never satisfied” mentality. You will be an early team member of this fast-growing and exciting line of business at Oracle.

What you will do:

• Collaborate with stakeholders, project managers, and technical teams to define data migration requirements, objectives, and scope for each project.
• Develop detailed data migration strategies, including timelines, resources, and risk assessments for assigned project.
• Identify data sources, target systems, and determine the appropriate migration approach (ETL, direct transfer, etc.).
• Work with customers to analyze and understand the structure and format of source data to ensure accurate mapping to the target system.
• Design and implement data transformation rules to ensure data is compatible with the target system's schema.
• Create and maintain data mapping documentation for reference and future audits.
• Develop and execute scripts, queries, or tools to extract, transform, and load data from source to target systems.
• Monitor the migration process, troubleshoot issues, and resolve any errors that occur during data transfer.
• Conduct testing and validation of migrated data to ensure completeness, accuracy, and compliance with requirements.
• Prepare detailed documentation of migration processes, including technical specifications, workflows, and data models.
• Provide regular progress reports to stakeholders, highlighting any risks, issues, or delays.
• Create post-migration reports and assist in post-migration audits to ensure data accuracy and completeness.
• Offer post-migration support to address any issues or concerns that arise after data migration.
• Use your exceptional customer service skills to guide customers through a successful migration process.

What you've done:

• Bachelor’s degree in computer science, information technology, data management, or equivalent (minimum 8 years) work experience.
• 2+ years of technical and/or consulting experience architecting enterprise and application solutions in public safety software.
• Proven experience in data migration, data analysis, or database management.
• Experience with data migration tools and techniques (e.g., ETL tools, SQL, data mapping tools).
• Familiarity with different database systems (e.g., Oracle, SQL Server, MySQL) and data formats (e.g., CSV, XML, JSON).
• Excellent analytical and problem-solving skills, with attention to detail.
• Ability to work independently and collaboratively in a fast-paced environment.
• Strong communication skills, with the ability to translate technical concepts into business terms.
• Proven self-starter that proactively develops working relationships with key internal and external stakeholders.
• Demonstrated experience in requirements gathering, use-case documentation, business analysis, integrations/interfaces, data conversions and other key elements of public safety implementations.

It would be awesome if you also had:

• Knowledge/familiarity with Oracle products and services, including Oracle Cloud Infrastructure (OCI)
• Experience working in a public safety position
• Management experience including hiring, developing and leading a team
• Experience with product development tools such as JIRA
• Experience with PowerShell, Python, or other programming languages

Note:

This is a Criminal Justice Information Systems (CJIS) sensitive position and will require a fingerprint-based background investigation, conducted by customer criminal justice agencies, to determine an applicant’s eligibility for access to criminal justice information. Employees hired for this position will be required to obtain and maintain CJIS access approval by Federal, state, and/or local agencies for Criminal Justice information, related law enforcement databases, and communications systems.

We are unable to provide visa sponsorship for this role at this time. No candidates requiring visa sponsorship will be considered.

#LI-Remote

#LI-JC1