ETL Developer
Long Island City, NY, United States
USD 105K-135K Mid-level Full Time
Tasks
- Administer SQL Server databases and perform performance tuning
- Analyze query plans create indexes and resolve deadlocks
- Build dimensional models in SSAS
- Create SSIS script tasks using C# or VB.NET
- Design and implement OLTP and OLAP data models
- Design and maintain SSAS cubes and tabular models
- Design database environments and data flow diagrams
- Develop ETL packages in SSIS
- Develop Power BI and Tableau dashboards
- Develop and maintain reports in SSRS
- Implement data warehousing business rules using stored procedures
- Implement disaster recovery scripts and procedures
- Integrate reporting and dashboards with SharePoint
- Maintain change control and testing for database modifications
- Monitor ETL and data warehouse performance and execution time
- Troubleshoot data quality and database performance issues
- Troubleshoot report dashboard and ETL issues
- Verify accuracy of data in reports dashboards and extracts
- Write stored procedures and database access code
Perks/Benefits
Skills/Tech-stack
Azure | Business Intelligence | Change Control | Csharp | Data Marts | Data Migration | Data Quality | Data Warehousing | Database Administration | Database performance | Database performance tuning | Deadlock Resolution | Dimensional Modeling | Disaster Recovery | Indexing | OLAP | OLTP | Oracle Business Intelligence | Oracle PLSQL | Performance Tuning | Power BI | Query Plan | SQL Server | SSAS | SSIS | SSRS | SharePoint | Stored Procedures | TSQL | Tableau | VBNet
Regions
Countries
States
Related jobs
-
Staff Data Analyst USD 154K-239KData Modeling | Data Pipelines | Data Quality | Data Transformation | Data VisualizationDiversity, equity, inclusion and belonging | Social impact | Well-being programsSenior-level Full TimeSan Francisco, California7h ago
-
Analytics & Business Intelligence - Associate USD 70K-100KAirbyte | DBT | Data pipeline | Machine Learning | Microsoft ExcelEmployer-Matched Retirement Plan | Flexible remote work | Parental leave | Subsidized healthcare | TelemedicineMid-level Full TimeSalt Lake City, Utah, United States R14h ago
-
Director, Business Reporting, Advanced Analytics & AI USD 170K-238KAI ethics | AWS | Azure | Churn Prediction | Customer 360Executive-level Full TimeBeachwood, Ohio, United States17h ago
-
Software Engineering - DataStage Developer USD 112K-129KAxway | Axway Secure SFTP | Azure | Azure DevOps | CA7 SchedulerHybrid work schedule | Remote workMid-level Full TimeSyracuse, New York, United States22h ago
-
Tableau Developer USD 87K-157KAWS DevOps | Amazon Web Services | Azure | Azure DevOps | Dashboard DevelopmentMid-level Full Time6314 Remote/Teleworker US, United States R1d ago
-
Insights and Analytics Intern - Miramar, FL. USD 56K-56KContinuous Improvement | Data Governance | Data Visualization | Lean Six Sigma | Microsoft ExcelEntry-level Full Time InternshipUSMMR01 - Miramar - 2801 South …1d ago
-
Agile | Cognos | Data Modeling | Data Pipelines | Data ReconciliationEducational opportunities | Health benefits | Savings benefitsEntry-level Full TimeUSA - FL - Partners! Federal … R1d ago
-
Data Visualization and Qlik Developer, Lead USD 112K-257KAgile | Business Intelligence | Clustering | Data Visualization | Experimental ResearchDependent care | Paid leave | Professional development | Tuition assistance | Work-life programsSenior-level Full TimeUSA, VA, Alexandria (4800 Mark Center …1d ago
-
Temporary Tableau Developer USD 86K-110KBusiness Intelligence | Dashboard Development | Data Analysis | Query Optimization | SQLFree sunglasses | Hybrid workMid-level TemporaryLos Angeles1d ago
-
Google BigQuery | Microsoft Excel | Microstrategy | PowerPoint | PythonMid-level Full TimeLas Vegas, NV, United States1d ago
-
Intern - Data Analytics USD 34K-34KData Aggregation | Data Analysis | Data Visualization | Microsoft Excel | Report WritingAcademic credit | Hybrid work environment | Paid internshipEntry-level InternshipUMass President's Office, UMass President's Office1d ago
-
Alteryx | Automation | Business Intelligence | Dashboard Development | Data ModelingBackup childcare | Financial coaching | Health insurance | Mental health support | On-site health and wellness centersSenior-level Full TimeColumbus, OH, United States1d ago
-
Mid-level Full TimeRemote (United States) R1d ago
-
Analytics Engineer USD 125K-150KAmazon Redshift | Business Intelligence | DBT | Data Modeling | Data VisualizationCaregiver support | Company holidays | Dental insurance | Fertility benefits | Flexible PTOMid-level Full TimeRemote - USA R1d ago
-
Business Intelligence Analyst / Data Analyst (SQL) USD 168K-207KAmazon Redshift | BigQuery | Data Pipelines | KPI Development | LookerBonus program | Equity incentive plan | Health benefits | Remote work optionsMid-level Full TimeMountain View, CA; San Francisco, CA1d ago
-
Data Developer USD 109K-147KConditional logic | Data Governance | Data Lake | Data Mart | Data Quality401k employer match | Business Casual Work Environment | Dental insurance | Long-term disability | Medical insuranceEntry-level Full TimeGreenville, South Carolina1d ago
-
Analytics | Analytics Strategy | Business Intelligence | Causal analysis | DashboardsSenior-level Full TimeUnited States1d ago
-
Tableau Developer | Onsite | Addison, TX USD 44K-154KExcel | Jira | MemSQL | Oracle | PL/SQL401k retirement plan | Dental insurance | Health insurance | Paid Holidays | Paid time offMid-level Full TimeUnited States1d ago
-
Automated reporting | Business Intelligence | Data Analysis | Data Governance | Microsoft ExcelEntry-level Internship Part TimeNew York City, NY, United States1d ago
-
Database Developer USD 111K-145KData Modeling | Data Transformation | Performance Tuning | Python | Query OptimizationFlexible working | Global career development | Referral bonus | Social events | Time offMid-level Full TimeBoston, US1d ago
-
Enrollment and Strategy Specialist USD 47K-47KBI Publisher | CRM | Campus Solutions | Data Analysis | Data MappingEntry-level Full TimeDallas1d ago
-
Business Data Engineer I USD 80K-111KBusiness Intelligence | Data Cleansing | Data Mining | Data Modeling | Data PipelinesMid-level Full TimeAtlanta, GA, United States2d ago
-
Data Analysis | Data Quality | Data Visualization | Exploratory Data Analysis | Health Informatics401k matching | Dental insurance | Disability insurance | Holidays paid | Life insuranceEntry-level Full Time InternshipRemote, United States R2d ago
-
Data Analyst USD 78K-145KCRM Analytics | Dashboards | Data Integrity | Data Validation | Microsoft Excel401k plan with employer matching | Dental insurance | Health insurance | Paid time off | Vision insuranceMid-level Full TimeMichigan - Remote, United States R2d ago
-
Marketing Measurement & Analytics BI Developer USD 92K-109KAzure Synapse | Cloud Computing | DAX | Dashboard Design | Data Modeling401k match | Adoption Assistance | Healthcare (Medical Dental Vision) | Hybrid schedule | Paid HolidaysMid-level Full TimeMinneapolis, MN, United States2d ago