Business Intelligence Data Modeler (Tableau/Cognos)
Duration: 3 Weeks with extension (Contract Position, No Benefits Provided)
Hourly Rate: $74 W2; $85 C2C/1099
Development and publication of project management documents and deliverable s in compliance with DIR Framework directives;
Conduct an assessment of HHS 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 an HHS Performance Measurement solution pilot.
Individual should have full technical knowledge of all phases of data and analytics solution planning, design, and implementation.
Worker responsibilities may include:
Ensuring timely and accurate 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).
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
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.
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.
Analyzing source system data, gathering metadata, and developing quality data mappings to support implementation efforts. 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
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.
Proven track record as technical lead on data analytics, data lake, or data warehousing projects
Teradata, Oracle, or SQL Server implementation experience.
Tableau, SalesForce, Business Objects, Cognos, Hyperion, or MicroStrategy implementation experience.
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).