Lead Business Intelligence Developer at Guild Education

| Greater Denver Area
Sorry, this job was removed at 5:41 a.m. (MST) on Wednesday, September 30, 2020
Find out who's hiring in Colorado.
See all Data + Analytics jobs in Colorado
Apply now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.

Guild is hiring a Lead Business Intelligence (BI) Developer. This role is responsible for the development, implementation, production support, and performance tuning of the underlying systems and reporting infrastructure for the data warehouse and data mart reporting environments. They design and implement reporting architecture solutions including the design of table structures, and the optimization of ETL processes and queries used to populate those structures with data from internal and external sources. This role will be a great fit for you if you have a strong understanding and passion for reporting infrastructure, table architecture, efficient ETL data pipelines, and scaling best practices.

As Lead BI Developer, you will:

  • Manage and lead key initiatives and large projects  (e.g. building a clean data set for data science, onboarding a new partner, or Next Chapter)
  • Build and define new reporting infrastructure based on needs of the business
  • Work closely with product, engineering, and analytics teams to scale reporting architecture and the ETL pipeline based on source of truth tables and events from the event bus
  • Partnering with tech leaders to shape decisions around scalable solutions for data storage and processing for reporting purposes
  • Find creative solutions to maximize system efficiencies (e.g. use a scripting language to automate a manual process)
  • Manage and support reporting infrastructure tools (e.g. Airflow, Snowflake, DBT, Looker)
  • Support monitoring, alerting, and anomaly detection efforts to measure performance, accuracy, and usage of data and reports
  • Support and mentor team members by sharing technical knowledge and to help troubleshoot issues that arise and technical skills to be learned
  • Solidify documentation for key systems

You are a strong fit for this role if you have:

Required Competencies

  • Experience in business intelligence, infrastructure, data engineering, analytics or a related technical role in a fast-paced business or start up environment
  • Experience building data pipelines, custom ETL processes, data warehouses, and table architecture
  • Expertise in database technologies such as Redshift, Snowflake, PostgreSQL, and working with large sets of data
  • Experience with BI tools such as Looker, Tableau, Power BI etc..
  • Ability to communicate well in person, on paper, and in code. You can explain technical concepts to product managers, engineers, analysts and stakeholders
  • Team player mindset, with strong interpersonal and influencing skills
  • Passion for our mission – Guild is pioneering a new path for education as a benefit in a complicated and regulated space – success means quickly and effectively adapting your expertise

Preferred Competencies

  • Experience automating processes using scripting languages such as Python
  • Experience with modern source control (Git / Github) practices
  • Demonstrated curiosity and interest in keeping up and experimenting with new technologies
  • Something else? Wonderful, we're curious to learn more about you!

About Guild:

Guild is increasing economic mobility for working adults by partnering with the largest employers in the country to offer education as a benefit to their employees via our marketplace of nonprofit universities and education institutions. Guild’s proprietary technology platform facilitates the administration of this innovative benefit and our team of coaches helps each employee navigate the path back to school, providing individualized support from day one through program completion. 

We also just became the latest female-led company to hit a $1billion valuation and the only B-corp with those qualifications.  Our Series D round was led by Ken Chenault, General Catalyst Partners chairman and former CEO of AMEX, and joined by Emerson Collective, LeadEdge Capital, and Iconiq. 

Guild Education is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees.

Read Full Job Description
Apply now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.

Technology we use

  • Engineering
  • Product
  • Sales & Marketing
    • JavaLanguages
    • JavascriptLanguages
    • PythonLanguages
    • RubyLanguages
    • ScalaLanguages
    • SqlLanguages
    • TypescriptLanguages
    • serverlessLanguages
    • GraphQLLanguages
    • SalesforceLanguages
    • LambdaLanguages
    • GraphQLLanguages
    • KinesisLanguages
    • API GatewayLanguages
    • AppSyncLanguages
    • S3Languages
    • CodeDeployLanguages
    • TerraformLanguages
    • CloudformationLanguages
    • EMRLanguages
    • RedshiftLanguages
    • JenkinsLanguages
    • AnsibleLanguages
    • VagrantLanguages
    • RedisLanguages
    • MetabaseLanguages
    • ReactLibraries
    • Node.jsFrameworks
    • Ruby on RailsFrameworks
    • SparkFrameworks
    • HerokuFrameworks
    • CypressFrameworks
    • AWSFrameworks
    • CircleCIFrameworks
    • Auth0Frameworks
    • PostgreSQLDatabases
    • Google AnalyticsAnalytics
    • LookerAnalytics
    • SegmentAnalytics
    • HeapAnalytics
    • IllustratorDesign
    • InVisionDesign
    • SketchDesign
    • ConfluenceManagement
    • TrelloManagement
    • ClubhouseManagement
    • Google DocsManagement
    • AirtableManagement
    • MiroManagement
    • SalesforceCRM
    • LookerCRM
    • SendGridEmail
    • MarketoLead Gen

