How Remoteville checks and expires listings
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