What are the responsibilities and job description for the Data Architect position at Pinnacle Software Solutions?
Job Details
Job Title: Data Architect
Location: Hybrid in Richmond, VA
Duration: 6 Months
Job Overview:
CarMax is seeking an experienced Data Architect to design and implement data solutions using Snowflake and Azure. The ideal candidate will be responsible for building conceptual data models, driving them to execution, and working closely with the Data Engineering and Business Analytics teams. The Data Architect will create and manage comprehensive data sets, conceptualize and implement the Enterprise Data Model (EDM), and develop models that include autonomy and taxonomy for primary and secondary domains.
Key Responsibilities:
- Data Architecture and Modeling: Architect and model data solutions using Snowflake and Azure, ensuring they align with business needs and technical requirements.
- Build Conceptual Data Models: Design and develop conceptual data models that are easily translated into logical and physical models for execution.
- Stored Procedures Implementation: Implement and optimize stored procedures while ensuring that additional transition layers are minimized.
- Snowflake Integration: Work extensively with Snowflake to build and maintain comprehensive and efficient data sets that support business intelligence and analytics needs.
- Enterprise Data Model (EDM) Implementation: Conceptualize, develop, and implement the Enterprise Data Model (EDM) for specific business units, ensuring alignment with business goals.
- Autonomy and Taxonomy Modeling: Develop data models that include autonomy and taxonomy for primary and secondary domains, ensuring data structures are scalable and flexible.
- Collaboration: Partner with the Data Engineering and Business Analytics teams to ensure seamless data integration and execution of data projects.
- Data Governance: Assist in establishing data governance practices, ensuring that data models are consistent, accurate, and follow best practices.
- Optimization and Performance: Continuously evaluate and optimize data solutions for performance, scalability, and reliability.
Mandatory Skills and Qualifications:
- Snowflake Experience: Strong hands-on experience with Snowflake as a data platform, including the design, integration, and management of data solutions.
- Azure Expertise: Extensive experience with Azure tools and services for data architecture, storage, and management.
- Data Modeling: Expertise in building conceptual, logical, and physical data models for large-scale, complex data systems.
- Stored Procedures Development: Proven experience implementing and optimizing stored procedures within Snowflake and Azure environments.
- Enterprise Data Model (EDM): Experience in designing and implementing the Enterprise Data Model (EDM), ensuring data consistency across business units.
- Data Integration: Experience working with data integration tools and technologies to manage and ensure data flow between systems.
- Collaboration with Cross-Functional Teams: Strong collaboration skills to work with Data Engineering and Business Analytics teams to ensure successful project execution.
- Data Taxonomy and Autonomy: Experience developing data models that include autonomy and taxonomy for primary and secondary domains.
- Data Governance: Familiarity with data governance principles and best practices, ensuring consistency, quality, and compliance across data sets.
- Problem-Solving and Troubleshooting: Strong troubleshooting skills for resolving data integration issues, performance bottlenecks, and optimization challenges.
Preferred Skills (Nice to Have):
- Familiarity with other data platforms or cloud services (AWS, Google Cloud).
- Experience with data orchestration tools such as Apache Airflow or Azure Data Factory.
- Knowledge of data warehousing principles and data lakes.
- Familiarity with data visualization tools and business intelligence platforms.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
