SQL Server/ BI Developer
- Location
- Chicago, IL · On-site
- Job type
- Contract
- Level
- Mid-level
- Experience
- 6+ years
- Listed
- Today
Skills & highlights for this role
- SQL Server
- T-SQL
- SQL Server Integration Services
- SQL Server Reporting Services
- Microsoft Dynamics GP
Also useful
- PowerShell
- Python
- MDX
How well does your resume fit this job?
Upload your resume to see your score for this Sonoma Consulting Inc. role, what matches, what's missing, and your best other matches.
Scored on our server and not saved there. The file stays in this browser so you don't have to upload it again after you sign up.
About the role
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.
Qualifications & Requirements
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
About the Company
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.
Additional Information: Titles: SQL Server Developer, SQL BI Developer, SQL Developer/ Admin
Skills: SQL Server, Financial Reporting, Microsoft Dynamics GP, Business Intelligence
From Sonoma Consulting Inc.'s careers page, first listed on Rolev.ai on November 19, 2026. Rolev.ai is not the employer.
How Rolev.ai helps with this application
Rolev.ai is a job search and application tool for US job seekers. For this SQL Server/ BI Developer role at Sonoma Consulting Inc., it shows how your resume fits, tailors your resume to the posting, and prepares the application for you to review.
See how you fit
Openings from employer career sites are ranked against your whole resume—and searchable inside Claude, ChatGPT, and Cursor via Rolev.ai MCP.
Tailor without inventing
Every change to your resume is checked against your original. New experience goes in only with your yes—zero fabricated claims.
Draft the full kit
Tailored and Full Match resumes, role-specific cover letters, and answers to employer screening questions are prepared in seconds.
1-Click Extension Autofill
The Chrome extension fills the employer's Greenhouse, Workday, Lever, or Ashby form in 1 click. You review it and press Submit.
Similar roles
All Database Administrator jobs- Director, Data Analytics and InsightsFmr · 200 Seaport Blvd, Boston MA
- Sr. Data Governance Platform EngineerU.S. Bank · Cupertino, CA
- Sr. Oracle DBA Database Admin MySQL DBAMaania Consultancy Services · Sarasota, FL
- Oracle DBABroadPoint Federal, Inc. · Washington, DC
- Adobe LifeCycle Specialist - Albany, NY - 6 Months - # 17281/110645Maganti IT Resources LLC · Albany, NY
- PeopleSoft AdministratorEsolvit Inc. · Austin, TX
Common questions
Where is the SQL Server/ BI Developer job at Sonoma Consulting Inc. located?
This SQL Server/ BI Developer position at Sonoma Consulting Inc. is located in Chicago, IL (On-site). Always check Sonoma Consulting Inc.'s application page for specific state eligibility or relocation policies.
What qualifications are required for SQL Server/ BI Developer at Sonoma Consulting Inc.?
For the SQL Server/ BI Developer role, Sonoma Consulting Inc. highlights 6+ years of relevant experience; experience with SQL Server, T-SQL, SQL Server Integration Services, SQL Server Reporting Services, Microsoft Dynamics GP. Rolev.ai can score your existing resume against these requirements and show any skill gaps before you apply.
How do I apply for the SQL Server/ BI Developer position at Sonoma Consulting Inc.?
This listing links directly to Sonoma Consulting Inc.'s SmartRecruiters application page. You can apply directly on Sonoma Consulting Inc.'s site, or use Rolev.ai to check your resume fit, generate a zero-hallucination tailored resume and cover letter for this posting, and autofill the SmartRecruiters application form in 1 click with the Rolev.ai Chrome extension. You always review the form and press Submit yourself.