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
- Take part in implementing complex BI solutions for SCC customers
- 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
