Remote MS SQL EDW SA Job in New York, NY InterSources Inc

Who you are

• Bachelor's Degree in Computer Science or related field or equivalent experience
• 7+ years of experience in software development with strong emphasis on Data warehousing concepts
• 5+ years advanced hands-on experience in developing ETL processes using major RDBMS (e.g. SQL Server, Azure Synapse, Oracle, Exadata, DB2, Teradata) and SQL
• 3+ years strong hands-on experience using Cloud tools like Azure Databricks, Azure Delta lake, Azure Data Factory, SQL Server, Azure Synapse, Azure DevOps, Data Lake(ADLS), PySpark, Databricks Notebooks
• Experience with data warehouse design techniques including slow changing dimensions, aggregation, partitioning and indexing strategies
• Experience with 'Lambda' architectures and a deep understanding of distributed storage and computation
• Experience with Agile methodology (Scrum)
• Experience in performance tuning and troubleshooting complex distributed systems
• Experience in CI/CD pipeline activities using tools like Azure DevOps and Azure Git Repo
• Experience with Jira, Confluence, and source code management tools

Desirables

• Knowledge of Stonebranch
• Experience with BI performance management tools like MicroStrategy or Tableau
• Insurance industry experience

What the job involves

• Lead and contribute to development activities supporting global Enterprise Data Warehouse Team
• Create the global EDM Development, Infrastructure & business interna and external data ETL process
• Design, develop, unit test, and implement various Data Engineering solutions