Senior Data Architect

We are looking to build a data organization that will help us make fast, effective, and insightful decisions while keeping high standards of trust with our business stakeholders and customers.

What you’ll do:

• You will engage with business analysts, developers, analytics team, data engineers and internal customers to implement ideas, optimize existing products, and create high performance, web-based products using powerful and contemporary cloud services
• Enable consistency in the data models and data architecture practices across the various application development and maintenance projects
• Create and maintain conceptual, logical and physical data models, metadata policies and procedures for functional design
• Create end-to-end vision on how logical design translates into one or more physical databases, and how the data will flow through the successive stages, all the way through CDP pipelines into our data warehouse
• Review existing data structures and objects and provide recommendations on use of SQL replication, Cross database joins, Linked Database servers and SQL Source Control
• Work with software architects, senior developers, Data analysts and DBAs to implement modern, best in class solutions
• Develop detailed specifications and documentation for proposed solutions
• Train and coach team members on Data Architecture Standards and guidelines
• Research and develop new ways and modern technologies to improve existing functionality
• Consolidate high-level information regarding all database servers, databases, and usage statistics
• Work with engineering teams to identify opportunities for database architecture improvements
• Work with finance and data engineers to identify cost savings opportunities
• Establish and implement data archive strategy
• Develop and deliver training sessions to engineering teams covering data architecture best practices
• Work with stakeholders to define their data requirements and to assist with ad hoc data analysis
• Troubleshoot data discrepancies, data outages and potential integration failures.
• Identify opportunities to improve processes and strategies for solving data engineering problems
• Verify data quality and assist in performing data cleaning activities

Requirements

What you’ll bring:

• Bachelor's degree in Computer Science, Information Technology, or a related field or related technical discipline, or the equivalent combination of education, technical training, or work experience
• Customer focused, understanding that delivering business value is of utmost importance
• Well-versed in core data lake, data warehousing and data security concepts
• Skilled at eliciting requirements and communicating across a diverse set of engineers and an business stakeholders
• At least 4 years experience building data models to support structured and semi-structured data
• Snowflake / Database modeling experience
• Highly proficient in SQL
• Working knowledge of AWS
• Familiar with data catalog functionality, business glossaries, metadata management and data lineage
• Experienced with at least one BI Tool like Tableau, Looker, or Sigma
• Strong Communication, negotiation and presentation skills to senior leadership
• Experience and practice with one or more of the following technologies:
  • Snowflake
  • DBT
  • Commercial or open source ETL / ETL tools i.e Airbyte or Fivetran
  • Experience or interest working in cloud-based environments preferred.
  • Experience with automated deployments a plus. 
  • Familiar with modern source control systems, especially Git
• Solid foundation in computer science, with experience in OO design and development and multiple data structures.
• Strong communication skills and the ability to communicate technical concepts to non-technical people.
• Capable of juggling multiple projects simultaneously

Benefits

• Health & Wellness: 100% coverage for medical, dental, and vision - employee and dependents.
• Learning & Development: $500 annually towards personal development opportunities.
• Unlimited PTO: Unlimited vacation policy for strong, fully charged batteries.
• 16 Weeks Paid Parental Leave: An inclusive policy to ensure you have time with your newborn or newly adopted child.
• Work Remotely: Flexible hours and work from home (especially these days!)
• 401K: Reach your financial goals while reducing your taxes
• HSA, FSA, & DCFSA: Pre-tax savings plans for healthcare and dependent care.

About Us:

Drata is on a mission to help build trust across the internet.

Drata is a security and compliance automation platform that continuously monitors and collects evidence of a company’s security controls, while streamlining compliance workflows end-to-end to ensure audit readiness.

We all recognize the importance of earning and keeping the trust of our customers when it comes to protecting their data. We’ve felt firsthand how burdensome achieving and maintaining a strong security and compliance posture can be at a fast-growing company. It’s a manual, redundant, error-prone, and unscalable process – and it only grows more complex and expensive over time.

Our team of SaaS, security, compliance, and audit experts have built a better way – with automation!

Employment at Drata is based solely upon individual merit and qualifications directly related to professional competence. We strictly prohibit unlawful discrimination or harassment on the basis of race, color, religion, veteran status, national origin, ancestry, pregnancy status, sex, gender identity or expression, age, marital status, mental or physical disability, medical condition, sexual orientation, or any other characteristics protected by law. We also make reasonable accommodations to meet our obligations under laws protecting the rights of the disabled.