The Application Development and Maintenance department is looking for a skilled and experienced Data Warehouse Developer to join our Business Intelligence development team. As part of our team, you will help design and implement complex DW and BI solutions for our customers, leveraging both on-premises and cloud technologies (primarily using Microsoft technology stack). We deliver end-to-end BI services, from architecting DW/BI solutions and designing \& developing Data Warehouses, to implementing ETL processes and developing the presentation layer.
Responsibilities
Participate in the design and development of Data Warehouse systems
Design, implement, fine tune Azure Synapse or Fabric pipelines for big data.
Establish data governance and metadata management practices.
Design and develop SQL stored procedures, functions, views, triggers
Design, implement and maintain database objects (tables, views, indexes) as part of the solutions we develop
Work closely with our Data Architects as part of DW solution design and development
Maintain library of model documents, templates, or other reusable BI technical knowledge assets
Estimate effort for assigned coding tasks
Qualifications
Advanced knowledge of relational databases \& SQL with a strong understanding of database structures/Data Modeling concepts
Strong understanding of Data Warehousing/ETL strategy and best practices as well as the ability to develop ETL processes using T-SQL/SSIS/Data Factory/Synapse Analytics/Microsoft Fabric
Hands-on experience working with Azure Data Platform technologies, including Azure SQL, Azure Data Factory, and Azure Synapse
Experience working with Microsoft Fabric and understanding its concepts and layers in a data management context
Working knowledge of business system analysis and requirements definition
Ability to translate business questions into data requirements and business intelligence
Experience in database development, SQL queries, stored procedures
Ability to adhere to coding standards and participate in peer code reviews
Knowledge and understanding of the software development life cycle
Experience with software documenting and version control
Analytical and troubleshooting skills with challenging technical subjects and tasks.
Strong written and verbal communication skills (English)
Preferred Skills
Expertise in Azure Data Stack (Synapse, ADF, Databricks).
Mastery of DAX optimization and query folding.
Experience with scripting for advanced analytics.
Experience in designing and developing complex reports using Power BI
Ability to create \& maintain Power BI data models and use DAX expressions