Sr. Database Analyst / Architect

Role: Database-Analyst Sr - Database Analyst/Architect Location: Lansing,MI Client rate: $50.00/hr Description: Database Analyst Senior – Office of Retirement Services Skills Required: Specific skills required: Database Analyst/Architect 5+ years of experience in the following: • Strong experience in database design, development and software development experience • 5+ years of enterprise database design or architecture experience is required • Expertise in architecting, designing (modeling) and developing backend databases in end-to-end enterprise applications • Must be able to comprehend requirements and work with team to produce Logical Data Model • Experience in ER/Win or similar data modeling tool • Experience in implementing Data Governance • Must be able to work with DBA to transform Logical to Physical model • Experience designing and deploying database reporting and monitoring tools • Strong knowledge with performance optimization and tuning with database applications • Experience in data security, capacity planning and failover procedures • Experience implementing data warehousing and business analytics Experience Preferred: Experience in data analysis related to the following business areas: Healthcare • Healthcare Insurance • Experience with HIPAA (4010/5010), EDI (834) • Knowledge of health care eligibility, online enrollment. Retirement • Retirement and Benefit Estimation • Experience working in Public Retirement systems. • Knowledge of generating benefit estimate Finance and Payments • Accounting principles • Understanding the general ledger • Knowledge in GAAP (Generally accepted accounting principles), • Cash receipts, Cash reconciliation, Account payables, Account receivables, • Invoice, Billing, revenue\expense recording, cash allocation, payment processing, general ledger entries Miscellaneous • Reporting requirement for 401k and 457 plans • History with Pension Plans • Reporting requirements for pension plans Skills Experience required Candidates Exp enterprise design 5 years DB architecture 5 years data modeling 5 years create LDM 5 years db perform optimize 5 year data security 5 years data governance 5 years capacity planning 5 years