Data Analytics Architect (Microsoft emphasis)

We are seeking a highly skilled and experienced Data Analytics Architect with a strong focus on Microsoft technologies to join our team. As a Data Analytics Architect, you will play a critical role in designing, implementing, and optimizing data analytics solutions leveraging Microsoft's suite of tools and technologies. Your expertise will be instrumental in transforming complex data into actionable insights, driving business growth, and supporting decision-making processes while actively participating in new opportunity pursuits. The Data Analytics Architect will work closely with the internal leadership on a variety of topics, including technical strategy, project estimation and resourcing. This role is very technically focused and will require some hands-on work.

• Solution Design: Collaborate with stakeholders to understand business requirements and translate them into scalable and efficient data analytics solutions utilizing Microsoft technologies.
• Microsoft Technology Expertise: Possess in-depth knowledge and hands-on experience with Microsoft Azure, Azure Data Services, Power BI, SQL Server, Azure Analysis Services, and other relevant Microsoft tools.
• Architecture Development: Develop end-to-end data analytics architectures, including data integration, data warehousing, data modeling, data visualization, and reporting, leveraging Microsoft platforms.
• Data Modeling: Design and optimize data models to support efficient data storage, retrieval, and analysis, ensuring data integrity, accuracy, and reliability.
• Data Integration: Implement data integration pipelines using Microsoft Azure Data Factory, Azure Data Lake, and other relevant tools to extract, transform, and load data from various sources into a unified data platform.
• Data Visualization and Reporting: Create visually appealing and interactive dashboards, reports, and visualizations using Microsoft Power BI, enabling users to gain valuable insights from data.
• Performance Optimization: Identify performance bottlenecks and implement optimizations to improve data processing, query performance, and overall system efficiency.
• Security and Compliance: Partner with our Security practice to ensure data security, privacy, and compliance with relevant regulations and standards are met.
• Collaboration and Mentoring: Collaborate with cross-functional teams, providing technical leadership and guidance to data engineers, analysts, and other stakeholders to ensure successful project delivery.
• Stay Updated: Keep abreast of the latest advancements in data analytics technologies (Microsoft based and others) and industry trends, continuously enhancing your expertise and applying best practices in solution design and implementation.

• Experience as a Data Analytics Architect or a Senior Data Integration Developer (Data Engineer) with a primary focus on Microsoft technologies.
• Extensive knowledge and hands-on experience with Microsoft Azure, Azure Data Services, Power BI, SQL Server, Azure Analysis Services, and other relevant Microsoft tools.
• Proficiency in data modeling, data integration, and data visualization techniques using Microsoft technologies.
• Strong problem-solving skills and ability to design scalable and efficient data analytics architectures.
• Excellent understanding of data warehousing concepts, data governance, and data quality principles.
• Solid knowledge of data security and compliance considerations in the context of data analytics.
• Strong verbal and written communication and collaboration skills, with the ability to effectively interact with stakeholders, at all levels, in all environments, scheduled and impromptu.
• Innovative with a demonstrated curiosity to expand skills and adapt to a changing technological landscape.
• Presents and maintains a strong professional presence in interactions with all levels of the organization as well as client environments.
• Strong customer service focus demonstrated ability to work closely with them to identify and resolve any potential communication or technical issues.
• Ability to present, facilitate and participate in requirements elicitation and brainstorming sessions with internal and external teams in small and medium group environments.
• Advanced experience in the facilitation and elicitation of information to design needs focused solutions while ensuring others who may be reluctant or unsure have been heard.
• Ability to negotiate conflicting viewpoints in a non-confrontational way.

• Experience architecting cloud-based database solutions in Azure.
• Expertise in the development of process and data models.
• Expertise with ETL tools (SSIS, Azure Data Factory, or similar).
• Experience with Power BI or similar data visualization tools.
• Experience with Artificial Intelligence or Machine Learning tools or languages, a plus (ex. R, Python) is beneficial.
• Experience with Source Control Management tools (Azure DevOps, JIRA, GIT, SVN)
• Experience with Agile or Scrum development methodologies or relevant methodologies.
• Track record for providing technology innovation and practical solutions that offers value for clients.

• Health Care Plan (Medical, Dental & Vision)
• Retirement Plan (401k, IRA)
• Life Insurance (Basic, Voluntary & AD&D)
• Paid Time Off (Vacation, Sick & Public Holidays)
• Family Leave (Maternity, Paternity)
• Short Term & Long Term Disability
• Training & Development
• Work From Home