
Open since Nov 2016
SQL Server/ BI Developer
AI Summary
Leads analysis, design, implementation, and testing of database development, system integration, reporting systems, and maintenance for a financial reporting data mart.
About this role
Sonoma Consulting is one of the fastest growing national IT Consulting and Executive Search company in the United States, which was founded in 2011 by Mark McGee, the President and CEO. Sonoma Consulting has two business divisions - IT Consulting Services & Executive Search to serve its 150 national clients which range from entrepreneurial start-ups to Global Fortune 500.
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
Skills
Explore related jobs
More jobs at Sonoma Consulting Inc.
Similar SQL Server jobs
- I
Director, Strategy & Execution - ETF & Index InvestmentsInvesco UK Limited · Downers Grove, Illinois - S
(Senior) Associate – Equity IndexingSolactive AG · Frankfurt am Main - MQuantitative Investment Strategies, Manager, Institutional Equity DivisionMS Smith Barney, LLC · Mumbai, India
- T
AVP of Trading - ActiveTidal Financial Group · Oak Brook, Illinois - E
Senior Elastic Engineer (TS/SCI w/CI Poly Required)Everfox Holdings, LLC · USA_VA_Onsite - E
Index Structurer, Italian marketEuronext Technologies SAS · Paris
Jobs in Chicago
- H
RSP Case Manager - 1st ShiftHaymarket Center · Chicago, Illinois - H
RSP Case Manager - 3rd ShiftHaymarket Center · Chicago, Illinois - P
Warehouse AssociateParts Authority · Chicago, IL - ESenior Director, Annual GivingEvangelical Lutheran Church in America · CHICAGO, Illinois
- ESenior Data Analyst LeadEvangelical Lutheran Church in America · CHICAGO, Illinois
- H
AssessorHaymarket Center · Chicago, Illinois
Browse these categories
Market data for this role
All reports →- SeriesRole reportsOne role family at a time: how many openings, what changed this week, who is hiring, what it pays.
- SeriesSalary reportsWhat employers publish in job postings, by level and workplace. Not self-reported pay.
- Market overviewState of tech hiring, September 2026: up 4.8%Tech hiring rose 4.8% month over month in September 2026, with 411,122 new listings. Customer support and account executive roles led the growth.