Azure Datawarehouse Architect

4 months ago

Houston, United States Spruce Power Full time
Job DescriptionJob Description

Azure Datawarehouse Architect (Solar Performance Focus)

Houston, TX

POSITION: AZURE DATAWAREHOUSE ARCHITECT

The Azure Datawarehouse Architect will have a unique opportunity to make a significant impact on transforming data into actionable insights and driving decision-making across the organization. The Azure architect be the primary data architect for our Azure Cloud Data Warehouse and Analytics environment with a strong focus on optimizing the Azure data landscape as well as modeling the data and creating ETL pipelines for integrating the data into the Enterprise Data Warehouse.

This role reports to the IT Director of Data & Analytics and will lead the architecture of our Azure environment. They will work closely with data providers and data owners to proactively monitor and detect/diagnose underperforming solar systems using the suite of Microsoft Data Tools.

The ability to play a key role and lead across all initiatives and tasks involved in data management – from data ingestion using Azure Data Factory pipelines, data integration using stored procedures and python scripts, data quality monitoring, Azure devops code management and Azure cloud administration, is critical for the success of this role.

Key responsibilities include:

· Work on Azure Cloud platforms to create ETL pipelines, optimizing data processing and storage.

· Analyze raw data to organize and build efficient data systems and pipelines, developing algorithms and prototypes for prescriptive and predictive modeling.

· Apply advanced data modeling techniques to integrate data from various sources to enhance quality and identify opportunities for data expansion to create analytical tools and programs.

· Lead end-to-end requirements gathering, development, testing, and deployment for data projects.

· Lead all aspects of the development processes, including testing, troubleshooting and support activities.

· Collaborate with business functions to ensure accurate, complete, and available data for analysis.

· Define, document, monitor, and track key performance indicators (KPIs), providing regular reports to stakeholders. Escalate technical support issues to internal and external teams as needed.

· Stay updated on industry trends, best practices, and emerging technologies in Azure cloud management and data warehousing techniques contributing to the advancement of Business Intelligence and Analytical capabilities throughout the organization.

· Performs other duties as assigned.

WHAT WILL SET YOU UP FOR SUCCESS

· Ability to thrive in a dynamic environment while effectively applying planning and organizational skills to set the team up for success.

· Ability to clearly & concisely explain reasoning for decisions.

· Must be able to express complex concepts to technical and non-technical colleagues and leadership.

· Ability to translate business requirements into technical solution design/concepts and tasks for junior team members

· Ability to work with internal application owners and downstream data consumers to understand and interpret requirements.

· Ability to communicate challenges and resolutions to business users and technical teams.

· Ability to engage and influence stakeholders.

TECHNICAL SKILLS
· 10+ years’ experience in data management with at least 5+ years of experience in Azure cloud administration.

· Experience with the following tools is mandatory:

· Azure Microsoft Databases

· Azure Data Factory

· Azure Portal Administration

· Expertise in Azure administration including IAM, storage management, Azure Advisor, Azure databases as well as Azure data monitoring tools.

· Expert-level ability to write and debug Python programs, complex SQL queries, stored procedures, and work with SQL Server relational databases.

· World class data modeling architecture experience including Star Schema/Kimball dimensional modelling.

· Should possess strong experience in designing slowly changing dimensions.

· Power BI and DAX experience a plus

· Python experience is a plus

· Authorized to work in the United States.

· Experience in solar industries is a plus.

EDUCATION

A bachelor's degree or higher in Computer Science, Information Technology, Data Science, or a related field.

EQUAL OPPORTUNITY EMPLOYER

We value a diverse work environment. Spruce Power is an equal opportunity employer and hires without consideration to race, religion, national origin, age, gender, sexual orientation, marital status, veteran status or disability.

Powered by JazzHR

