SQL Analytics Engineer

Found in: Appcast US C2 - 2 weeks ago

Boston, United States Pure Lithium Corporation Full time

Job Description:

Working with a small team of Software and Data Engineers, you will play a critical role in transforming raw data into well-formed models to accelerate research for Pure Lithium’s battery technology.


You will interact directly with scientists in the laboratory, translating their requirements into code. As you architect data models primed for analytics, you will act as the point person for researchers to build dashboards and other reporting layers.


Responsibilities:

  • Design and build data models in SQL, using tools like dbt
  • Collaborate with research scientists on requirements gathering
  • Enable staff to write their own reporting queries and build their own reports
  • Configure and optimize cloud data warehouse, including permissions, compute and storage parameters, and table schemas
  • Diagnose long-running and resource-intensive queries, improving performance
  • Productionize dbt flows, using data orchestration tools such as Prefect and Fivetran
  • Reduce complexity within our data pipelines while maintaining performance
  • Maintain a data dictionary and field questions about how to best leverage our data warehouse for reporting purposes


Qualifications:

  • Expertise with data transformation tools (e.g., dbt)
  • Expertise with data modeling approaches and philosophies (e.g., Kimball)
  • Expertise with at least one cloud data warehouse (e.g., Snowflake, Redshift)
  • Experience using version control such as Git and collaboration platforms such as Github
  • Knowledge of Python in the context of data transformations and manipulations
  • Experience with Analytics or Business Intelligence tools like Hex, Jupyter Notebook, Tableau
  • Knowledge of common data integration patterns (e.g., CDC, ELT, etc.)
  • Knowledge of common data integration / orchestration platforms (e.g., Prefect, Fivetran, Apache Airflow)


We seek applicants from all backgrounds, communities, and industries.

We are committed to having a team that is made up of diverse skills, experience, and abilities.

We encourage you to apply even if you do not meet all the desired qualifications.


Benefits:

  • Fully covered health and dental
  • Generous vacation time
  • Weekly company Grubhub allowance
  • MBTA pre-tax commuter benefit
  • Vibrant and supportive team


How to Apply:

If you are a driven and organized professional ready to take on a challenging role in a fast-paced startup environment, we want to hear from you. Please submit your resume, along with a brief cover letter highlighting your relevant experience and explaining why you are the ideal candidate for this position.


Interested candidates should apply via LinkedIn. Applications will be reviewed on a rolling basis, starting March 5th, 2024. Pure Lithium is an equal opportunity employer committed to unlocking innovation and achieving its mission with diverse backgrounds, perspectives, and experiences. Please see our website, www.pureithium.io, for more information.


About Pure Lithium:

A fast-paced Boston-based start-up, Pure Lithium provides the foundation for lithium metal to supplant lithium-ion as the predominant battery technology. Our mission is to enable the mass adoption of lithium metal batteries by getting lithium from the ground into the battery as quickly, sustainably, and inexpensively as possible.


