DescriptionTechnical lead role requiring strong technical background hands-on experience in Data Modeling XMLs and other Azure technologies along with data analysis skills and leadership abilities. Reporting to the COG IPL and Distribution the candidate participate in multiple project teams for the delivery of data solutions and MS Dynamics configuration including new development maintenance and enhancements. The candidate will also assist with the daily operations. The candidate must also have experience working with MS Dynamics Sales and Service modules.
Primary Responsibilities:
- Provide technical knowledge for the Dynamics Data and Analytics group; the candidate will need to understand the technical design development & support of the Dynamics ecosystem.
- Build & deploy data pipelines in Azure Synaptic Analytics or Python to integrate new sources of data into data ware house
- Develop maintain and build on data warehouse model.
- Collaborate with other Data Engineers Business Intelligence and other stakeholders to ensure data projects are completed on time.
- Development integration and maintenance of Microsoft Dynamics 365 (D365) including integration to other business systems
- Write clean testable code using Microsoft stack ( SQL Server etc.)
- Ensuring enterprise policies best practices standards and processes are followed.
- Translate business requirements into technical specifications and recommend solutions to meet & support business needs
- Write up and maintain technical specifications design documents and process flows.
- Be part of offshore development resources to analyze design construct and test software development projects focused on analytics and data integration
- Effectively communicate within the team externally with other teams business customers and senior leaders
- Work in Agile development team and stakeholders throughout the project.
- Elaborate technical stories and ensure to understand the deliverables.
- Play an active role in mitigating impediments impacting successful completion of Release/Sprint Goals.
- Collaborate with business IT architecture and technical teams across multi-functional areas to complete deliverables.
- Assist in Data Architecture design tool selection and data flows analysis.
- Work with large amounts of data interpret data analyze results perform gap analysis and provide ongoing reports.
- Handle ad-hoc analysis & report generation requests from the business.
- Respond to data related inquiries to support business and technical teams.
QualificationsQualifications
Technical Skills / Experience:
- 10years of proven working experience of 5 years in ETL methodologies Data integration and data migration and insurance business
- Solid understanding of Insurance data
- Technical expertise regarding data architecture models and database design development
- Fluent in various database technologies like SQL server Oracle Azure Synapse and Cosmos
- Strong knowledge of and experience with T-SQL XMLs Python ETL frameworks and Databricks
- Strong Knowledge of analyzing datasets using Excel
- Strong analytical skills with the ability to collect organize analyze and disseminate significant amounts of information with attention to detail and accuracy
- Proficient in learning new technologies with the ability to quickly understand capabilities and work with others to guide these into development
- Good communication and presentation skills
- Solid problem solving decision making and analytical skills
- Knowledge & working experience with MS Dynamics is critical
- Experience with JIRA Service Now Clarity and Azure DevOps
- Experience being part of high-performance agile teams in a fast-paced environment
- Must understand the system scope and project objectives to achieve project needs through matrix management and collaboration with other enterprise teams
- Proven ability to produce results in the analysis design testing and deployment of applications
- Strong team emphasis and relationship building skills; partners well with business and other IT areas
- Applies technical knowledge to determine solutions and solve complex problems
- Ability to be proactive self-motivated detail-oriented creative inquisitive and persistent
- Excellent communication and negotiation skills.
- Ability to organize plan and implement work assignments juggle competing demands and work under pressure of frequent and tight deadlines
- Bachelors or Masters Degree in Computer Science Information Systems or another related field.
Required Experience:
Staff IC