Responsible for consulting with clients, developing analytics solutions, and creating dashboards using SQL and Power BI to improve operational efficiency and decision-making.
Our team is looking for a Senior Technical Consultant with expertise in data analytics, Power BI, and SQL to join our customer-facing consulting team. You’ll work with clients to turn ERP data into actionable insights via dashboards and reports that drive project success, operational efficiency, and strategic planning. This role blends technical problem-solving with consultative interaction. You'll be the bridge between raw project/financial data and the business decisions our firms rely on to manage risk, allocate resources, and drive profitability.
What You’ll Do
- Collaborate with stakeholders to understand reporting needs and translate them into robust technical solutions
- Partner directly with clients to assess reporting needs and deliver analytics solutions using Power BI and SQL
- Design and build custom dashboards and interactive reports tailored to project-centric operations, including time tracking, WIP, labor cost analysis, and resource utilization
- Develop performant SQL queries/views and data pipelines pulling from our data lake
- Interpret and model complex ERP data structures common in AEC workflows (e.g., timesheets, subcontracts, project financials)
- Serve as the analytics subject matter expert in cross-functional project teams involving implementation, integration, and transformation efforts
Your First 90 Days
In your first 30 days, you will become familiar with our solutions, the industries we serve, and our customer first approach. You will immerse yourself in our company-wide onboarding while partnering closely with internal teams to learn more about your role and projects. As your familiarity with our team, operations, and data structures grow, so too will your impact and influence.
In your first 60 days, you will begin collaborating with customers to assess their needs and develop analytics solutions that address real, quantifiable business challenges. You will help design and build dashboards and reports tailored to project-centric operations, along with contributing as the subject matter expert to deliver impact solutions.
In your first 90 days, your efforts and successes will allow you to deliver actionable insights to drive project success, operational efficiency, and strategic planning for your customers. By building strong relationships with stakeholders and delivering high-quality solutions, you will help unlock and deliver value to our growing customer base.
Who You Are
- 5+ years of SQL experience, ideally working with ERP or financial/project management systems
- 3+ years building Power BI dashboards, with strong skills in DAX and Power Query
- Demonstrated success consulting with external clients, ideally in a SaaS or implementation context
- Strong communicator—capable of simplifying complex data problems for non-technical audiences
- Comfortable juggling multiple client engagements and working independently when needed
- Strong knowledge of data visualization principles and ability to represent data clearly and concisely
- Ability to understand ERP data structures and map business processes to reporting needs
- Bachelor’s degree in Computer Science, Information Systems, Engineering, or related field
Your Differentiators
- Exposure to AEC ERP platforms (e.g., Deltek, BST, CMiC, Unanet, Viewpoint, Procore)
- Understanding of AEC-specific concepts like labor cost vs. effort, project cost accounting, contract/billing types, and work-in-progress (WIP) metrics
- Experience extracting insights from project lifecycle data (e.g., time entry, procurement, invoicing, forecasting)
Our Values
- We are a Team. Employees, customers, and partners working together.
- We are Customer-Focused. Customers are the heart of everything we do.
- We are Driven. Seeking exceptional outcomes.
- We Own our Success. Every employee has a stake in our company.
- We do the right thing and have fun in the process.
The salary range for this opportunity is $100,000 - $121,900 per year. You will be eligible for employee equity as well as discretionary bonus compensation, subject to plans that may be in effect from time to time. You will further be eligible to participate in Unanet's employee benefits plans and programs. For more details on Unanet's benefits offerings, please visit https://unanet.com/employee-benefits.
Unanet is proud to be an Equal Opportunity Employer. Applicants will be considered for positions without regard to race, religion, sex, national origin, age, disability, veteran status or any other consideration made unlawful by applicable federal, state or local laws.
Top Skills
Dax
Power BI
Power Query
SQL
Similar Jobs at Unanet
Enterprise Web • Fintech • Marketing Tech • Software
The Marketing Operations Manager oversees daily marketing operations, optimizes processes, manages campaigns, leads the team, and collaborates cross-functionally.
Top Skills:
HubspotMarketing AutomationSalesforce
Enterprise Web • Fintech • Marketing Tech • Software
The Principal Customer Solutions Engineer ensures customers achieve desired outcomes with Unanet's products, providing technical support, demos, and building relationships to drive customer retention and success.
Top Skills:
ChurnzeroGainsightSalesforceUnanet
Enterprise Web • Fintech • Marketing Tech • Software
The Enterprise Account Executive is responsible for managing the sales cycle, prospecting, demonstrating solutions to customers, and exceeding sales goals.
Top Skills:
Salesforce.Com (Sfdc)
What you need to know about the Seattle Tech Scene
Home to tech titans like Microsoft and Amazon, Seattle punches far above its weight in innovation. But its surrounding mountains, sprinkled with world-famous hiking trails and climbing routes, make the city a destination for outdoorsy types as well. Established as a logging town before shifting to shipbuilding and logistics, the Emerald City is now known for its contributions to aerospace, software, biotech and cloud computing. And its status as a thriving tech ecosystem is attracting out-of-town companies looking to establish new tech and engineering hubs.
Key Facts About Seattle Tech
- Number of Tech Workers: 287,000; 13% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Amazon, Microsoft, Meta, Google
- Key Industries: Artificial intelligence, cloud computing, software, biotechnology, game development
- Funding Landscape: $3.1 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Madrona, Fuse, Tola, Maveron
- Research Centers and Universities: University of Washington, Seattle University, Seattle Pacific University, Allen Institute for Brain Science, Bill & Melinda Gates Foundation, Seattle Children’s Research Institute
