SQL Server / BI Developer
At a glance
Mid-level Data Analysis & BI role at Sonoma Consulting Inc. Chicago · contract.
Pay not stated Data Analysis & BI salary
dataroles summary, based on the employer's posting.
What you'll do
- Review current Microsoft Dynamics GP reports and exports, then document how they work
- Match reporting needs to Dynamics GP data and add missing information to the financial data mart
- Connect SQL Server Reporting Services or Power BI with SharePoint for financial reporting
- Bring new sources into the warehouse and define its dimensions, fact tables, data loads and controls
- Lead database analysis, design, implementation and testing for development, integration, reporting and maintenance
What you bring
- At least six years with the Microsoft SQL Server stack, including Reporting, Analysis and Integration Services
- At least five years using T-SQL, with two or more years of MDX
- Two or more years with PowerShell, Python or a comparable scripting language
- Working knowledge of SQL replication, performance tuning, web services and the software development lifecycle
Who this fits
This mid-level contract role suits a SQL Server developer focused on financial reporting and business intelligence. You must be local to Chicago and work onsite in downtown Chicago; the contract is listed as lasting six to twelve months.
From the employer
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
Data Analysis & BI work from LinkedIn, X, Reddit and Upwork, in one list.
Each morning you get everything that fits, strongest first.
Data Analysis & BI
Find me workBy the team behind dataroles.