Note: The job is a remote job and is open to candidates in USA. Dwyer Instruments is seeking a Junior Analytics Engineer to join their Business Intelligence (BI) team. This role is ideal for early-career professionals who are eager to learn and work with data, providing hands-on experience in building data pipelines and supporting analytics.
Responsibilities
- Assist in building and maintaining data pipelines using Microsoft Fabric (Data Factory, Lakehouse, OneLake)
- Support data ingestion from various sources into analytics-ready datasets
- Write and optimize basic to intermediate SQL queries and PySpark
- Help prepare data for Power BI reports and dashboards
- Perform data validation and quality checks
- Troubleshoot simple data pipeline and data issues with guidance
- Document data processes and learn platform best practices
- Design, develop, and maintain Power BI dashboards and reports
- Translate business requirements into data models and visualizations
- Write and optimize SQL queries to extract and validate data
- Create and maintain Power BI data models, DAX measures, and calculated fields
- Perform data validation and quality checks to ensure report accuracy
Skills
- 0–2 years of experience in data engineering, analytics, or a related technical role (internships, academic projects, or bootcamp experience are welcome)
- Basic understanding of SQL and relational databases
- Familiarity with data concepts (ETL, data pipelines, data models)
- Understanding of data modeling concepts
- Familiarity with DAX fundamentals (measures, calculated columns)
- Willingness and enthusiasm to learn new tools and technologies
- Ability to adapt and work in a fast-paced environment
- Strong team player with analytical and problem-solving skills
- Good communication skills and willingness to learn in a fast-paced environment
- Knowledge of SQL queries, Python or Py-Spark
- Exposure to cloud platforms (Azure preferred)
- Academic or project experience with BI or analytics and AI
- Understanding of data warehousing fundamentals
- Power BI certification (PL-300) or working toward it
Company Overview
Dwyer Instruments is an industrial automation company that offers gas sensing and air velocity instrumentations and controls. It was founded in 1931, and is headquartered in Michigan City, Indiana, USA, with a workforce of 501-1000 employees. Its website is http://www.dwyer-inst.com.Company H1B Sponsorship
Dwyer Instruments has a track record of offering H1B sponsorships, with 1 in 2022. Please note that this does not guarantee sponsorship for this specific role.
Apply Now