Data Warehouse Architect-W2 candidates only

Job Title: Senior BI Developer/ Data Warehouse Architect Work Location: Dallas, TX
Duration: 3 months contract to hire
Education/Experience Required: Thorough understanding of PowerBI architecture and capabilities such as CI/CD pipelines, data modeling, security, architecture, etc.
Job Description:

We are looking for a Senior BI Developer/ Data Warehouse Architect to join our team. Our client is modernizing its data platform and data visualization strategies from a traditional solution (SQL Server, SSIS, and Tableau) to a more modern cloud data platform using Azure SQL Managed Instance and Microsoft Fabric.

The ideal candidate will play a key role in orchestrating the transition to a modern data platform, have a deep technical understanding of Power BI and possess strong business acumen to translate customer use cases into compelling and efficient visualization designs. This role will drive innovation, enhance user experience, and enable data democratization across our organization.
Responsibilities :

Collaboration

• Collaborate with subject matter experts, often in ambiguous situations, to determine business information and reporting requirements.
• Foster improved alignment of technology initiatives with business strategies by building and maintaining relationships with technology teams and business partners.
• Provide technical and architectural guidance to projects and teams to ensure effective reporting and analyses.

Data Visualization and Administration

• Define, design, develop, document, and maintain Power BI data models and visualizations.
• Implement advanced techniques using Power BI Premium, XMLA Endpoints, and Tabular Editor 3 to elevate our analytics capabilities.
• Develop and maintain complex DAX, Power Query formula language (M), and T-SQL queries.
• Stay ahead of data science trends and emerging tools and technologies to continually enhance frameworks, processes, and best practices.
• Provide guidance on Power BI security, user mapping, and app deployment.
• Maintain adherence to security and architectural standards as well as usability design principles.

Data Engineering

• Work with various data sources such as SQL Server, DataVerse, Excel, Azure SQL, SharePoint Lists/Libraries, API based data, and unstructured data.
• Oversee and conduct analysis, design, implementation, and support of the company data warehouse which may include developing ETL routines using appropriate tools
• Stay informed about new developments and technologies through continuous learning, industry publications, vendor contacts, trainings, etc.

Skills & Qualifications :

• Thorough understanding of PowerBI architecture and capabilities such as CI/CD pipelines, data modeling, security, architecture, etc.
• Experience with Azure SQL Database, Azure SQL Managed Instance, On-Premise SQL Server and Azure DevOps.
• Strong knowledge of PowerBI dashboard development, Data Visualization concepts, ETL processes, Data Architectures, and Data Modeling.
• Must have an analytical mind, be a critical thinker and problem solver.
• Excellent communication skills (verbal and written) and ability to effectively communicate with both business and technical teams.
• Ability to deal with ambiguity and competing objectives in a fast-paced environment.
• Proven experience working in a team oriented, collaborative environment.

Preferred:

• Familiarity with Azure Data Factory, Azure Synapse, and/or SSIS
• Knowledge of Azure services, including Azure Data Lake
• Experience implementing API calls
• Experience with manufacturing data
• Knowledge of D365 Finance and Operations data

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.