Our integrated supply chain development approach solves many pain points for the battery industry. Pure Lithium is led by a world-class team of executives and scientists with extensive experience inventing and commercializing battery and energy technologies. It established its laboratory in Charlestown, Massachusetts, in January 2021, where it produces lithium metal, polymer electrolytes, and batteries daily.

  • Analytics Engineer

    Found in: beBee jobs US - 1 week ago

    Boston, Massachusetts, United States firsthand Full time

    firsthand is changing the way individuals living with Serious Mental Illness (SMI) get care. We are focusing on delivering real outcomes for a cohort that has historically been underserved, stigmatized, and deprioritized. By building a service focused on whole-person care, firsthand aims to find, establish a trusting relationship with, and support quality...

  • Staff Analytics Engineer

    Found in: beBee jobs US - 3 weeks ago

    Boston, Massachusetts, United States Robin Full time

    About Robin:Robin is the leading hybrid workplace experience platform. Since 2014, we've empowered people to do their best work by building tech solutions that fuel vibrant workplace experiences. Our platform redefines work and community building for hybrid companies everywhere. With industry-leading desk booking and room scheduling software alongside our...

  • SQL Database Administrator

    4 days ago

    Boston, United States JobRialto Full time

    Perform the tasks of migrating databases from a data center environment to AWS environments with SQL running on EC2. Perform Database Administration for MS SQL Server and other database tools. Troubleshoot and resolve database issues. Tuning and Optimization using Native Monitoring and Troubleshooting Tools. Monitor, troubleshoot, and resolve failed tasks or...

  • Senior Data Engineer

    1 week ago

    Boston, United States Selby Jennings Full time

    Overview: Our client, one of Boston's longest tenured private asset managers, is looking for a motivated Senior Data Engineer to join their Enterprise Data team to develop and support critical data processing and warehousing applications Responsibilities: Designing and implementing Python and SQL solutions Proficiency with data collection, data wrangling,...

  • Senior Data Engineer

    Found in: beBee S US - 2 weeks ago

    Boston, United States Selby Jennings Full time

    Overview: Our client, one of Boston's longest tenured private asset managers, is looking for a motivated Senior Data Engineer to join their Enterprise Data team to develop and support critical data processing and warehousing applicationsResponsibilities: Designing and implementing Python and SQL solutions Proficiency with data collection, data wrangling,...

  • Senior Data Engineer

    Found in: Appcast Linkedin GBL C2 - 2 weeks ago

    Boston, United States Selby Jennings Full time

    Overview: Our client, one of Boston's longest tenured private asset managers, is looking for a motivated Senior Data Engineer to join their Enterprise Data team to develop and support critical data processing and warehousing applicationsResponsibilities:Designing and implementing Python and SQL solutionsProficiency with data collection, data wrangling,...

  • Enterprise Data Engineer

    Found in: Appcast US C2 - 2 weeks ago

    Boston, United States Selby Jennings Full time

    Overview: Our client, one of Boston's longest tenured private asset managers, is looking for a motivated Senior Data Engineer to join their Enterprise Data team to develop and support critical data processing and warehousing applicationsResponsibilities:Designing and implementing Python and SQL solutionsProficiency with data collection, data wrangling,...

  • Senior Data Engineer

    1 week ago

    Boston, United States Selby Jennings Full time

    Overview: Our client, one of Boston's longest tenured private asset managers, is looking for a motivated Senior Data Engineer to join their Enterprise Data team to develop and support critical data processing and warehousing applications Responsibilities: Designing and implementing Python and SQL solutions Proficiency with data collection, data wrangling,...

  • Senior Data Engineer

    2 days ago

    Boston, United States Selby Jennings Full time

    Overview: Our client, one of Boston's longest tenured private asset managers, is looking for a motivated Senior Data Engineer to join their Enterprise Data team to develop and support critical data processing and warehousing applications Responsibilities: Designing and implementing Python and SQL solutions Proficiency with data collection, data wrangling,...

  • Jr. SQL Developer

    1 week ago

    Boston, United States Grand Circle LLC Full time

    Job DescriptionJob DescriptionTitle: Jr. SQL Developer Location: Boston, MA (3 days onsite) Rate: DOE Overseas Adventure Travel is seeking a qualified Jr. SQL Developer in our Marketing Operations department with a focus on performing back end development in our Marketing CMS.This SQL Developer will work with every team involved with marketing...

  • Senior Manager Analytics

    Found in: beBee jobs US - 2 weeks ago

    Boston, Massachusetts, United States Forsyth Barnes Full time

    This is an exciting opportunity to work with one of the top Retail brands in the US. As the Senior Manager, Analytics you will lead a small team of Analysts with a view to grow out the scope of the team as projects being to get traction.As an organization they are consumer first and keen to take a deeper dive into the core products they provide with an...

  • PL/SQL Developer

    Found in: Appcast Linkedin GBL C2 - 2 weeks ago

    Boston, United States Compunnel Inc. Full time

    PL/SQL Developer (AWS/Java)Location – Boston MA – 2 weeks onsite in a MonthSpecial Note:70% DB – Oracle SQL, PL/SQL 30% (mid-tier) Java stack , spring boot , Kafka , AWSThe Expertise and Skills You BringExpertise writing Oracle PL/SQL and performing data analysis.You have an understanding of ETL tools like Informatica and scheduling tools.You have a...

  • PL/SQL Developer

    Found in: Appcast US C2 - 2 weeks ago

    Boston, United States Compunnel Inc. Full time

    PL/SQL Developer (AWS/Java)Location – Boston MA – 2 weeks onsite in a MonthSpecial Note:70% DB – Oracle SQL, PL/SQL 30% (mid-tier) Java stack , spring boot , Kafka , AWSThe Expertise and Skills You BringExpertise writing Oracle PL/SQL and performing data analysis.You have an understanding of ETL tools like Informatica and scheduling tools.You have a...

  • Geotectonical Engineer

    4 days ago

    Boston, United States Verisk Analytics Full time

    Work with a team of established research scientists and engineers with a diverse background in geology, geophysics, and earthquake seismology and engineering to conduct and assimilate emerging seismic hazard research to develop and enhance models. Th Engineer, Research Scientist, Solutions, Modeling, Technical Engineer

  • Data & Analytics Practice Lead

    1 week ago

    Boston, United States Focus Technology Solutions Inc Full time

    Job DescriptionJob DescriptionIf you are a dynamic self-starter experienced in the Data & Analytics space, this is the role for you! We are hiring a Data & Analytics Practice Lead to join our growing team. This is a senior-level role that oversees the delivery of data and analytics solutions for our clients. You will be responsible for ensuring the quality,...

  • Senior Analyst, Analytics

    Found in: beBee jobs US - 2 weeks ago

    Boston, Massachusetts, United States Arcadia Full time

    Arcadia is dedicated to happier, healthier days for all. We transform diverse data into a unified fabric for health. Our platform delivers actionable insights for our customers to advance care and research, drive strategic growth, and achieve financial success. For more information, visit Why This Role Is Important To ArcadiaThe Senior Analyst will join the...

  • Data Analytics Solution Architect

    Found in: Appcast Linkedin GBL C2 - 2 weeks ago

    Boston, United States Curate Partners Full time

    *** 6-12 Week Project ***"Need someone who is well-spoken, Senior level and can help the smallteam drive Analytics strategy. Must have strong healthcare payer experience. Need to be able to dive into existing architecture and artifacts and help create a new future state of architecture, with best practices and standards. Dennis said he will interview people...

  • Data Analytics Solution Architect

    2 weeks ago

    Boston, United States Curate Partners Full time

    *** 6-12 Week Project ***"Need someone who is well-spoken, Senior level and can help the smallteam drive Analytics strategy. Must have strong healthcare payer experience. Need to be able to dive into existing architecture and artifacts and help create a new future state of architecture, with best practices and standards. Dennis said he will interview people...

  • Data Analytics Solution Architect

    Found in: Appcast US C2 - 2 weeks ago

    Boston, United States Curate Partners Full time

    *** 6-12 Week Project ***"Need someone who is well-spoken, Senior level and can help the smallteam drive Analytics strategy. Must have strong healthcare payer experience. Need to be able to dive into existing architecture and artifacts and help create a new future state of architecture, with best practices and standards. Dennis said he will interview people...

  • Senior Analyst, Analytics

    Found in: beBee S US - 2 weeks ago

    Boston, United States Arcadia Full time

    Arcadia is dedicated to happier, healthier days for all. We transform diverse data into a unified fabric for health. Our platform delivers actionable insights for our customers to advance care and research, drive strategic growth, and achieve financial success. For more information, visit arcadia.io. Why This Role Is Important To Arcadia The Senior...