Associate Data Visualization Engineer
Role details
Job location
Tech stack
Job description
- Assist in architecting and designing Business Intelligence solutions to drive insights using data and data analytics
- Partner with stakeholders, process specialists, business teams, and users to elicit and document business requirements for new metrics and reports
- Develop scorecards, static and interactive dashboards, data visualizations, data extracts, and other analytics and reporting to tactically meet the needs of stakeholders
- Collaborate with IT teams to develop end-to-end solutions including data acquisition, data modeling, ETL/ELT processes, data analytics, and data visualizations
- Assist in the development of complex interactive/dynamic dashboards, complex data modeling, and other data visualizations to support decision making at DTSC
- Partner with the data management team to support the enterprise business intelligence system including: ETL/ELT, data cleansing/quality, operational data store (ODS), data warehouse (DW), and data mart components as well as end user reporting, analysis, and visualization tools, Electronic applications submitted through your CalCareer Account are highly recommended. If you are unable to apply electronically through your CalCareer account, please mail a completed and signed STD. 678 and application package to the mailing address provided above in the "Application Instructions" section. Applications must be postmarked on or before the final filing date.
For mail-in or drop-off applications, please include JC# 515758 and indicate the basis of your eligibility in the Examination(s) or Job Title(s) section. SROA and surplus candidates should submit a copy of their letter with their application.
Pending Budget Approval - DTSC will obtain all necessary approvals prior to extending a job offer.
Foreign Degrees
Applicants who completed their education outside the United States (with foreign degree/ transcripts) must obtain and submit verification of United States course/degree equivalency.
Foreign education credential evaluation services can be found at https://www.naces.org.
DO NOT include any confidential information to your application or supporting documents (i.e., Social Security Number, birthdate, marital status, medical information, examination results, method of eligibility, etc.).
Requirements
- Knowledge and Experience with data analytics and report design principles
- Experience or education in one or more of the following technologies: Power BI, Tableau, Qlik Sense, Google Looker, etc. Power BI experience is strongly desired
- Understanding of a typical data stack, e.g. Data Warehouses, Query layer and Presentation layer
- Experience with running basic SQL queries to extract data
- Knowledge of Data Modeling concepts e.g. Star-schema, Snowflake schema and Aggregation etc
- Experience in modeling a semantic layer in an Enterprise Setting, including defining relationships between entities and deriving needed data columns
- Experience building data visualization and analytics solutions in an enterprise setting using BI data visualization products, This position is not eligible for visa sponsorship. Applicants must be authorized to work in the United States without the need for visa sponsorship by the start date of employment. The Department of Toxic Substances Control does not participate in E-Verify for employment authorization purposes.
Benefits & conditions
Effective July 1, 2025, specific Bargaining Units and associated Excluded State employees are subject to a salary reduction between 2% - 4.62% in exchange for hours in the Personal Leave Program 2025 (PLP 2025) per month. For more details, please click here https://hrmanual.calhr.ca.gov/Home/ManualItem/1/2113.
