Job Description:Role Overview: This role is a technical hybrid of Data Analytics and Workforce Intelligence. You will design and maintain automated ETL pipelines in Google BigQuery, build forecasting and capacity models using SQL, Python, or R, and deliver executive-ready Tableau dashboards to optimize company-wide staffing and workflow efficiency.
Key Responsibilities- Forecasting & Capacity Modeling: Build, deploy, and maintain predictive models for workflow and workforce capacity planning based on historical data and business drivers.
- Data Engineering & ETL: Develop and manage automated ETL pipelines, validation checks, and error handling to ensure data reliability within Google BigQuery.
- Advanced Querying & Analytics: Write and optimize complex SQL queries alongside Python or R scripts for large-scale data cleaning, statistical analysis, and task automation.
- BI & Visualization: Design and build interactive Tableau and Excel dashboards to deliver actionable insights to cross-functional stakeholders.
- Project Management: Gather business requirements, manage project lifecycles under tight deadlines, and maintain thorough technical documentation.
Job Qualifications:Qualifications- Education: Bachelor's degree in Computer Science, Mathematics, Statistics, Data Science, or a related quantitative field.
- Experience: 5+ years of directly related analytical experience.
- Core Tech Stack: Expert-level SQL, Python or R (for predictive analytics), and Google BigQuery (or equivalent cloud data warehouses).
- BI & Scripting: Strong proficiency in Tableau and scripting languages (e.g., Python, PowerShell) for workflow automation.
- Domain Expertise: Strong knowledge of statistical forecasting models and workforce capacity planning techniques.
- Soft Skills: Proven cross-functional collaboration, project monitoring, and communication skills.
Annual Pay Range:77,700 - 100,000 USD
Application Window:This opportunity is expected to remain posted through the date identified below, subject to business needs.
Thrive with CotalityAt Cotality, we offer more than just a job, we provide a benefits experience designed to support your whole self. From a flexible working model to competitive time off and standout health coverage with meaningful perks and growth opportunities, our package is built to help you thrive at work and in life.
Highlights, depending on role classification, include:
- Time off: Generous PTO and 11 paid holidays, plus well-being and volunteer time off.
- Family Support: Up to 16 weeks of fully paid parental leave and a baby stipend.
- Health: Multiple medical plan options with mental health and wellness support offerings.
- Retirement: 401(k) with company match and vesting after one year.
- Financial Perks: $400 annual well-being stipend and tuition assistance up to $5,250.
- Extras: Recognition Rewards, Referral bonuses, exclusive discounts and more!
Please note, Qualifications, locations and experience of the individual ultimately selected for the position may impact the final actual offered compensation, which may vary from the posted range
