Database Architect
Albany, NY, United States
A USD 111K-140K (estimate) Senior-level Full Time
Tasks
- Create data migration strategies
- Design and document database models using modeling tools
- Design data integration architecture using Informatica
- Design star schema and snowflake schema
- Develop OBIEE dashboards and reports
- Develop OBIEE repository RPD and metadata models
- Develop advanced SQL for data analysis optimization and reporting
- Develop logical and physical dimensional data models
- Establish data governance lineage and data quality frameworks
- Maintain and troubleshoot ETL processes
- Maintain and troubleshoot OBIEE reporting solutions
- Participate in requirements gathering and translate business requirements
- Support data warehouse and reporting solutions
- Tune performance for high volume data marts
Perks/Benefits
- N/A
Skills/Tech-stack
Business Intelligence | Data Governance | Data Lineage | Data Quality | Data Warehouse | Dimensional Modeling | ETL | Informatica | OBIEE | OBIEE 11g | Oracle | RPD Development | SQL | Snowflake Schema | Star Schema
Related jobs
-
Featured Feat. Principal Knowledge & Data Architect USD 174K-284KAWS Neptune | Canonicalization | Chunking | Cypher | DBTBenefits including health and wellness programs | Health, wellness, and retirement plansSenior-level Full TimeHeadquarters - Chevy Chase, MD R5d ago
-
Senior Data Architect USD 114K-180KAPIs | AWS Redshift | Apache Airflow | Apache Kafka | Apache SparkSenior-level Full TimeNashville, TN, United States7h ago
-
AWS | Apache Iceberg | Application refactoring | Architectural Reviews | Cloud ComputingFlexible work culture | Mentorship | Work-life balanceSenior-level Full TimeNew York, New York, USA22h ago
-
Agile | Amazon Web Services | Azure DevOps | Cloud Data | Cloud Data PlatformsSenior-level ContractMcLean, VIRGINIA, United States22h ago
-
Agentic Workflows | CI/CD | Docker | Embeddings | Evaluation instrumentationEducational assistance | Health and wellness benefits | Hybrid work schedule | Paid Holidays | Paid maternity and parental bonding leaveSenior-level Full TimeNew Jersey Office - 210 Hudson … R22h ago
-
Software Dev Architect I, Data & Analytics USD 150K-200KAPI Design | AWS | Angular | Automated testing | AzureSenior-level Full TimeTulsa Main Office, United States22h ago
-
Data Architect (DB2, Oracle) USD 120K-136KAccess Control | Cloud Computing | DB2 | Data Architecture | Data GovernanceBenefits | Paid time offSenior-level Full TimeJersey City, United States22h ago
-
Principal Data Engineering USD 112K-193KAzure | Azure Data | Azure Data Factory | Batch Processing | CI/CD401k contribution | Comprehensive benefits package | Equity stock purchase | Incentive and recognition programs | Remote work flexibilitySenior-level Full TimeEden Prairie, Minnesota, UNITED STATES; REMOTE R22h ago
-
Data Engineering Lead Senior Manager USD 148K-306KAWS | Agile | Data Architecture | Data Modeling | Data QualityIndustry training | Professional certificationsSenior-level Full TimeWashington, DC23h ago
-
Data Platform Architect USD 131K-165KAI integration | Artificial Intelligence | Data Architecture | Data Catalog | Data GovernanceSenior-level Full TimeSuitland, MD1d ago
-
API Design | Apache Airflow | Automated testing | CI/CD | DBTComprehensive health care and benefits | Growth opportunities | Inclusion and diversity | Public service missionSenior-level Full TimePhiladelphia, PA, United States1d ago
-
Solutions Architect - Financial Services (Hunter) USD 180K-247KAWS | Apache Spark | Azure | Cloud platform | DSSTravel opportunitiesSenior-level Full TimeGeorgia; Illinois; Massachusetts; New Jersey; New …1d ago
-
Senior Data Architect USD 150K-175KAWS | Azure | Collibra | DBT | Data Architecture401k matching | Flexible PTO | Gym access | HSA employer contributions | Hybrid work scheduleSenior-level Full TimeChicago, IL, US1d ago
-
Data Architect W/Top Secret Clearance USD 135K-175KArchive Recovery | Data Modeling | Data Warehousing | Data acquisition | Database Architecture401k | Dental insurance | Health insurance | Holiday pay | Life insuranceSenior-level Full TimeWashington, DC, United States1d ago
-
Sr. Enterprise Data Architect USD 136K-210KAI Data | AI data readiness | AWS | Apache Spark | Architecture patternsHybrid work | Work from home up to three days per weekSenior-level Full TimeBaltimore, Maryland, United States1d ago
-
AI Solutions Architect USD 148K-226KApache Kafka | Apache Spark | Application Programming | Application Programming Interfaces | Batch ProcessingSenior-level Full TimeTyson's Corner, VA1d ago
-
Data Platform Architect USD 100K-150KAccess Management | Alation | Amazon Redshift | Apache Flink | Apache HudiBenefits package | Full-time W2 employment | Remote workSenior-level Full TimeUnited States - Remote R1d ago
-
Data Platform Architect USD 100K-150KAccess Control | Alation | Amazon Redshift | Apache Flink | Apache HudiRemote workSenior-level Full TimeUnited States - Remote R1d ago
-
Data Platform Architect USD 100K-150KAccess Management | Alation | Amazon Redshift | Apache Hudi | AtlanCareer growthSenior-level Full TimeUnited States - Remote R1d ago
-
C2 Mission Systems Data Architect USD 99K-225KAWS | Amazon Kinesis | Apache Flink | CI/CD | Cloud ArchitectureDependent care | Paid leave | Professional development | Tuition assistance | Work-life programsSenior-level Full TimeUSA, NV, Nellis AFB (4370 Washington …1d ago
-
Senior AI/ML Architect USD 131K-219KAPI Development | AWS | Azure | CI/CD | Data Governance12 paid holidays | Company-matching 401k | Disability benefits | Employee assistance program | Life insuranceSenior-level Full TimeGreenville, United States1d ago
-
Principal, Digital Data Architecture - Remote USD 112K-193KAPIs | Adobe Analytics | Adobe Customer Journey | Adobe Customer Journey Analytics | Adobe Experience401k contribution | Comprehensive benefits package | Equity stock purchase | Incentive and recognition programs | Remote work flexibilitySenior-level Full TimeEden Prairie, Minnesota, UNITED STATES; REMOTE R1d ago
-
Architect of Data Architecture USD 114K-165KAPI Design | API Versioning | AWS | Access Control | Analytics engineering401k with company match | Family and medical leave | Medical, dental, vision and life insurance | Paid Long Term Disability | Paid Short Term DisabilitySenior-level Full TimeKS Remote, United States R1d ago
-
Enterprise Data Architect USD 100K-150KAccess Control | Access Management | Alation | Amazon Redshift | Apache KafkaSenior-level Full TimeUnited States - Remote R1d ago
-
Data Platform Architect USD 100K-150KAccess Management | Amazon Redshift | Apache Flink | Apache Hudi | Apache KafkaBenefits package | Career growth | Remote workSenior-level Full TimeUnited States - Remote R1d ago