Database Architect 1
Tasks
- Build ETL pipelines using TSQL stored procedures
- Coordinate deployments and releases
- Design data integration routines for moving cleansing and transforming data
- Design data quality audit controls
- Design implement and maintain database objects
- Document source-to-target mappings
- Identify data sources and create data flow diagrams
- Implement database security
- Monitor and cleanse data
- Optimize data warehouse performance
- Perform scheduled integrity checks
- Provide on call after hours support
- Provide technical enablement for database application development
- Recommend data models for ingestion and analytics
- Translate business requirements into data analysis and data mapping
Perks/Benefits
Skills/Tech-stack
Azure Data | Azure Data Factory | Azure Synapse | Azure Synapse Analytics | CI/CD | Data Factory | Data Governance | Data Lake | Data Mart | Data Modeling | Data Quality | Data Warehouse | Data integration | Database Design | Database security | ETL | GitHub | Integration Services | Microsoft SQL | Microsoft SQL Server | Parallel processing | Performance Tuning | Power BI | Relational Database | Relational Database Design | SQL Server | SQL Server Integration Services | SQL Server integration | Server Integration Services | Stored Procedures | Synapse Analytics | TSQL
Education
Bachelor of Arts | Bachelor of Engineering | Bachelor of Science
Related jobs
-
Data Architect USD 112K-174KAcceptance Testing | Agile | Application Lifecycle Management | Application lifecycle | Business IntelligenceSenior-level Full TimeNYC, NY3h ago
-
AI Solution Architect USD 150K-181KAWS | Agent-based | Agent-based systems | Azure | Data ModelingEquity | Health and wellness packagesSenior-level Full TimeNew York City20h ago
-
Databricks Solution Architect USD 180K-247KAmazon Web Services | Apache Spark | Azure | Compliance | Cost ManagementSenior-level Full TimeUnited States21h ago
-
AI Governance | AI Solution | AI Solution Architecture | APIs | AgileSenior-level Contract Full TimeTampa, FL, United States1d ago
-
AWS S3 | Airbyte | Apache Airflow | Apache Hudi | Apache Iceberg401k plan | Disability insurance | Employee assistance program | Employee discount program | Health/Dental/VisionSenior-level Full TimeRemote - Nationwide, United States R1d ago
-
Senior Data Architect USD 150K-175KAWS | Azure | Collibra | Collibra Unified Data Quality | DBT401k matching | Dental insurance | Flexible PTO | Gym access | HSA employer contributionsSenior-level Full TimeChicago, IL, US1d ago
-
Principal Data Architect (Snowflake) USD 184K-241KAI tools | Access Control | Azure | Azure SQL | CDataEmployee awards | Industry certification support | Matching 401k | Recognition programs | Remote or hybrid work optionsSenior-level Full TimeUnited States R1d ago
-
Principal Data Architect USD 123K-224KAPIs | Access Control | Agile | Apache Spark | Azure DataContinuous professional developmentSenior-level Full TimeUnited States R1d ago
-
Databricks Architect (Lead Data Platform Architect) USD 180K-247KABAC | AWS | Airflow | Apache Spark | AutoscalingSenior-level Full TimeNew York, United States1d ago
-
Senior-level Full TimeUS-OH-Columbus1d ago
-
Senior Solution Architect – Databricks USD 123K-176KAmazon Web Services | Apache Spark | Asset bundles | Azure | CI/CD401k savings plan | Dental insurance | Flexible Spending Accounts FSAs | Health Savings Account (HSA) | Health insuranceSenior-level Full TimeUS-Nationwide-FIELD, United States1d ago
-
AWS | Azure | CI/CD | Data Modeling | Data QualitySenior-level Full TimeTwo Destiny Way, Westlake TX, United … R1d ago
-
Generative AI Enterprise Architect USD 151K-220KAPI Integration | AWS | AWS Bedrock | Agent Orchestration | CI/CDDental insurance | FMLA | Health insurance | Life insurance | Paid Long Term DisabilitySenior-level Full TimeKS Overland Park, United States1d ago
-
AI and ML Solutions Architect, Lead USD 112K-257KAI Agents | AWS | AWS Bedrock | Amazon SageMaker | Artificial IntelligenceDependent care | Disability insurance | Health insurance | Life insurance | Paid leaveSenior-level Full TimeUSA, VA, Ashburn (19886 Ashburn Rd), …1d ago
-
Data Engineering Architect, Senior (INDG) USD 175K-220KData Modeling | Data Pipelines | Data Quality | Data Warehousing | Database DesignSenior-level Full TimeArlington, VA - 1801 S Bell …1d ago
-
Web Application Architect 4 USD 170K-220KAWS | Architecture patterns | Batch inference | CI/CD | Cloud ArchitectureSenior-level Full TimeArlington, VA - 1801 S Bell …1d ago
-
Senior Data Platform Architect USD 130K-218K800-53 | AI | AWS | AWS Landing Zones | Azure Landing ZonesFinancial security options | Fully remote | Health benefitsSenior-level Full TimeHybrid Phoenix AZ, United States R1d ago
-
AWS | Apache Airflow | Apache Spark | Azure | Azure DataSenior-level Full TimeTexas, Texas, United States1d ago
-
Tableau Technical Architect (Secret clearance) USD 148K-285KAWS | Authentication | Azure | Data integration | Disaster RecoverySenior-level Full TimeVirginia - Washington DC Metro - … R1d ago
-
Data Architect USD 138K-191KAlation | Azure Data | Azure Data Factory | Azure Service | Azure Service BusSenior-level Full TimeNC.Durham Office, United States1d ago
-
AI | AWS | Analytics | Autonomous Database | Azure401k match | Dental insurance | Health insurance | Life insurance | Paid HolidaysSenior-level Full TimeUnited States1d ago
-
Data Architect (P4642) USD 162K-262KAI system architecture | Access Control | Audit Logging | Azure | Azure Data5 day in office scheduleSenior-level Full TimeCincinnati, OH; Chicago, IL1d ago
-
Senior Data Architect (AWS, Azure, GCP) USD 120K-200KAWS | Amazon DynamoDB | Amazon Kinesis | Apache Airflow | Apache Kafka1 to 1 care | 401k matching | Certification support | Disability insurance | Employee resource groupsSenior-level Full TimeReston, VA, United States R1d ago
-
Senior Data Architect (AWS, Azure, GCP) USD 120K-200KAWS | Amazon DynamoDB | Amazon Kinesis | Apache Airflow | Azure401k matching | Disability insurance | Employee resource groups | Fertility benefits | Health coverageSenior-level Full TimeRichmond, VA, United States R1d ago
-
Data Architect (AWS, Azure, GCP) USD 120K-200KAWS | Airflow | Azure | Cloud platform | Cosmos DB401k matching | Disability insurance | Employee wellness stipends | Fertility coverage | Flexible work environmentSenior-level Full TimeReston, VA, United States R1d ago