Software Engineer, SSIST-SQLWe're seeking an independent,drivenSSIS T-SQLEngineertomanage the current portfolioofreportsandown the fullMicrosoft SQL Server reporting life cycle.Workingwith theCOO, thishighly-visible role will be responsible fordesigning, developing, and maintainingreports that arecriticalto support theenterpriseincluding gathering requirements, data modeling, T-SQLscriptingand stored procedure creation.This personwill be responsible for the analysis, coding, and unit-level testing ofallenhancements, maintenance changes, and new developments.Ensuring that programming and design standards, time frames, and deliverables are met,they'll proactively assesscurrent needs against reports already deployed, definereport layout design, execution, deployment,and subscription management.About the team:AppNexus powers the real-time sale and purchase of digital advertising. We simplifythe most sophisticated machine learning and data science capabilities to help our customers unlock their greatest potential. Our data platform team handles 12 billion transacted ad requests per day and 2-4 terabytes of data per hour.We are looking for a senior engineer to elevate our data ingestion and pipeline processing that emphasizes high performance & optimize map-reduce designs to support even faster, higher volume, delivery of actionable data for our stakeholders.About thejob:Design and develop database objects, tables, stored procedures, views, triggers and SSIS packagesSupport all the C- Level executives with their Data Warehouseviaall required reportingPerformance tuning the stored procedures and T-SQLscriptsAssist developers with complex query tuning and schema refinementPerform data analysis to ensurereportaccuracy and create documentation&diagrams for existing database structuresCreateprotocols and procedures to ensure consistency and accuracy in the report development processDesign, develop, and maintaininternal and client-facingreportsProviding database support for development and deployment of database scripts in Development, Test, Pre-Production and Production environmentsAssist in capturing business requirements for application development, enhancement, or modificationMonitoring performance and managing parameters to provide fast query responses to front-end usersSupport COO with ad-hoc requestsAboutyour skillsand experience:Bachelor's degree in Computer Science orsimilar computationalfield of study3-7 yearsof experience in software development, using Microsoft SQL Server 2008 (queries, views, procedures), SQL Server Database Design, Stored Procedure Design and implementationSolidexperience with developing SSIS packagesandcoding complex stored procedures (using T-SQL).Proven analytical problem solving and debugging skillsExperience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues etc.Familiarity with BI technologies (e.g. Microsoft Power BI)More about you:You are passionate about a culture of learning and teaching. You love challenging yourself to constantly improve, and sharing your knowledge to empower othersYou like to take risks when looking for novel solutions to complex problems. If faced with roadblocks, you continue to reach higher to make greatness happenYou care about solving big, systemic problems. You look beyond the surface to understand root causes so that you can build long-term solutions for the whole ecosystemYou believe in not only serving customers, but also empowering them by providing knowledge and toolsAppNexus is proud to offer equal opportunity in all aspects of employment. We strive to foster a diverse, inclusive and engaging work environment. We welcome applications from all candidates and look forward to receiving yours! Ourinclusivityin action:Partnering with Path Forward to offerreturnships to help caregiversreenter the workforceSharing feedback openly through roundtable discussions on how to make progress on ourDiversity & Inclusion goalsGalvanizing diversity and inclusionthrough our affinity groups (including OutNexus, AppNexus Women's Network, AppNexus Latino Alliance and BlackNexus to name just a few!)Partnering with Fairygodbossto support our commitment to women's advancement in techProviding reasonable accommodations for persons with disabilities, both for interviewees and for employees. Should you require an accommodation, please let us know at your earliest convenience so that we maymake arrangements
AppNexus provides trading solutions and powers marketplaces for Internet advertising.