Job Title: | Database Developer - Azure - Data warehousing |
Contract Type: | Permanent |
Location: | Theale |
Industry: | |
Salary: | Negotiable |
REF: | RC/P/DatabaseDev_1717577301 |
Contact Name: | Rohit Chavda |
Contact Email: | Rohit.Chavda@projectpeople.com |
Job Published: | 11 months ago |
Job Description
Database Developer
Permanent
Theale- Hybrid way of working
This role is with forward-thinking Telecom Company at the forefront of innovation, and we're on the lookout for a skilled Database Developer to join our passionate team in Theale. With a commitment to excellence and a focus on pushing boundaries, we're ready to welcome a talented individual who shares our vision.
Key Responsibilities:
As a Database Developer, you will:
- Design, develop, and maintain high-performance databases.
- Collaborate with cross-functional teams to understand data requirements.
- Optimize and enhance database performance.
- Troubleshoot and resolve database issues.
- Stay updated on the latest trends and technologies in database development.
Requirements:
- Deliver BAU work, import, staging, and report production including review and continual development of the daily and overall warehouse processes/controls to improve the performance and reliability of production and deliver business efficiencies.
- Own deliverables for the analysis and development of queries, tables, stored procedures, and information provision to the business.
- Assist in delivery of all aspects of issues, reporting and development in an efficient and effective fashion, aligned to critical business timeframes and deadlines.
- Be an ambassador for the Data Warehouse team across the business through appropriate meetings around BAU and projects.
Deliver analysis and development of business requirements through the following:
- Support ETL architecture for overall data migration, data models, data mappings, business logic and data cleansing methods.
- Designing and scheduling complex SSIS Packages, PowerShell scripts for transferring data from multiple data sources to SQL Server.
- Data ingestion into the data warehouse using SSIS & databricks. Transformation of data Azure Synapse.
- Configuring source ingestion of source feeds into Azure DWH.
- Running CI/CD pipelines and pull requests.
- Data validation, reconciliation and data quality measurement and improvements. Both in storage and report production
- Data backup and storage
- Development of new data integrations from additional and expanding data sources to blend data into current dataset for reporting.
- Performance tuning of all stages of data life cycle: ingestion, storage and reporting using appropriate keys/tables/views/SQL/relationships etc.
- Issue route cause analysis, ownership, and solutions
- Testing and implementation of changes
- Providing support to other projects as required and working together with data and other teams.
- Excellent problem-solving skills and attention to detail.
If sounds Interesting, Please share your updated CV to discuss further.
Project People is acting as an Employment Agency in relation to this vacancy.
