7.30.2013

data architect (State of Michigan)

SOA Data Architect - Information Technology Specialist 14 at $26.92 - $39.35 hourly
Department: Technology, Management and Budget

The Agency Services Bureau supporting the Michigan Department's of Technology, Management & Budget, Civil Service Commission, Department of Education, and Center for Educational Performance and Information (CEPI) is recruiting to fill an Information Technology Specialist 14 position.  The position will serve as the CEPI Data Architect (CDA) is responsible for Data Services architecture, governance and implementation as it relates to software development at Agency Services/ CEPI.   The CDA implements enterprise data services governance within the meta-data management repository, oversees all data services development, and ensures that all data services are integrated into the enterprise data framework.  In collaboration with Service Oriented Architecture (SOA) designs agency data frameworks that integrate in to the enterprise data frameworks.  Develops and propagates data subscriptions and standards to the development areas. Conducts testing and implementation of data services components and trains development staff on their use. Is responsible for data services developer tools. Mentors Senior development staff on correct tool usage and data modeling standards. As the Data Architect, is primarily responsible for defining and implementing relational data models and OLAP solutions, including infrastructure planning and design, for CEPI’s strategic Statewide Longitudinal Data System (SLDS) program.  In this capacity, the CDA provides relational and OLAP database designs for the SLDS and assists CEPI and Agency Services staff with ETL design and implementation.

KNOWLEDGE, SKILLS, AND ABILITIES

·         Thorough knowledge of Database Design.
·         Thorough knowledge in use case modeling, transaction and OLAP-based data modeling and use of related modeling tools, and the development and documentation of detailed technical design specifications.
·         Thorough knowledge in developing and using SQL databases and queries.
·         Thorough knowledge in developing and using SAS databases and queries.
·         Thorough knowledge of Internet protocols, and .NET system design concepts.
·         Thorough knowledge of Service Oriented Architecture (SOA).
·         Thorough knowledge of design and development.
·         Skills to analyze multiple system architectures and points of system interaction.
·         Thorough knowledge of application and network security issues.
·         Ability to troubleshoot under difficult circumstances and to independently act to resolve issues that need immediate attention.
·         Ability to plan, resource and lead projects.
·         Ability to quickly learn and implement new technologies and procedures.
·         Ability to establish and maintain good rapport with agency staff at all levels.

=== Required Education and Experience

   Education
Possession of a bachelor's degree with at least 21 semester (32 term) credits in computer science, data processing, computer information systems, data communications, networking, systems analysis, computer programming, or mathematics.
   Experience
Four years of professional experience equivalent to an Information Technology Infrastructure or Programmer/Analyst P11 or one year equivalent to an Information Technology Infrastructure or Programmer/Analyst 12.

6.15.2013

State of Michigan

Job #: 6401-13-PSC-108 Jaya           Job Title: Departmental Analyst E 9-11
Salary: $18.50 - $28.97 hourly          Department: Licensing and Regulatory Affairs - LARA

This entry level analyst performs economic and statistical analysis of utility reports, financial records, and rate case presentations to determine the appropriate level of rates for regulated energy utilities, utilizing laws, regulations, and Commission policies and precedents.
This analyst must develop the skills and expertise to testify as an expert witness in contested rate proceedings.

=-=-= also, Database Development Specialist     Department: House of Representatives     Salary: Negotiable

The Database Development Specialist is a member of the Information Systems Department for the Michigan House of Representatives. Responsibilities include database design and implementation, development of new databases and applications, maintenance of existing databases and applications. Development environment for desktop and web-based applications include VB.NET, ASP.NET, SQL Server and FileMaker Pro databases.

5.31.2013

database architect, State of Michigan

Job Title: ITS 14 Database Solution Architect
Salary: $26.92 - $39.35 hourly (x2000 hours/year)
Location: Lansing, Michigan
Dept: Technology, Management and Budget

