Apply on Employer Site

NEOGOV · 2 months ago

SENIOR DATA MANAGEMENT SPECIALIST (DATA MIGRATION SPECIALIST)

Thurston County – Olympia, WA

Full-time

Hybrid

Senior Level, Lead/Staff

$94K/yr - $123K/yr

8+ years exp

NEOGOV is seeking a Senior Data Management Specialist to join their team in support of a transformational software replacement project for the Washington Courts of Limited Jurisdiction. This role involves migrating data from legacy systems to a new commercial-off-the-shelf (COTS) solution, ensuring data quality and integrity throughout the process.

GovTechHuman ResourcesInformation TechnologySoftware

No H1B

Responsibilities

Work with project and agency business analysts and technical staff as well as vendor resources to identify field level data mapping, moving data from SQL Server and other data sources and converting it into the COTS products

Responsible for designing, testing, and executing data conversion routines to migrate data from legacy databases into the new COTS database using current ETL tools and best practices

Create and implement automated validation routines to ensure that data quality, integrity, and completeness are maintained; provide reports as requested

Participate in design reviews of high risk, high impact statewide systems and services

Responds to customer service requests and provides expert level troubleshooting, problem resolution and consulting

Participates in design reviews of high risk, high impact statewide systems and services

Reviews and evaluates work products for accuracy and applicability

Performs duties as required

Qualification

ETL toolsSQL ServerData ConversionData CleansingT-SQLInformatica PowerCenterData Quality AssurancePower BIAnalytical skillsProblem-solvingLeadership skillsCommunication skillsTeamwork

Required

A Bachelor's degree in Information Technology, Computer Science, OR closely allied field

Eight (8) years of experience in a complex information technology environment

Five (5) years of experience using modern ETL and data cleansing tools, such as: Informatica PowerCenter Designer, Informatica PowerCenter Workflow Manager, Informatica PowerCenter Workflow Monitor, Informatica PowerCenter Repository, and/or SQL 2012 or higher programmable objects

Preferred

Proven analytical and problem-solving abilities

Strong leadership skills

Ability to effectively prioritize and execute tasks in a high-pressure environment

Good written, oral, and interpersonal communication skills

Ability to conduct research into data, software, and reporting solutions as required by the business

Ability to communicate ideas in business-friendly and user-friendly language

Highly self-motivated and directed

Keen attention to detail

Team-oriented and skilled in working within a collaborative environment

Tact/diplomacy

Skilled in writing SQL queries or other program languages for data verification and quality assurance purposes and creating analysis-ready data tables

Experienced or proficient with computer database software, analytical tools, and other programming languages, including SQL, R or Python, HTML, C#, ArcGIS, and/or other IT-related languages or applications

Experience with Git source control and CI/CD technologies is strongly desired

Demonstrated experience and expertise in T-SQL, SQL Server, Data Conversion, Data Cleansing methodologies

Experience with Extract, Transform and Load (ETL) tools strongly desired

Able to identify key facts in a range of data; notices when data is inaccurate, incomplete, or needs verification; distinguishes information not pertinent to a decision or solution

Breaks down complex information into parts. Sorts and groups data and applies relationships. Sees underlying principles, patterns, or themes in various related information

Detailed-oriented, strong organizational skills, and ability to multi-task in a fast-paced environment

Strong initiative-taker with a positive, can-do attitude, with the ability to work independently and as a team member in a fast-paced environment under tight deadlines

Strong commitment to trust, teamwork, and collaboration principles by demonstrating transparent communication

Experience creating meaningful executive-level reports and data dashboard solutions using tools like SQL Server Reporting Services (SSRS) and Power BI

Ability to communicate effectively and professionally, both orally and in writing. Must possess the ability to communicate technical information to lay audiences using plain language and communicate effectively and efficiently with skilled technical staff

Interpersonal skills to work across divisions and ability to cultivate and maintain effective professional working relationships with co-workers, customers and clients

Ability to learn new concepts and skills, absorb and retain new information quickly