SQL Server/ BI Developer

2 days ago


Chicago, Illinois, United States Sonoma Consulting Full time $105,000 - $180,000 per year
Company Description

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.

Job Description

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 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

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

Additional Information

Titles: SQL Server Developer, SQL BI Developer, SQL Developer/ Admin

Skills: SQL Server, Financial Reporting, Microsoft Dynamics GP, Business Intelligence


  • BI Developer

    4 days ago


    Chicago, Illinois, United States Kaizen Analytix LLC Full time $80,000 - $120,000 per year

    About the RoleWe are seeking an experienced BI Developer to support a large-scale analytics and reporting initiative. This role is responsible for designing, developing, and optimizing scalable business intelligence solutions using Microsoft Power BI and Microsoft Fabric.The ideal candidate is highly skilled in data modeling, DAX, ETL, and cross-functional...

  • BI Developer

    2 days ago


    Chicago, Illinois, United States Kaizen Analytix Full time $90,000 - $120,000 per year

    About the RoleWe are seeking an experienced BI Developer to support a large-scale analytics and reporting initiative. This role is responsible for designing, developing, and optimizing scalable business intelligence solutions using Microsoft Power BI and Microsoft Fabric.The ideal candidate is highly skilled in data modeling, DAX, ETL, and cross-functional...

  • Power BI Developer

    2 days ago


    Chicago, Illinois, United States Robert Half Full time $80,000 - $120,000 per year

    We're looking for a Power BI Developer to design, develop, and manage dynamic, embedded reporting solutions that help stakeholders visualize and act on impact data. This role is ideal for someone who blends technical development skills with a strong design sensibility and a passion for storytelling through data. As a member of our team, you'll play a...

  • OBIEE Developer

    6 days ago


    Chicago, Illinois, United States Atria Group Full time $100,000 - $120,000 per year

    Company Description Job Description TITLE: OBIEE Developer (2 DEVELOPERS NEEDED)Location: Downtown Chicago (550 W Adams)Duration: MonthsRate: DOEInterview: step personal interview (flexible to Skype)Top Three Skills:1. Developer on at least 2 full OBIEE lifecycle implementations 2. Experience in working directly with the clients to set up review...


  • Chicago, Illinois, United States Northwestern Medicine Full time $110,000 - $126,000 per year

    The salary range for this position is $ $60.90 (Hourly Rate) Placement within the salary range is dependent on several factors such as relevant work experience and internal equity. For positions represented by a labor union, placement within the salary range is guided by the rules outlined in the collective bargaining agreement. We offer a wide range of...

  • Sr. BI Manager

    1 day ago


    Chicago, Illinois, United States Cushman & Wakefield Full time $110,500 - $130,000

    Job TitleSr. BI ManagerJob Description SummaryJob DescriptionPOSITION :     Sr Business Intelligence ManagerOverviewCushman & Wakefield's Client Solutions Team seeks to provide technology-enabled solutions supporting increased operational efficiencies and enhanced occupant experiences. By delivering best-in-class solutions driven by defined functional...


  • Chicago, Illinois, United States New York Technology Partners Full time $150,000 - $200,000 per year

    Job Title:Data EngineerPosition Type:ContractLocation: Chicago, IL(Onsite from Day 1, Hybrid Model – 3 Days Onsite)Job Summary:P&C domain insurance.Data ETL, SQL both should be strong.10+ Years experience.Both Development and testing is required.Communication should be excellent.Key Responsibilities:Design, build, and maintain scalable and reliable ETL/ELT...


  • Chicago, Illinois, United States Community Tax, LLC Full time $60,000 - $90,000 per year

    Power BI Data Analyst – Your Foot in the Door to Real Business ImpactLocation: Chicago, IL (Office near O'Hare International Airport – hybrid)You're good with data — but you're even better at finding what it means.If you've been stuck just pulling reports or formatting dashboards, it's time for the next step. We're a nationally recognized Tax...

  • Tableau Developer

    6 days ago


    Chicago, Illinois, United States DSM-H Consulting Full time

    Location: Open for Peoria, IL as wellRole and Overview of the role:It is primarily a visualization developer with some critical thinking skills. It's a brand new project. There's going to be a lot of chasing of information, a lot of working with uncertainty in terms of brand new projects. Need to dig in, try to figure out all of the answers that can. So this...


  • Chicago, Illinois, United States HashRoot Full time $200,000 - $250,000 per year

    Job Title: Senior Eagle Development ConsultantExperience: 15+ YearsLocation: Chicago, IL / Jacksonville, FL / San MateoContract Duration: Long TermWork Time: US Time ZoneJob SummaryWe are seeking an experienced Senior Eagle Development Consultant with deep expertise in Eagle STAR and PACE platforms. The role involves designing, developing, and integrating...