Job title: Sr Data Architect
USA remote role
Please reply with your expected Contract range–
Compest Solutions Inc. is a trusted provider of technology services and staffing solutions, successfully serving clients across the USA, Canada, and India for over 15 years. We specialize in implementing and supporting diverse client projects while fulfilling critical staffing needs. Our commitment to delivering high-quality services at competitive rates is supported by flexible engagement models, including on-shore, near-shore, and off-shore options.

Following is the JD for the Data Architect role. Minimum 12+ years of experience.

• Strong proficiency in relational database management systems (MS SQL Server), NoSQL databases, including storage (Azure Blob Storage), compute (Azure VMs, and big data processing (Azure Databricks).
• Experience in Designing robust and scalable data architectures leveraging Azure, encompassing data lakes, warehouses, pipelines, and streaming solutions.
• Experience with cloud and hybrid-cloud implementations including IaaS, PaaS and SaaS.
• Experience in Integrating data from diverse sources into cloud environments using tools like Azure Data Factory, or custom ETL processes.
• Ensuring data solutions comply with industry standards like GDPR, implementing security best practices, encryption, and access controls.
• Experience working on solutions that collect, process, store and analyze large volumes of business-critical data.
• Experience in developing both multidimensional and tabular models with large and complex datasets.
• Optimizing data pipelines, queries, and storage for performance and cost-efficiency, monitoring and tuning to meet SLAs and business requirements.
• Performance Optimization: Optimizing data pipelines, queries, and analytics performance for MicroStrategy dashboards and reports.
• Implementing disaster recovery, backup, and high availability strategies for data resilience and business continuity.
• Designing logical and physical data models for SQL Server databases, ensuring integrity, normalization, and performance.
• Collaborating with cross-functional teams to understand data integration needs and provide tailored solutions.
• Experience in Master data management system.
• Designing and implementing Azure Data Analytics solutions.
• Analysis and Solution Architecture Design.

• Strong proficiency in relational database management systems (MS SQL Server), NoSQL databases, including storage (Azure Blob Storage), compute (Azure VMs, and big data processing (Azure Databricks).
• Experience in Designing robust and scalable data architectures leveraging Azure, encompassing data lakes, warehouses, pipelines, and streaming solutions.
• Experience with cloud and hybrid-cloud implementations including IaaS, PaaS and SaaS.
• Experience in Integrating data from diverse sources into cloud environments using tools like Azure Data Factory, or custom ETL processes.
• Ensuring data solutions comply with industry standards like GDPR, implementing security best practices, encryption, and access controls.
• Experience working on solutions that collect, process, store and analyze large volumes of business-critical data.
• Experience in developing both multidimensional and tabular models with large and complex datasets.
• Optimizing data pipelines, queries, and storage for performance and cost-efficiency, monitoring and tuning to meet SLAs and business requirements.
• Performance Optimization: Optimizing data pipelines, queries, and analytics performance for MicroStrategy dashboards and reports.
• Implementing disaster recovery, backup, and high availability strategies for data resilience and business continuity.
• Designing logical and physical data models for SQL Server databases, ensuring integrity, normalization, and performance.
• Collaborating with cross-functional teams to understand data integration needs and provide tailored solutions.
• Experience in Master data management system.
• Designing and implementing Azure Data Analytics solutions.
• Analysis and Solution Architecture Design