What are the responsibilities and job description for the Senior Data Warehouse Architect / Senior Developer position at Platinum Enterprise Solutions, Inc.?
Must Have:
- SSAS
- Data Warehouse
- SQL
- Azure
Key Responsibilities: As a part of the firm’s IT Application Development and Support department, responsibilities will include:
• Participate in the architectural discussions, design and development of the cloud migration project
• Rollup sleeves to analyze and fix production issues
• Analyze and assess existing platform for maintainability, reliability, scalability, security, and performance.
• Define standards for the design and analysis of load processes, data flows and data models.
• Lead the design, build, and deployment of ETL (extract, transform, and load) processes for large data sets.
• Review the existing platform architecture and come up with recommendations to solve the current performance issues which exist in cube processing, Data imports, Drill throughs.
• Facilitate code reviews, software design sessions and architectural reviews.
• Participate in technical advisory roles, as required
• Interact with business users, as required.
• Provide ad hoc support in troubleshooting highly complex production issues as they arise.
• Conduct root cause analysis and performance tuning for data load processes.
• Ability to problem solve, recommend, and develop technical solutions
Education and professional experience Required:
• Bachelor's degree in Computer Science, Information Systems, or another four-year degree with IT OR equivalent experience. Master’s degree preferred.
• Overall 15 years in Microsoft technology – SQL Server, SSIS, SSAS
• 10 years of experience delivering Data Warehouse solutions
• 5 years serving as a Data Warehouse architect with a demonstrated track record of implementing highly scalable and available solutions into a highly transactional production setting
• Data Warehouse Technologies: Azure Synapse Analytics, Data Lake, pipelines, Azure SQL Pool
• Data Warehousing & ETL o Significant data warehouse experience from planning, to design, to implementation. o Experience of designing strategies for ETL audit, load balance, exception handling and high data volumes.
• Hands on experience in all areas of SQL Server development including stored procedures, functions, and triggers.
• Proven expertise in Data warehouse methodologies as well as extensive knowledge of OLTP/OLAP technologies.
• Ability to design, organize, and implement module, perform system testing,
• Plan and automate tasks to maintain existing system
• Ability to research and trouble-shoot application problems
• Highly motivated team player with strong communication and interpersonal skills
• Business analysis, especially business requirements gathering Proficient In:
• Relational Database Concepts
• Data Warehouse Concepts
• Dimensional Data Modeling and Notation
• Microsoft SSIS
• ETL Processes
• OLAP Cube Development experience
• MDX experience is preferred
• Microsoft Team Foundation Server / Git
• Application Performance Tuning and Optimization
• Agile development methods and Dev/Ops CI/CD (Preferred)
Please contact:
recruiter@platinumesol.com
Platinum Enterprise Solutions
