Your role. As a senior member of the Data Services team, you will be the lead developer on complex data engineering projects. You will be expected to lead and mentor junior developers on best practices and project delivery. This role will also have responsibility for management of end-to-end delivery of assigned projects. JOB RESPONSIBILITIES . Develop solutions to address current and future information system needs, and create process improvements and controls for defined solutions . Works closely with customers and colleagues to identify opportunities to utilize information systems to improve business processes, promote the strategic use of information while enabling seamless access to information. . Interacts with the staff to produce data mapping and requirements, deliver high quality solutions utilizing Microsoft Data Integration Stack . Provides prototyping solutions, prepares test scripts, and conducts tests and for data replication, extraction, loading, cleansing, and data modeling. . Possesses working knowledge of Relational Database Management Systems (DBMS) and data warehouse front-end tools. . Be proficient in creating and maintain SQL data structures and store procedures. . Works closely with the technical and business team lead to drive solution options analysis, development and implementation of BI solutions. . Contributing team member to thedesign and support of data architecture, database design and integration, transformations, and load processes. QUALIFICATIONS . SSIS Experience with Project Deployment Method and SQL Agent Jobs Set-up in an Azure data management environment. . Proven experience with data warehousing and data modeling, specifically building/understanding Microsoft Azure data management technologies . Comfortable with creating data flows, executing stored procedures within SSIS . Setting up and troubleshooting SQL Agent Jobs . SSMS and T-SQL Experience - Strong T-SQL Skills . Problem Solver - Interested in finding solutions to/supporting existing solutions, as well as, continuing to advance through new development . Nice to have: Informatica Experience (IICS) - Especially with Workday Integration Experience . Experience with Azure DevOps, ADF Experience (Running SSIS from ADF and native ADF pipelines) . Analytical approach to problem-solving ability to use technology to solve business problems . Passionate about learning new technologies . Familiarity with database-centric applications . Strong verbal and written communication skills strong time-management and organizational skills . Ability to work in a fast-paced environment . Proven ability to build out, enhance, and maintain the company data environment, including modifications and maintenance of various ETLs, transactional data sets, and company data assets. . Manage data access, data quality, and data delivery tasks within the framework of specific client BI and IT projects. . Ability to work assigned projects and trouble tickets, delivering results within promised timeframes. . Ability to validate & ensure production level functionality/style is thoroughly tested, and the code reflects the current standards. . 3-5 years' experience using the Microsoft Azure Data integration tools including SSIS/IR, ADF and ADO
