ETL Architect - Epic Snowflake SSIS
Remote - Wisconsin, United States
R
USD 110K-164K (estimate) Senior-level Full Time
Tasks
- Automate recurring ETL imports
- Build and maintain SQL scripts and indexes
- Create source-to-target mapping documents
- Design and develop database objects
- Design dimensional models
- Design end-to-end ETL architecture
- Design staging databases for change data capture
- Design test cases and templates
- Design transformation logic
- Develop ETL jobs and implement data models
- Document and enforce data standards and naming conventions
- Identify data quality issues
- Implement Reference Data Management
- Implement error handling and audit balance control
- Implement master data management
- Implement metadata capture and data lineage
- Mentor and train staff on ETL concepts
- Monitor incident management queue
- Perform source data profiling
- Stand up data warehouse ETL center of excellence
- Support data governance program
- Troubleshoot database and ETL tool issues
- Tune legacy SQL queries for performance
- Validate data extracts and deliverables
- Write stored procedures and views
Perks/Benefits
- N/A
Skills/Tech-stack
Automation | Case design | Change Data Capture | Data Capture | Data Governance | Data Lineage | Data Management | Data Mart | Data Modeling | Data Quality | Data Transformation | Data Warehousing | Data profiling | Database Triggers | Database Views | Dimensional Modeling | ETL | Error Handling | Master Data | Master Data Management | Metadata Management | Microsoft SQL | Microsoft SQL Server | Multidimensional modeling | Performance Tuning | Reference Data | Reference Data Management | Relational modeling | SQL | SQL Indexes | SQL Server | SQL stored procedures | SSIS | Source-to-Target Mapping | Stored Procedures | Test Case | Test Case Design
Education
Roles
Related jobs
-
Sr. Databricks Solutions Architect USD 160K-250KAI | AWS | Apache Spark | Azure | Cloud platformRemote work | Travel up to 30 percentSenior-level Full TimeWork from home, VA, United States R7h ago
-
Databricks Pipeline Architect USD 150K-180KAWS Glue | AWS Lambda | Agile | Amazon S3 | Amazon Web ServicesRemote workSenior-level Full TimeWork from home, VA, United States R7h ago
-
Associate Technical Architect - DE - Databricks USD 121K-202KAWS S3 | AWS Secrets | AWS Secrets Manager | AWS Step Functions | AirflowCareer development | Innovation-focused culture | Learning and growth | Work-life balanceMid-level Full TimeUSA - Remote, United States R3d ago
-
Machine Learning Solutions Architect USD 155K-216KAPIs | AWS | AWS SageMaker | Amazon EMR | Amazon Redshift10 paid holidays | 4 weeks PTO | Advanced training and certifications | Professional development | Remote-first work environmentSenior-level Full TimeUS-Remote R4d ago
-
Director, Data Platform & Analytics USD 173K-184KBigQuery | DBT | Dagster | Data Catalog | Data Governance401k match | Adoption support | Calm app access | Company holidays | Fertility supportExecutive-level Full TimeRemote - US R4d ago
-
FHIR Data Architect USD 118K-193KAPI Management | Active Directory | Azure API | Azure API Management | Azure Active DirectorySenior-level Full TimeRemote, Oregon, United States R4d ago
-
Senior Data Architect - Hybrid USD 135K-203KAWS | Access Control | Azure | Azure Data | Azure Data Factory401k | Career growth | Disability plans | Employee assistance program | Hybrid workSenior-level Full TimeRemote - USA, United States R4d ago
-
Enterprise Application AI Architect USD 150K-205KAPI Integration | Auditability | Automation | Context protocols | CrewAISenior-level Full TimeDenver, CO;San Francisco, CA;New York, NY;Los … R5d ago
-
Senior Data Architect USD 149K-200KAI/ML | API Integration | APIs | AWS | AWS Glue401k match | Employer paid health care | Training and development fundsSenior-level Full TimeUnited States - Remote R5d ago
-
AWS | Azure | Batch Processing | Big Data | Business IntelligenceCareer development opportunities | Fast-growing environment | High responsibilitySenior-level Full TimeUnited States - Remote R5d ago
-
Solutions Architect/Data Engineer USD 145K-175KAWS | AWS IAM | AWS Lambda | Amazon EC2 | Amazon RDS401k matching | Dental insurance | Employee development program | Employee referral program | Medical insuranceSenior-level Full TimeRemote, MD, US R6d ago
-
Tableau Administrator with AWS - REMOTE USD 92K-190KAWS API | Amazon Web Services | Data Warehousing | Data integration | EC2Remote workMid-level Full TimeMclean, VA, US R6d ago
-
VP, Enterprise Data Architect USD 167K-300KAWS | Access Control | Agentic AI | Azure | CCPABonus eligible | Dental insurance | Health insurance | Paid time off | Remote workSenior-level Full TimeUSA - MN - Minneapolis, United … R6d ago
-
DW/BI Architect (Remote) USD 160K-164KAzure Data | Azure Data Factory | Azure DevOps | Azure Fabric | Azure SQLCorporate discounts | Employee Assistance Program (EAP) | Flexible work environment | Internal mobility program | Learning and development platformSenior-level Full TimeRemote, United States R7d ago
-
EPIC ODB Engineer / Architect - Remote USD 120K-190KClustering | Containerization | Dynatrace | Globals | GrafanaSenior-level Full TimePlano, TX, US R7d ago
-
Data and Analytics Technical Lead USD 128K-185KAPI Gateway | AWS CloudFormation | AWS Glue | Amazon Web Services | Business Intelligence401k match | Employee discounts | Floating holidays | Paid parental leave | Paid time offSenior-level Full TimeIndependence OH - 6112, United States R7d ago
-
Senior-level Full TimeUS (Remote) R8d ago
-
Agile | CDW | Cloud Migration | Data Architecture | Data IntegrityCorporate discounts | Employee assistance program | Flexible work environment | Internal mobility program | Learning and development platformSenior-level Part TimeRemote, United States R8d ago
-
Access Control | Azure | Azure Databricks | Azure Storage | Azure Well Architected401k matching | Choice time off | Hybrid work | Medical, dental, and vision insurance | Paid HolidaysMid-level Full TimeNEW YORK CITY, United States R8d ago
-
Senior Distinguished Data Engineer (Remote - Eligible) USD 286K-392KAWS | Big Data | Data Architecture | Data Engineering | Data ModelingSenior-level Full TimeMcLean, VA, United States R8d ago
-
AI strategy | API Integration | Agentic AI | Business Intelligence | CRMExecutive-level Full TimeUnited States - Remote R8d ago
-
Senior Manager AI Architecture Innovation USD 151K-246KAI Foundry | AI Search | AKS | Access Control | Agent OrchestrationSenior-level Full TimeRemote, OH, US R8d ago
-
AI orchestration | APIs | AWS | Advanced Analytics | Automation401k matching program | Adoption Assistance | Development and career growth opportunities | Fertility treatments | Flexible work scheduleSenior-level Full TimeVirtual Office (Texas), United States R8d ago
-
Analytics Architect USD 100K-203KAI Builder | AI Search | API Development | Access Control | AuthenticationFully remote within contiguous US | Secret clearance requiredSenior-level Full TimeArlington, VA R12d ago
-
Databricks Pipeline Architect USD 150K-180KAWS Glue | AWS Lambda | AWS S3 | Agile | Amazon Web ServicesPublic trust clearance support | Remote workSenior-level Full TimeWork from home, VA, United States R12d ago