BI Developer

Location: Medellin, Antioquia, Colombia | Department: Technology, BI Analytics & Reporting | Type: Full Time | Min. Experience: Experienced

At SproutLoud our people and culture are central to our incredible growth. Perhaps that is why in 2016 SproutLoud was ranked one of the "50 Innovative Companies to Watch," by Silicon Review. In 2015, We were named among the "50 Most Promising Google Technology Solution Providers" in the country by CIO Review, and among the "Top 10 Marketing Automation Solution Providers" nationwide by Marketing Tech Insights. SproutLoud has also been recognized as one of the fastest-growing American technology companies by Deloitte in 2012 and 2011, by Inc. 5000 in 2012 and 2011, by Inc. 500 in 2010. And in 2016, for the sixth time since 2009, the South Florida Business Journal ranked SproutLoud among "Fastest-Growing Technology Companies. Come grow with SproutLoud. 

Overview:

The BI Developer is an integral member of the BI Analytics & Reporting team, which is responsible for analyzing millions of marketing-related records. The BI Analytics & Reporting team works with data partners on mission critical projects to provide the best analytics to brands we serve. 

As a member of our BI Analytics & Reporting team, the BI Developer is responsible for the design, development, implementation, and support of mission-critical ETL processes utilizing the Pentaho PDI (Kettle) platform. He/she imports data from disparate sources such as Postgres, MongoDB, or flat files, transforming it to conform to our EDW standards and then loading it into our EDW.  He/she also enables our BI Analytics & Reporting team to develop mission critical BI reports, dashboards, and data extracts using LogiAnalytics or SQL queries.

Working with cross-functional teams, system architects, stakeholders and partners, the BI Developer participates in gathering and documenting reporting requirements to meet business needs of internal and external clients. He/she uses key skills and experience to take the business requirements and design, develop, test and implement frameworks and ETL processes that work with the underlying data sources and destinations. 

This role is the go-to-person for any questions related to Pentaho and LogiAnalytics, regarding its administration and development - and coaches other team members on the framework, standardization of the processes, and best practices.

Responsibilities:

  • Serve as a member of the BI Analytics & Reporting team involved in analysis, design, implementation, and support of SproutLoud’s reporting and analytics solutions
  • Apply strong analytical and project management skills, including a thorough understanding of how to interpret customer business needs and translate them into operational requirements
  • Acquire data from primary or secondary data sources and maintain databases/data systems
  • Collaborate with developers and subject matter experts to establish the technical vision and analyze tradeoffs between usability and performance needs
  • Build reports, dashboards, and other data tools that enable self-service for business users
  • Develop ETL processes to ensure automated data flow from back-end systems to front-end visualizations
  • Lead data-modeling efforts around SproutLoud’s data warehouse databases
  • Participate in testing of products and processes to identify requirements defects, to meet standards, and to ensure effectiveness
  • Show a keen eye for detail and adhere to deadlines within a fast paced environment
  • Work in an agile team environment
  • Work in a continuous integration environment
  • Train, coach and advise other team members about ETL processes, ETL frameworks, EDW standards, and analytics best practices
  • Make key decisions and judgments on own

Requirements:

  • BA/BS in information systems, statistics, math, economics or equivalent
  • Strong knowledge of and experience with reporting packages (Business Objects etc), databases (SQL etc), programming (ETL frameworks)
  • 3+ years SQL and PL/SQL Development Experience
  • 3+ years of experience modeling schemas for data warehouse
  • 3+ years working with high-volume OLTP systems
  • Experience with SQL Query tuning
  • Experience with ETL processes
  • Experience developing key metrics, reports and dashboards
  • Technical expertise regarding data models, database design development, data mining and segmentation techniques
  • Good oral and written communication skills

Not required, but would be a plus:

  • Experience with Pentaho PDI (Kettle)
  • Experience with LogiAnalytics or any other analytics platform
  • Experience with PostgreSQL
  • Knowledge of statistical programming and statistical methods to analyse data
  • Experience with big data and map-reduce technologies
  • Experience within Unix/Linux environments
  • Experience with Version Control Systems
  • Experience some Perl or Shell scripting

We are building the best local marketing platform and service offering around - and we need a great team to help us execute.

Having a career at SproutLoud means you are on a team that helps each other win. You will be in an environment that is 100% jerk-free, and share values with others who are accountable, care, inspire, elevate and grow.

At SproutLoud, we continue to cultivate an environment that aspires to be one of the best places to work - period. SproutLoud pays the majority of cost for some benefit programs with our team members. Programs include health-care coverage, flexible schedules, professional development programs, paid transportation and parking, forward vacation time. We also have fun along the way - gym membership right next door, breakfast Fridays, BBQ/Picnic Summers, Happy Hours, etc.

Come Join Us!

Apply for this position

* Required fields
First name*
Last name*
Email address*
Phone number*
Resume*

Attach resume as .pdf, .doc, or .docx (limit 2MB) or paste resume

Paste your resume here or attach resume file

Cover Letter*
In 150 characters or fewer, tell us what makes you unique. Try to be creative and say something that will catch our eye!*