--Description
This position will support the DHS Legacy applications, MiSACWIS, MI Bridges and Bridges application databases.  This position is the UNIX Database Server Architect; serving as the backup to the ITS 15 DBA.  The incumbent must have a solid understanding of the UNIX operating based system, understands paging and swapping, inter-process communication, devices and device drivers and can preform system analysis and tuning.  The incumbent will identify database and UNIX Operating System tasks which should be automated and then write tools to automate them.  The incumbent will be able to program in at least two or more administrative languages, (shell, Perl, Awk, TK) and port C programs form one platform to another and write small C programs.
This position supports approximately 10 production database servers with over 1600 Oracle schemas with 10+ TB of data for over 90 applications for the following environments: Production-PROD, User Acceptance Testing-UAT, Quality Assurance Testing-QAT, Integration-INT, and Development-DEV.

--Education
Possession of a bachelor's degree with at least 21 semester (32 term) credits in computer science, data processing, computer information systems, data communications, networking, systems analysis, computer programming, or mathematics.

--Experience
Four years of professional experience equivalent to an Information Technology Infrastructure or Programmer/Analyst P11 or one year equivalent to an Information Technology Infrastructure or Programmer/Analyst 12.

2.23.2013

State of MI (SoMI) statistician

Job #:ks-4301-12-Stat13-C7
Job Title:Statistician Specialist 13 - CSA Quality Improvement
Closing Date/Time:Tue. 02/26/13 5:00 PM Eastern Time
Salary:$24.42 - $35.84 hourly
Bargaining Unit:SCIENTIFIC AND ENGINEERING (SEIU)
Location:Lansing, Michigan
Department:Human Services - Central Office



  Description

Position functions as the statistical expert for the Children’s Services Administration - Division of Continuous Quality Improvement (DCQI).  Position is responsible for the completion of highly complex work assignments involving sample design, creation of queries, statistical evaluation and verification of data integrity, analysis and calculations of data. Position is also responsible for development of child welfare reports, spreadsheets and graphics for use in presentations or inclusion in documents. Position will act as the expert for reporting on child welfare DCQI data related items as specified in the Modified Settlement Agreement, Child and Family Services Review, Child and Family State Plan (5 year plan), etc.

  Education

Possession of a bachelor’s degree with at least 12 semester (18 term) credits in statistics.

  Experience

Four years of professional experience in the systematic collection, compilation and interpretation of numerical data equivalent to a Statistician, including two years equivalent to a Statistician P11 or one year equivalent to a Statistician 12.

2.01.2013

State of MI - dept of tech, management, budget


 -- note job scope and training requested

The Center for Educational Performance and Information (CEPI) is recruiting to fill three Departmental Analyst 9-P11 positions in its Longitudinal Data unit.
 
In each of these positions, the analyst will be responsible for documenting, integrating, analyzing, and reporting from complex, multi-agency data resources in a manner that accurately portrays information on Michigan students, staff, and schools over time. The work includes supporting the creation of an environment that encourages maximum use of CEPI’s Michigan Statewide Longitudinal Data System (MSLDS) for improving education policy decision-making and meeting federal and state data reporting requirements. These positions work closely with the reporting and implementation team managers in achieving the overall goals of the Longitudinal Data unit and CEPI by responding to the education data needs of schools, state agencies, the Legislature, the Governor’s office and other stakeholders. 
 
Note: the focus of one position is that of a reporting analyst.  In this role, the employee will follow the standards, policies, procedures and protocols related to data quality, reporting tool designs/models, and other data manipulation techniques.   Ideal candidates for this position will have a concentration of college courses in statistical theory, logic and analytics, as well as database design and modeling.
 
The focus of the other position (two jobs) is that of an extraction, transformation and loading (ETL) analyst.  The employee will follow the standards, policies, procedures and protocols related to extraction, transformation, and loading (ETL) processes, quality assurance activities, and other data manipulation techniques.  Ideal candidates will have a concentration of college courses in information management systems that include database design and modeling.  Note:  If you applied for one of these two ETL positions in December-January 2012 your application has been retained.  It is not necessary to reapply.