ETL Architect - Epic Snowflake SSIS
Remote - Wisconsin, United States
R
USD 110K-152K (estimate) Senior-level Full Time
Tasks
- Assist with data source integration and validation
- Build SQL scripts and indexes
- Capture metadata and data lineage
- Create requirements and mapping documents with transformation rules
- Design data warehouse and data mart solutions
- Design end-to-end ETL architecture
- Develop ETL jobs with error handling and audit controls
- Develop and tune SQL queries and ETL processes
- Develop database objects procedures views and triggers
- Enforce data governance program
- Implement data transformation logic
- Implement master data management
- Maintain service level agreement support
- Perform data profiling and identify data quality issues
- Stand up ETL center of excellence
- Support ETL tool upgrades and enhancements
- Troubleshoot database and ETL issues
Perks/Benefits
- N/A
Skills/Tech-stack
Audit controls | Automation | Change Data Capture | Data Capture | Data Governance | Data Lineage | Data Management | Data Mart | Data Modeling | Data Quality | Data Transformation | Data Warehousing | Data profiling | Dimensional Modeling | ETL | Error Handling | Indexing | Integration Services | Master Data | Master Data Management | Metadata Management | Microsoft SQL | Microsoft SQL Server | Performance Tuning | Query Tuning | Reference Data | Reference Data Management | SQL | SQL Server | SQL Server Integration Services | SQL Server integration | SSIS | Server Integration Services | Stored Procedures | T-SQL | Triggers | Views
Education
Roles
Related jobs
-
Data Architecture, Senior Advisor USD 146K-234KAWS | Access Control | Azure | CI/CD | Cloud Computing100 percent remote | Active clearance optionSenior-level Full TimeUnited States R1d ago
-
VP - Snowflake Data Architect USD 148K-200KAI SQL | AWS | Airflow | Audit compliance | AzureFlexible time off | Healthcare | Hybrid work model | Leave benefits | Retirement benefitsSenior-level Full TimePR2-Princeton - 1 University Square Drive, … R1d ago
-
Director - Data Engineering USD 166K-215KAWS | Azure | Bash | Cloud Data | Cloud data warehousingDiscretionary bonus | Flexible time off | Healthcare | Hybrid work model | Leave benefitsExecutive-level Full TimeSF4-San Francisco - 400 Howard Street, … R1d 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 R2d 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 R2d ago
-
Senior-level Full TimeUnited States - Remote R2d ago
-
Prompt Engineering USD 100K-150KAgentic Workflows | Chunking | Design Patterns | Deterministic systems | EmbeddingsRemote workMid-level Full TimeUnited States - Remote R2d ago
-
Sr Staff AI Architect USD 143K-185KAPI Design | AWS | Access Control | Azure | Compliance401k | Commuter benefits | Dental insurance | Employee stock purchase plan | Health insuranceSenior-level Full TimeUS - Carlsbad, CA - 5781 … R2d 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 R2d 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 R2d ago
-
Data Architect USD 90K-130K3NF | API | Ab Initio | Active metadata | Apps ScriptCompetitive benefits | Diversity and inclusion initiatives | Opportunities for growth | Remote workSenior-level Full TimeMaryland, USA R3d ago
-
SAP Master Data Architect / Analyst (Hybrid) USD 132K-251KAPIs | BRF+ | Bill of Materials | Change Request | Change Request Management401k match | Dental insurance | Disability coverage | Employee assistance program | Life insuranceSenior-level Full TimeUS-NC-CHARLOTTE-2730 ~ 2730 W Tyvola Rd … R3d ago
-
Data Architect (Clearance Required) - Remote (US) USD 81K-138KAWS | Access Controls | Azure SQL | CI/CD | Cloud ArchitectureOccasional travel to DC Metro for onsite meetings | Remote work | Top Secret clearance sponsorship N/ASenior-level Full TimeNationwide Remote Office (US99), United States R3d ago
-
Data Platform Architect USD 100K-150KAWS | Access Management | Alation | Atlan | AzureBenefits | Remote workSenior-level Full TimeUnited States - Remote R3d ago
-
Enterprise Data Architect USD 105K-123KArchimate | Azure | Business Intelligence | Cloud Computing | Data Governance401k | Career development | Education assistance | Employer sponsored dental insurance | Employer sponsored health insuranceSenior-level Full TimeMO - St. Louis County Central … R3d ago
-
AI Forward Deployed Engineer | $120K-$150K + Hybrid + Equity | AI-Based Outage Intelligence Company A USD 120K-150KAI workflows | API Integration | Automation | Backend Services | Customer OnboardingDirect impact on company growth | Equity | Fast-moving startup environment | Hybrid work environment | Significant ownershipMid-level Full TimeKing of Prussia, PA, United States R3d ago
-
AI Architect USD 139K-220KAI Security | APIs | Access Controls | Amazon Web Services | AuditabilitySenior-level Full TimeRemote, United States R4d ago
-
Senior Engineer & Data Architect, Financial Systems USD 130K-195KADFDI | AWS S3 | Azure Data | Azure Data Factory | Azure Data LakeMentorship | On-call rotation | Remote workSenior-level Full TimeRemote CA Outside Bay Area, United … R4d ago
-
Principal Engineer, Data Engineering USD 102K-170KAPI Management | Agile Development | Azure | CI/CD | Container DeploymentInclusive work environment | Mentorship | Remote work optionsSenior-level Full TimeUS017 NJ New Brunswick - 1 … R4d ago
-
Sr Data Architect USD 158K-237KAccess Control | Amazon Web Services | Azure Data | Azure Data Factory | CCPA401k | Career growth | Disability plans | Employee assistance program | Flexible workSenior-level Full TimeRemote - USA, United States R4d ago
-
Principal Data Architect USD 108K-163KAPIs | Access Management | Analytics Cloud | Autonomous Data Warehouse | CI/CDFlexible hybrid work schedule | Health and life insurance | Paid time off | Pension or retirement benefits | Personal/Family Care leavesSenior-level Full TimeTampa, FL, United States R4d ago
-
Data Architect USD 170K-200KADR | Access Control | Amazon Redshift | Artificial Intelligence | Azure SynapseEAP | Fully remote | Open PTO | Paid Holidays | Tuition reimbursementSenior-level Full TimeRemote (United States) R5d ago
-
Data Scientist/ Data Architect USD 215K-265KAWS | Anomaly Detection | Apache Spark | Artificial Intelligence | AzureSenior-level Full TimeSan Francisco - Remote, CA, United … R5d ago
-
Enterprise Data Architect USD 142K-191KAccess Control | Data Architecture | Data Classification | Data Contracts | Data GovernanceSenior-level Full TimeUnited States R5d ago
-
Cloud Data Platform & Integration Architect, VP USD 172K-191KAWS | Azure | CI/CD | Change Data Capture | Cloud AgnosticEducational assistance | Health and wellness benefits | Paid Holidays | Paid Maternity Leave | Paid parental bonding leaveSenior-level Full TimeNew Jersey Office - 210 Hudson … R5d ago