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