Microsoft BI/Data Warehouse Architecture Consultant

2 weeks ago


Alpharetta, United States Alithya Group Full time

** Microsoft BI/Data Warehouse Architecture Consultant**

Alpharetta, Georgia, United States ** Microsoft BI/Data Warehouse Architecture Consultant**

us ** Alpharetta, Georgia, United States**

Please note that this position oversees the United States. Candidates can be located anywhere in the U.S. and will report to our office in Alpharetta.

At the heart of Alithyas values is the well-being of our employees and their families. That's why we continue to follow the Public Health recommendations closely.

We remain close to you, while keeping our distance. Phone, Microsoft Teams, Zoom or however you like.

Take your ambitions to the next level In this multi-faceted client facing role, you will be responsible for helping our clients achieve business success by making data understandable and actionable. You will participate in requirements gathering sessions, identify and implement KPIs, measures, dimensions, and other key business drivers to run and improve the clients overall business. Your experience in Data Warehousing and Business Intelligence Architecture design, along with your expertise in ETL, Data Modeling, and other Microsoft Azure based data/analytical services, will allow you to successfully implement our data and analytics solutions.

The successful candidate will help determine data and analytical requirements by analyzing client operations and applications; reviewing objectives, key business metrics and enterprise reporting requirements with clients; evaluating current systems, and helping define the architecture/ETL strategies for moving data from heterogeneous source systems to a data warehouse and making that data accessible through various reporting applications (e.g., Power BI). The candidate should be well versed in cloud-based vs on-premise data options. The candidate will help define processes to ensure that the client's business goals and objectives are met by the proposed data architecture and design, and lead the data design and integration effort, including data sourcing and transformation. The candidate will play a key role in developing advanced data and analytical solutions.

When it just clicks

* Experience:

+ in architecture, design and development of data integration (ETL) solutions, including data quality and master data management - primarily using Microsoft technologies;

+ with transactional and/or dimensional conceptual and logical data modeling;

+ architecting, designing and developing reporting and analytics solutions;

+ designing and developing advanced analytics solutions, both on-premises and cloud-based;

+ dealing with all levels of business and technical personnel.

* Strong experience with the following technologies:

+ Database Technologies: T-SQL, MDX, DAX, Microsoft SQL Server, Azure Data Lake, Azure Synapse, Azure Data Lake, or other cloud Data Service Providers;

+ Data Integration: SSIS, Azure Data Factory, Databricks, or other enterprise ETL tools;

+ Reporting/Analytics: Power BI, SSAS, SSRS, Excel.

* Strong verbal and written communications;

* Ability to:

+ quickly gain expertise in new technologies and train team members and external clients;

+ provide technical leadership in the delivery of data warehouse/business intelligence solutions.

* Experience with (preferred):

+ Master Data Management, Metadata Management, Data Governance, Data Strategies and Assessments, Data Modeling;

+ Big Data, Data Lake, Column-Oriented Datastores, and various other on-premises and cloud-based advanced data technologies;

+ estimating projects and writing project proposal documents;

+ Microsoft Dynamics AX/D365 Finance & Operations;

+ TimeXtender or other Data Warehouse Automation tools;

+ Data Modeling tools;

+ hardware architectures and configurations;

+ pre-sales demonstrations.

* Languages required:

+ English: 4/4

40481 #LI-Hybrid

* Opportunities to develop and grow your career;

* Work with diverse technologies, projects, clients and sectors;

* Spend your days in a creative and innovative environment;

* Share experience and knowledge as part of an agile and dynamic team;

* A great harmony between work and personal life;

* Access to exciting educational opportunities (internal, conferences, events, courses, certifications, etc.);

* Personal recognition of your important professional contributions;

* Great cultural diversity across our teams.

Because creativity, passion, integrity and wellness are the companys core values, we are looking for people like you who are enthusiastic, innovative, open-minded, team players and eager to learn.

Working at Alithya is a chance to be part of an energetic, dynamic, and growing team of more than 2,000 professionals in Canada, the United States and France. Our diverse practices and the extensive major projects entrusted to us by our prestigious clients allows us to offer many high growth potential opportunities to our employees in well-established technologies.

Alithya Group is an advocate for workforce diversity and as such, encourages the participation of women in management roles, and implements immigrant-friendly recruiting initiatives

