JD of Senior Developer (.Net)

POSITION:    Senior Developer (.Net)

LOCATION:    Shanghai/Nanjing, China

JOB TYPE:     Developer/ETL/SSIS/SQL Server/In-House IT

REPORT TO:    In-house IT Director

COMPANY:     A global data-driven, technology-enabled performance marketing agency

INTRODUCTION/OBJECTIVE:

The Senior Developer candidate must be a dynamic contributor, passionate about software development and committed to making a difference in an organization filled with smart, creative people. The incumbent will be part of a team responsible for the development and support of various SaaS (Software as a Service) integration solutions (Salesforce, Workday, Concur), traditional back-office systems (HRIS, Finance, etc.), and strategic data warehouses and reporting tools. We seek a candidate experienced in SSIS-based data transformations, query / database optimization and consuming web services in .NET applications. Candidate must be technically proficient and possess good interpersonal, troubleshooting, and documentation skills. Must be comfortable working in a small team setting and possess an unrelenting focus on quality and scalability.

KEY RESPONSIBILITIES:

  • Review Business Requirements to identify ETL requirements and design, develop and test complex SSIS solutions
  • Create stored procedures, triggers and views
  • Monitor and optimize database objects and SQL Server databases (2008 R2, 2014, 2016) using industry-standard tools and practices (SQL Profiler, Analyzer, Query Plans)
  • Reverse engineer and understand complex integrations
  • Design and develop .NET applications to consume web services from our cloud systems
  • Develop and maintain data mappings between source and destination data stores
  • Document project specific processes and data flows, data dependencies, data definitions and relevant business rules. Establish data dictionaries to support the buildout of a data governance infrastructure
  • Must demonstrate strong problem solving ability, logic and analytical skills
  • Participate in data modeling initiatives
  • Perform quality assurance and testing at the unit level
  • Ability to manage multiple projects in a fast paced environment
  • Ability to work independently and collaborative with other team members
  • Troubleshoots production issues, identifying root cause and implementing sound technical resolutions in a timely manner

QUALIFICATIONS:

  • 5+ years experience as a ETL Developer
  • Hands on experience with SQL Server SSIS and ETL processes
  • Experience in consuming REST and SOAP web services using Microsoft .NET
  • Familiarity with designing and implementing ETL in large databases and data warehouses utilizing both relational and dimensional design concepts
  • Familiarity with agile development techniques and objectives
  • Demonstrable development skills – packages, triggers, views, queries, etc.
  • Experience in other ETL tools is a plus
  • Experience in SSAS and SSRS is a plus
  • Degree in a technical field or commensurate experience
  |  10+ years' experience in executive search industry. He had held senior positions in the largest international executive search firms and the largest domestic executive search firm. Alan has demonstrated an illustrious and consistent track record of successes in account management as well as assignment delivery.  |  more
              
Work in Beijing
Work in Shanghai
Work in Guangzhou
Work in Nanjing
Work in Hangzhou
Work in Shenzhen