DescriptionAs the Enterprise Data Flow Specialist, 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:
- 5+ years of experience in a similar role, such as Data Analyst, Data Architect, or Data Engineer.
- Bachelor's degree in computer science, information systems, or a related field (or equivalent experience).
- Demonstrated ability to work on complex, enterprise-scale data environments.
- Proficient in Snowflake, SQL Server, database schemas, T-SQL, and stored procedures.
- Experience with ETL tools such as Azure Data Factory (ADF), SSIS, or DBT is highly desirable.
- Strong understanding of data warehousing and database architecture principles.
How We'll Support You:
- Join the largest marketing and fundraising company in North America serving the nonprofit industry where we prioritize innovation and professional growth.
- Collaborate with industry subject matter experts with over 5,000 employees across the enterprise.
- To help you stay energized, engaged and inspired, we offer a wide range of benefits including comprehensive healthcare, paid holidays and generous paid time off so you can have the time and space to recharge pursue your other passions and be with the people you care about.
- Moore is committed to creating a diverse environment and is proud to be an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, disability, age, or veteran status.
#LI-RF1