Sr. BI Engineer 2U, Inc.
THIS JOB HAS EXPIRED What we?re looking for:
As a Senior Business Intelligence Developer at 2U, you will have the opportunity to use all of the skills that you've developed over your career in building complex software systems. Being the supporting infrastructure behind some of the most prestigious universities requires careful market analysis and a constant assessment of our student?s learning experience. This requires powerful analytical systems, and will you have the opportunity to help build them from the ground up using Amazon Redshift, Tableau, and Python.
Key responsibilities include but are not limited to:
Perform source system analysis, requirements gathering with customers, and data modeling for data marts in Redshift, including preparing comprehensive source to target mapping documents with transformation rules.
Work with the technology team to establish and support a data governance process for 2U?s multiple source systems
Build and maintain data flow/ETL systems that migrate data from Salesforce, cloud based marketing systems, and traditional transactional systems, into Amazon Redshift clusters using SQL and open source technologies
Things that should be in your background:
Deep understanding of relational databases, especially PgSQL, although working experience with other SQL database systems is sufficient
Familiarity/experience with traditional ETL systems such as Informatica, SSIS, Kettle, and/or experience using cloud based systems such as SnapLogic or Informatica Cloud. At a minimum you should know what the tools do and why you would use them
Familiarity/experience with dimensional data modeling and experience constructing 3rd normal form data models. Knowledge of data warehousing theory, especially Kimball?s contributions, is helpful here
Working with customers to analyze needs and turn them into clear and effective requirements
Solid written and verbal communication skills, and not letting ego get in the way of discussing solutions and helping others
Software development experience with at least one programming language, e.g. Python
Experience working in a security-focused environment
Other attributes that will help you in this role:
Experience working with BI and visualization tools such as Tableau, OBIEE, and report creation environments such as Jaspersoft and SSRS
Experience using HTTP API clients (SOAP, REST) in scripting language environment to extract data from products such as Salesforce.com, Facebook, Mixpanel, Google AdWords, or Bing Ads
Loves futzing with data and dreams of becoming a data scientist some day
Enjoys working with open source tools and has fun developing software on Linux systems
Knowledge of R and/or Python based data programming skills is a definite plus
You can provide publicly accessible work examples via GitHub, Launchpad, or Bitbucket
You have an active StackExchange profile that you can share
Founded in 2008 by a unique team of education veterans with unparalleled experience, 2U Inc. partners with preeminent institutions of higher education to deliver rigorous, selective degree programs online to students globally.
2U supplies universities with the tools, expertise, capital, and global recruiting needed to build and support programs of quality and scale.
Technology: 2U develops state-of-the-art technology platforms that give universities the ability to deliver traditional offline curricula in a unique online learning environment.
Instructional Design: Our instructional designers work closely with faculty to translate classroom courses into a compelling combination of synchronous and asynchronous online and real-world experiences, using the best educational and social technologies available. We work side-by-side with professors to evolve those courses. We make improvements as usage and learning patterns emerge and new technologies become available.
Infrastructure: 2U provides the support infrastructure and the logistical components of our partners? online programs. This includes comprehensive student support services from enrollment through graduation and beyond, as well as practical learning experiences in communities around the world.
Resources: 2U makes an upfront investment of over $10 million in each of our partner programs. By supplying capital and global marketing capabilities, we enable universities to give high-performing students around the world a transformational educational experience.
Since our founding, 2U has partnered with some of the most prestigious research universities to deliver groundbreaking online degree programs. You can read about our partners here (www.2U.com/partners).
||New York, NY |
THIS JOB HAS EXPIRED