Environmental And Safety Solutions, Inc. banner

Software Engineer (261)

Environmental And Safety Solutions, Inc.

The Role

Overview

Develop and optimize Azure data pipelines, ETL, and dashboards for enterprise data.

Key Responsibilities

  • power bi
  • etl processes
  • azure security
  • data quality
  • databricks tuning
  • data pipelines

Tasks

-Develop and maintain interactive dashboards and reports using SAP Business Objects and Power BI, translating complex data into actionable business insights. Focus on performance optimization and data accuracy. -Implement and manage complex ETL (Extract, Transform, Load) processes to seamlessly integrate data from diverse sources (e.g., databases, APIs, streaming platforms) into Azure Data Lake, ensuring data quality and consistency. -Implement and maintain Azure Security & Governance policies, including access control, data encryption, and compliance frameworks, to ensure data protection and adherence to industry best practices. -Implement data quality checks and validation rules throughout the data pipeline to ensure data accuracy, completeness, and consistency. -Collaborate effectively with cross-functional teams (e.g., business analysts, data scientists, product managers) to understand business requirements, translate them into technical solutions, and communicate technical concepts clearly. -Monitor, troubleshoot, and enhance existing data solutions, proactively identifying and resolving performance bottlenecks and data quality issues. -Optimize data storage and retrieval mechanisms within Azure, including performance tuning of Databricks clusters and Azure SQL databases, to improve query performance and scalability. -Design, develop, and optimize scalable and efficient data processing pipelines and architectures within Azure Data Lake and Databricks, leveraging best practices for performance and maintainability. -Leverage Azure Data Factory for data orchestration, workflow automation, and scheduling, ensuring reliable and timely data delivery. -Create and maintain comprehensive technical documentation, including design specifications, data flow diagrams, and operational procedures, to facilitate knowledge sharing and team collaboration.

Requirements

  • sql
  • azure
  • etl
  • power bi
  • master's
  • problem solving

What You Bring

-Master's degree in a relevant field. -Solid understanding of data modeling concepts, ETL processes, and big data frameworks (e.g., Spark). -4+ years of hands-on experience in data engineering, data warehousing, and cloud-based data platforms. -Strong proficiency in SQL, including complex query writing, query optimization, and performance tuning. -Understanding of DevOps practices and CI/CD pipelines for data applications. -Experience in optimizing and managing large-scale datasets in cloud environments. -Experience with data governance tools and frameworks. -Excellent communication and collaboration skills. -Deep expertise in Azure Data Lake, Azure Data Factory, Azure Security & Governance, Databricks, and SAP Business Objects. -Experience with other cloud platforms (e.g., AWS, GCP). -Bachelor’s degree in computer science, Engineering, or a related field and 2-5 years of experience or 5+ years of relevant work experience. -Proven experience in developing and maintaining Power BI dashboards and reports. -Familiarity with machine learning models and data science concepts. -Experience developing and maintaining ETL packages using SSIS and reports using SSRS. -Strong analytical and problem-solving skills with a keen attention to detail. -Hands-on experience with Azure services such as Azure Synapse Analytics, Azure SQL Database, and Azure Blob Storage. -Must be a U.S. Citizen.

The Company

About Environmental And Safety Solutions, Inc.

-Evolved from a local compliance firm into a national EHS consultancy. -Built on a deep background in chemical manufacturing and engineering. -Projects include OSHA/EPA compliance audits, industrial hygiene, air and water permitting, and geologic risk assessments. -Services are tailored to provide custom safety and environmental programs for each client’s operations. -Clients span Fortune 500 companies to small businesses across sectors like chemical, construction, utilities, and manufacturing. -The company’s financials reflect steady growth, reporting annual revenue around $10 million. -Leadership includes seasoned professionals with decades of EHS expertise guiding project delivery and client strategy. -Standout fact: it’s a certified MBE and Black-owned firm, leveraging that status to serve both large and community-based clients.

Sector Specialisms

Aerospace

Automotive

Healthcare

Manufacturing

Packaging

Petro-chemical

Public Utility

Pulp & Paper

Stamping

Construction

Mining

Retail

Legal

Health Care

Plastics

Warehousing

Transportation Logistics

Pharma

Industrial