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
-
Solutions Architect - Public Sector USD 139K-247KAWS | Apache Spark | Azure | Cloud platform | Data EngineeringTravel opportunitiesSenior-level Full TimeRemote - Washington D.C. R18h ago
-
Principal Data Architect USD 197K-337KAdvanced Analytics | Apache Flink | Apache Hadoop | Apache Hadoop YARN | Apache KafkaCareer Development Programs | Interactive learning toolsSenior-level Full TimeChicago, Illinois, USA R1d ago
-
Teamcenter Data Architect USD 113K-154KActive Workspace | BMIDE | Configuration Management | Confluence | Data Documentation401k matching | Employee assistance program | Life insurance | Long-term disability | Medical, dental, and vision insuranceSenior-level Full TimeSt. Paul, MN; Remote (United States) R2d ago
-
Sr. Director Data Platform & Analytics USD 178K-255KAirbyte | BigQuery | DBT | Dashboarding | Data Governance401k | Educational reimbursement | Fertility and adoption assistance | Flexible paid time off | Health benefitsSenior-level Full TimeRemote (United States) R2d ago
-
Architecture governance | Azure Data | Azure Data Factory | Business Continuity | Business IntelligenceRemote workSenior-level ContractPittsburgh, PA, United States R2d ago
-
Senior-level Full TimeChicago - 550 Van Buren, United … R2d ago
-
ABAC | AWS | Audit Logging | Azure | CI/CDSenior-level Full TimeChicago - 550 Van Buren, United … R2d ago
-
IT Data Architect USD 92K-120KAWS | Azure | Big Data | Business Intelligence | Cloud Computing401k retirement plan | Company-Paid Holidays | Dental insurance | Disability insurance | Floating holidaysSenior-level Full TimeTennessee - Virtual, United States R2d ago
-
Principal Forward Deployed Engineer USD 175K-175KAPI Design | Agentic Architectures | CDC | Copilot Studio | CrewAI401k match | Dependent care FSA | Flexible savings account | Health savings account | High-trust environmentSenior-level Full TimeRemote, U.S. (West Coast Preferred) R2d ago
-
Azure Data | Azure Data Factory | Azure Synapse | Azure Synapse Analytics | CI/CDDental insurance | Health insurance | Professional development and training | Remote work flexibility | Retirement benefitsSenior-level Full TimeIdaho R3d ago
-
Technical Delivery Lead USD 94K-164KAgentic AI | Apache Kafka | CI/CD | Cloud Native | Cloud Native ArchitectureBonus eligibility tied to performance | Comprehensive total rewards packageSenior-level Full TimeDayton WFH, United States R3d ago
-
Data & Semantic Model Architect USD 140K-199KAPIs | Allotrope | CDISC | Common Data Model | Data GovernanceSenior-level Full TimeUnited States - Remote R3d ago
-
AWS | Airflow | Apache Spark | Data Governance | Data Quality401k matching | Bonus program | Equity plans | Medical, dental, and vision coverage | Merit-based salary increasesSenior-level Full TimeColumbia R4d ago
-
Power BI Architect USD 117K-238KAggregations | Azure | Azure Data | Azure Data Lake | Azure DatabricksCareer development opportunities | Entrepreneurial environment | High degree of individual responsibilitySenior-level Full TimeHouston, Texas, United States - Remote R4d ago
-
Data Engineer - Clearance Required USD 101K-174KDashboarding | Data Governance | Data Modeling | Data integration | Digital EngineeringSenior-level Full TimeRemote, United States R6d ago
-
Delivery Solutions Architect - U.S. Federal Sector USD 180K-247KAccount Management | Business Analysis | Cloud Cost Optimization | Cost Optimization | Data EngineeringHybrid work | Travel up to 30 percentSenior-level Full TimeRemote - New York R6d ago
-
Delivery Solutions Architect - U.S. Federal Sector USD 180K-247KBusiness Analysis | Data Architecture | Data and AI | Discovery Workshops | Distributed SystemsHybrid work | Travel up to 30%Senior-level Full TimeRemote - Virginia R6d ago
-
Delivery Solutions Architect - U.S. Federal Sector USD 180K-247KAccount Management | Business Analysis | Distributed Systems | Program Management | Project ManagementHybrid work | Travel up to 30 percentSenior-level Full TimeRemote - Washington D.C. R6d ago
-
Sr. Delivery Solutions Architect - Manufacturing USD 219K-301KDistributed Systems | KPI Reporting | Program Management | Project Management | PythonHybrid work | Travel up to 30%Senior-level Full TimeRemote - Missouri R6d ago
-
Sr. Delivery Solutions Architect - Manufacturing USD 219K-301KAccount Management | Business Analysis | Consultative Pre Sales | Data Architecture | Data and AITravel up to 30%Senior-level Full TimeRemote - Illinois R6d ago
-
Data Architect (Hybrid - Cloud and On-Prem) USD 113K-188KAWS | Data Governance | Data Ingestion | Data Lineage | Data Modeling401k retirement plan | Adoption Assistance | Basic Life and Supplemental Life | Company-Paid Holidays | Dental and vision flexible spending accountSenior-level Full TimeGH Office: Tysons Corner, VA (Headquarters), … R6d ago
-
Teamcenter Data Architect USD 113K-154KBMIDE | Configuration Management | Confluence | Data Governance | Data Mapping401k matching | Disability insurance | Employee assistance program | Life insurance | Medical/Dental/Vision insuranceSenior-level Full TimeSt. Paul, MN; Remote (United States) R6d ago
-
AI Solution Architect I USD 123K-190KAPI | Artificial Intelligence | Azure AI | Classification | Data Modeling401k match | Dental insurance | Employee assistance program | FSA plans | HSA contributionSenior-level Full TimeVirtual Office, United States R7d ago
-
Senior Consultant - Data Engineering / Data Architect USD 147K-253KAWS | Analytics | Azure | Cloud Computing | Dashboards401k match | Disability insurance | Hybrid work options after 90 days | Medical/Dental/Vision | Paid HolidaysSenior-level Full TimePhoenix, AZ, US R7d ago
-
Data Analyst-Tech Con-Data & Analytics-Data Arch & Eng-FSO-Manager-Multiple Positions-1707768 USD 181K-181KAWS | Big Data | Cassandra | Cloud Computing | Cloud platform401k plan | Dental insurance | Flexible vacation policy | Hybrid work model | Medical insuranceMid-level Full TimeHartford, CT, US, 06103 R7d ago