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
-
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 R19d ago
-
Enterprise Data and Application Architect USD 135K-200KAPI | ASP.Net Core | Access Management | Apache Airflow | Apache SparkSenior-level Full TimeNashville, TN, United States7h ago
-
AI & Data Analytics Presales Solution Architect USD 153K-208KAI strategy | Azure Data | Azure Data Factory | Azure Synapse | Data Factory401k with profit sharing | Flexible work arrangements | Generous PTO plan | Generous parental leave | Medical/Dental/VisionSenior-level Full TimeUS CA San Ramon, United States23h ago
-
Cloud Platforms | Data Architecture | Data Modeling | Data Quality | Data WarehousingBackup childcare | Financial coaching | Health care coverage | Mental health support | On-site health and wellness centersMid-level Full TimePlano, TX, United States1d ago
-
Principal Solution Architect USD 166K-218KAWS | AWS Data | AWS Data Migration | AWS Data Migration Services | AWS Managed AirflowKnowledge sharing and training | Ownership over work | Professional development and upskilling | Remote-first work cultureSenior-level Full TimeUS - Remote R1d ago
-
Senior Solutions Architect USD 165K-216KAI coding | AI coding tools | AWS | Amazon Redshift | AthenaCareer growth | Mentorship | Ownership | Remote-firstSenior-level Full TimeUS - Remote R1d ago
-
Solutions Architect USD 165K-216KAWS | AWS CloudFormation | AWS Data | AWS Data Migration | AWS Data Migration ServiceSenior-level Full TimeUS - Remote R1d ago
-
AI Architect USD 142K-223KAI Agents | APIs | Agile | Application Programming | Application Programming InterfacesCollaborative inclusive environment | Professional growth opportunities | Work-life balanceSenior-level Full TimeUnited States1d ago
-
AI/ML Systems Engineer USD 135K-210KAI Assurance | AI Governance | AI machine learning | Agentic Workflows | Anomaly DetectionSenior-level Full TimeDayton, OH, USA1d ago
-
Data Architect | Contract | Los Angeles USD 135K-178KAPIs | AWS | Access Control | Batch Data Processing | Batch dataSenior-level Full TimeLos Angeles, California, United States1d ago
-
Data Engineer USD 114K-160KCribl | Data Modeling | Data Warehouse | Data analytics | Data pipeline401k match | Holiday pay | Medical, dental & vision coverage | Paid time offMid-level Full TimeHuntsville, AL, United States1d ago
-
Architect (Sr. Data Engineer/Architect Skillset) USD 114K-170KCloud Data | Cloud Data Platforms | Communication | Data Engineering | Data ModelingOnsite Weekly ScheduleSenior-level Full TimeDallas, Texas, United States1d ago
-
Senior AI Solutions Architect (Remote Opportunity) USD 148K-207K800-53 | AI Risk Management Framework | AWS Cloud | Amazon Bedrock | Auditability401k employer match | Corporate laptop | Dental insurance | Federal Holidays | Medical insuranceSenior-level Full TimeCharleston, SC - Remote R1d ago
-
Cloud Data Architect USD 145K-160KAWS | Access Management | Amazon Redshift | Apache Flink | Apache KafkaCareer growthSenior-level Full TimeUnited States - Remote R1d ago
-
Data Platform Architect USD 100K-175KAccess Management | Alation | Apache Flink | Apache Spark | AtlanSenior-level Full TimeUnited States - Remote R1d ago
-
Data Infrastructure Architect USD 175K-200KAWS | Access Management | Amazon Redshift | Apache Flink | Apache KafkaCareer growth potential | Direct W2 | Remote workSenior-level Full TimeUnited States - Remote R1d ago
-
Data Architect (Nashville, TN) USD 106K-141KAPI Integration | Data Governance | Data Lineage | Data Modeling | Data Quality403b retirement plan | Accident insurance | Calm app | Cancer Insurance | Critical illness insuranceSenior-level Full TimeNashville, TN, United States1d ago
-
Senior-level Full TimeAshburn, VA (VA28), United States1d ago
-
Snowflake Architect - Cortex & Agentic AI Lead USD 90K-120KAI Agent | AI agent orchestration | Agent Orchestration | Compliance | Cortex AnalystCompany-Paid Holidays | Employee assistance programs | Life and disability insurance | Medical, dental, and vision coverage | Paid time offSenior-level Full TimeIrving, TX, US1d ago
-
Enterprise AI Architect USD 156K-220KAI Governance | API | AWS | AWS Bedrock | Agentic AICareer development opportunities | High degree of individual responsibilitySenior-level Full TimeDallas, Texas, United States - Remote R1d ago
-
Data Architect I (Grant Funded) USD 93K-154KData Cleansing | Data Modeling | Data Validation | Data integration | Database Design401b retirement plan employer match | Backup childcare and eldercare | Employee assistance program | Flexible spending accounts | Health Savings Account employer contributionSenior-level Full TimeChicago, IL, United States1d ago
-
Enterprise Data Architect USD 100K-150KAccess Management | Alation | Amazon Redshift | Apache Flink | Apache HudiSenior-level Full TimeUnited States - Remote R1d ago
-
Senior-level Full TimeBerkeley Heights, New Jersey, United States1d ago
-
BI Desktop | Cognos Migration | Data Modeling | Data Visualization | Dimensional ModelingSenior-level Full TimeNew York, New York, United States2d ago
-
Digital Enterprise Sr. Data Architect USD 113K-185KAPI Integration | Artificial Intelligence | Business Intelligence | Cloud services | Cybersecurity401k employer matching | Continuing education assistance | Federal holiday schedule | Healthcare benefits | Paid time offSenior-level Full TimeArnold AFB, TN, United States2d ago