Vacancy caducado!
Job Description - Senior Azure Data Integration Developer
Senior Azure Data Integration Developer- Collaborate with internal customers, prospects and stakeholders, understand and translates business use cases and/or requirements into data analysis and data mapping and consequently data integration routines which involves moving, cleansing and transforming large amount of data between multiple systems.
- Identifies data sources, provides data flow diagrams and documents source to target mapping and process.
- Collaborate with the Data Architect to recommend optimal data models for data ingestion and BI developer for analytic reports
- Facilitate the development of data integration efforts by leading small teams of 1-2 junior developers in addition to hands on design and development of large complex ETL jobs including error handling, disaster recovery.
- Design, implement and maintain database objects (tables, views, indexes, etc.) and database security.
- Validate data integration routines by developing and executing test plans and scenarios including data design, tool design, data extract/transform, networks, and hardware.
- Maintain the data warehouse performance by optimizing batch processing through parallelization, performance tuning etc.
- Work with the Data Architect to establish processes for governing the identification, collection and use of corporate metadata to assure metadata is accurate and valid in the business intelligence environments.
- Ensure data quality through creation of audit controls, proactive monitoring and data cleansing techniques
- Provide on-call support after hours around once a month in the even there are issues.
- 7+ years of experience in Data Warehousing and Business Intelligence
- 5+ Years in BI development leveraging the Microsoft SQL Server. Needs to be an expert in T-SQL
- 3+ Years of working in a parallel data ware house environment such as Netezza, Client/PDW or Teradata.
- 5+ Years in SSIS and use of Stored Procedures.
- 1-2 Years in Azure Data Ware house (Synapse), Azure Data Factory, SQL VMs
- Strong understanding data modeling (i.e. conceptual, logical and physical model design, experience with Operation Data Stores, Enterprise Data warehouses and Data Marts).
- Deep understanding of relational database design concepts and SQL programming
- Experience guiding/mentoring developers with lesser experience.
- Requires strong analytical, conceptual and problem-solving abilities.
- Strong experience with business intelligence and data warehousing design principles and industry best practices.
- Bachelor's degree - preference in computer/information sciences or business/commerce.
- Strong communications skills - oral and written
- Self-starter with strong work ethic
- Flexible and resilient, handle various demands planned and unplanned
- Proven ability to handle multiple tasks and projects simultaneously, no hand holding.
- Problem solver and desire to close issues, pragmatic and realistic with solutions
- Professional demeanor, working with senior level managers and vendors
- Ability to work independently under minimal supervision and meet deadlines.
- Strong sense of accountability, adaptability, flexibility and a sense of urgency.
- Demonstrated ability to establish priorities, organize and plan work to satisfy established timeframes.
- Passionate about continuously improving organizational practices.
- Ability to learn and apply new technologies quickly and self-directed.
- Ability to prioritize and multi-task across numerous work streams
Vacancy caducado!