What are the responsibilities and job description for the Sr. Snowflake DBA/Architect - onsite time required Frisco TX weekly position at OpTech?
Job Details
Why work at OpTech?
OpTech is a woman-owned company that values your ideas, encourages your growth, and always has your back. When you work at OpTech, not only do you get health and dental benefits on the first day of employment, but you also have training opportunities, flexible/remote work options, growth opportunities, 401K and competitive pay. Apply today!
Sr. Snowflake DBA/Architect
Onsite requirement: FRISCO, TX (2 -3 days a week)
Position Qualifications:
Bachelor's Degree in computer science, engineering or in a technology related field OR equivalent through a combination of education and/or technology experience OR 12 years of technology experience 8 years of experience in Data Engineering, BI Engineering or related field in architecting and developing end-to-end scalable data applications
8 years of experience Snowflake database setup, administration, ERWIN modeling, designing, implementing enterprise data warehouse solutions with strong SQL query capabilities
8 years of experience implementing data governance, security, PII data handling, monitoring & alerting unauthorized data access, changes
6 years of experience in onboarding new data tools, configuring, integrating Snowflake with Informatica, BI, Analytical tools and with OKTA, SailPoint, CyberArk
8 years of experience managing compute & storage, applying best practices for schema, table, DDL creations, querying, evaluating load operations & performance
6 years of working knowledge of different databases (e.g., SQL & NoSQL), S3 datalake, CICD, Jenkins and AWS cloud technologies; leveraging SQL or Python programming languages
6 years of experience developing strong collaborative relationships with key business, technology and data teams
6 years of experience in working with data engineering best practices across the development lifecycle, including agile methodologies, coding standards, code reviews, source management, build processes and testing
Licenses/Certificates Required:
- Snowflake SnowPro
- Advance Architect Certification is a must ( Amazon Web Services Solution Architect or Certified Data Analytics)
OpTech is an Equal Opportunity Employer (EOE), all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.