Greetings from Sonoma Consulting.
Title: SQL Server Developer/Administrator
Location: Downtown Chicago
Duration : 6-12 Months Contract
Must be local Chciago
Overview:
Leads in analysis, design, implementation and testing activities associated with database development, system integration, reporting systems and maintenance.
Experience required:
6+ years of experience with complete Microsoft SQL Server stack o Microsoft SQL Server 2008-2016 o SQL Server Reporting Services o SQL Server Analysis Services o SQL Server Integration Services
• 5+ years T-SQL experience, minimum 2+years MDX • Familiar with SQL Server data replication topologies including transactional and snapshot.
• Familiar with SQL Server performance tuning and physical implementations including indexing strategies, maintenance plans, and partitioned tables.
• Minimum 2+ years PowerShell, Python or similar scripting language
• Familiarity with web services, XML, SOAP, WSDL, UDDI
• Familiarity with the software development lifecycle (SDLC) • Strong interpersonal communications, time management, organization, decision making and customer service skills.
Focus Area:
Financial reporting from Microsoft Dynamics GP – Review and document existing reporting capabilities and exports. Map requirements to data sources within Dynamics GP. Extend and integrate missing elements into existing Financial data mart where required. SQL Server Reporting Services/Power BI and SharePoint integration Add and integrate new data sources into existing data warehouse. Define necessary dimensions, fact tables, load processes and controls
Titles: SQL Server Developer, SQL BI Developer, SQL Developer/ Admin
Skills: SQL Server, Financial Reporting, Microsoft Dynamics GP, Business Intelligence
Job details are sourced from the employer's original posting.
Open job postingAbout the company
Company Description Halo Group is a premier provider of IT talent. We place technology experts within the teams of the world’s leading companies to help them build innovative businesses that keep them one step closer to their customers and one step ahead of the competition. We offer a meaningful work environment for employees, attractive and interesting engagements for consultants, and cutting-edge digital innovation for our customers. We delight in helping our customers execute their digital vision. Big projects or small, Halo Group knows that by combining the highest quality talent with our unwavering support, we will become an invaluable extension of the team. Halo Group's experienced consultants in Detroit, Atlanta and Dallas specialize in all areas of product/project governance, UX/UI, multi-platform applications, quality assurance/testing, cloud computing, and data analytics. Since its inception, Halo Group has been recognized for numerous awards, including: - INC 5000 - Future 50 - 101 Best and Brightest - Michigan 50 Companies to Watch - Goldline Research - “Most Dependable Companies” - Ernst & Young - “Entrepreneur of the Year” Finalist