Data Warehouse Analyst- Pipeline - Overture Partners
Boston, MA 02108
About the Job
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:
- Bachelors 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.
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.
Source : Overture Partners