[Remote] Solution Architect - Data Analytics

Note: The job is a remote job and is open to candidates in USA. Core BTS is looking for an Azure Data and Analytics Solution Architect to join their growing team. The role involves designing, building, and delivering end-to-end data and analytics solutions for enterprise clients, leveraging modern data platform technologies.

Responsibilities

• Discuss best practices and strategies for modern data and analytics with clients
• Integrate data sources to build models and reports for business users
• Configure and operationalize cloud infrastructure in Azure
• Speak intelligently to Microsoft’s cloud data strategy and roadmap
• Stay current Microsoft technologies and modern data platform best practices

Skills

• Data engineering experience in Azure and be familiar with modern data platform technologies like Azure Analysis Services, Azure Data Lake, Azure Databricks, Azure Data Warehouse, and Azure Data Factory
• 3+ years of experience in data engineering and modeling
• Ability to design an end-to-end data analytics solution architecture and drive its implementation
• Deep understanding of Agile engineering practices
• Data Warehousing
• Data ETL/ELT
• Data Modeling (Dimensional/Kimball)
• T-SQL
• Azure Data Factory (or strong SSIS experience)
• Azure Data Lake Store
• SQL Server/Azure SQL
• Azure Analysis Services or SQL Server Analysis Services (SSAS) - Tabular
• Azure DevOps/Continuous Integration & Continuous Delivery
• Ability to work independently and as a member of a team
• Strong written and oral communication skills
• Strong troubleshooting skills
• Ability to adjust to new client cultures and projects
• Adapt positively to change by embracing new practices, processes, or circumstances
• Present a positive, professional, and self-confident image
• Respond to clients in a timely and professional manner
• Understand and strive to consistently meet or exceed client expectations
• Collaborate with clients to identify and address their business needs
• Communicate accurately, concisely, and effectively
• Respectfully listen to others' ideas and concerns with an open mind
• Display a strong commitment to NRI's vision, mission, and values
• Meet commitments to others and deliver on time
• Hold self and others accountable for responsibilities
• Accept responsibility for own decisions and actions without excuses
• Self-starter
• Azure Synapse/Azure SQL Data Warehouse
• Power BI/DAX
• Databricks
• Azure Functions
• Azure Logic Apps
• Azure AD
• Data Vault
• Database administration and performance tuning
• SQL Server Integration Services (SSIS)
• Python
• Application development experience
• Previous consulting experience
• HDFS
• Azure Stream Analytics/Azure Event Hub
• Azure Data Lake Analytics/Apache Hive
• Azure Cosmos DB
• Apache Spark/HDInsight
• PowerShell
• .NET development
• R/Scala
• [ASP.NET](http://ASP.NET) MVC/Web API
• Snowflake/BigQuery/Redshift

Benefits

• Health, Vision, and Dental Insurance
• Life Insurance
• Health/Dependent Care Flexible Spending
• 401(k) Plan
• Short-Term and Long-Term Disability Coverage
• Generous Vacation and Flex Time Off Programs
• Company Paid Holidays
• Training and Development Opportunities

Company Overview

Core BTS is a customer-centric technology consulting organization dedicated to transforming IT experiences and delivering value to clients. It was founded in 1984, and is headquartered in Madison, Wisconsin, USA, with a workforce of 501-1000 employees. Its website is http://www.corebts.com.

Company H1B Sponsorship

Core BTS has a track record of offering H1B sponsorships, with 5 in 2025, 1 in 2023, 7 in 2022, 5 in 2021, 12 in 2020. Please note that this does not guarantee sponsorship for this specific role.