You are:

A deeply experienced Data Engineering, Modeling, and Analytics professional with experience working within a team setting to design, deploy, and support data and analytics solutions. You have played the role of a Data Engineer, Database Administrator, Data Analyst, and/or Data Steward. You are an excellent written and verbal communicator, enjoy solving problems, and are looking to play a leadership role in a rapidly growing team.

In the past you have worked on mid to large scale data projects, utilized SQL or Python to create, read, update, and delete data entities in relational or non-relational database platforms. You have experience with ERPs, CRMs, or other OLTP system’s data formats and converting them to a new snowflake or star schema format using an ETL tool or procedure. People around you consider you a subject matter expert or the “go to person” when it comes to solving data integration, data migration, or general data engineering challenges.

The team:

Our Data Integration and Migration services (DIMS) team members have served in both consulting and industry roles and specialize in helping organizations deploy repeatable, scalable, and sustainable solutions that save time and resources. Our DIMS team has experienced rapid growth and maintains a strong pipeline and is constantly looking for ways to develop our delivery methods, technical solutions, and grow our client skillsets through certifications and regular training opportunities.

Our team strives to be first choice advisors and well-rounded individuals both at work and out of the office. We enjoy meeting virtually and in person at RSM sponsored events, participating in firm CDI groups, and innovating using emerging technologies. We also focus on maintaining a healthy work life balance while managing our client obligations.

Work you’ll do:

  • Partner closely with RSM internal Private Equity (PE), Mergers and Acquisitions (M&A) and specialty teams to support clients throughout separations, integrations, and sell/buy side deals
  • Collaborate closely with external client business, data, technical, project management, and partner teams to build relationships, deliver complex projects, and explore new solutions to their problems/challenges
  • Document the scope, create estimates, and form timelines for external client projects based on a set of assumptions and dependencies gathered through client conversations, surveys
  • Manage engagement financials and project plans to ensure on budget and on time delivery
  • Draft and drive Statements of Work (SOWs), be the key point of contact to client executive sponsors, complete independence and conflict checks with internal compliance teams
  • Lead client assessments of current state people, process, technology, and data through survey, individual interview, virtual or in person workshops, and data profiling and cataloging methods.
  • Define development plans, requirements and solution architectures for data pipelines, lakes, warehouse, analytics, and governance use cases
  • Work with data in both 3NF and Star Schemas, define data mappings, reference data, and data lineage of attributes of data entities (Bonus: Experience working w/ NoSQL data formats)
  • Develop and demonstrate technical solutions using some of the following technologies and languages (with plenty of opportunity to explore new technical solutions):

o T-SQL and Python

o Github Repositories

o Snowflake Data Cloud

o Microsoft SQL Server Integration Services, Azure Data Factory

o Azure Data Studio or Microsoft SQL Server Management Studio

o Microsoft SQL Server Database Engine, Azure SQL Database, Azure SQL Managed Instance

o Azure DevOps, Atlassian Jira

o Power BI Desktop & Service

o Tableau Desktop & Server

o Alteryx Designer & Server

  • Complete certifications in various frameworks, technologies, and methodologies
  • Triage and resolve bugs/defects, manage Quality Assurance (QA) and test plans
  • Act as a leader on practice management efforts, participate in future hiring, performance management, and personal development plans for new team members
  • Author digital written, video, and audio content such as how to articles, white papers, release notes, and other content intended to be posted on RSM’s website or Industry Journals
  • Travel to client sites

We’d like you to have:

  • Experience partnering with Private Equity (PE), Mergers and Acquisitions (M&A) or other specialty teams
  • At least 8 years in a data and analytics role
  • At least 4 years of experience leading teams
  • At least 3 years of external client service

The firm offers a competitive benefits package, base compensation, and an employee bonus program for eligible roles based on individual and firm performance per program guidelines. Base compensation ranges can be found between the ranges noted below in the posting, and an actual offer can vary based upon on role, hiring location, and qualifications. For additional information on RSM’s total rewards, visit our website at 

If required by applicable law or client policy, you may be required to be vaccinated for COVID-19 or have an approved accommodation.

You want your next step to be the right one. You've worked hard to get where you are today. And now you're ready to use your unique skills, talents and personality to achieve great things. RSM is a place where you are valued as an individual, mentored as a future leader, and recognized for your accomplishments and potential. Working directly with clients, key decision makers and business owners across various industries and geographies, you'll move quickly along the learning curve and our clients will benefit from your fresh perspective.

Experience RSM US. Experience the power of being understood.

RSM is an equal opportunity/affirmative action employer. Minorities/Females/Disabled/Veterans.

Read Full Description
Confirmed 20 hours ago. Posted 30+ days ago.

Discover Similar Jobs

Suggested Articles