Associate, Data & Integration Engineer

RSM Data Engineering Role

We are the leading provider of professional services to the middle market globally, our purpose is to instill confidence in a world of change, empowering our clients and people to realize their full potential. Our exceptional people are the key to our unrivaled, inclusive culture and talent experience and our ability to be compelling to our clients. You'll find an environment that inspires and empowers you to thrive both personally and professionally. There's no one like you and that's why there's nowhere like RSM.

An experienced Data Engineering and system integration professional with experience working within a team setting to design, deploy, and support system implementations. You have played the role of a Data Engineer, Database Administrator, and/or Data Steward. You are an excellent written and verbal communicator, enjoy solving problems, and are looking to support a rapidly growing team.

You have experience working on mid- to large-scale data projects and have used SQL or Python to create, read, update, and delete data across relational and non-relational database platforms. You understand the data structures of ERP, CRM, HCM, and other OLTP systems, and have experience transforming and converting data using ETL tools or scripting languages. You are considered a subject matter expert—or the go-to person—when it comes to solving data integration, data migration, and broader data engineering challenges.

The team: You will be working with a national team with a client base that extends across the United States. Our 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 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:

• Play a role in projects teams that deliver complex data and digital solutions to our clients
• Provide input to client project plans and solution architectures.
• Support client discovery of current state people, process, technology, and data through survey, individual interview, virtual or in person workshops, and data profiling.
• Perform metadata mapping, define identifier and code transformations, and the generation of technical requirements documentation for data pipelines, workflows, and other solutions.
• Develop and demonstrate technical solutions using the following technologies and languages (with plenty of opportunity to explore new technical solutions):
• T-SQL and Python
• Git Reposo Snowflake Data Cloud
• Microsoft SQL Server Integration Services (SSIS), Azure Data Factory (ADF)
• Microsoft SQL Server Database Engine, Azure SQL Database, Azure SQL Managed Instance
• Azure DevOps, Atlassian Jira
• Alteryx Designer & Server
• 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)
• Triage and resolve bugs/defects, manage Quality Assurance (QA) and test plans
• Complete work according to project budgets and timelines which have been defined to you to ensure on time and on budget delivery
• 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
• Complete certifications in various frameworks, technologies, and methodologies
• Support practice management efforts, participate in future hiring, performance management, and personal development plans for new team members
• Support the drafting of Statements of Work (SOWs) for new client work
• Travel to client sites as needed

We'd like you to have:

• 1 – 3 years in a data engineer role

At RSM, we offer a competitive benefits and compensation package for all our people. We offer flexibility in your schedule, empowering you to balance life's demands, while also maintaining your ability to serve clients. Learn more about our total rewards.

RSM does not tolerate discrimination and/or harassment based on race; color; creed; sincerely held religious beliefs, practices or observances; sex (including pregnancy or disabilities related to nursing); gender (including gender identity and/or gender expression); sexual orientation; HIV Status; national origin; ancestry; familial or marital status; age; physical or mental disability; citizenship; political affiliation; medical condition (including family and medical leave); domestic violence victim status; past, current or prospective service in the Indian Armed Forces; Indian Armed Forces Veterans, and Indian Armed Forces Personnel status; pre-disposing genetic characteristics or any other characteristic protected under applicable provincial employment legislation.

Accommodation for applicants with disabilities is available upon request in connection with the recruitment process and/or employment/partnership. RSM is committed to providing equal opportunity and reasonable accommodation for people with disabilities. If you require a reasonable accommodation to complete an application, interview, or otherwise participate in the recruiting process, please send us an email.