Location

370 17th St., Suite 3600, Denver, CO 80202

An Insider's view of Guild Education

What’s the vibe like in the office?

We're fast-paced and got a little bit of a startup vibe, so there's always plenty to learn from and grow!People are collaborative and ready to bring their knowledge, experience, and ideas to the table to make sure we're doing right by each other and our students.As hard-working as everyone is, you can also be rest assured we also love to celebrate!

Kendry

Bilingual Student Success Advisor

How do you collaborate with other teams in the company?

We're incredibly cross functional and believe heavily in developing and cultivating strong relationships not only with our external partners, but internally across and within departments as well. One of my favorite traditions is that each new hire at Guild is given a coffee card when they start to encourage them to grab coffee with others and get t

Annie

Partner Marketing, Employer Success

How has your career grown since starting at the company?

Since my humble beginning as a Guild Intern, I have had opportunities afforded to me that stretch me in ways that align with my values and push me to be a little uncomfortable while still having welcome support. I’m now in a position where I get to learn first-hand from experts that I don’t believe I was qualified for before working at Guild.

Paco

Senior Associate of University Operations

What kinds of technical challenges do you and your team face?

My team works on ensuring that new users can find what they need and engage with our platform easily. Many of the technical challenges we face involve scaling the early-stage version of Guild’s app into something more flexible for our next growth phase. We deal with the difficult (but fascinating!) tradeoffs of these decisions every day.

April

Software Engineer

What are Guild Education Perks + Benefits

Guild Education Benefits Overview

At Guild, we’re expanding opportunity for America’s workforce, and we’re committed to doing the same for our own employees by supporting them professionally and personally. Guild offers benefits and perks to support all employees and their families. From $0 medical premiums to a flexible parental leave policy to tuition assistance to company equity for all employees, we have something for everyone at Guild.

Culture
Volunteer in local community
Guild has a yearly "Guild Gives Back" day, where we provide organized volunteer opportunities to all our employees as well as a "12 Days of Giving" around the holidays!
Friends outside of work
Eat lunch together
Intracompany committees
Daily stand up
Open door policy
Team owned deliverables
Team based strategic planning
Group brainstorming sessions
Pair programming
Open office floor plan
Diversity
Documented equal pay policy
Dedicated Diversity/Inclusion Staff
Highly diverse management team
Guild has a highly diverse management team, with nearly 75% of employees reporting to female leadership.
Unconscious bias training
Health Insurance & Wellness Benefits
Flexible Spending Account (FSA)
Disability Insurance
Dental Benefits
Vision Benefits
Health Insurance Benefits
Life Insurance
Wellness Programs
Onsite Gym
Retirement & Stock Options Benefits
401(K)
Company Equity
Child Care & Parental Leave Benefits
Generous Parental Leave
Vacation & Time Off Benefits
Unlimited Vacation Policy
Generous PTO
Paid Holidays
Paid Sick Days
Perks & Discounts
Casual Dress
Commuter Benefits
Some Meals Provided
Happy Hours
Relocation Assistance
Fitness Subsidies
Professional Development Benefits
Job Training & Conferences
Tuition Reimbursement
Diversity Program
Lunch and learns
Cross functional training encouraged
Promote from within
Continuing Education stipend
More Jobs at Guild Education40 open jobs
All Jobs
Finance
Data + Analytics
Dev + Engineer
HR
Marketing
Operations
Product
Project Mgmt
Sales
Content
Data + Analytics
new
Denver
Finance
new
Denver
Operations
new
Denver
Data + Analytics
new
Denver
Project Mgmt
new
Denver
Marketing
new
Denver
Developer
new
Denver
Operations
new
Denver
Project Mgmt
new
Denver
Developer
new
Denver
Developer
new
Denver
Developer
new
Denver
Data + Analytics
new
Denver
Operations
new
Denver
Operations
new
Denver
Developer
new
Denver
Operations
new
Denver
Developer
new
Denver
Operations
new
Denver
Developer
new
Denver
Developer
new
Denver
Apply now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.
Save jobView Guild Education's full profileSee more Guild Education jobs