About TRANSFORM

Transform, Inc. delivers the first machine-learning and AI platform for video that answers the fundamental questions of why audiences connect, react and engage. Our innovative software analyzes the creative essence of video, allowing companies to see direct connections between their content and viewer behaviors. Transform’s technology can be tailored for any video content -- TV shows, trailers, local newscasts, consumer and retail ads -- providing actionable insights that help increase viewing, subscriptions and purchases.

ABOUT THE BI DEVELOPER ROLE

The BI Developer will be a team member in our engineering group building analytical products. You will be developing using the best-of-breed technologies, work with seasoned team members and stretch your talents into new areas of data science.

The ideal candidate will display strong experience in working with both transactional databases as well as data warehouses; building data pipelines; transforming and conforming data; and building reports.  The individual should love working with data and able to work well individually in structured and ambiguous environments as well as be part of a collaborative team working on a rich variety of projects. Must be comfortable in communicating with business as well as customers when required.  

Responsibilities:

  • Create scalable and fault-tolerant data pipelines with complex transformations

  • Able to navigate in an IT environment to access data from databases, files servers and other environments

  • Work with various data source file formats  

  • Ensure data security to meet privacy requirements

  • Develop in Python or Scala

  • Develop in SQL using complex CTEs and Window Functions

  • Build high volume data pipelines (Full and Incremental Pulls)

  • Build data quality processes and reporting

  • Design and performance tune analytical dashboards

  • Develop fact and dimension schemas

  • Design and develop analytical dashboards

  • Build data quality and system monitoring dashboards

  • Select the appropriate visualization method for a given report

  • Work with data scientists and other BI developers

About You

Minimum Qualifications:

  • 3 years experience developing and productionalizing BI data solutions

  • Understanding of Ralph Kimball Methodology for building Warehouses and Pipelines

  • Bachelor’s Degree in Information Technology, Computer Science or equivalent experience

  • Experience with one or more databases (Snowflake, SQL Server, Oracle, Teradata, My SQL, or Ingres)  

  • Heavy Experience in SQL

  • Experience in Python, Scala

  • Experience with and designing solutions for columnar warehouses

  • Experience working with large amounts of data

  • Experience working with AWS EC2 and S3 features or Azure equivalent



    Email our team at careers@transform.digital