Sr. Data Engineering Architect

| Hybrid
Sorry, this job was removed at 1:41 p.m. (CST) on Wednesday, June 28, 2023
Find out who's hiring in Chicago.
See all Data + Analytics jobs in Chicago
Apply
By clicking Apply Now you agree to share your profile information with the hiring company.



At West Monroe, our people are our business.

We pride ourselves on bringing a different mindset to consulting—and that takes a different approach: highly collaborative, flexible, and tenacious.

Our people-first culture is core to our identity. It’s something we care about, and something we strive to enrich and preserve. No hierarchies. No siloes. No egos. Just smart ideas, unique perspectives, and the drive to make an impact for our clients. 

We also know that the best outcomes for both our people and our clients result from including diverse perspectives at the table. That’s why inclusion & diversity is one of our core values. 

Every day our clients rely on us to help them tackle their greatest challenges, by strategically deploying technology through a business-focused and industry-specific lens. We bring together both the right knowledge and the right approach, so that they can capitalize on opportunities and deliver real results. That takes the right team. And that’s where you come in.

Ready to thrive in the next step on your career journey?

Core Responsibilities: 

  • Work closely with our clients as part of a development team to lead design and architecture requirements
  • Responsible for providing technical direction, advisory services, and support to delivery teams and oversight to technical solutions
  • 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
  • Coordinate project workstreams related to ETL / Reporting requirements and development

Qualifications

  • Minimum 10+ years of hands on professional development experience 
  • Strong technical experience in ETL tools (Informatica, Talend, IBM DataStage, Snowflake, Azure Data Factory, AWS Glue, etc.), database platforms (Oracle Snowflake, Redshift, or Azure), and reporting tools (IBM Cognos, SAP Business Objects, Microsoft Reporting Services, or MicroStrategy)
  • Experience performing complex data migration to and from disparate data systems/platforms as well as to/from the cloud (AWS, Azure, GCP, etc.)
  • Experience with the Microsoft SQL Server platform (2016 or later) is required
  • Experience with Data Visualization tools including PowerBI, Tableau, Looker, etc.
  • Good knowledge of standard concepts, best practices, and procedures within a data warehousing and Business Intelligence (BI) environment 
  • Excellent organizational and communication skills to work in a fast-paced environment and manage and prioritize multiple tasks simultaneously 
  • Desire to work across our core industries including but not limited to Financial Services, Energy & Utilities, Consumer & Industrial Products, and Healthcare & Life Sciences
  • Ability to work well in a team of 2 – 5 consultants

Ready to get started? Join our team and make an impact. 

 

To learn more about inclusion and diversity at West Monroe, visit www.wmp.com/inclusion.  

 

Read Full Job Description
Apply Now
By clicking Apply Now you agree to share your profile information with the hiring company.

Technology we use

  • Engineering
    • C#Languages
    • JavaLanguages
    • JavascriptLanguages
    • KotlinLanguages
    • PythonLanguages
    • ScalaLanguages
    • ASP.NETFrameworks
    • Backbone.jsFrameworks
    • Node.jsFrameworks
    • SpringFrameworks
    • AccessDatabases

Location

Chicago is our headquarters, our largest office, and where it all started. Located in the Loop, you’ll find representation across all practices and industries. As our first office, Chicago remains one of the firm’s main hubs for technology and innovation, relying on top talent from the area.

An Insider's view of West Monroe

How does your team reward individual success?

We have this incredible platform called SHOUTOUT, where employees can showcase the great work they have done or worked on with a team. I love it because we can see all the kudos people give each other, and it makes me so happy!

Britt

Employer Brand Specialist

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

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

Senior Manager, Technology

What are West Monroe Perks + Benefits

West Monroe Benefits Overview

Choosing where to build your career is an important decision. Should you choose to build it with West Monroe, we take that commitment seriously.

We believe that when people get the support they need to thrive, they care more, do more, and achieve more. In fact, that’s our whole business strategy. So 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 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.

Culture
Volunteer in local community
Partners with nonprofits
Open door policy
Open office floor plan
Flexible work schedule
Remote work program
Diversity
Dedicated diversity and inclusion staff
Mandated unconscious bias training
Diversity employee resource groups
West Monroe has six ERGs: Black Employee Network, Interfaith, Pan-Asian Network, SOMOS, WMPride, and Women's Leadership Network.
Hiring practices that promote diversity
Health Insurance & Wellness Benefits
Flexible Spending Account (FSA)
Dental insurance
Vision insurance
Health insurance
Life insurance
Wellness programs
Mental health benefits
Financial & Retirement
401(K)
401(K) matching
Company equity
Employee stock purchase plan
Performance bonus
Charitable contribution matching
Child Care & Parental Leave Benefits
Generous parental leave
Company sponsored family events
Vacation & Time Off Benefits
Unlimited vacation policy
Paid volunteer time
Paid holidays
Paid sick days
Office Perks
Commuter benefits
Company-sponsored outings
Free snacks and drinks
Some meals provided
Company-sponsored happy hours
Recreational clubs
Fitness stipend
Home-office stipend for remote employees
Professional Development Benefits
Job training & conferences
Lunch and learns
Promote from within
Mentorship program
Online course subscriptions available
Paid industry certifications

More Jobs at West Monroe

Apply Now
By clicking Apply Now you agree to share your profile information with the hiring company.
Learn more about West MonroeFind similar jobs like this