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
