MS SQL EDW SA
Skills
Azure Data FactoryAWS LambdaData ArchitectureData CleaningData ModelingData WranglingDatabase Design
What the job involves
The main requirements, responsibilities and hiring steps.
Requirements
- 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
Nice to have
- Knowledge of Stonebranch
- Experience with BI performance management tools like MicroStrategy or Tableau
- Insurance industry experience
Day to day
- 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