Note: The job is a remote job and is open to candidates in USA. Seneca Holdings is part of the Seneca Nation Group, focusing on federal government contracting. They are seeking a Senior Data Scientist to support the Department of Veterans Affairs in workforce learning and development by converting raw data into actionable insights and reports.
Responsibilities
- Build and maintain a SQL Server data warehouse, including ETL processes sourcing from multiple enterprise applications and SharePoint
- Replace cursor-based data cleansing routines in SQL Server with Python-based processing
- Catalog and document existing ETL workflows and their interdependencies to reduce technical debt
- Design pipeline orchestration outside of SQL Server, including credential and secrets management for scheduled jobs and data connections; evaluate candidate tools against the customer's constraints, present recommendations, and implement the approved approach
- Establish source control and dependency management practices so analytical code runs reproducibly across machines and environments
- Design a repeatable deployment process for ETL and analytics code, moving changes from development through test to production with peer review, versioned releases, and a rollback path, and document what tooling and access each option would require so the customer can decide what to stand up
- Conduct statistical analysis, regression, and predictive modeling to answer organizational questions and support projections
- Apply machine learning and text analytics methods where they demonstrably add value, including classification, forecasting, and segmentation, and make the ROI case before committing to an approach
- Perform exploratory analysis on new and archival data sources to surface trends that conventional reporting misses
- Design and implement data quality controls, including automated validation
- Evaluate model performance and refine methods over time
- Maintain a technical backlog of planned engineering work, nice-to-have improvements, and identified deficiencies affecting data security or data quality, and work with stakeholders to sequence remediation
- Design, build, and maintain Power BI semantic models, reports, and dashboards, including KPI and performance-tracking products
- Diagnose and resolve Power BI performance problems, including decomposing monolithic semantic models into separate, targeted models and updating downstream reports
- Develop custom visualizations programmatically in Python, embedded as Python visuals in Power BI where native visuals fall short, and produce interactive or publication-quality tabular output outside the Power BI canvas where the audience calls for it
- Respond to rapid-turnaround ad hoc data calls from senior leadership and external inquiries
- Define measurements and KPIs, and build reporting standards and templates that make findings usable without rework
- Produce and maintain technical documentation, system maps, and process flow diagrams
- Work directly with program stakeholders to translate ambiguous questions into measurable analysis
- Consult on data design for enterprise applications under development
- Present findings and recommendations to non-technical audiences
Skills
- 5+ years of experience in data science, data engineering, or advanced analytics. Bachelor's degree in a quantitative or technical field preferred; equivalent professional experience accepted in lieu of a degree
- Advanced SQL and hands-on experience with on-premises Microsoft SQL Server, including performance tuning
- Strong Python for data work: dataframe-based manipulation and numerical computing, programmatic charting, and querying SQL Server directly through a Python database connector
- Demonstrated Power BI development experience, including DAX, Power Query, semantic model design, and performance optimization
- Experience building and maintaining ETL processes (SSIS or comparable)
- Applied experience across a range of analytical methods: regression, classification, time series forecasting, clustering and segmentation, dimensionality reduction, and statistical inference including hypothesis testing and uncertainty quantification
- Working knowledge of version control and Python environment/dependency management
- Experience assessing an existing analytics environment and producing design options with trade-offs, dependencies, and implementation paths for decision-makers who control the tooling and infrastructure
- Ability to document work clearly and communicate analytical findings to non-technical stakeholders
- Ability to obtain and maintain a VA background investigation and PIV credential
- Must be a U.S. citizen, as required by the customer for this position
- Experience with pipeline orchestration tools such as Apache Airflow, Azure Data Factory, or comparable
- Exposure to Microsoft Fabric, Azure Synapse Analytics, or Azure Machine Learning, and a point of view on when migration is warranted
- Experience implementing deployment pipelines or CI/CD for Power BI assets
- Interactive visualization and publication-quality tabular reporting beyond standard dashboard tooling
- Tree-based ensemble methods on tabular data
- Time series methods: seasonal decomposition, and validation approaches appropriate to temporal data
- Text analytics on unstructured sources: topic modeling, text classification, and entity extraction
- Experiment tracking and model lifecycle practices
- Experience collaborating with SharePoint and Power Platform developers on shared data models
- Prior VA, VHA, or federal health IT experience
- Microsoft certifications: Power BI Data Analyst Associate (PL-300) or Azure Data Scientist Associate (DP-100)
Benefits
- Balanced mix of benefits and programs
- Your total rewards package includes benefits and perks, flexible work-life balance, professional development opportunities, and performance and recognition programs
- Comprehensive benefits package that includes medical, dental, vision, life, and disability
- Voluntary benefit programs (critical illness, hospital, and accident)
- Health savings and flexible spending accounts
- Retirement 401K plan
- One of our fundamental principles is to offer competitive health and welfare benefits to our team members, providing coverage and care for you and your family
- Full-time employees working at least 30 hours a week on a regular basis are eligible to participate in our benefits and paid leave programs
Company Overview