Data Warehouse Developer/SQL Analyst
Location:
Chicago , Illinois
Posted:
October 22, 2017
Reference:
14633_1
Job Summary

Job Summary:

 

As a Data Warehouse Developer/SQL Analyst in our Performance Manufacturing & Distribution unit, you will have the opportunity to play a crucial role in our emerging M&D Business Intelligence Practice. You will be responsible for designing, developing, maintaining, monitoring and extending the data warehouse and analytics architecture to meet our client’s business analysis and reporting needs.  You will work closely with the data warehouse architect, functional ERP implementation team, and our clients to identify key metrics and capture business logic required to transform raw data into actionable insights.


Qualifications

Essential Duties and Responsibilities:

  • Assists in the gathering of business requirements by analyzing source systems and reporting
  • Designs, develops, and supports new and current ETL processes using T-SQL, employing industry standards and best practices to enhance loading of data from the ERP system
  • Develops reports and visualizations using SQL Server Reporting Services, Power BI, and Excel
  • Provides analytical support and consultation on projects to ensure appropriate design, implementation, testing, and documentation
  • Troubleshoots and adjusts existing data warehouse applications
  • Develops and maintains relationships with clients by building personal credibility and trust
  • Demonstrates a high level of personal integrity and strong work ethic
  • Willingness to travel to client sites as needed

Required Qualifications:

  • Five or more years of experience
  • Has a passion for data, reporting & analytics, and data warehousing
  • Desire to work with a dynamic team of seasoned professionals who implement complex, high-value projects for mid-size and large manufacturing companies world wide
  • Enjoys challenge.  Desire to grow both technically and as a professional consultant
  • Experience with SQL (Microsoft, Oracle, PostgreSQL, MySQL, etc.), including the creation of complex views, stored procedures, and/or packages
  • Ability to analyze complex data structures with minimal direction
  • Understanding of star schema models and data warehouse theory
  • Strong team player with willingness to collaborate
  • High comfort level working on multiple simultaneous assignments and dealing with assignment prioritization changes
  • Bachelor’s degree, preferably in Computer Science, Informatics, or a similar field


 


Company Overview

Crowe Horwath LLP (www.crowehorwath.com) is one of the largest public accounting and consulting firms in the United States. Under its core purpose of “Building Value with Values®,” Crowe uses its deep industry expertise to provide audit services to public and private entities, while also helping clients reach their goals with tax, advisory, risk and performance services. With offices coast to coast and 2,600 personnel, Crowe is recognized by many organizations as one of the country's best places to work. Crowe serves clients worldwide as an independent member of Crowe Horwath International, one of the largest global accounting networks in the world, consisting of more than 150 independent accounting and advisory services firms in more than 100 countries around the world.

 


A little about us:
Crowe Horwath LLP is a public accounting, consulting and technology firm dedicated to connecting specialized knowledge with innovative technology to bring value to our clients.

Know someone who would be interested in this job? Share it with your network.