Analytics Engineers
6 months contract or contract to hire
Remote Work
Submit US Citizens/GC Holders
This person must have Tableau, Snowflake, Python, and SQL.
Their company helps students find jobs.
The BI team works across all functions of the company. They use Salesforce for all of the data across the board. This is transactional data that uses data for end to end data models and pipelines.
They are a Tableau shop. So someone who really knows end to end.
Their data pipeline tool is 5 trend? Snowflake data warehousing is what they’re using. Not only do the the BI work and analytics, but also the administration. People who need to know SQL. Wants people to know Tableau and data connection. Very aware of the data admin.
Two roles are a bit more junior, but these are 2 roles that are pretty senior.
Snowflake is new in their environment and it’s not a requirement, just need someone who knows the general data warehousing.
Tableau is absolutely necessary for this. Create a dashboard, take requirement changes and publish it all out.
The Lead is the most important part of the team. They are looking at contract to hire because it is very urgent right now. She did say that contract could be more important.
She is working with multiple vendors and their internal team.
Their interview process is very long typically, she said 6-8 weeks in Europe. Mentioned about 3-4 interviews.
Contract really is the ideal way because the interview process only has to be Anita and Gary.
They haven’t had found strong technical interviews with the candidates. SQL, Data Modeling and Tableau. It only has been a couple of weeks.
Remote is fine for these roles. They do prefer people in states where they have offices.
The pay bands I told them are way too low. I did tell them about that, and got a decent amount of push back.
They have a lot of perks and benefits.
Talked a bit about hourly rates for contractors. Really want to find people that are willing to stay.
Visa is not ideal for them. Last case scenario if at all.
Gary did say 80-90 per hour as the bill rate for these candidates. Really find intangibles, love diversity in the hires.
KEY RESPONSIBILITIES:
This individual’s core responsibilities will be to partner and solution across the enterprise to strategize, design, and produce sophisticated analytical insight that will drive data-driven decision-making across multiple levels of leadership, including senior leadership. This will primarily be executed using database software, with a strong emphasis on SQL and data warehousing. Projects the Senior Analytics Engineer will work on include:
• Extractions and feeds from other systems or services
• Data modeling, processing and warehousing
• Advanced analytics
• Visualization and reporting (alone or in collaboration with Analytics Engineer)
• Reviewing code and supporting the development of other Year Up Analytics Engineers
• Training, support and consulting in a leadership capacity (business-facing engagements)
Further responsibilities will include:
• Data Engineering
• Data Modeling
• Data Analysis
• Business Analysis
• Process automation
• Ad hoc research and analysis
• Data quality investigations
• Maintenance and technical support for existing business intelligence tools and systems
Additionally, there may be a long-term opportunity for:
• Project Management
Data Governance and Master Data Management (MDM)
QUALIFICATIONS:
• Minimum of 3-5 years of experience in Business Intelligence
• Strong SQL proficiency
• Python proficiency
• Demonstrated experience building reliable and resilient data pipelines
• Experience with data visualization, whether using Excel software such as Tableau, Power BI, Looker, etc., or a graphical programming language like D3.js
• Experience with git and knowledge of CICD best practices
• Demonstrated experience with strategic and complex quantitative analysis
• Demonstrated expertise influencing enterprise functions with measurable business outcomes
• Experience working on an agile team
• A proven record of creative problem solving
o Experience framing, investigating and resolving ambiguous problems will be particularly valuable
• Adaptability and learning agility
o The ideal candidate will be comfortable operating in an environment with rapidly shifting priorities, and will be capable of contributing proactively in new and unfamiliar contexts
• A passion for working with young adults, an unshakable belief in their potential, and a strong commitment to the mission of Year Up
• Understanding of the Opportunity Divide and its drivers
• Commitment to diversity and inclusion
Candidates with one or more of the following will be particularly competitive:
• Professional experience working in a related field, especially in IT or Education
• Familiarity with Salesforce, Netsuite, Workday
• Experience with any of the following: dbt, Snowflake, Fivetran, Tableau, AWS
• Experience with orchestration tools such as Airflow or Prefect
• Knowledge of statistics/machine learning and experience delivering this functionality in a production environment
• Data engineering experience