Data Architect
Concord Music Group, Inc.
- Nashville, TN
- Permanent
- Full-time
- Develop and maintain the data architecture strategy to support digital transformation.
- Works with business and IT partners in the design of the data warehouse to ensure interoperability and data normalization with applications and BI tools.
- Design data models, schemas, and data flows to ensure effective data integration, storage, and retrieval.
- Create and maintain detailed documentation for data solutions, including data models, architectures, workflows, and integration points.
- Design, implement, data marts that provide business teams with ad-hoc access to large datasets.
- Provide best practices and governance for the use of Snowflake as an enterprise platform.
- Establish and enforce data management standards, best practices, and governance policies.
- Monitor data usage, quality, and performance, and make recommendations for improvements
- Work with IT and security teams to ensure data security protocols are in place and adhered to.
- Set up a BI Framework to manage the data and reporting structure for BI tools.
- Perform administrative functions, such as SSO and security/access control set up for the data and BI platforms.
- Engage with business stakeholders to understand their data requirements and translate them into effective data architecture solutions.
- Train and assist the business with the usage of BI Tools.
- Works closely with the EPM and ERP teams designing data solutions for the finance teams.
- Responsible for the roadmaps for Bi tools and Snowflake as a Data warehouse, keeping up to date with platform capabilities and how to implement new features in the platforms.
- Evaluate AI capabilities in BI platform and Snowflake for future use
- Bachelor’s degree in computer science, or related quantitative discipline
- Minimum 10+ years of work experience in data management/architecture
- Current hands-on experience with all of the following required: Power BI, AWS, Snowflake. This is a hands-on role.
- 3+ years of Snowflake experience with a SnowPro Core or Advanced certification; Must be conversant with recent features and development of Snowflake.
- 3+ years of Power BI experience.
- Hands-on experience in administering Snowflake and PowerBi.
- AWS Experience required
- Knowledge of security (SAML, OAuth, OpenID, Kerberos, Policies, entitlements etc.)
- Experience with architecting and maintaining high availability production systems
- ERP and or accounting functional knowledge desired
- Able to collaborate with a cross-functional team of developers and consultants and enjoys the challenge of shifting priorities to support a growing business