Microsoft Solution Developer Specialist

Data And Shared Services Solution Developer Specialist Interview: Phone and Skype Visa: USC, GC, GC EAD Remote but must be local to Vienna, VA or Pensacola, FLDescription: Data and Shared Services Solution Developer SpecialistTop 5 Skills: Data/DWH Modeling, Semantic Layer Development, Azure Data Products and SQL Server Solutioning, Power BI, and Data AnalysisLooking for a hands-on Microsoft Data Analytical Solution Specialist (SQL Server, Azure Data Products, Power Platform and Power BI) to assist with designing, developing, and/or supporting business-focused solutions which addresses various SG&R business needs. Also, act as a "Developer Specialist" who will be involved in one or more ad hoc projects that may include developing and implementing data models, business intelligence / reporting solutions using a suite of Microsoft provided tools such as SQL Server, Microsoft Azure SQL, and Microsoft Azure Analytics Platforms/tools, SharePoint, PowerApps, Power BI, Power Automate.Job Responsibilities:Business Intelligence Development: Provide a wide variety of hands-on support that may include performing one or more of the following activities:Data modeling and data analysis including relational, dimensional, and tabular data on a Microsoft-based data and analytical platformSupport SG&R Data Governance, Metadata Management and Data Quality Management processes enablementDevelop/Support custom data integrations/APIs with other applications such as ServiceNow, PeopleSoft, MS PurviewEnable automation using low code platforms (PowerApps, PowerBI), Azure DevOps, CI/CD pipelines, and related toolingDesign and develop various dashboards / Business Intelligence reports using PowerBI and integrate them within SharePointDevelop and execute DAX queries and data modeling tasks in Power BISelf-Service Semantic Layer: Responsible for designing and build out of Self-Service Semantic-Layer leveraging SG&R data warehouse in SQL Server or Azure Cloud-Based SQL Platform that will support various SG&R businessRisk Profiling Datawarehouse: Partner with ISD and SG&R Metrics and Analytics Team to implement an ON-PREM or CLOUD-BASED Datawarehouse for Risk ProfilingProgram Management: Support adoption and implementation of Agile Practices and automation of baseline processes, where applicableRequired Experience: At least 5 years of hands-on solutioning experience and developer skills in one or more domain/product areas as described below:Data Definition and Manipulation (Business Intelligence)Experience in relational modeling, data warehousing, data scrubbing, and manipulation techniquesHands-on SQL skills with strong discipline in following SQL coding styles which improves code supportabilityAdvanced experience in tuning SQL query performance, identifying the need and creation of SQL indexesUnderstanding of various data formats (E.g., XML, JSON) is a mustMicrosoft Office/Power Platforms ProductsDemonstrated project experience developing solutions using one or more tools from the Power Platform (Power Apps, Power Automate / Flow, Power BI)Hands on experience in Power BI and DAX scripting language requiredExperience in developing Office solutions leveraging native office integrations and inter-operability capabilitiesMicrosoft Azure Data Platforms/ProductsExperiences and knowledge in building data solutions using one or more Microsoft Azure Data Platform and ProductsPreferred Skills:Strong Microsoft Data Products and Platforms Skills (both on-prem and cloud-based products)Experiences building solution in Azure Platform using Azure Data ProductsKnowledge in at least one scripting language (R, Python, SAS JMP, VBA) is a plusExperience in building custom data integrations/APIs with other applications such as ServiceNow, PeopleSoft and use of tools like SplunkExperience in implementing Data Quality Controls and understanding of Data Governance Concepts is a plusStrong understanding of Agile approaches and practicesWillingness to learn new technologies/tools and passion for a career in technology fieldExcellent customer service and communication skillsDelivery focused team player with an Agile mindsetStrong sense of ownership and business accountabilityWorking experience in a project-based/consulting type work environment is a plus