EPIC Certified ETL Architect
Remote - Georgia, United States
R
USD 95K-130K (estimate) Senior-level Full Time
Tasks
- Automate ETL job execution
- Create database objects tables stored procedures views triggers
- Create source-to-target mapping documents
- Design and build ETL and reporting applications
- Design change data capture
- Design end-to-end ETL architecture
- Design staging databases
- Design transformation logic
- Develop dimensional model design
- Identify data quality issues
- Implement ETL error handling
- Implement Reference Data Management
- Implement audit balance control mechanisms
- Implement master data management
- Implement metadata capture
- Maintain ETL environments with upgrades and enhancements
- Maintain SQL scripts indexes and complex queries
- Mentor ETL and BI team members
- Notify proactively on failures
- Perform source data profiling
- Provide production level support and on call support
- Stand up data governance and data quality processes
- Troubleshoot database and ETL tool issues
- Tune legacy SQL queries
- Validate data lineage
- Write and execute test cases
Perks/Benefits
- N/A
Skills/Tech-stack
Automation | Change Data Capture | Data Capture | Data Governance | Data Lineage | Data Management | Data Mart | Data Quality | Data Transformation | Data Warehousing | Data profiling | Database Design | Database Development | Dimensional Modeling | ETL | Indexing | Master Data | Master Data Management | Metadata Management | Microsoft SQL | Microsoft SQL Server | Microsoft SSIS | Performance Tuning | Reference Data | Reference Data Management | SQL | SQL Server | SQL stored procedures | SQL triggers | SQL views | Service Oriented | Service-Oriented Architecture | Staging Databases | Stored Procedures | T-SQL
Education
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 R25d ago
-
Data Infrastructure Architect USD 175K-200KAWS | Access Management | Amazon Redshift | Apache Flink | Apache KafkaRemote workSenior-level Full TimeUnited States - Remote R1d ago
-
Azure | DAX | Data Modeling | Dataflows | ETL401k matching | Counseling sessions | Dental insurance | Disability coverage | Employee assistance programMid-level Full TimeUS-PR-AGUADILLA-110 ~ Rd 110 N Km … R2d ago
-
Lead Data Analyst USD 100K-139KAmazon Redshift | DBT | Data Governance | Data Lakehouse | Data Modeling401k match | Disability insurance | Flexible schedule | Health insurance | Life insuranceSenior-level Full TimePlantation, Florida, United States R2d ago
-
Director, Data Analyst/BI Engineer USD 138K-175KAWS | Access Control | Aggregated Event Measurement | Airflow | BigQuery401k match | Healthcare Dental Vision | PTO | Paid Holidays | Parental leaveExecutive-level Full TimeUnited States R2d ago
-
Data Architect USD 100K-121KAWS | AWS Glue | Amazon Redshift | Azure | Azure Data401k matching | Disability insurance | Flexible work schedule | Life insurance | Medical insurance company paidSenior-level Full TimePlantation, Florida, United States R2d ago
-
Business Intelligence | Dashboarding | Data Automation | Data Storytelling | Data analyticsBonus | Flexible working hours | Health benefits | Remote workExecutive-level Full TimeRemote USA, United States R3d ago
-
APIs | AWS | Agentic AI | Azure | Claude401k | Dental insurance | Fully remote US based | Generous PTO | HolidaysSenior-level Full TimeRemote USA, United States R3d ago
-
AWS | Altair | Automation | Azure | Claim EditingRemote workMid-level Full TimeSouth Carolina Work at Home, United … R3d ago
-
Architect - Data Engineer USD 165K-216KAPI Design | Access Control | Batch Processing | Change Data Capture | CubeSenior-level Full TimeUSA - Remote, United States R3d ago
-
Principal AI Solutions Architect USD 120K-205KAPM | Artificial Intelligence | Automation | Insurance Workflow | Insurance Workflow Knowledge100 percent paid health insurance | 401k employer match | Development and growth opportunities | Floating holidays | HSA or FSASenior-level Full TimeUnited States - Remote R3d ago
-
Manager, Finance Technology and Analytics USD 135K-150KArtificial Intelligence | DAX | Data Warehouse | Dimensional Modeling | LLMMid-level Full TimeRemote California, United States R3d ago
-
Business Intelligence | Clinical data | Data Quality | Data Validation | Data Visualization401k retirement savings | Bonus incentive plan | Flexible overtime availability | Life insurance | Long-term disabilityMid-level Full TimeRemote US, United States R3d ago
-
Sr. BI Data Analyst USD 81K-95KAnalytics | Business Intelligence | Data Modeling | Data Quality | Data Validation401k | Health insurance | Paid time offSenior-level Full TimeRemote, USA, United States R3d ago
-
AWS | Analytics | Architecture Design | Azure | Cloud ArchitectureSenior-level Full TimeRemote - California; Remote - Colorado; … R3d ago
-
Analyst NA Sales Strategy & Analytics USD 55K-83KDashboard Development | Data Modeling | Data Quality | Data Visualization | ForecastingComplimentary products | Hybrid work model | Professional development | Volunteer opportunities | Work from anywhere 6 weeks annuallyMid-level Full TimeColumbus, Ohio, United States R3d ago
-
Manufacturing AI & Analytics Architect USD 86K-136KAPIs | AWS | Anomaly Detection | Azure | Cloud ComputingContinuing education support | Dental insurance | Flexible work schedule | Health insurance | Mentorship programsSenior-level Full TimeMelbourne, FL, US R4d ago
-
Artificial Intelligence | Automation | Business Intelligence | Customer Lifetime Value | Data GovernanceRemote work | Travel 15 to 20 percentExecutive-level Full TimeRemote, United States R4d ago
-
Data Engineering, Director USD 189K-215KAWS | Azure | Cloud infrastructure | Container Orchestration | Data ArchitectureFlexible time off | Healthcare | Hybrid work model | Leave benefits | Retirement benefitsExecutive-level Full TimeAT8 - 725 Ponce de Leon … R4d ago
-
ABAC | AWS | Agent Tool Interfaces | Alerting | Audit LoggingSenior-level Full TimeChicago - 550 Van Buren, United … R4d ago
-
Associate Director – AI / Generative AI Engineering USD 98K-140KAI Evaluation | Cloud deployment | Data Governance | Generative AI | Language ModelsFlexible hybrid work model | Health and life insurance | Paid time off | Pension/retirement benefitsMid-level Full TimeJersey City, NJ, United States R4d ago
-
Lead Data Analyst, Marketing USD 120K-150KAffiliate Marketing | Creative Analytics | Customer Acquisition | Customer Acquisition Cost | DashboardingCareer growth path | Education and best practice support | Remote-first culture | Self service analytics enablementSenior-level Full TimeAsheville, NC (remote); Atlanta, GA (remote); … R5d ago
-
Lead Data Analyst, Marketing USD 120K-150KAd-Hoc | Ad-hoc analysis | Affiliate Marketing | Dashboard Development | Data ModelingCareer growth path | Competitive benefits | Profit-sharing bonus | Remote-first work environmentSenior-level Full TimeArlington, VA (remote); Baltimore, MD (remote); … R5d ago
-
AI/ML Architect USD 124K-215KAWS SageMaker | Anomaly Detection | Azure ML | Behavioral analytics | Cloud Machine LearningSenior-level Full TimeUnited States R5d ago
-
Senior Analyst, Visual Analytics (Tableau) USD 50K-114KData Modeling | Data Visualization | Databricks | Embedded Analytics | Power BISenior-level Full TimeRemote, IL, United States R5d ago