Sr. BI (SQL / ETL) Developer Consultant

Sr. BI (SQL / ETL) Developer Consultant
222 W Adams St, 11th Floor
Chicago, Illinois, 60606
United States

West Monroe isn’t a start-up consulting firm, but we act like one.

From day one, our people have the opportunity to make a definitive personal impact for their clients and their careers. What does this mean? It means we seek out the best of the best, and then we challenge them to make us better.

If you are looking to be a “behind the scenes” technologist, this isn’t the place for you. We celebrate driven professionals who thrive in a collaborative environment. Our consultants work on front lines – partnering with clients to deliver game changing solutions in the most dynamic industries. Sound interesting? Then West Monroe Partners just might be t he place for you.

Think you’re up to the challenge?
West Monroe Partners is seeking an experienced Business Intelligence (BI) Consultant to join our emerging Advanced Analytics Practice in the Chicago office developing technology solutions for our clients in the data warehousing and BI space. This is an excellent opportunity to work within our Information Management team with Fortune 250 clients developing BI strategy and roadmaps, implementing new customer facing reporting and analytics platforms, while gaining exposure to a variety of industries including healthcare, insurance, manufacturing, E&U, and professional services. Candidates will need to demonstrate in-depth understanding and prior experience in Microsoft SQL Server Integration Services, ETL development, and reporting solutions.

What will you be doing?
* Work closely with our clients as part of a development team to evaluate requirements and develop business intelligence and data warehousing solutions·
* Design and develop data warehouse database schemas·
* Design and develop extract, transform, and load (ETL) mappings, procedures, and schedules·
* Coordinate activities with data source application owners to ensure integration and data integrity
* Design and develop reports, dashboards, KPIs, and data extracts

What do we need you to bring with you?
* Bachelor’s degree required
* Minimum 3+ years of hands on professional development experience
* Strong technical experience in ETL tools (Informatica, IBM DataStage, or Microsoft Integration Services), database platforms (Oracle or SQL Server), and reporting tools (IBM Cognos, SAP Business Objects, Microsoft Reporting Services, or Microstrategy)
* Experience with the Microsoft SQL Server platform (version 2008 or later) is required
* Good knowledge of standard concepts, best practices, and procedures within a data warehousing and business intelligence environment
* Excellent organizational and communication skills to work in a fast-paced environment and manage and prioritize multiple tasks simultaneously
* Ability to work well in a team of 2 – 5 consultants
* Ability to travel 50% nationally

So, if you’re looking for an opportunity to flex your technical muscles in a high-energy, team-oriented environment where you own your career, we’d love to hear from you.
Think you’ve got what it takes? Join our team and make us better.

West Monroe Partners is an Equal Employment Opportunity Employer -
We believe in treating each employee and applicant for employment fairly and with dignity. We base our employment decisions on merit, experience, and potential, without regard to race, color, national origin, sex, sexual orientation, gender identity, marital status, age, religion, disability, veteran status, or any other characteristic prohibited by federal, state or local law.

Read Full Job Description

Technology we use

  • Engineering
    • .NETLanguages
    • C#Languages
    • JavaLanguages
    • JavascriptLanguages
    • PythonLanguages
    • ScalaLanguages
    • AngularJSFrameworks
    • ASP.NETFrameworks
    • Backbone.jsFrameworks
    • Node.jsFrameworks
    • SpringFrameworks
    • AccessDatabases
    • CassandraDatabases
    • Microsoft SQL ServerDatabases
    • MongoDBDatabases
    • MySQLDatabases
    • OracleDatabases
    • PostgreSQLDatabases

Location

222 West Adams Street , Chicago, IL 60606

An Insider's view of West Monroe Partners

How do you collaborate with other teams in the company?

West Monroe's collaborative culture allows you to grow professionally by working across practices, industries and offices - all while creating value for the client.

Kirsten

Senior Consultant, Mergers & Acquisitions

What makes someone successful on your team?

If you refuse to shy away from a challenge and enjoy working with an intelligent group of people that genuinely care about those around them, your success will be imminent at West Monroe.

Adam

Manager, Advanced Analytics

What are West Monroe Partners Perks + Benefits

Health Insurance & Wellness Benefits
Dental Benefits
Vision Benefits
Health Insurance Benefits
Retirement & Stock Options Benefits
401(K) Matching
Company Equity
Employee Stock Purchase Plan
Child Care & Parental Leave Benefits
Generous Parental Leave
Flexible Work Schedule
Remote Work Program
Vacation & Time Off Benefits
Unlimited Vacation Policy
Paid Volunteer Time
Paid Holidays
Paid Sick Days
Perks & Discounts
Beer on Tap
Commuter Benefits
Company Outings
Stocked Kitchen
Some Meals Provided
Happy Hours
Recreational Clubs
Fitness Subsidies
Professional Development Benefits
Job Training & Conferences
Diversity Program

Additional Perks + Benefits

Where you decide to build your career is one of the most important decisions you will make. Our hope is you see the value of building it here at West Monroe Partners. As a firm, we strive to provide a total rewards model that illustrates our commitment to our people and their growth, creating value today, tomorrow and well into the future.

We invest in you. At West Monroe Partners, we don't just give lip service to the philosophy that people matter. We invest in it, through an attractive package of rewards that promotes your health and well-being, your financial future, your development, and your satisfaction and enjoyment at work.

More Jobs at West Monroe Partners72 open jobs
All Jobs
Finance
Data + Analytics
Design + UX
Dev + Engineer
HR
Marketing
Operations
Product
Project Mgmt
Sales
Operations
new
Chicago
Project Mgmt
new
Chicago
Project Mgmt
new
Chicago
Product
new
Chicago
Operations
new
Chicago
HR
new
Chicago
Project Mgmt
new
Chicago
Operations
new
Chicago
Marketing
new
Chicago
Operations
new
Chicago
Data + Analytics
new
Chicago
Project Mgmt
new
Chicago
Project Mgmt
new
Chicago
Operations
new
Chicago
Developer
new
Chicago
Developer
new
Chicago
Operations
new
Chicago
Project Mgmt
new
Chicago
Developer
new
Chicago
Developer
new
Chicago
Operations
new
Chicago
Developer
new
Chicago
HR
new
Chicago
Project Mgmt
new
Chicago
Project Mgmt
new
Chicago
Project Mgmt
new
Chicago
Project Mgmt
new
Chicago
Developer
new
Chicago
Project Mgmt
new
Chicago
Finance
new
Chicago
Data + Analytics
new
Chicago
Developer
new
Chicago
Operations
new
Chicago
Data + Analytics
new
Chicago
Developer
new
Chicago
Project Mgmt
new
Chicago
Developer
new
Chicago
Operations
new
Chicago
Developer
new
Chicago
Operations
new
Chicago
Developer
new
Chicago