Trimark Associates, Inc. · 10 hours ago
Data Analytics & Integration Engineer
Folsom, California, United States
Full-time
Hybrid
Mid Level
$85K/yr - $115K/yr
3+ years expTrimark Associates, Inc. is focused on finding and revealing the truth through analytics, automation, and optimization. They are seeking a skilled professional with a background in business intelligence development and predictive analytics to enhance their operations and create intuitive tools.
Consulting
Responsibilities
Develop clean and compact ETL pipelines using SQL, PowerQuery (M), and DAX to support nimble data modeling
Design, build, and optimize Power BI reports and dashboards for various business units
Optimize datasets, query folding, relationships, and incremental refresh strategies
Troubleshoot and fix existing reports while improving performance and usability
Train business users in effective report usage and self-service analytics
Manage data imports, transformations, and integrations between ERP, HR, Task Tracking, and Time Tracking
Leverage Microsoft LogicApps, Azure Data Factory and other middleware to integrate data across platforms
Develop ML models (XGBoost, Random Forest, ELM, KNN) using Python and logistic + linear regression
RAG-powered (LlamaIndex/LangChain) solutions
Qualification
Required
Robust knowledge of Python (Pandas, NumPy, scikit-learn, Matplotlib, PySpark, PyTorch), SQL, M, DAX and HTML
3+ years of Power BI
1+ years of ML/AI
1+ years of Azure Data Factory
1+ years of REST API development
Experience building data models, managing relationships, and implementing best practices for report performance
Strong anticipatory problem-solving, analytical, and communication skills
Ability to work cross-functionally and interdepartmentally with accounting, operations, and business stakeholders
Can translate what people say into what they really need
Can see the big picture and the details simultaneously
A listen first, talk second mindset
Self-starter
Preferred
Python
JavaScript
SSIS
Azure Data Factory
Azure AI Document Intelligence
Microsoft Logic Apps
RAG-based AI (LlamaIndex/LangChain)
RESTful services
An interest in exploring the data visualization space for market leading ML/AI tools
Company
Trimark Associates, Inc.
Follow us to discover company developments, our energy clients' successes and employment opportunities.
51-200 employees
H1B Sponsorship
Trimark Associates, Inc. has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (2)
2024 (1)
2023 (1)
2022 (1)
2021 (1)
Funding
Current Stage
Growth StageLeadership Team
Dean Schoeder
Management Consultant
Mark Morosky
President
Company data provided by crunchbase