Data Architect
| Company | Copeland |
|---|---|
| Location | Remote in USA, St. Louis, MO, USA, Bellefontaine, OH, USA |
| Salary | $130000 – $200000 |
| Type | Full-Time |
| Degrees | Bachelor’s, Master’s |
| Experience Level | Senior, Expert or higher |
Requirements
- Bachelor’s or Master’s degree in Computer Science, Data Science, Information Systems, or a related field.
- 10+ years of experience in the data domain, with 5+ years of experience showing proficiency as a Data Architect or a similar role.
- Expert level experience with cloud-based data platforms such as Snowflake & Databricks.
- Demonstrable experience working with cloud platforms such as AWS, Azure, or GCP, and cloud data architectures.
- Good experience with dbt for building and managing data transformation pipelines, optimizing workflows, and ensuring efficient data processing.
- Deep understanding of Master Data Management (MDM) processes, including data governance, data quality management, and the integration of MDM with other systems.
- Good experience in crafting and managing data warehouses, data lakes, and other storage solutions.
- Advanced knowledge of SQL to manage and manipulate large datasets efficiently.
- Proficient in scripting languages (e.g. Python, Shell) for automation of data workflows.
- Solid understanding of version control systems, like Git, Github, Bitbucket.
- Expertise in designing complex data models (dimensional, star/snowflake schemas), query optimization, and performance tuning.
- Experience with modern data integration tools such as ADF, Fivetran, Estuary.
- Ability to work in close collaboration with teams from various functions, displaying solid communication and leadership skills.
- Strong problem-solving and analytical skills to find opportunities for data optimization and efficiency.
Responsibilities
- Lead the design and implementation of robust, scalable, and high-performance data models in Snowflake.
- Collaborate closely with the MDM team to design and optimize the data architecture, ensuring the data hub effectively supports the MDM model and facilitates seamless integration and performance within the MDM hub.
- Design and manage end-to-end ETL/ELT pipelines integrating Snowflake with various business and analytical systems, such as MDM hub, APIs, databases, and third-party services.
- Establish and enforce data governance policies, rules, and standards, ensuring data quality, security, and compliance with regulations.
- Work closely with business analysts, data engineers, analysts and data scientists to understand business requirements and translate them into efficient data solutions.
- Design and optimize enterprise data models, schemas, and structures to support current and future business reporting and analytics needs.
- Monitor and optimize the performance of enterprise data models and transformations for high performance and scalability.
- Investigate and resolve data-related issues and inefficiencies in the data pipeline, ensuring minimal downtime and disruption to business operations.
Preferred Qualifications
- Experience with MDM technologies and platforms (e.g. Informatica MDM, Profisee, and Reltio)
- Familiarity with data visualization tools such as Tableau, Power BI, or SIGMA.
- Experience with CI/CD pipelines for data engineering.
- Understanding data quality frameworks and standard methodologies.
- Certification in relevant technologies such as Snowflake, dbt, or Microsoft Azure is a plus.