Data Analyst - Licensing System

Consulting, IT, Analyst, SQL, System, Architect, C, Management, Systems
Full Time

Job Description

Overview

About Public Consulting Group

Public Consulting Group, Inc. (PCG) is a leading public sector solutions implementation and operations improvement firm that partners with health, education, and human services agencies to improve lives. Founded in 1986 and headquartered in Boston, Massachusetts, PCG has over 2,500 professionals in more than 60 offices worldwide. PCG's Technology Consulting practice offers a full spectrum of quality Information Technology (IT) services to help state and local government agencies at every stage of the IT life cycle. Through its specialized IT services, PCG's Technology Consulting team finds cost-effective ways to help agency partners deliver successful IT systems that enhance the lives of the user base. To learn more, visit https://www.publicconsultinggroup.com/technology-consulting/

Responsibilities

The Data Analyst is responsible for the data related requirements and design, data integrity and security, data mapping for application migration and integration, and data flows during project implementation. This client facing role will include but not limited to analyzing Client's existing data and the solution requirements to design how all data will be handled, including how data will be migrated, how data flows through all the integrated systems, how the data will be used and analyzed, complete data mapping, understand and develop database schemas, and designing/developing/managing SQL databases. The Data Analyst will collaborate with the System Architect on decisions about the technologies and the architecture to be used to support the data requirements on projects. A strong understanding of SQL is required along with a basic understanding of third-party data management tools such as MS SQL Server, PowerBI, Informatics, etc

Responsibilities:
• Create and manage data flow diagrams and responsible for understanding the overall data ecosystem of large enterprise systems
• Analyze current state data model and Design future state conceptual unified data model,
• Develop data migration pipeline between source and staging databases to future state target database.
• Design and implementation of data creation and data migration of thru SQL programs/scripts
• Demonstrate expertise on platform specific object data model
• Perform database release automation process and support continuous Integration & Delivery
• Use creative problem-solving to automate the collection and analysis from available data sources in order to deliver actionable output.
• Participate in post migration support, troubleshooting and answering end user questions
• Review and analyze data, matching it with migration scenarios, and determining where there are anomalies

Qualifications

Required Skills/Experience:
• 8+ years of relevant work experience in analytics, system development, programming, data engineering, business intelligence or integration services..
• 5+ years of programming experience in languages like SQL, C#, etc
• 5+ years of hands-on experience with data analysis tools like SQL Query Analyzer and SQL Reporting.
• 5+ years of hands-on experience in writing complex, optimized SQL queries across large datasets.
• 3+ years of demonstrable ability in data analysis, data modeling, and data warehousing, or similar skills
• 3+ years of hands-on experience in analysis of current state data model and design of future state conceptual unified data model.

Desired Skills/Experience:
• Experience with enterprise tools, such as Licensing Management Systems and Payment Portal
• Looking at the environment (clients, partner agencies and vendors) holistically and understanding how the project will impact areas beyond the stated scope.
• Leading teams with diverse skill sets in multiple locations, including offshore
• Bringing experience with many types of technologies and delivering out-of-the-box thinking and creative problem-solving possibilities.
• Multi-vendor, multi-year project experience.

#D-PCG

#LI-AH1

EEO Statement

Public Consulting Group is an Equal Opportunity Employer dedicated to celebrating diversity and intentionally creating a culture of inclusion. We believe that we work best when our employees feel empowered and accepted, and that starts by honoring each of our unique life experiences. At PCG, all aspects of employment regarding recruitment, hiring, training, promotion, compensation, benefits, transfers, layoffs, return from layoff, company-sponsored training, education, and social and recreational programs are based on merit, business needs, job requirements, and individual qualifications. We do not discriminate on the basis of race, color, religion or belief, national, social, or ethnic origin, sex, gender identity and/or expression, age, physical, mental, or sensory disability, sexual orientation, marital, civil union, or domestic partnership status, past or present military service, citizenship status, family medical history or genetic information, family or parental status, or any other status protected under federal, state, or local law. PCG will not tolerate discrimination or harassment based on any of these characteristics. PCG believes in health, equality, and prosperity for everyone so we can succeed in changing the ways the public sector, including health, education, technology and human services industries, work.
Dice Id : RTL111231
Position Id : 2021-7092
Originally Posted : 1 month ago
Have a Job? Post it

Similar Positions

Functional Manager - Licensing & Payment Portal (Public Sector)
  • Public Consulting Group, Inc.
  • Sacramento, CA, USA
Lead Business Analyst (CA PAL Process)
  • Public Consulting Group, Inc.
  • Sacramento, CA, USA
Salesforce Integration Architect
  • Public Consulting Group, Inc.
  • Sacramento, CA, USA
Cyber Security Analyst
  • Public Consulting Group, Inc.
  • Sacramento, CA, USA
Director, Technology Consulting
  • Public Consulting Group, Inc.
  • Sacramento, CA, USA
Senior Enterprise Architect
  • Delegata
  • Sacramento, CA, USA
IT Operations Manager
  • Kelly
  • Folsom, CA, USA
Level 1 Flex Technician
  • Kelly
  • Folsom, CA, USA
Senior Programmer Analyst
  • Sacramento Regional Transit District
  • Sacramento, CA, USA
Full Stack Web Application Designer
  • Kelly
  • Folsom, CA, USA