MS SQL EDW SA /software engineer

Job Description:
Seeking a senior MS SQL EDW SA /software engineer responsible for leading and contributing to development activities supporting global Enterprise Data Warehouse Team. The ideal candidate will have a strong background in a heterogeneous data management environment. This individual should have extensive experience with data warehousing best practices and techniques and possess extensive knowledge, hands-on experience, and expertise with medium to large enterprise MS SQL data warehousing environments. This person will create the global EDM Development, Infrastructure & business interna and external data ETL process.

This position will be a highly visible member of Insurance industry the Enterprise Data Warehouse development team. This team focuses on the design, development, unit testing, and implementation of various Data Engineering solutions. You will be a part of EDW modernization projects and will impact how the data is processed, transformed, organized, and used for Corporate Reporting, Analytics and Data Science teams.

What will you do:
• Must Have Understanding on Accord Model in EDW
• Insurance industry experience is must
• Provide thought leadership to the build & development.
• Collaborate with Scrum Master in determining the sequence of development execution and own and deliver design artifacts for each sprint.
• Work closely with Principal Engineers, Solution, and Enterprise Architecture to ensure strategic solutions aligned with the enterprise reference architecture.
• Works independently to develop, configure, code, and test programs of varying complexity and scope
• Apply knowledge of the latest trends in the industry and engage with other team members to consult and help implement appropriate technology practices and solutions.
• Ensure implementations are highly scalable, highly available, performant, and secure.
• Estimate own and, in some cases feature-level work effort for input to project planning.
• Escalate delays, issues, risks, and highlights to project managers and/or project leads.

What You Bring

• Bachelor's Degree in Computer Science or related field or equivalent experience
• 7+ years of experience in software development and design experience with strong emphasis on Data warehousing concepts, database design patterns, ETL methodologies, Processing and Transforming massive quantities of Data, Data cleansing, Data wrangling, and Data quality
• 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: 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
• You have experience with 'Lambda' architectures elegantly integrating real-time and batch mode compute and services loads and a deep understanding of the concepts behind distributed storage and computation, in both streaming and batch processing systems
• Strong problem solving and documentation skills.
• Experience with Agile methodology (Scrum)
• You have experience in performance tuning and troubleshooting complex distributed systems and running and maintaining services in 247 production environment
• Working experience in CI/CD pipeline activities using toolsets such as Azure DevOps and Azure Git Repo
• Experience with Jira, Confluence, and source code management tools.
• Knowledge of Stonebranch (Enterprise scheduling tool) and BI performance management tool (e.g. MicroStrategy, Tableau) experience is a plus