Alithya · 22 hours ago

Microsoft Data and Analytics Consultant

Alpharetta, GA

Full-time

Remote

Mid Level

Maximize your interview chances

ConsultingInformation Technology

Insider Connection @Alithya

Discover valuable connections within the company who might provide insights and potential referrals.
Get 3x more responses when you reach out via email instead of LinkedIn.

Responsibilities

Participate in requirements gathering sessions;

Identify and implement KPIs, measures, dimensions, and other key business drivers;

Analyze client operations and applications;

Review objectives, key business metrics and enterprise reporting requirements with clients;

Evaluate current systems and help define the architecture and ETL strategies for data warehousing;

Make data accessible through various reporting applications (e.g., Fabric).

Qualification

Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.

Data integration (ETL)Microsoft technologiesData modelingT-SQLDAXPySparkMicrosoft FabricSQL ServerAzure Data LakeAzure SynapseSSISAzure Data FactoryDatabricksPower BISSASSSRSExcelMaster data managementMetadata managementData governanceData strategiesBig dataData lakeDynamics AX/D365TimeXtenderJet Data ManagerERP data sourcesEnglish AdvancedClient development skills

Required

Bachelor’s degree in science

Experience architecting, designing and developing data integration (ETL) solutions (primarily using Microsoft technologies), as well as with reporting and analytics solutions

Experience with transactional and/or dimensional conceptual and logical data modeling, for both traditional relational data warehouse and modern data lake house architectures

Strong experience with: database technologies: T-SQL, DAX, PySpark, Microsoft Fabric, SQL Server, Azure Data Lake, Azure Synapse, or other cloud data service providers

Strong experience with: data integration: SSIS, Azure Data Factory, Databricks, or other enterprise ETL tools

Strong experience with: reporting or analytics tools: Fabric/Power BI, SSAS, SSRS, Excel

Excellent presentation, communication, leadership and client development skills to effectively present information to C-level management, public groups and/or boards of directors

English: Advanced