Business Analyst

Technical lead role requiring strong technical background, hands-on experience in Data Modeling, XML’s 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 ( ASP.NET, 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.

Qualifications

Technical Skills / Experience:

• 10+years 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, XML’s, 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
• Bachelor's or Master's Degree in Computer Science, Information Systems, or another related field.