7fu1QZ4Kvl

  • Azure Datawarehouse Architect

    20 hours ago

    Houston, Texas, United States Spruce Power Full time

    Job Title: Azure Datawarehouse ArchitectAbout the Role:Spruce Power is seeking an experienced Azure Datawarehouse Architect to join our team. As a key member of our data management team, you will be responsible for designing and implementing scalable and secure data warehouses on Azure.Key Responsibilities:Design and implement ETL pipelines using Azure Data...

  • Azure Datawarehouse Architect

    7 days ago

    Houston, Texas, United States Energy Service Experts Full time

    Job Title: Azure Datawarehouse ArchitectAt Energy Service Experts, we are seeking a highly skilled Azure Datawarehouse Architect to join our team. As a key member of our data management team, you will play a critical role in designing and implementing our Azure cloud data warehouse and analytics environment.Key Responsibilities:Design and implement ETL...

  • Azure Datawarehouse Architect

    3 months ago

    Houston, United States Spruce Power Full time

    Azure Datawarehouse Architect (Solar Performance Focus) Houston, TX POSITION: AZURE DATAWAREHOUSE ARCHITECT The Azure Datawarehouse Architect will have a unique opportunity to make a significant impact on transforming data into actionable insights and driving decision-making across the organization. The Azure architect be the primary data architect for our...

  • Azure Datawarehouse Architect

    3 months ago

    Houston, United States Spruce Power Full time

    Azure Datawarehouse Architect (Solar Performance Focus) Houston, TX POSITION: AZURE DATAWAREHOUSE ARCHITECT The Azure Datawarehouse Architect will have a unique opportunity to make a significant impact on transforming data into actionable insights and driving decision-making across the organization. The Azure architect be the primary data architect for our...

  • Azure Datawarehouse Architect

    4 days ago

    Houston, Texas, United States Energy Service Experts Full time

    Azure Datawarehouse ArchitectThe ideal candidate will have a strong background in data management and cloud administration, with a focus on Azure cloud platforms. They will be responsible for designing and implementing ETL pipelines, optimizing data processing and storage, and developing algorithms and prototypes for prescriptive and predictive modeling.Key...

  • Azure Architect

    3 weeks ago

    Houston, United States Ledgent Technology Full time

    Job Overview: We are looking for a Senior Azure Architect to join our team for a 3-month contract, with the possibility of transitioning to a permanent role. In this position, you will play a critical role in designing, implementing, and managing Azure cloud solutions that align with our business objectives. The ideal candidate will have extensive experience...

  • Azure Architect

    3 weeks ago

    Houston, United States Ledgent Technology Full time

    Job Overview: We are looking for a Senior Azure Architect to join our team for a 3-month contract, with the possibility of transitioning to a permanent role. In this position, you will play a critical role in designing, implementing, and managing Azure cloud solutions that align with our business objectives. The ideal candidate will have extensive experience...

  • Azure Infrastructure Architect

    1 day ago

    Houston, Texas, United States Smartbridge Full time

    Job Title: Azure Infrastructure ArchitectAbout the Role:We are seeking an experienced Azure Infrastructure Architect to join our team at Smartbridge. As an Azure Infrastructure Architect, you will be responsible for designing and implementing scalable and secure cloud infrastructure solutions on the Microsoft Azure platform.Key Responsibilities:Design and...

  • Azure Architect

    1 week ago

    Houston, United States Jobot Full time

    Job DescriptionJob DescriptionThis Jobot Job is hosted by: Adam BennettAre you a fit? Easy Apply now by clicking the "Apply Now" buttonand sending us your resume.Salary: $130,000 - $145,000 per yearA bit about us:We are a world-renowned company that is transforming our IT team. We are replacing an Azure Architect who will own much of our global cloud...

  • Azure Architect

    2 months ago

    Houston, United States Pinnacle Group, Inc. Full time

    Roles and Responsibilities:Promotes and adheres to Client’s architectural standards and guidelines and works closely with the Enterprise Architects to develop target architectures and technology standardsProvides explicit architecture consulting to project teams, across corporate functions, understands and frames the business problem to be solved. Identify...

  • Azure Virtual Desktop Architect

    2 weeks ago

    Houston, Texas, United States Element Technologies Full time

    Job Title: Azure Virtual Desktop ArchitectWe are seeking a highly skilled and experienced Citrix and Azure Virtual Desktop Architect to join our team at Element Technologies.Key Responsibilities:Design and implement end-to-end virtual desktop solutions using Citrix and Azure technologies.Collaborate with cross-functional teams to understand business...

  • Azure Solution Architect

    4 months ago

    Houston, United States ECF Data, LLC Full time

    Job DescriptionJob DescriptionSeeking a US based Azure Solution Architect to join us inThe Azure Engineer will provide the engineering and second level of support for all Azure platform and related services. A successful candidate for this position will be able to demonstrate technical skills, proficiency with the design, implementation and support of...

  • Azure Solutions Architect

    1 day ago

    Houston, Texas, United States Hines Full time

    Job Title: Azure Solutions ArchitectJob Summary:Hines is seeking an experienced Azure Solutions Architect to join our team. As a key member of our IT department, you will be responsible for designing, implementing, and maintaining complex cloud infrastructure solutions using Microsoft Azure.Responsibilities:Design and implement end-to-end solutions using...

  • Azure Virtual Desktop Architect

    4 days ago

    Houston, Texas, United States Element Technologies Full time

    Job Title: Azure Virtual Desktop ArchitectWe are seeking a highly skilled and experienced Citrix and Azure Virtual Desktop Architect to join our team at Element Technologies.About the Role:The successful candidate will be responsible for designing, implementing, and maintaining virtual desktop solutions that leverage Citrix technologies and the Azure...

  • Azure Architect

    4 weeks ago

    Houston, United States Smartbridge Full time

    Job DescriptionJob DescriptionAll the benefits and perks you need:100% Paid Healthcare Insurance, including First Primary Care Wellness ProgramStart accruing Paid Days Off from Day OneCareer DevelopmentFitness ReimbursementMatching 401K Retirement PlanMentoring ProgramTeam EventsAnd more….SmartbridgeWe simplify business transformation, applying thought...

  • Azure AD B2C Architect

    3 days ago

    Houston, United States Bluo Software LLC Full time

    Role DescriptionPosition: Azure AD B2C ArchitectLocation: Houston, TexasEmployment Type: ContractExperience Level: 8+ yearsPosition Overview:We are seeking an experienced Azure AD B2C Architect to lead the implementation, adoption, and support of Azure Active Directory B2C for our business unit. The project has three primary objectives: The first objective...

  • Azure Virtual Desktop Architect

    19 hours ago

    Houston, Texas, United States Element Technologies Full time

    Job Title: Azure Virtual Desktop ArchitectElement Technologies is seeking a highly skilled and experienced Azure Virtual Desktop Architect to join our team. As a key member of our infrastructure team, you will be responsible for designing, implementing, and maintaining virtual desktop solutions that leverage Azure technologies and Citrix products.Key...

  • Azure Data Warehouse Architect

    2 weeks ago

    Houston, Texas, United States Inceed Full time

    Senior Azure Data Warehouse Architect OpportunityWe are seeking a highly skilled Senior Azure Data Warehouse Architect to lead our team in transforming data into actionable insights and supporting decision-making across the organization.Key Responsibilities:Develop and optimize ETL pipelines on Azure Cloud platforms for efficient data processing and...

  • Snowflake Data Architect with AWS or Azure

    3 weeks ago

    Houston, United States Smart IT Frame LLC Full time

    Snowflake Data Architect with AWS or AzureLocation :: Houston , TX and New JerseyJob Description: Minimum of 15 years IT experience in Data & BI&A solution architecting of which at least 3+ years in Azure Snowflake & Data bricks.Good experience in Data architecture, data warehousing architecture, ETL/ELT, parallel and multi-processing, APIs, Streaming and...

  • Snowflake Data Architect with AWS or Azure

    3 weeks ago

    Houston, United States Smart IT Frame LLC Full time

    Snowflake Data Architect with AWS or AzureLocation :: Houston , TX and New JerseyJob Description: Minimum of 15 years IT experience in Data & BI&A solution architecting of which at least 3+ years in Azure Snowflake & Data bricks.Good experience in Data architecture, data warehousing architecture, ETL/ELT, parallel and multi-processing, APIs, Streaming and...