Sr. System/Data Analyst

Job Description

The client is currently in the planning stage of a Data and Analytics initiative with a goal to accomplish the following:

•           Must have accurate written communication for documents and other written commutations for the project.

•           Development and publication of project management documents and deliverables in compliance with Framework directives;

•           Assess data analytics and reporting needs.

•           Creation of an RFP that clearly defines the services and deliverables required of a single vendor to design and implement the data and analytics solution;

•           Obtainment of matching federal funds for this initiative through the development of federally approved IAPD(s);

•           Implementation of a Performance Measurement solution pilot.

•           Individual should have full technical knowledge of all phases of data and analytics solution planning, design, and implementation.

•           Must have excellent oral and written communication skills.

•           Worker responsibilities may include:

•           Ensuring timely and accurate written communications between other application development/support project teams and external stakeholders as appropriate.

•           Analysis and validation of requirements and data sources in the overall design and implementation of data and analytics and performance measurement solution.

•           Development and/or review of plans for infrastructure, storage, and networking requirements for data and analytics and performance measurement solution.

•           Working with business and data analysts, developers, database administrators and requirements analysts to validate the translation of business requirements into technical requirements.

•           Review and validation of conceptual and logical data models from data analysis results of business requirements translation.

•           Assist in cost estimation for project resources – staffing, hardware, and software.

•           Gather, document and/or validate security requirements.

•           In-depth knowledge of databases, data modeling and analytical tools.

•           Interpreting new and changing business requirements to determine the impact on system design

•           Must have excellent skills in requirements analysis, data assessment, business process reengineering, and familiarity with data and analytics design concepts.

•           Responsible for preparation and/or review of any technical designs and/or documents.

•           Provide input and feedback, as requested, to the development of an Implementation Advanced Planning Document (IAPD) and Request for Proposal (RFP).

Requirements:

Yrs       Experience

•           8          Experience on enterprise level systems projects in the Information Technology (IT) industry with a minimum of 4 years on data, analytics, or business intelligence projects. 

•           6          Strong analytical and complex problem-solving skills with experience as a systems analyst for all phases of the system development lifecycle, including requirements analysis, design, development, implementation, operations, and maintenance.

•           4          Data modeling and design for data solutions, i.e., data warehouses, data lakes, data marts.

•           3          Developing processes and procedures for technology road maps and implementation planning for enterprise level systems.   Including the creation and maintenance of diagrams and documentation supporting that effort.

•           3          Analyzing source system data, gathering metadata, and developing quality data mappings to support implementation efforts. 

•           Must expert written communication skills for documents and other written communications for the project.

•           A proven ability to validate that appropriate enterprise data and analytics solution development methodologies are in place that ensure effective management of technical risk, smooth integration of COTS or SaaS products, identification and control of interfaces and development dependencies, and system quality through configuration management quality assurance and testing.

•           Ability to review and assess complex logical data models & support compliance to policies and procedures including data structures & data elements naming standards.

•           Understanding of Metadata concepts, tools and repositories for enterprise data repositories

•           Must have excellent oral and written communication skills.

•           Knowledge of data and analytics solution design and implementation process, from business requirements through logical modeling, physical database design, data sourcing and data transformation, data loading, SQL, end-user tools, database and SQL performance tuning.

•           Proven ability to identify and monitor risks and issues associated with data quality of source system data, the potential impact to a data warehousing solution, and the quality checks and testing required for a successful data acquisition and transformation.

•           Bachelor’s degree in Computer Science, Electrical Engineering, Systems Engineering, or other relevant discipline.

Preferred Skills:

Yrs       Skills/Experience

•           3+        Teradata, Oracle, or SQL Server implementation experience.

•           3+        Tableau, Salesforce, Business Objects, Cognos, Hyperion, or MicroStrategy implementation experience.

•           Proven track record as technical lead on data analytics, data lake, or data warehousing projects

•           Prior experience on an Agile sprint team is preferred.

•           Experience analyzing data and systems for aging, mental retardation and/or developmental disabilities, behavioral health, substance abuse, Medicaid health, or long-term services, including support issues, policies, and/or administration.

•           Experience working in a public-sector environment (State, Federal, county, city, or government-funded private entities that work actively with government organizations).