Design and implement data warehouse architectures and solutions that support operational reporting and data analysis.
Create and manage ETL (Extract, Transform, Load) processes to integrate data from multiple source systems into the data warehouse.
Develop and deploy BI solutions using tools such as Cognos Analytics, SSRS, or other reporting platforms. Ensure the availability of meaningful and actionable insights to business stakeholders.
Design and maintain data models, schemas, and database objects to ensure optimal performance and efficient querying.
Monitor data quality and troubleshoot data issues, ensuring accurate and consistent data across the warehouse and BI systems.
Build and optimize complex reports, dashboards, and data visualizations for business users to support decision-making.
Work closely with business stakeholders, business analysts, and other technical teams to understand data requirements and provide technical solutions.
Continuously assess and improve the performance of ETL processes, data warehouse queries, and BI reports.
Create and maintain clear, comprehensive documentation for all BI and data warehousing processes, including data flow diagrams, code documentation, and system configurations.
Provide training and support to end-users for BI Tools and solutions; including developing user guides and best practices.
Provide support to end-users and address issues related to data, reporting, and BI tools.

Requirements

3+ years of experience in Data Warehouse, Business Intelligence, or ETL development.
Strong experience with ETL tools (e.g., SQL Server Integration Services (SSIS), Talend, Informatica).
Experience with data modeling techniques and database design.
Proficiency in SQL for querying, optimizing, and managing relational databases (SQL Server, Oracle, etc.).
Familiarity with BI tools such as Cognos Analytics, SSRS, etc.
Understanding of data warehousing concepts (Star Schema, Snowflake Schema, OLAP).
Knowledge of data governance and data quality management best practices.
A Bachelor’s degree in Computer Science, Information Technology, or a related field is preferred.

Benefits

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

ETLdata warehousingdata modelingSQLreportingdata visualizationdatabase designdata quality managementdata analysisBI solutions

communicationcollaborationproblem-solvingtrainingdocumentation