This position is no longer open for applications

Lead Data Warehouse Engineer

Job Description:

Lead Data Warehouse Engineer Summary:

Signature Consultants is seeking a Data Warehouse Engineer for an opportunity in Chicago, IL. The Lead Data Warehouse Engineer will design and operate our ETL pipelines and craft our EDW schemas for storage and query efficiency. The ideal candidate should have experience working with a variety of tools and languages. If not, no worries, you can teach us what you know to shape our stack, tools, and processes.

Responsibilities:

  • Re-factoring fact and dimension tables for query performance
  • Evaluating cloud warehousing solutions from multiple providers
  • Brainstorming with the business owners what data is needed for new reports
  • Leading a brown bag on efficient SQL queries for reports in the warehouse
  • Optimizing ETL jobs to improve transform performance and data availability time

Requirements:

  • Azure, MS SQL for the EDW
  • Power BI and Tableau for visualization
  • CSV dumps in S3 from Production systems
  • SalesForce and QuickBooks as other primary data sources
  • JIRA, Bitbucket, Confluence, Slack for our SDLC
  • Scrum, for our development model with no red tape or obstacles to doing the right thing

About Signature Consultants, LLC

Headquartered in Fort Lauderdale, Florida, Signature Consultants was established in 1997 with a singular focus: to provide clients and consultants with superior staffing solutions. For the seventh consecutive year, Signature was voted as one of the “Best Staffing Firms to Work For” and is now the 15th largest IT staffing firm in the United States (source: Staffing Industry Analysts). With 25 locations throughout North America, Signature annually deploys thousands of consultants to support, run, and manage their clients’ technology needs. Signature offers IT staffing, consulting, managed solutions, and direct placement services. For more information on the company, please visit www.sigconsult.com.

Apply Now

To apply for this job, please complete the following 6 fields and we will immediately follow-up (* = required).

Choose File
.doc, .docx, .txt, .pdf, .html
Would you like to help us get to know you even better?

The intent of asking for the following information is to assist Signature in meeting its commitments to equal opportunity and affirmative action requirements. Completing and returning this section is purely VOLUNTARY on your part and will have absolutely no effect on the status of your employment application.

Signature Consultants is committed to providing reasonable accommodation to qualified individuals with physical and mental disabilities according to state and federal disability discrimination laws. If, because of a disability, you need assistance or a reasonable accommodation for any part of the employment process, please email hr@sigconsult.com or call 888-838-1020. Signature Consultants will partner with you in good faith to identify and implement a reasonable accommodation, if any, that is appropriate and consistent with its legal obligations.

Signature Consultants is an Affirmative Action and Equal Opportunity Employer, Minority/Female/Disabled/Veteran/Gender Identity/Sexual Orientation.

EEO is the law: http://www.dol.gov/ofccp/regs/compliance/posters/pdf/eeopost.pdf