Description

U.S. News & World Report is a multifaceted digital media company dedicated to helping citizens, consumers, business leaders and policy officials make important decisions in their lives. We publish independent reporting, rankings, data journalism and advice that has earned the trust of our readers and users for nearly 90 years. Our platforms on usnews.com include Education, Health, Money, Travel, Cars, News and 360 Reviews.
We reach more than 40 million people monthly during moments when they are most in need of expert advice and motivated to act on that advice directly on our platforms. Our signature franchises include our "Best" series of consumer guides on colleges, graduate schools, hospitals, diets, cars, financial services and more. These guides provide an easy-to-digest list for consumers to better understand and compare when making their decisions. We continue to publish annual guides of the authoritative Best Colleges and Best Hospitals rankings on our website and in print. And our U.S. News Live flagship conferences highlight important national conversations including Healthcare of Tomorrow and Healthiest Communities.
We believe in having a broad range of talent and backgrounds at U.S. News. We strive to maintain a welcoming workplace where everyone is given an opportunity to succeed and contribute to their fullest. Learn more about our Diversity, Equity and Inclusion initiative.
Position Requirements

Your role in helping us shape the future:
We are looking for a Sr. Data Engineer to work on all stages of data warehouse development with a focus on Python ETL development. By specializing in data extraction and loading using Python, this role will help build our large-scale custom data platform.
U.S. News empowers everyone to thrive. The developers at U.S. News have a great deal of independence and a minimum of overhead. By leveraging Python, AWS cloud, Google BigQuery, data science, and other technologies, you'll be driving a major transformation within U.S. News.
We offer a casual work environment. Our offices are in the Georgetown neighborhood of Washington, D.C. We are also open to having this role work anywhere in the U.S.
Are you up to the challenge?
As a Sr. Data Engineer with a focus on Python ETL, you will create robust and resilient data pipelines that ingest data from a variety of sources, including cloud storage, relational databases, unstructured data, and third-party APIs. These pipelines will stage and format the data, then load it into a cloud data warehouse. Once in the warehouse, data will be transformed and joined with other data sources. The resulting data structures will be optimized for analytics and other activations. Reporting, visualizations, advanced analytics, and outbound integrations will be built on top of the transformed data.
You should definitely have:

• 5 - 8 years experience
• College -with major STEM discipline (Bachelors Degree)
• Demonstrated experience writing Python for data engineering tasks
• Practical experience with AWS, especially using Lambda and S3 for data extraction and loading
• Strong understanding of ETL / ELT concepts and exposure to a range of data pipeline tools
• Experience working with cloud data warehouses such as BigQuery (strongly preferred), Snowflake, or Redshift
• Familiarity with relational databases, as they relate to extracting and loading data, especially PostgreSQL
• Knowledge of data modeling techniques such as star schemas

It would be nice if you had:

• Ability to write SQL for both ETL transformations and reporting
• Experience with dbt
• Some experience with AI and ML services such as Google Cloud Data Lab or Cloud ML engines or similar services in AWS or Azure
• Exposure to and understanding of Google Analytics and Google Ad Manager data
• Expertise with Google Cloud Platform, especially its data-centric tools like BigQuery, Cloud Functions, Cloud Storage, Dataflow, Dataprep, Looker, and DataStudio
• Experience with version control, such as Git
• Experience with Unix-based operating systems, such as Linux or Mac OS X, along with the shells and command-line tools available in those environments

What it's like to work with us:

• Talent is our best asset!
• We invest in people with passion and potential who understand U.S. News' dedication to our consumers.
• Entrepreneurial, mission-driven culture with core values of quality and integrity
• Focus on fostering personal and professional growth
• Competitive benefits including paid vacation time, medical, tuition reimbursement, and training
• Collaborative Work Environment ~ Fun, diverse, inclusive and ambitious co-workers

Other Job Info

• These statements are intended to describe the general nature and level of work being performed by employees assigned to this job. This is not intended to be an exhaustive list of all responsibilities, duties, and skills required of employees assigned to this job.

• U.S. News & World Report strongly encourages all employees to be fully vaccinated (including boosters).

• In New York City, the anticipated base salary for this position is $90,000 - $130,000 . The actual base salary offered will depend on a variety of factors, including without limitation, the qualifications of the individual applicant for the position, years of relevant experience, level of education attained, certifications or other professional licenses held, interview performance, and if applicable, the location in which the applicant lives and/or from which they will be performing the job.

Full-Time/Part-Time
Full-Time
Number of Openings
1
About the Organization
U.S. News & World Report is a publisher of news and information that empowers people to make better, more informed decisions about important issues affecting their lives.
EOE Statement
We are an equal employment opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability status, protected veteran status or any other characteristic protected by law.
Tags
This position is currently accepting applications.