Data Engineer II

Description & Requirements

As a Data Engineer II at Forvis Mazars, you will be a member of the Enterprise Data Services (EDS) team who works across Firm Technology Services on different projects and in a variety of settings to build systems that collect, manage, and convert raw data into usable information. The goal is to make data available in a secure and performant manner to support the technical, operational, and business needs of Forvis Mazars. Typically, a Data Engineer II is responsible for building data pipelines and supporting infrastructure to bring together information from different source systems.

We are recognized internally as "the go-to people" for the most complex Information Management assignments. We analyze, design, and develop enterprise data and information architecture deliverables, focusing on data as an asset of value to the business.

Working on the Enterprise Data Services team means we solve hard, complicated problems with aggressive timelines. Having and making a conscious effort to support and contribute towards a collegial attitude working together is of paramount importance for the successful functioning of the team. Each team member is expected to actively participate in the development of solutions as called upon and be able to work independently with confidence and knowing you have the support of the team.

How you will contribute:

• Collaborate with a team to understand, in depth, both the business and technical problems EDS seek to solve
• Maintain an enterprise-perspective when designing, developing, and implementing solutions and delivering services
• Work with technical resources to assist and guidance to other teams (such as Software Development, Robotic Processing & Automation, etc.) in developing conceptual, logical, and physical data models to meet specific application needs, to enable support for Forvis Mazars enterprise data needs, in a way consistent with Forvis Mazars enterprise and data architecture principles and guidelines
• Work with the Enterprise Data Services (EDS) Analytics team to establish dashboards and other monitoring tools to monitor the status of data pipelines and data quality in the pipelines
• Support updating enterprise systems and processes (example, STAR updates for Practice Structure Changes)
• Operationally maintain & troubleshoot existing data integrations
• Support the growing data management infrastructure, which may include:
• Maintain the Master Data and Master Metadata Repositories.
• Assist with the development, implementation, and maintenance of DataSpring repositories
• Data Quality
• Data Lineage

We are looking for people who have Forward Vision and:

• Strong analytical and design skills
• Work collegially and collaboratively within the team
• Ability to consult successfully with Product Management, Project Management, and business stakeholders

Minimum Qualifications:

• Bachelor's degree in a related field
• 3 years or more of experience in a related field
• Knowledge of Data and its relationship to Information and the development of domain driven data products
• Proficiency in SQL/SSMS/SSIS/SSAS/Data Modeling to make necessary modifications
• Experience with data profiling in order to work with business stakeholders and understand their data needs
• SQL Proficiency and knowledge of semantic data concepts
• Proficiency using ETL tools such as SQL Server Management Studio (SSMS), SQL Server Integration Studio (SSIS), or Azure Data Factory (ADF)

#LI-OAK, #LI-KCMO, #LI-CLTSP, #LI-CLTU, #LI-DFW

#LI-AQ1