Azure Data Engineer

Main Outputs and Responsibilities for This Position

• Participate in the analysis, design, development, troubleshooting and support of the enterprise data platform solutions.
• Design, construct, test and implement Data Engineering solutions including:
• Data Warehousing
• ETL and ELT Development
• Data Pipelines Collection and Discovery
• Data Orchestration
• Master Data Management
• Database Development
• Data Mapping
• Integrate with diverse source systems (including but not limited to: In-House, Vendor-based, On-prem and Cloud-based, and Office 365)
• Work with DevOps team and participate in testing of all database-related changes and application updates
• Responsible for the day-to-day database development/administrative tasks which include the development of queries, views, and other database schema objects
• Lead role in establishing data management best practices to ensure data accuracy and quality
• Maintain data model schema and hierarchy within the data warehouse
• Contribute to business continuity documentation through Azure DevOps
• Communicate with business users in gathering and refining requirements as and when required where a dedicated Business Analyst is not part of the project/work items
• Knowledge of programming concepts with hands-on experience highly advantageous

Key Skills:

• The successful candidate should have experience with Microsoft related Data Engineering Tools (eg Azure Data Factory, Synapse, MS Fabric, Transact SQL scripting, BigData, Spark)
• Experience in Master Data Management beneficial
• Experience building visuals through MS Tools (eg Power BI) highly beneficial
• Understanding of insurance / accounting principles will be highly beneficial
• Knowledge of Data Transformation Services, File Transfer Protocol
• Intensive troubleshooting knowledge
• Good Communication Skills and attitude to learning new ways of doing things including new tools.