Data Architect - Senior
Lake Park Building, United States
USD 117K-127K Senior-level Full Time
Tasks
- Balance data access optimization and resource utilization
- Build data integration pipeline models
- Create data warehouse standards
- Create data warehouse testing plans
- Create entity relationship diagrams
- Create unit testing and integration testing
- Design data models
- Design data warehouse systems
- Develop ad-hoc SQL queries
- Develop data marts
- Develop solutions with PLSQL
- Develop solutions with Python
- Develop solutions with SQL
- Develop sourcing loading transformation pipelines
- Document business process and process flows
- Ensure data usability
- Implement ETL processes
- Integrate data with standards
- Lead database physical design
- Maintain metadata documentation
- Optimize reporting data presentation
- Perform system and data analysis
- Test and validate data quality
- Troubleshoot data warehouse issues
- Verify data structure accuracy and quality
Perks/Benefits
Skills/Tech-stack
Alteryx | Architecture Modeling | Architecture modeling tools | Azure Databricks | BMC Control-M | Cloud services | Cognos | Control-M | Data Marts | Data Modeling | Data Warehousing | Data integration | Database Design | ETL | Informatica Intelligent Cloud | Informatica Intelligent Cloud Services | Informatica PowerCenter | Integration Testing | Intelligent Cloud Services | Microsoft SQL | Microsoft SQL Server | Modeling Tools | Oracle | PLSQL | Python | R | SQL | SQL Server | SQL querying | Tableau | Unit Testing
Education
Master of Engineering | Master of Science | Master of Science in Computer Science | Master of Science in Information Systems
Roles
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 R7d ago
-
Director, AI Architecture USD 159K-230KAzure | Bias detection | CI/CD | Computer Vision | Data PipelinesOnsite childcare | Paid parental leave | Paid time off | Public Service Loan Forgiveness Qualified Employer | Retirement programsSenior-level Full TimeTexas-Dallas-5323 Harry Hines Blvd7h ago
-
Senior-level Full TimeUnited States - Remote R19h ago
-
Data Platform Architect USD 100K-175KAccess Management | Alation | Amazon Redshift | Apache Flink | Apache HudiRemote workSenior-level Full TimeUnited States - Remote R19h ago
-
Senior-level Full TimeWork at Home - Tennessee, USA …19h ago
-
AWS | Cloud Run | Containerization | Django | Docker401k | Dental insurance | Medical insurance | Paid sick hours | Vision insuranceSenior-level Contract Full TimeSan Jose, CA, United States19h ago
-
Staff Data Platform and Products Architect USD 132K-250KAPI Gateway | Apache Airflow | Apache Beam | Apache Kafka | BigQueryAdoption & Surrogacy Reimbursement | Community service time off | Employee resource groups | Fertility treatments | Flexible family care daysSenior-level Full TimeDearborn, MI, United States20h ago
-
Data Architect USD 110K-200KArtificial Intelligence | Artificial Intelligence Security | Data Architecture | Data Governance | Data ModelingSenior-level Full TimeDC Metro Area22h ago
-
Technical Architect - Enterprise Data USD 138K-200KAI API | AI API integration | API Integration | Azure | Azure DataDiversity and inclusion | Work-life balanceSenior-level Full TimeDallas, TX, United States1d ago
-
Digital Analytics Senior Consultant USD 149K-180KAdobe Experience | Adobe Experience Platform | Adobe Journey Optimizer | Adobe Web SDK | Channel activationSenior-level Full TimeUnited States1d ago
-
Customer Success | Data Engineering | Distributed Systems | Presales | Program ManagementHybrid work | Travel up to 30%Senior-level Full TimeRemote - California; Remote - Colorado; … R1d ago
-
Epic | Health Catalyst) | Qlik | SQL | SnowflakeDriving distance to worksite | Monthly onsite visitsSenior-level Full TimeBellaire, TX, United States1d ago
-
Azure Data -AI -Architect USD 119K-258KAzure Compliance | Azure Data | Azure Data Factory | Azure Databricks | Azure DevOpsSenior-level Full TimeUSA1d ago
-
Data Architect USD 165K-190KAccess Control | Azure | Canonical Data | Canonical Data Modeling | Cloud Architecture401k match | Dental insurance | Medical insurance | Mental health support | Paid HolidaysSenior-level Full TimeMinneapolis, MN1d ago
-
Enterprise Cybersecurity AI Architect USD 128K-237KAI Services | API | API Gateways | API Security | Adversarial Machine LearningSenior-level Full TimeAtlanta, GA, United States1d ago
-
Angular | Autogen | CI/CD | Databricks | Distributed SystemsMentoring system | Professional developmentSenior-level Full TimeJersey City, NJ, United States1d ago
-
Principal AI Engineering Architect USD 224K-308KAWS | Data Processing | Docker | Google Cloud | High AvailabilityAdoption and surrogacy reimbursement | Cancer Care Program | Employee Assistance Program (EAP) | Fertility coverage | Flexible time offSenior-level Full TimeUnited States - Remote R1d ago
-
Data Warehouse Architect USD 145K-217KAgile | Data Governance | Data Lineage | Data Modeling | Data QualityRemote workSenior-level Full TimeRemote - Texas, United States R1d ago
-
Data Infrastructure Architect USD 175K-200KAccess Management | Alation | Amazon Redshift | Apache Hudi | AtlanRemote workSenior-level Full TimeUnited States - Remote R1d ago
-
Solutions Architect USD 116K-165KAWS | Access Control | Apache Airflow | Azure | Azure DataDisability insurance | Health, dental, and vision benefits | Hybrid work schedule | Paid Holidays | Retirement plan matchSenior-level Full TimeRICHMOND, VA, US, 232191d ago
-
Big Data Architect USD 100K-150KAccess Management | Alation | Apache Flink | Apache Hudi | Apache IcebergCareer growth | Mentorship | Remote workSenior-level Full TimeUnited States - Remote R1d ago
-
Principal Data Architect, CMC Digital USD 145K-234KAccess Control | Amazon Redshift | Architecture-as-Code | Business glossary | Cloud DataDiscretionary year end shutdown | Family planning benefits | Health insurance | Location-specific perks | Mental health supportSenior-level Full TimeMTC North - Norwood - USA …1d ago
-
Database Administrator (DBA) / Data Architect USD 111K-155KAWS | Access Control | Azure | Backup & Recovery | CI/CDSenior-level Full TimeAuburn Hills, MI, United States1d ago
-
Senior Director, Fellow, Data Architect USD 136K-285KAccess Management | Apache Airflow | Apache Iceberg | Automated testing | AzureFlexible resources and tools | Paid leaves | Paid volunteer time | Wellbeing programsSenior-level Full TimeNew York, NY, United States1d ago
-
Data Solutions Architect USD 116K-223KAgile | Amazon Web Services | Apache NiFi | Azure Data | Azure Data Factory401k with company match | Dental insurance | Health insurance | Learning and development reimbursement | Paid HolidaysSenior-level Full TimeChicago, Denver, Houston, Minneapolis, New York1d ago