Sr. Database Analyst / Architect
About this role
Company Description
Job Description
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
Ā
Ā
Ā
Qualifications
Additional Information
Frequently Asked Questions
Is the salary disclosed for the Sr. Database Analyst / Architect position at stemxpert1?
Where is the Sr. Database Analyst / Architect position at stemxpert1 located?
Is the Sr. Database Analyst / Architect role at stemxpert1 full-time or part-time?
How do I apply for the Sr. Database Analyst / Architect position at stemxpert1?
When was the Sr. Database Analyst / Architect job at stemxpert1 posted?
You'll be redirected to stemxpert1's official application page on SmartRecruiters.