Job Description
Client:Finance / Investment / Wealth Management
Position: Azure Data Platform Administrator
Pay:$110K - $130K
Location: [On site first 90 days then work on site 3 days a week] at either Plano, TX or Camas, WA
Scope: As an Azure Data Platform Administrator , you will perform administration of our Azure data and analytics platform, including Azure Synapse, Azure Data Factory, ADLS, Azure ML/AI and reporting as part of a collection of systems in a large technology ecosystem.
Education: BS/MS or equivalent in Computer Science or related field or a combination of technical skills, cloud, system administration and operations
Experience MUST HAVES:
- Minimum of 5 years of experience as a MS SQL Server administrator, system or cloud administrator
- Experience with investment management systems and processes
- Experience with cloud data warehouse and analytics technologies, specifically Azure Synapse, Azure Data Factory, ADLS and SQL Server (SSIS and SSAS), Power BI is required
Responsibilities:
- Work with stakeholders (Infrastructure and Operation and Information Security) to ensure smooth and secure operations of Azure data and analytics platform including Azure Synapse, ADF, Azure ML/AI, Power BI and etc
- Oversee data warehouse and analytics platform on Azure from implementation, maintenance to enhancements and ongoing operations
- Manage various Azure data pipelines, job schedules and systems to ensure performance and uptime
- Maintain up-to-date platform documentation and provide technical support to database, application and business intelligence (BI) developers
- Perform maintenance and troubleshooting activities for data warehouse and BI platform on Azure and resolve issues
- Ensure metadata (data catalog) are tracked for all data objects in the platform
- Perform system monitoring and performance analysis
- Perform ongoing security controls audit and review to ensure compliance
- Review system application logs and identify potential issues and improvements
- Participate in capacity planning, cloud cost analysis and cloud resources optimization
- Provide after-hour system and application support
- Develop and implement various work plans for projects
Benefits:
- 100% paid medical, dental and vision premiums for you and your qualifying dependents
- A 50% 401(k) match, up to the IRS maximum
- 20 days of PTO, plus 10 paid holidays
- Family Support programs including 8 week Paid Primary Caregiver Leave, fertility, family forming, and hormonal health assistance and back-up child, adult, and elder care
- $10,000 fertility, hormonal health and family-forming benefit
Qualification
Bachelor's Degree
Key skill Required
- SQL
- SQL Server
- Azure
- Azure ML
- Business Intelligence
- Analysis
- Analytics
- Audit
- Azure Data Factory
- Cloud Data Warehouse
- Compliance
- Computer Science
- Cost Analysis
- Data Pipelines
- Data Warehouse
- Database
- Documentation
- Ecosystem
- Finance
- Implementation
- Information Security
- Infrastructure
- Intelligence
- Investment Management
- Maintenance
- Management
- Management Systems
- Metadata
- Optimization
- Performance Analysis
- Power BI
- Reporting
- Science
- Security
- System Monitoring
- Troubleshooting
