SQL Server Programmer
Posted on: 2 Jan 2021
Moosic, PA
Job Description
Overview
HarperCollins is seeking an experienced SQL Server professional to join their centralized Data Management team, which encompasses an enterprise-wide scope in terms of managing, surfacing and controlling corporate data assets and providing technical support for data access, data definition and data management.
This person will code and analyze SQL Servers programs that support both software applications as well as those used in data warehousing/analysis. This will involve working with business analysts and other PMO partners to develop and execute data migration plans, administer data management procedures and support and rectify daily operational production issues. It will also involve working closely with software developers to optimize database and query performances.
This position reports to the Manager, SQL Systems, working closely with the PMO and business teams.
Responsibilities
* The essential responsibility of this developer is to analyze/create/debug views, functions, triggers and stored procedures using SQL, while coordinating with other Software development teams. This requires strong knowledge and experience with modern SQL Server technology (prefer SQL 2016 and higher), as well as strong knowledge of SQL Server internals with an emphasis on how to optimize query performance.
* Additionally, strong knowledge of database, scripting in C, with or without the use of SSIS (is a plus), will be required for the purposes of data extraction, manipulation, and transformation.
* The selected candidate should be willing to work on production issues which may require availability after business hours (either remotely or in person).
Qualifications
* Experience with MS SQL Server.
* Good understanding about BI environment, using SQL Cubes and power BI
* Technical fluency in all phases of the data management lifecycle.
* Demonstrated proficiency with database programming using T-SQL, as well as scripting using C focused on data manipulation and transformation.
* Experience in designing and creating complex SSIS based programs is a plus.
HarperCollins Publishers is an Equal Opportunity Employer.
About HarperCollins
HarperCollins Publishers is the second largest consumer book publisher in the world, with operations in 17 countries. With 200 years of history and more than 120 branded imprints around the world, HarperCollins publishers approximately 10,000 new books every year in 16 languages and has a print and digital catalog of more than 200,000 titles. Writing across dozens of genres, HarperCollins authors include winners of the Nobel Prize, the Pulitzer Prize, the National Book Award, the Newbery and Caldecott Medals and the Man Booker Prize. HarperCollins, headquartered in New York, is a subsidiary of News Corp(Nasdaq: NWS, NWSA; ASX: NWS, NWSLV)and can be visited online at.
Job Locations US-NJ-Monmouth Junction | US-PA-Moosic
Category Information Technology
Equal Opportunity Employer
All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, protected veteran status, or disability status. EEO/AA/M/F/Disabled/Vets
News Corp.
New York, New York
News Corporation, a media and information services company, creates and distributes content for consumers and businesses worldwide. It operates in five segments: News and Information Services, Book Publishing, Digital Real Estate Services, Subscription Video Services, and Other. The company distributes content and data products, including The Wall Street Journal, Factiva, Dow Jones Risk & Compliance, Dow Jones Newswires, Barron’s, MarketWatch, and DJX through various media channels, such as newspapers, newswires, Websites, mobile device applications, tablets and e-book readers, newsletters, magazines, proprietary databases, live journalism, video, and podcasts. It also owns and operates daily, Sunday, weekly, and bi-weekly newspapers comprising The Australian, The Weekend Australian, The Daily Telegraph, The Sunday Telegraph, Herald Sun, Sunday Herald Sun, The Courier Mail, The Sunday Mail, The Advertiser, The Times, The Sunday Times, The Sun, The Sun on Sunday, and New York Post, as well as digital mastheads and other Websites.
In addition, the company offers home-delivered shopper media that include free-standing inserts and direct mail products; in-store marketing products and services primarily to consumer packaged goods manufacturers; in-store merchandising services; and digital marketing solutions. Further, it publishes general fiction, nonfiction, children’s, and religious books; and provides sports programming content to approximately 200 channels distributed through cable, satellite, and Internet protocol, as well as broadcast rights to live sporting events. Additionally, the company offers property and property-related services on its Websites and mobile applications, as well as residential and commercial property Websites; online real estate services; and professional software and services products, which comprise Top Producer, FiveStreet, and ListHub. News Corporation was incorporated in 2012 and is headquartered in New York, New York.
-
IndustryMedia/Entertainment
-
No. of Employees28,000
-
Website
-
Jobs Posted3303
