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
-
Access Control | Amazon Redshift | Apache Iceberg | Data Architecture | Data CatalogSenior-level Full TimeAustin, Texas, United States; Dallas, Texas, …5h ago
-
APIs | Access Management | C++ | Cloud infrastructure | Code reviewSenior-level Full TimeNew York, NY, USA; Chicago, IL, …7h ago
-
Delivery Solutions Architect USD 180K-247KBusiness Analysis | Consulting | Customer Success | Data Architecture | Distributed SystemsAnnual performance bonus | Comprehensive benefits | Equity | Executive stakeholder access | Hybrid workSenior-level Full TimeSouthwest - United States19h ago
-
Sr. Delivery Solutions Architect USD 180K-247KBusiness Analysis | Data Engineering | Data Intelligence | Data Intelligence Platform | Distributed SystemsHybrid work | Travel up to 30 percentSenior-level Full TimeWest Coast - United States19h ago
-
Delivery Solutions Architect USD 180K-247KBusiness Analysis | Data Architecture | Discovery Workshops | Distributed Systems | Executive CommunicationHybrid work | Travel 30 percentSenior-level Full TimeCentral - United States19h ago
-
AWS | Apache Spark | Azure | Cloud platform | Data WarehousingTravel opportunitiesSenior-level Full TimeGeorgia; Illinois; Massachusetts; New York; North …19h ago
-
Solutions Architect - Financial Services (Insurance) USD 180K-247KAWS | Apache Spark | Artificial Intelligence | Azure | Cloud platformTravel opportunitiesSenior-level Full TimeGeorgia; Illinois; Massachusetts; New York; North …20h ago
-
Salesforce CRM Analytics and Sales/Service Architect USD 151K-207KAPI Integration | Agile delivery | CRM Analytics | Dashboard Design | Dashboard bindingsSenior-level Full TimeSunnyvale, CA, United States21h ago
-
Senior AI Architect USD 175K-267KAPI Design | Artificial Intelligence | CI/CD | Cloud Computing | Containerization401k | Education reimbursement program | Flexible schedule | Hybrid schedule | Relocation assistanceSenior-level Full TimeLivermore, CA, United States R1d ago
-
Technical Program Manager, Professional Services USD 180K-248KAWS | Apache Spark | Azure | Batch Processing | CI/CDSenior-level Full TimeUSCA1d ago
-
Data Platform Architect USD 100K-150KAWS | Access Control | Alation | Amazon Redshift | Apache FlinkBenefits package | Long-term engagement | Remote workSenior-level Full TimeUnited States - Remote R1d ago
-
Data Platform Architect USD 100K-150KAWS | Access Management | Alation | Amazon Redshift | Apache Flink100 percent remote work | Benefits | Full-time W2 employmentSenior-level Full TimeUnited States - Remote R1d ago
-
Senior-level Full TimeUnited States - Remote R1d ago
-
Prompt Engineering USD 100K-150KAgentic Workflows | Chunking | Design Patterns | Deterministic systems | EmbeddingsRemote workMid-level Full TimeUnited States - Remote R1d ago
-
Manager, Pharmacy Services Data Architect USD 66K-145KAI Governance | BigQuery | Dashboard validation | Data Integrity | Data ModelingBonuses | Dental coverage | Medical coverage | Paid time off | Retirement savings optionsSenior-level Full TimeWoonsocket-1 CVS Drive, United States1d ago
-
Data Scientist III - Lead Data Architect USD 108K-180KAWS SageMaker | Amazon Redshift | Apache Spark | Azure Machine Learning | Azure Synapse401k plan | Commuter benefits | Continuing education | Corporate wellness program | Dental insuranceSenior-level Full TimeOakland, CA, United States1d ago
-
SAP AI Architect USD 151K-340KAI Governance | API Management | APIs | Agent systems | AutogenConstant learning | Flexible working models | Great benefits | Skill growthSenior-level Full TimeNewtown Square, PA, US, 190731d ago
-
Principal Integration Engineer - Trade Data Warehouse USD 143K-169KApache Spark | Automation | Data Modeling | Data Pipelining | Data StreamingAdoption Assistance | Disability insurance | Employer retirement plan | Healthcare (Medical Dental Vision) | Life insuranceSenior-level Full TimeCharlotte, NC, United States1d ago
-
Principle Architect, Data Engineer - Pursuit and Capture USD 116K-209KAPI Integration | Azure Data | Azure Data Factory | CRM API | Cloud Computing401k | Childcare subsidy | Commuter benefits | Disability insurance | Employee stock grantsSenior-level Full TimeWA-Headquarters, Building 2, United States1d ago
-
AI | Amazon Web Services | Apache Spark | Big Data | Cloud ComputingSenior-level Full TimeCentral - United States; Chicago, Illinois; …1d ago
-
Analytics Architect - Hybrid in Dallas, TX USD 120K-152KBusinessObjects | Data Governance | Data Modeling | Data Quality | Data SecurityHealthcare experience plus | Hybrid workSenior-level Full TimeDallas, Texas R1d ago
-
Sr. Data Architect USD 165K-200KAWS | Analytics | Cloud Computing | Data Architecture | Data Governance401k | Dental insurance | Flexible spending account | Health insurance | Paid time offSenior-level Full TimeCamp Springs, MD R1d ago
-
Apache Hadoop | Apache Kafka | Apache Spark | Audit Logging | AutomationRemote work | Training and mentorship program | Travel up to 30 percentSenior-level Full TimeUnited States1d ago
-
Senior AI/ML Architect - AI Program USD 153K-210KAWS | Algorithms | Azure | C++ | Computer VisionDental insurance | FSA | HSA | Medical insurance | Retirement planSenior-level Full TimeRochester, MN, United States1d ago
-
Specialist Solutions Architect - Data Engineering USD 180K-247KAWS | Anomaly Detection | Azure | Change Data Capture | Data CaptureContinuous learning | Internal training programs | Mentorship | Travel up to 30 percentSenior-level Full TimeUnited States1d ago