What are the responsibilities and job description for the Data Scientist (Power BI) position at KPG99 INC?
Title: Data Scientist (Power BI)
Location: Northborough, Ma – Hybrid
Duration: 6 months Contract.
Interview Mode : Phone Video
Job Description:
Data Science Contractor with a strong data development/engineering and data modeling focus to support the development of a scalable data foundation for reporting, analytics, and future AI initiatives. As part of the transition to a new incident management system, this role will build and maintain the upstream data structures needed to enable reliable, efficient, and scalable analytics while aligning with future enterprise data platform plans.
Required Skills & Experience
- Bachelor’s degree in a quantitative field (e.g., Computer Science, Data Science, Information Systems, Engineering) with 4–6 years of hands‑on experience
- Experience supporting Power BI or similar BI tools, including building models optimized for reporting performance
- Understanding of predictive analytics concepts and experience designing data structures that support forecasting, trend analysis, and machine learning workloads
- Strong proficiency in SQL, including writing complex queries and designing relational schemas
- Proven experience designing and maintaining relational databases or analytical data warehouses
- Hands-on experience with database definition and manipulation languages (DDL and DML) to create, modify, and maintain tables and structures
- Experience building and managing data pipelines using APIs, including incremental data loading
- Proficiency in Python or a similar language for data ingestion, transformation, and automation
- Solid understanding of ETL/ELT concepts and managing data transformations upstream of reporting tools
- Experience handling semi-structured data (e.g., JSON) and managing schema evolution
- Understanding of data architecture principles, including designing data solutions with future scalability and platform migration in mind
Preferred Qualifications
- Experience working with SaaS platforms and API based data sources
- Exposure to modern data transformation or modeling frameworks (e.g., dbt or similar approaches)
- Familiarity with database performance optimization concepts such as indexing and query tuning
- Experience working in cloud-based data environments or modern data platforms (e.g., Snowflake or equivalent)