Data Warehouse Analyst- Pipeline

Remote Jobs; Massachusetts; On-site; USD 90,000 - 120,000; Full time

Job summary

Remote Jobs is seeking a detail-oriented Data Warehouse Analyst to join our team in Massachusetts. You will design, build, and maintain secure data warehouse systems that support data mining, analytics, and reporting.

You will collaborate with IT and business stakeholders to develop a data strategy, ensure data quality, and optimize ETL processes, while generating actionable insights and maintaining documentation of standards and procedures.

Qualifications

• Bachelor's degree in CS, IT, Data Science, or related field.
• Proven experience as a Data Warehouse Analyst, Data Warehouse Engineer, or similar role.
• Strong knowledge of OLAP, ETL frameworks, and database management.

Responsibilities

• Design and implement efficient data warehousing solutions.
• Collaborate with IT teams and management to devise a data strategy that aligns with organizational goals.
• Analyze and interpret complex data sets and turn them into actionable insights.
• Develop, optimize, and maintain data warehouse architecture, including ETL processes.
• Ensure data quality and integrity in databases.
• Handle the design, construction, and support of warehouse data, tables, and cubes.
• Provide data-related technical support and training to teams.
• Generate reports from warehouse data, conduct analysis, and provide actionable insights.
• Document all data warehouse and reporting standards and procedures.
• Evaluate and improve existing BI systems.

Skills

Data warehousing

ETL

SQL

Analytical thinking

Data quality

Education

Bachelor's degree in Computer Science, Information Technology, Data Science, or related field

Tools

SSIS

SSRS

Power BI

SQL Server

Job description

Our company is at the forefront of data management and analytics, committed to delivering powerful data solutions to drive informed decision-making. We specialize in developing and maintaining state-of-the-art data warehouses that support data mining, analysis, and reporting. Our team values innovation, precision, and a collaborative approach to harness the full potential of data.

We are seeking a detail-oriented and experienced Data Warehouse Analyst to join our team. This role involves designing, building, and maintaining efficient and secure data warehouse systems. You will be instrumental in managing our data storage and retrieval processes, ensuring data integrity, and providing vital support for data analytics.

Key Responsibilities:

• Design and implement efficient data warehousing solutions.
• Collaborate with IT teams and management to devise a data strategy that aligns with organizational goals.
• Analyze and interpret complex data sets and turn them into actionable insights.
• Develop, optimize, and maintain data warehouse architecture, including ETL processes.
• Ensure data quality and integrity in databases.
• Handle the design, construction, and support of warehouse data, tables, and cubes.
• Provide data-related technical support and training to teams.
• Generate reports from warehouse data, conduct analysis, and provide actionable insights.
• Document all data warehouse and reporting standards and procedures.
• Evaluate and improve existing BI systems.

Qualifications

• Bachelor's degree in Computer Science, Information Technology, Data Science, or a related field.
• Proven experience as a Data Warehouse Analyst, Data Warehouse Engineer, or similar role.
• Strong knowledge of database management systems, online analytical processing (OLAP), and ETL (Extract, transform, load) framework.
• Knowledge of SQL queries, SQL Server Reporting Services (SSRS), and SQL Server Integration Services (SSIS).
• Experience with BI technologies (e.g., Microsoft Power BI, Oracle BI).
• Analytical mind with problem-solving aptitude.
• Excellent organizational and analytical abilities.
• Outstanding communication and presentation skills.

Summary:

Design, build, and maintain data warehouse systems, ensuring efficient data management and integrity, and supporting data analytics. Responsibilities include developing warehouse architecture, collaborating on data strategy, analyzing data sets for insights, maintaining data quality, and enhancing BI systems.

JOB-24372