Search Jobs

Browse the latest opportunities at TPI.

Downey, CA

Posted: 07/19/2023 Job Number: 20181371

Title: Azure Data Warehouse Developer
Location: Downey, CA
Duration: 12 Month contract

Skills Required:

Strong understanding of relational database concepts, SQL (Structured Query Language), and data modeling.
Knowledge of various databases used in data warehousing, such as Oracle, SQL Server, PostgreSQL, or MySQL.
Proficiency in ETL tools like Azure Data Factory, Azure Synapse, or Microsoft SSIS (SQL Server Integration Services) to extract data from various sources, transform it to fit the target schema, and load it into the data warehouse.
Ability to design and implement data warehouse data models, including star schema, snowflake schema, and dimension hierarchies for optimized data retrieval and analysis.
Understanding of data integration techniques and data quality processes to ensure data accuracy, consistency, and reliability in the data warehouse.
Knowledge of data warehouse architecture principles, such as data staging areas, data marts, data lakes, and the overall data flow.
Familiarity with data warehouse development methodologies and the ability to apply best practices in building scalable and maintainable data warehouses.
Experience with BI tools like Power BI and IBM Cognos to create interactive and insightful dashboards and reports based on data stored in Synapse Data Warehouse.
Proficiency in scripting languages like Python, Perl, or Shell scripting for automating ETL processes and data manipulation.