What are the responsibilities and job description for the Enterprise Data Flow Architect position at Moore DM Group?
Description
As the Enterprise Data Flow Architect , you'll play a pivotal role in ensuring the organization has a comprehensive understanding of how data flows across its systems and processes. This individual will analyze, document, and present the movement, transformation, and storage of data to both technical and executive audiences. They will work closely with cross-functional teams, including data engineers, analysts, and business stakeholders, to ensure the accurate and efficient representation of data flows, while identifying opportunities for optimization.
Moore is a data-driven constituent experience management (CXM) company achieving accelerated growth for clients through integrated supporter experiences across all platforms, channels and devices. We are an innovation-led company that is the largest marketing, data and fundraising company in North America serving the purpose-driven industry with clients across education, association, political and commercial sectors.
Check out www.WeAreMoore.com for more information.
Your impact :
- Analyze and map data flows across the organization, documenting the source, transformation, and destination of data.
- Create detailed and visually completing diagrams, schemas, and documentation suitable for technical and executive audiences.
- Deeply understand the organization's data architecture, including Snowflake, SQL Server, and other data storage technologies.
- Review and analyze database schemas, T-SQL scripts, stored procedures, and queries to trace and validate data movements.
- Collaborate with data engineering and product teams to gather requirements and validate data flow documentation.
- Present findings, documentation, and recommendations to technical teams and executive leadership in clear and concise formats.
- Provide insights into the organization's ETL processes, leveraging tools like Azure Data Factory (ADF), SSIS, and DBT.
- Identify inefficiencies or bottlenecks in current data flow processes and recommend solutions.
Your profile :
How We'll Support You :
LI-RF1