The diversification of our workforce is another factor that sets us apart, resulting from our many international recruitment initiatives and our ongoing efforts to promote diversity and inclusion. We belong to the 30% Club, which encourages womens access to leadership positions.



  • Alpharetta, United States Diverse Lynx Full time

    Job Title: Production Support Data Analyst Location: Alpharetta, GA; Conshohocken, PA; Florham Park, NJ; Purchase NY (Hybrid) Duration: Full Time/Permanent TECHNICAL QUALIFICATIONS: Hybrid Monday/Friday remote and Tue/Wed/Thurs on-site. ETL/Informatica and P&C insurance domain experience is must for this role. 3+ years of data analysis experience for a data...

  • Senior Data Engineer

    Found in: Appcast Linkedin GBL C2 - 3 weeks ago


    Alpharetta, United States Visionaire Partners Full time

    Senior Data Engineer We seek a Senior Data Engineer for an exciting new opportunity! You will play a critical role in the design, build and maintenance of scalable data data pipelines DB's, Data Warehouse / Data Lakehouse etc. You will be part of a major technical modernization across an enterprise. We need a candidate who is very experienced data...

  • Senior Data Engineer

    3 weeks ago


    Alpharetta, United States Visionaire Partners Full time

    Senior Data Engineer We seek a Senior Data Engineer for an exciting new opportunity! You will play a critical role in the design, build and maintenance of scalable data data pipelines DB's, Data Warehouse / Data Lakehouse etc. You will be part of a major technical modernization across an enterprise. We need a candidate who is very experienced data...

  • Senior Data Engineer

    Found in: Appcast US C2 - 2 weeks ago


    Alpharetta, United States Visionaire Partners Full time

    Senior Data Engineer We seek a Senior Data Engineer for an exciting new opportunity! You will play a critical role in the design, build and maintenance of scalable data data pipelines DB's, Data Warehouse / Data Lakehouse etc. You will be part of a major technical modernization across an enterprise. We need a candidate who is very experienced data...


  • Alpharetta, United States CareerBuilder Full time

    Summary Join Aperia Solutions, a leader in SaaS solutions for the Payments and Compliance industries. Aperia is a Texas-based fintech and managed consultancy firm that creates custom SaaS applications and other software-based solutions for the payments, banking, and processing industry. Founded in 1999, Aperia offers business intelligence, risk management,...

  • Data Engineer

    Found in: Appcast Linkedin GBL C2 - 6 days ago


    Alpharetta, United States LocumTenens.com Full time

    The Data Engineer is responsible for supporting and developing LocumTenens.com’s business applications, utilizing multiple technologies as required by the business. The role works to design and implement efficient and effective data pipelines between various LT systems and to/from LT’s data lake as needed to meet LT business and accounting needs. The DE...

  • Data Engineer

    Found in: Appcast US C2 - 7 days ago


    Alpharetta, United States LocumTenens.com Full time

    The Data Engineer is responsible for supporting and developing LocumTenens.com’s business applications, utilizing multiple technologies as required by the business. The role works to design and implement efficient and effective data pipelines between various LT systems and to/from LT’s data lake as needed to meet LT business and accounting needs. The DE...


  • Alpharetta, United States Lorven technologies Full time

    Job DescriptionJob DescriptionRole: Azure Data ArchitectLocation: Alpharetta, GA (hybrid 3-days on-site)Job Type: Contract (Only W2)Project descriptionWe are seeking a highly skilled and experienced Senior Developer specializing in Data Engineering to join our technology-driven team. The ideal candidate will have significant hands-on expertise in Data...


  • Alpharetta, United States Lorven technologies Full time

    Job DescriptionJob DescriptionRole: Azure Data ArchitectLocation: Alpharetta, GA (hybrid 3-days on-site)Job Type: Contract (Only W2)Project descriptionWe are seeking a highly skilled and experienced Senior Developer specializing in Data Engineering to join our technology-driven team. The ideal candidate will have significant hands-on expertise in Data...

  • Microsoft Collaboration Architect

    Found in: Appcast Linkedin GBL C2 - 1 day ago


    Alpharetta, United States Visionaire Partners Full time

    Microsoft Collaboration Architect We seek a Microsoft Collaboration Architect who can help us transition to MS Office 365 / MS Collaboration Suite. Our technical stack is squarely in the MS / Azure world. We seek Senior level - hands on Architect for this position! The purpose of this position centers on architecting and implementing robust collaboration...


  • Alpharetta, United States Visionaire Partners Full time

    Microsoft Collaboration Architect We seek a Microsoft Collaboration Architect who can help us transition to MS Office 365 / MS Collaboration Suite. Our technical stack is squarely in the MS / Azure world. We seek Senior level - hands on Architect for this position! The purpose of this position centers on architecting and implementing robust collaboration...

  • Microsoft Collaboration Architect

    Found in: Appcast US C2 - 1 day ago


    Alpharetta, United States Visionaire Partners Full time

    Microsoft Collaboration Architect We seek a Microsoft Collaboration Architect who can help us transition to MS Office 365 / MS Collaboration Suite. Our technical stack is squarely in the MS / Azure world. We seek Senior level - hands on Architect for this position! The purpose of this position centers on architecting and implementing robust collaboration...


  • Alpharetta, United States SmartIPlace Full time

    Job DescriptionJob DescriptionRole: Warehouse Automation ConsultantLocation: Alpharetta/GA (hybrid)Visa: USC/GC/GC-EAD/H4-EADHire Mode: ContractResponsibilities: Drive all aspects of technical development from technical design to successfully delivering solutions. Manages creation of application documentation. Guides system integration. Evaluates and...


  • Alpharetta, United States SmartIPlace Full time

    Job DescriptionJob DescriptionRole: Warehouse Automation ConsultantLocation: Alpharetta/GA (hybrid)Visa: USC/GC/GC-EAD/H4-EADHire Mode: ContractResponsibilities: Drive all aspects of technical development from technical design to successfully delivering solutions. Manages creation of application documentation. Guides system integration. Evaluates and...


  • Alpharetta, United States CareerBuilder Full time

    Title: Lead Snowflake Developer Location: Alpharetta, GA (Hybrid) Duration: 6 - 12 Months (Possibility for extension) JOB DESCRIPTION: Lead will need to be technically savvy and client facing. Skill's Required: Please look for candidates with Kafka, AWS, Snowflake and BI reporting. Looking for someone who can write complex SQLs understand the existing...

  • Microsoft 365 Specialist

    Found in: Appcast Linkedin GBL C2 - 2 weeks ago


    Alpharetta, United States Intellectt Inc Full time

    Job Title: Microsoft 365 SpecialistLocation: Alpharetta GA 30004 United StatesJob Roles and ResponsibilitiesBuild, manage, and administer the organization-wide deployment of Microsoft 365 enterprise platform (Productivity via Office Applications, Enterprise Collaboration viaTeams, OneDrive, and SharePoint, Email and Calendaring via Exchange Online,Enterprise...

  • Microsoft 365 Specialist

    Found in: Appcast US C2 - 2 weeks ago


    Alpharetta, United States Intellectt Inc Full time

    Job Title: Microsoft 365 SpecialistLocation: Alpharetta GA 30004 United StatesJob Roles and ResponsibilitiesBuild, manage, and administer the organization-wide deployment of Microsoft 365 enterprise platform (Productivity via Office Applications, Enterprise Collaboration viaTeams, OneDrive, and SharePoint, Email and Calendaring via Exchange Online,Enterprise...


  • Alpharetta, United States Intellectt Inc Full time

    Job Title: Microsoft 365 SpecialistLocation: Alpharetta GA 30004 United StatesJob Roles and ResponsibilitiesBuild, manage, and administer the organization-wide deployment of Microsoft 365 enterprise platform (Productivity via Office Applications, Enterprise Collaboration viaTeams, OneDrive, and SharePoint, Email and Calendaring via Exchange Online,Enterprise...

  • Lead SnowFlake Engineer/BI Engineer/ETL Engineer/Data Lead Engineer

    Found in: Appcast Linkedin GBL C2 - 2 weeks ago


    Alpharetta, United States CirrusLabs Full time

    Title: Lead Snowflake Developer Location: Alpharetta, GA (Hybrid) Duration: 6 - 12 Months (Possibility for extension)JOB DESCRIPTION:Lead will need to be technically savvy and client facing.Skill's Required:Please look for candidates with Kafka, AWS, Snowflake and BI reporting.Looking for someone who can write complex SQLs understand the existing Complex...


  • Alpharetta, United States CirrusLabs Full time

    Title: Lead Snowflake Developer Location: Alpharetta, GA (Hybrid) Duration: 6 - 12 Months (Possibility for extension)JOB DESCRIPTION:Lead will need to be technically savvy and client facing.Skill's Required:Please look for candidates with Kafka, AWS, Snowflake and BI reporting.Looking for someone who can write complex SQLs understand the existing Complex...