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 R1d ago
-
Sr. IT Architect USD 115K-169KData Cleansing | Data Modeling | Data Security | Database Design | Database performanceSenior-level Full TimeRemote - Texas, United States R20h ago
-
Data Architecture and Insights Analyst USD 95K-110KDashboard Development | Data Dictionary | Data Documentation | Data Modeling | Data PipelinesDental insurance | Disability insurance | Life insurance | Medical insurance | Paid HolidaysSenior-level Full TimeWest Hollywood, CA (Hybrid) R22h ago
-
Business Intelligence Engineer USD 105K-144KCloud Data | Cloud Data Platforms | DAX | Data Modeling | Data performanceFlexible hybrid work model | Health and life insurance | Paid time off | Pension/retirement benefits | Personal/Family Care leavesMid-level Full TimeJersey City, NJ, United States R23h ago
-
Business Data Engineer USD 140K-170KAPIs | AWS | Amazon Web Services | Data Pipelines | PythonFlexible working hours | Remote work options | Vacation policyMid-level Full TimeRemote US R1d ago
-
AWS | BI Data modeling | Cloud Data | Cloud Data Platforms | DAXHealth and life insurance | Hybrid work model | Paid time off | Pension/retirement benefitsSenior-level Full TimeJersey City, NJ, United States R1d ago
-
Data Architect USD 117K-160KAWS Glue | AWS Lambda | AWS RDS | AWS S3 | Access Control401k match | Dental insurance | Flexible spending accounts | Health insurance | Life insuranceSenior-level Full TimeArlington, Virginia, United States R1d ago
-
Enterprise Data Architect USD 100K-150KAccess Management | Alation | Amazon Redshift | Apache Flink | Apache HudiSenior-level Full TimeUnited States - Remote R1d ago
-
Data Platform Architect USD 100K-150KAccess Management | Alation | Amazon Redshift | Apache Flink | Apache KafkaBenefits package | Career growth | Remote workSenior-level Full TimeUnited States - Remote R1d ago
-
Data Platform Architect USD 100K-150KAWS | Access Control | Alation | Amazon Redshift | Apache FlinkCareer growth | Health benefits | Remote work | W2 employmentSenior-level Full TimeUnited States - Remote R1d ago
-
Data Platform Architect USD 100K-150KAWS | Access Management | Alation | Amazon Redshift | Apache FlinkCareer growth | Employee benefits | Remote workSenior-level Full TimeUnited States - Remote R1d ago
-
Business Intelligence | Dashboard Development | Data Lakes | Data Visualization | Data Warehousing401k | Dental insurance | Disability insurance | Health insurance | Life insuranceSenior-level Full TimeRemote, United States R1d ago
-
Principal Solution Architect - Data Platform Security USD 166K-218KAWS Secrets | AWS Secrets Manager | Access Control | Account Guardrails | Attack PathAutonomy | Continuous improvement | Global team collaboration | Mentorship | Remote workSenior-level Full TimeUS - Remote R2d ago
-
API Integration | AWS | Accessibility | Azure | D3.jsCollaborative environment | Contract extension | Flexible international environment | Fully remote work | High autonomySenior-level Full TimeCanada R2d ago
-
Data Platform Architect USD 100K-150KAlation | Amazon Redshift | Apache Flink | Apache Kafka | Apache SparkSenior-level Full TimeUnited States - Remote R2d ago
-
Business Intelligence | Crystal Reports | Curriculum Development | Dashboards | Data AnalysisRemote workEntry-level Full TimeBusiness Office - Benson Tower, United … R2d ago
-
Enterprise Data Architect USD 116K-185KAWS | Azure | Cloud Computing | Data Governance | Data ModelingRelocation allowed within approved states | Remote work within approved statesSenior-level Full TimeWFH State of Oklahoma, United States R2d ago
-
Principal AI Security & Privacy Architect USD 171K-244KAI | AI Governance | Asana | Automated decision making | By Design401k retirement plan | Annual bonus | Dental insurance | Flexible spending account | Life insuranceSenior-level Full TimeVirginia, United States of America R2d ago
-
Cloud Solutions Architect (Remote) USD 110K-148KAPI Integration | AWS | AWS Fargate | AWS Lambda | Amazon Aurora401k matching | Company holidays | Dental insurance | Health insurance | Learning and development programsSenior-level Full TimeSupport Center - Akron, OH, United … R2d ago
-
Apache Spark | Cloud Computing | Data Engineering | Data Governance | Data analyticsCompetitive benefits package | Remote workSenior-level Full TimeUnited States R3d ago
-
Customer Support Systems & Analytics Lead USD 138K-192KBusiness Intelligence | Dashboards | Data Governance | Data Hygiene | Data ModelingSenior-level Full TimeSan Francisco, CA, New York, NY, … R3d ago
-
Strategy & Analytics Lead USD 164K-225KAnalytics | Business Operations | Data Analysis | Data-Driven Decision Making | Data-drivenEquity | Health benefits | Hybrid work | Remote flexibilitySenior-level Full TimeNew York City, NY; San Francisco, … R3d ago
-
Associate (M&E Data Analyst) - North America USD 79K-125KArtificial Intelligence | Big Data | Data Modeling | Data Quality | Data VisualizationFormal training | Leadership opportunities | Mentorship | Remote work | Travel opportunitiesMid-level Full TimeUnited States R3d ago
-
BI governance | CI/CD | CTE | Common table expressions | DAXRemote workMid-level ContractRancho Cordova, United States R3d ago
-
Information Management Data Architect USD 126K-188KAI Agent | AI Agent framework | Agent Framework | Apache Iceberg | Apache SparkBonus plan | Health insurance | Retirement planSenior-level Full TimeRemote, Ohio, United States of America R3d ago