Are you passionate about designing, developing, and maintaining advanced database systems?
At Predictive Strategies, we are looking for a skilled Database Architect to join our team! In this role, you'll have the opportunity to create and manage our cutting-edge databases and data warehouse platforms. You'll develop both physical and logical schemas to handle and process hundreds of millions of rows of data. Additionally, you'll implement highly secure data storage and access solutions using technologies like TDE, Always Encrypted, and Secure Enclaves. If you have a knack for designing robust and secure data architectures and want to make an impact with your expertise, we'd love to hear from you!
Key Responsibilities:
- Collaborate with Chief Information Officer to understand reporting and analysis needs
- Creation and ongoing monitoring of ETL jobs in Microsoft SSIS.
- Design and development of a robust warehouse solution and attendant ETL jobs and processes.
- Produce and maintain Tableau data sources and, to a lesser extent, the creation of reports in Tableau.
- Responsible for ensuring high-performance access to diverse data sources, enforcing architectural constraints and rejecting designs which compromise system integrity, security or reliability.
Qualifications:
- 5+ years of experience in the design, development and management of Microsoft Azure SQL Servers
- 2+ years of experience in working in Azure environments
- Experience with large-scale databases (500m+ records)
- Ability to write complex, high-performant SQL queries in Transact-SQL (T-SQL)
- 5+ years of experience in the design, development, and management of data warehouse platforms
- 2+ years of experience working with Tableau data sources and reports
- Bachelor’s degree or better
What We Offer:
We offer competitive compensation packages including benefits such as medical insurance, retirement plans, paid time off, and a collaborative work environment.
Join our team today!
Job Type: Full-time
Pay: $115,000.00 per year
Benefits:
- 401(k)
- 401(k) matching
- Dental insurance
- Health insurance
- Paid time off
- Vision insurance
Compensation package:
Experience level:
Schedule:
Security clearance:
Work Location: Remote