Andersen Corporation

BI & Automation Analyst

Remote

Not SpecifiedCompensation
Mid-level (3 to 4 years), Senior (5 to 8 years)Experience Level
Full TimeJob Type
UnknownVisa
Business Intelligence, Data & Analytics, AutomationIndustries

Requirements

Candidates should possess a Bachelor's degree in Statistics, Computer Science, Data Science, Business, or a related field, or have equivalent practical experience. Required hands-on experience includes Power BI, Power Automate, Power Query, SQL, and Azure Synapse. Strong analytical and problem-solving skills with a focus on operational efficiency and process improvement are necessary, as is the proven ability to manage multiple projects and communicate effectively across technical and non-technical audiences.

Responsibilities

The BI & Automation Analyst will design, develop, and optimize datasets using SQL for reporting and analysis. Responsibilities include creating interactive reports with Power BI and SSRS, building automated workflows with Power Automate and Power Query, and maintaining cloud-based data pipelines in Azure Data Lake and Azure Synapse. The role also involves supporting reporting tools like Excel and R, collaborating with cross-functional teams to gather requirements and develop solutions, and documenting data processes to ensure accuracy and quality.

Skills

SQL
Power BI
SSRS
Power Automate
Azure Data Lake
Power Query
Azure Synapse
Excel
R
Data Pipelines
Reporting
Automation
Data Analysis
Data Visualization
Process Optimization

Andersen Corporation

Specializes in replacement windows and doors

About Andersen Corporation

Renewal by Andersen specializes in replacing windows and doors for homeowners looking to improve their homes. They offer a variety of styles and colors, focusing on high-quality, energy-efficient products. The process begins with a consultation where customers can use an Augmented Reality tool to visualize how different options will look in their homes. After selecting products, precise measurements are taken for a custom fit, and professional technicians handle the installation. This company stands out from competitors by providing a complete service from consultation to installation, ensuring customer satisfaction. Their goal is to enhance the aesthetics, functionality, and energy efficiency of homes while maintaining a strong reputation for quality, as shown by their awards.

Cottage Grove, MinnesotaHeadquarters
1995Year Founded
VENTURE_UNKNOWNCompany Stage
VR & AR, Consumer GoodsIndustries
5,001-10,000Employees

Risks

Rising raw material costs could squeeze profit margins.
Labor shortages may delay project timelines and increase costs.
Emerging smart window technologies could impact market share.

Differentiation

Renewal by Andersen uses Augmented Reality for customer consultations, enhancing decision-making.
The company offers a complete service from consultation to professional installation.
Renewal by Andersen is recognized for high customer satisfaction, winning multiple J.D. Power awards.

Upsides

Increased demand for energy-efficient home improvements boosts market growth.
Expansion into Locust Grove, Georgia, with a $420 million investment enhances capacity.
Growing interest in eco-friendly materials aligns with Andersen's sustainable product offerings.

Land your dream remote job 3x faster with AI