Database Architect

JSM Consulting Inc
  • Albany, NY
  • Instant Apply
30+ days ago

Job Description



84 Months Experience developing and maintaining logical and physical dimensional data models, including star schema, snowflake schema, and data migration strategies in enterprise data warehouse and business intelligence environments.
84 Months Experience using data modeling tools (e.g., Erwin) for data model design, documentation, and review to ensure compliance with enterprise data standards and development best practices.
84 Months Experience in relational data management, database design, and development using Oracle technologies, including advanced SQL programming for data analysis, optimization, and reporting in data warehouse environments.
72 months of experience supporting healthcare analytics environments, including maintenance and troubleshooting of OBIEE reporting solutions and ETL processes to ensure data availability, accuracy, and business continuity.
48 Months Experience in designing enterprise data integration architecture using Informatica, including implementing best practices and mentoring team members for data warehouse and reporting solutions.
48 Months Experience participating in business analysis and requirements gathering sessions, including translating business requirements into data and reporting requirements.
48 months of experience using business intelligence tools (e.g., OBIEE 11g) to support data analytics, reporting, and enterprise decision-support solutions.
24 Months Experience designing and implementing enterprise OBIEE dashboards and reports, including repository (RPD) development, metadata modeling, and performance tuning for high-volume data mart environments.
24 Months Experience establishing and enforcing enterprise data governance, lineage, and data quality frameworks to ensure data integrity, compliance, and reliable reporting across data marts and reporting environments.
Bachelor's degree in IT field

Numbers & Facts

LocationAlbany, NY

Skills

  • Best Practicesunmatched
  • Business Analysisunmatched
  • Business Intelligenceunmatched
  • Business Intelligence Softwareunmatched
  • Data Analysisunmatched
  • Data Managementunmatched
  • Data Martunmatched
  • Data Migrationunmatched
  • Data Modelingunmatched
  • Data Modeling Toolsunmatched
  • Data Qualityunmatched
  • Data Warehousingunmatched
  • Database Architectureunmatched
  • Database Designunmatched
  • Database Extract Transform and Load (ETL)unmatched
  • Database Programmingunmatched
  • Decision Supportunmatched
  • Dimensional Modelingunmatched
  • Documentation Modelsunmatched
  • Enterprise Architectureunmatched
  • Enterprise Data Integrationunmatched
  • Healthcareunmatched
  • Identify Issuesunmatched
  • Informaticaunmatched
  • Information Technology & Information Systemsunmatched
  • Maintain Complianceunmatched
  • Mentoringunmatched
  • Metadataunmatched
  • Migration Strategyunmatched
  • Oracleunmatched
  • Oracle Business Intelligence Enterprise Edition (OBIEE)unmatched
  • Performance Modelingunmatched
  • Performance Tuning/Optimizationunmatched
  • Reporting Dashboardsunmatched
  • Requirements Managementunmatched
  • SQL (Structured Query Language)unmatched
  • Snowflake Schemaunmatched
  • Standards Developmentunmatched
  • Star Schemaunmatched
  • erwin Data Modelerunmatched

Be found by employers

5,500+ employers search our resume database daily. Add yours to get found by recruiters looking for candidates like you.

Level up your application

Professional resume templates

Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.

Free resume templates

Resume Builder

Improve your existing resume or start from scratch and create a standout, ATS-friendly resume. Add job-specific content, download and apply.

Resume Builder