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 Architect (Remote) USD 148K-172KData Documentation | Data Governance | Data Lineage | Data Modeling | Data Quality401k match | Healthcare coverage | Life and disability coverage | Paid parental leave | Paid personal time offSenior-level Full TimeBoston, Massachusetts, United States; New York, … R1d ago
-
Data Platform Architect USD 100K-150KAccess Management | Alation | Amazon Redshift | Apache Flink | Apache KafkaSenior-level Full TimeUnited States - Remote R1d ago
-
Prompt Engineering Architect USD 100K-150KAgent Frameworks | Chunking | Embeddings | Evaluation | Fine TuningCareer growth | Mentorship | Remote workSenior-level Full TimeUnited States - Remote R1d ago
-
Manager, Platform & AI Architecture - REMOTE USD 117K-152KAgile | Agile delivery | Architecture Framework | Architecture governance | Artificial Intelligence401k employer match | Community Volunteer Time Off | Company-paid disability insurance | Dental insurance | Employee assistance programSenior-level Full TimeGeorgia - Remote, United States R1d ago
-
Prompt Engineering Architect USD 100K-150KAgent systems | Agentic Workflows | Chunking | Deterministic Evaluation | EmbeddingsBenefits | Career growth | Remote workSenior-level Full TimeUnited States - Remote R1d ago
-
Data Platform Architect USD 100K-150KAWS | Access Management | Alation | Amazon Redshift | Apache FlinkSenior-level Full TimeUnited States - Remote R1d ago
-
AI-Ready Knowledge Architect USD 96K-181KBusiness glossary | Data Catalog | Data Governance | Data Lineage | Data ManagementFlexible work optionsSenior-level Full TimeFor Those Who Work At Home, … R1d ago
-
Salesforce Data Architect, Revenue Solutions USD 87K-266KAgile | Confluence | DBAmp | Data Architecture | Data MigrationFlex Time | Remote work | Team collaboration | Travel up to 25 percentSenior-level Full TimeRemote - United States R2d ago
-
AI Solutions Architect USD 195K-247KAPI Integration | Data Architecture | Data Governance | Data Modeling | Data ontologyAnnual refresh grants | Equity grant | Flex First Work Options | Remote workSenior-level Full TimeUnited States - Remote R2d ago
-
Sr. AI Engineer/Architect (Remote) USD 145K-207KAPI Development | AWS | Apache Spark | Azure | Cloud platformContract-to-hire | Remote workSenior-level Full TimeEagan, MN, United States R2d ago
-
Power BI Architect-67189 USD 100K-150KAlation | Amazon S3 | Apache Airflow | Apache Iceberg | AzureFlexible working arrangements | Health and wellbeing benefits | Work-life balanceSenior-level Full Time(DEAI DS) US Remote DE, United … R2d ago
-
Data Platform Architect USD 100K-150KAWS | Access Management | Alation | Amazon Redshift | Apache FlinkSenior-level Full TimeUnited States - Remote R2d ago
-
Data Platform Architect USD 100K-150KAccess Management | Alation | Apache Flink | Apache Hudi | Apache Kafka100 percent remote work | Benefits | Full-time W2 employmentSenior-level Full TimeUnited States - Remote R2d ago
-
Data Platform Architect USD 100K-150KAccess Management | Alation | Amazon Redshift | Apache Flink | Apache HudiSenior-level Full TimeUnited States - Remote R2d ago
-
Prompt Engineering Architect USD 100K-150KAgent systems | Agentic Workflows | Chunking | Deterministic Evaluation | EmbeddingsCareer growth | Mentorship | Remote workSenior-level Full TimeUnited States - Remote R2d ago
-
Prompt Engineering Architect USD 100K-150KAgentic Workflows | Embeddings | Evaluation Frameworks | Fine Tuning | IndexingSenior-level Full TimeUnited States - Remote R2d ago
-
Prompt Engineering Architect USD 100K-150KAgent architecture | Chunking | Embeddings | Evaluation | Fine Tuning100 percent remote work | Career growth potential | Employee mentoringSenior-level Full TimeUnited States - Remote R2d ago
-
Head of Architecture, Integration, and Data Engineering USD 175K-220KAI Governance | API Design | Analytics enablement | Azure | Azure DataFull-time permanent role | Remote workSenior-level Full TimeRemote, United States R3d ago
-
Salesforce Data Architect USD 87K-266KAgile | CCPA | Confluence | DBAmp | Data CleansingCollaborative culture | Employee recognition | Flexible schedule | In-person collaboration | Remote workSenior-level Full TimeRemote - United States R3d ago
-
Principal Architect USD 170K-212KAccess Management | Amazon Redshift | Amazon Web Services | Apache Airflow | Apache SparkSenior-level Full TimeUS - Remote R3d ago
-
AI Architect Lead (Hybrid-within BankUnited's footprint) USD 140K-200KAI Foundry | AWS | AWS Bedrock | Artificial Intelligence | AutogenHybrid workSenior-level Full TimeMiami Lakes, FL, United States R3d ago
-
Data Architect USD 148K-233KApache Spark | CI/CD | Data Modeling | Database engineering | Databricks401k match | Bench pay | Education assistance | Healthcare reimbursement | Internet reimbursementSenior-level Full TimeUnited States - Remote R3d ago
-
Senior Data Architect USD 184K-215KAWS | Azure | Cloud Computing | Data Architecture | Data CatalogingTelecommuting permittedSenior-level Full TimeCambridge, Massachusetts R4d ago
-
Sr Data Architect USD 143K-204KApache Kafka | Apache Spark | Azure Data | Azure Data Factory | Azure DatabricksSenior-level Full TimeLATAM (Remote), US (Remote) R4d ago
-
Data Architect USD 120K-195KAPI Design | AWS GovCloud | AWS RDS | Amazon Aurora | Cloud ArchitectureFully remoteSenior-level Full TimeUnited States R4d ago