hero

Opportunities at
World Positive Startups

58
companies
598
Jobs
Leverage our network to build your career.
Tell us about your professional DNA to get discovered by any company in our network with opportunities relevant to your career goals.

Data Analyst (SQL Wizard)

Diamond Foundry

Diamond Foundry

IT, Data Science
San Francisco, CA, USA · Wenatchee, WA, USA
Posted on Thursday, April 6, 2023
Diamond Foundry Inc. is the global leader in single-crystal diamond technology. We produce single-crystal diamond (SCD) wafers by crystallizing greenhouse gas into diamond using proprietary plasma reactors powered by zero-emission energy. Founded in 2012 in San Francisco, California by Stanford/M.I.T./Princeton engineers, Diamond Foundry Inc. received $315MM in funding and has had a multi-year track record of profitable fast growth.
We are looking for a detail-oriented, hands-on Data Analyst to strengthen and grow our data collection, analysis, and presentation pipelines, which we use to report key business metrics and analyze our manufacturing process in real-time. You will be working with a team of veteran mechanical, electrical, metrology, and software engineers, supporting and leading various analytics projects to enhance and visualize our data-driven manufacturing systems. A strong candidate has a subset of the listed skills/qualifications and an interest in developing others.
We are looking for a data engineer to conceptualize, test, and design improvements for manufacturing related data collection systems. We have built our data collection system from scratch, and use it to report key business metrics and analyze our manufacturing process in real-time. You'll be working with an experienced team of mechanical, electrical, metrology, and software engineers, both assisting senior engineers and taking responsibility for your own engineering projects. Your goal will be to achieve maximum productivity for our production line through improving data extraction techniques, standardizing data collection methods, and ensuring data security.

Responsibilities:

  • Create, maintain, and own analytical models and dashboards for internal clients, turning data into an actionable and compelling narrative with visualizations.
  • Coordinate with stakeholders to record, develop, and document business rules and data definitions.
  • Create visibility of data and software issues among internal teams.
  • Prepare ongoing reports for a broad range of stakeholders, including senior business leadership, to communicate trends, patterns, and forecasts to inform business decisions.
  • Assist data and software engineers in database and application troubleshooting.
  • Document and organize the work of the software development team in a manner that can be accessed by appropriate users when needed.
  • Coordinate with the broader Factory Automation Systems team on team-wide initiatives.
  • Lead the development of company best practices around data analytics, dashboarding, and reporting.
  • Leading the design, development, and deployment of new BI reports, frameworks, and tools, including visual insights, detail reports, and dashboards.
  • Building new BI reports to provide insight into production metrics for external customers while mitigating proprietary information exposure.
  • Optimizing all stages of the data lifecycle, from initial planning, to ingest, through final display and beyond.
  • Designing and implementing data extraction, cleansing, transformation, loading, and replication capabilities.
  • Organizing and maintaining documentation so others are able to understand and use it.
  • Implement, troubleshoot and maintain security standards for data storage, transfer, and interpretation.
  • Develop highly available, highly scalable, encrypted, data storage, and disaster recovery for our systems.
  • Designing new capabilities for data analysis and sourcing solutions from software service providers when appropriate.
  • Performing data correction and providing data correction tools to enable a self sustaining dataset.

Requirements:

  • Strong communication and data presentation skills.
  • Bachelor's Degree in Business, Computer Science, or related field.
  • 3+ years experience in an analysis-focused role.
  • Expertise with Looker or other common analytics and reporting tools (Power BI, Google Data Studio, Google Sheets / Excel, Tableau).
  • Technical proficiency in SQL.
  • Knowledge of program development and project management concepts.
  • Demonstrated ability to work independently under limited supervision and as a team member in a collaborative environment.
  • Comfort with ambiguity and task prioritization in a fast-moving environment.
  • Ability to work cross-functionally, building and maintaining trust with internal stakeholders.
  • Strong communication and data presentation skills, experience analyzing data and communicating the results to senior business leaders.
  • Ability to work cross-functionally, building and maintaining trust with internal stakeholders.
  • Experience in querying and manipulating large data sets using data querying languages (e.g. SQL), scripting languages (e.g. Python), or statistical/mathematical software (e.g. R, SAS, Matlab).
  • Experience with GCP (Google BigQuery, CloudSQL, Looker).
  • Bachelor's degree in Computer Science or similar engineering discipline.
  • 3+ years of software/SQL/CS engineering experience.
  • Experience with maintaining security protocols across an organization.
  • A qualified candidate will have a subset of these skills:
  • Software: SQL, Looker, Python, HTML, Java.
  • Experience in building reports and real time BI analytics.
  • Operational knowledge of servers both locally and in the cloud.
Diamond Foundry believes in supporting our employees from the workplace to their personal and home life. We provide eligible employees with an opportunity to enroll in a variety of benefit programs, generally including health insurance, flexible spending accounts, retirement savings plans, life and disability insurance programs, and a number of programs that provide for both paid and unpaid time away from work. Perks include employee discounts to VRAI and catered lunches for onsite staff. All benefits offered are available starting your first day.
Diamond Foundry is an Equal Opportunity Employer and considers qualified applicants for employment without regard to race, color, creed, religion, national origin, sex, sexual orientation, gender identity and expression, age, disability, veteran status, or any other protected factor under federal, state or local law.
This employer participates in E-Verify and will provide the federal government with your Form I-9 information to confirm that you are authorized to work in the U.S.
If E-Verify cannot confirm that you are authorized to work, this employer is required to give you written instructions and an opportunity to contact Department of Homeland Security (DHS) or Social Security Administration (SSA) so you can begin to resolve the issue before the employer can take any action against you, including terminating your employment.
Employers can only use E-Verify once you have accepted a job offer and completed the Form I-9.