Senior Data Engineer
Posted on 11/20/2022
San Francisco, CA, USA
- Bachelor's degree or equivalent experience required
Management Consulting has been the foundation of Point B’s employee-owned company for 25+ years. Our collaborative, forward looking leadership approach ensures our customers are on the right path to success.
Point B is a consulting company dedicated to helping organizations with critical initiatives in the areas of customer engagement, growth investments, workforce experience and operations excellence. Our diverse set of experts spans 13 U.S. locations, with international reach via our partnership with Nextcontinent. We’ve helped global organizations of all stages and sizes achieve sustainable success by focusing on the humans at the center of change.
Point B has been consistently recognized as one of the best places to work by Fortune® magazine, The Wall Street Journal, Consulting® magazine, Vault.com® and many others.
Firmwide Operations at Point B delivers internal and external results through leadership, process, people, and technology while supporting employees in delivering their best for our customers.
Our operations team includes roles focused on People & Culture, Executive Talent, Risk & Legal, Finance, Travel & Events, Communications & Change Management, IT & Facilities, and Marketing. Working across these disciplines we create the foundation from which Point Bers discover and grow their careers.
The Senior Data Engineer, IT creates and manages structures and analytic solutions that turn data into insights. Priorities in this role include designing, developing, and maintaining data solutions, crafting and executing queries, and presenting information in reports and dashboards. The Senior Data Engineer, IT supports business intelligence efforts by leading and mentoring the team in Data Warehouse schema development, ETL, SQL, optimization, testing, Agile/Scrum activities, visualization, automation, and leading build projects.
WHAT YOU’LL GET TO DO:
Collaborates with Product Owner to ensure clarity of business requirements
Clarifies business requirements for team members
Translates business requirements into technical implementation
Develops data warehouse schema by profiling data, updating modeling star schema, and mapping data sources to star schema
Creates ETL processes and troubleshoot ETL failures
Performs SQL coding, performance tuning, and query optimization
First point of contact for SQL engine and setup
Unit tests own code, tests/validates others’ code, performs integrative testing
Participates as team member and leader in Agile/Scrum team
Effectively uses and manages Atlassian/JIRA for projects
Leads projects and manages project team members
Identifies and fixes bugs
Creates, modifies, and optimizes reports and dashboards using Tableau and Salesforce
Monitors and resolves system performance
Develops ad hoc queries as requested to support business customers
Responds to and supports business partners through ticketing system and office hours
Supports team efforts and builds authentic relationships with individuals in work groups and teams
Actively mentors other team members
Consistently demonstrates and lives Point B cultural tenets and values
Participates in firm culture activities to connect regularly with other Point B’ers (e.g., FW Ops Meetings, Geo Meetings)
WHAT WE OFFER:
The opportunity to affect the learning approach for our firm’s future
The chance to impact the journey of our employees’ growth and development
An environment that encourages you to identify new opportunities and the support to make it happen
The opportunity to build and be part of a fun and collaborative culture with teams that are as passionate about their communities as they are about their work
WHAT WE EXPECT YOU’VE ALREADY DONE:
Bachelor’s degree or equivalent experience required
High level of project organization, attention to detail, and time management
Ability to translate business requirements into technical implementation
Experience working with third party vendor resources
Ability to multi-task and react positively to frequent changes in priorities, focusing on outcomes
Strong oral and written communication skills
Demonstrated ability to work effectively in good coordination with matrixed teams and manager, including internal, external, and remote staff
Demonstrated problem-solving and critical thinking skills
Excellent interpersonal skills, characterized by presence, respect for others, good listening skills, clear writing and thinking skills and ability to think on his/her feet
Drives for optimal solutions that are simple and add value; prevents unsustainable complexity
Ability to anticipate, recognize, and respond to stakeholder needs and requests
Possesses executive presence
10+ years relevant experience suggested; prioritizing agility and depth of technical knowledge (vs specific number of years)
THE KIND OF PEOPLE WE LOOK FOR:
Innate problem solvers who want to grow in a flexible, collaborative culture
Engaging leaders who make a positive impact on their firm, clients, and communities
Versatile people who thrive on variety and challenge
Successful in ambiguous environments
Desire to and ability to learn
Passion for Point B’s Mission, Vision, Values & Culture
Gets it done brand and attitude
Ability to work from home
Ability to work non-standard work hours when necessary
YOUR OFFICE HOME BASE:
COMPENSATION AND BENEFITS:
The estimated salary range for this role is $113,000 - $187,000 USD per year. This salary range is provided as required by local and state law as applicable. Individual salaries vary on a number of factors including but not limited to geography, skills, education, experience and unique qualifications where applicable.
Bonuses are awarded at Point B’s discretion and are based upon individual contributions and overall firm performance.
INTRIGUED TO LEARN MORE?
When you apply for this role, your information will be personally reviewed by our talent acquisition team (not by a robot). You can expect to hear back from us with feedback if we think there could be a fit and what next steps look like.
WHAT MAKES POING B DIFFERENT?
Our Founding Purpose and Values of our firm. Be part of a fun and collaborative culture with teams that are as passionate about their communities as they are about their clients
Employee Ownership – Giving you a voice in directing your career and building our firm
Benefits – Our comprehensive package includes competitive base pay and an annual bonus, complete health benefits including an option for 100% employer paid premium for medical, vision and dental coverage for employees, ownership shares through our ESOP, self-directed time off and more
Work-Life Balance – A unique culture that recognizes the importance of flexibility and collaboration. Our local and national model empowers you to choose the life you want
Award winning – We are proud to be named a Best Workplace in the US by Fortune magazine, Best Workplaces for Millennials, and Best Workplaces for Women. Hear more about why people love working at Point B on GlassDoor
We are an equal opportunity employer committed to a diverse workforce. We do not discriminate on the basis of race, religion, color, national origin, gender, gender identity, sexual orientation, age, marital status, veteran status or disability. You can read more about our commitment to diversity on our Careers Website.
Point B is committed to providing equal opportunities for persons with disabilities or religious observances, which includes providing reasonable accommodation for in any individuals with disabilities or for religious purposes. Applicants with disabilities may contact our Accommodations team at [email protected] or 206-517-5000 to request and arrange for accommodations through the application and/or recruiting process. If you need assistance to accommodate a disability or religious observance, you may request an accommodation at any time. Please note: This mailbox is only for accommodation requests or questions. Please use the Contact Us form for any recruiting inquires.
Legal Information for Job Seekers can be accessed on our Careers Website.
Pursuant to the San Francisco Fair Chance Ordinance, we will consider for employment qualified applicants with arrest and conviction records.
Management consulting and venture investment
Point B's mission is to build an enduring firm for the benefit of our people by creating value in diverse ways and putting others first.
- Employee ownership through ESOP
- Competitive pay & annual bonus
- Comprehensive health benefits
- Flexible wellness stipend
- Paid parental leave
- Unlimited vacation
- Flexible leave of absence
- Community leadership support
- Social & community events
- Professional development stipend
- Financial planning & 401(k)
- Life & disability
- Technology stipend
Company Core Values