Job Description
Job Type: Full time
Workplace: Atlanta, GA
• Support the Data Solutions team by architecting and designing information solutions that meet business requirements
Responsibility
• Sets data vision and direction, collaborate and drives cloud data architecture strategy and long-term planning.
• Recommends standards, policies, and procedures for the form, structure, and attributes of the data tools and systems.
• Design data solutions for Snowflake using best practices.
• Design operational data store (ODS) that complements the data warehouse
• Fosters the reusability of data through modeling consistency, simplicity, and discoverability.
• Integrate with other Snowflake databases.
• Design an approach to migrate existing warehouses in MS SQL to Snowflake. The existing MS SQL warehouse is heavy with store procedures for business logic. The migration will require both the new warehouse (Snowflake) and the existing warehouse (MS SQL) to function simultaneously. We envision an interim design before fully migrating and retiring the existing warehouse (MS SQL).
• Provides guidance and oversight, sharing best practices in data architecture to the team members.
• Collaborates with and guides the business in data rationalization and data sourcing.
• Communicates data architecture to stakeholders and team members
• Research latest data technologies and develops proof of concept
• Involved in data vendor selection processes and management throughout the project lifecycle.
• Plan effective data storage, sharing, and publishing
Job Qualification
•5+ years of working experience designing and building relational and/or dimensional conceptual/logical data models, transforming conceptual/logical data models into physical models and data artifacts, and in the development of data architectures using application/tools
•Working experience in the development of data architectures
•Demonstrated experience with agile development.
•Demonstrated proficiency in working both independently and as part of a team
•Superior analytical and written, and verbal communication skills
•Collaborates to drive strategy for specific tools, platforms, and solution patterns for existing and new distributed systems platforms.
•Experience with cloud solutions Snowflake and Amazon Glue.
•Experience with structured and unstructured data.
•Experience with Microsoft SQL Server 2016 (Required) and SSIS (Preferred)
Contact
Email: [email protected]