Software Engineer (261)

ESS-261

Job Title: Software Engineer
US Citizenship Required - No exceptions

Job Summary:
We are seeking a highly skilled and motivated Software Engineer specializing in Data Engineering to join our growing team. This critical role will focus on designing, developing, and optimizing our data infrastructure within the Azure cloud environment. The ideal candidate possesses a deep understanding of data engineering principles and extensive hands-on experience with Azure Data Lake, Azure Data Factory, Databricks, and SAP Business Objects. You will play a key role in building and maintaining robust data pipelines, ensuring data quality, and enabling data-driven insights for the business. This position requires a U.S. Citizenship due to project requirements.

This position is designated as part-time telework per our global telework policy and will require at least three days of in-person attendance per week at the assigned office or project. Weekly in-person schedules will be determined by the individual and their supervisor, in consultation with functional or project leadership

Major Responsibilities:

• 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.
• 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.
• 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.
• Leverage Azure Data Factory for data orchestration, workflow automation, and scheduling, ensuring reliable and timely data delivery.
• 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.
• Optimize data storage and retrieval mechanisms within Azure, including performance tuning of Databricks clusters and Azure SQL databases, to improve query performance and scalability.
• 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.
• Implement data quality checks and validation rules throughout the data pipeline to ensure data accuracy, completeness, and consistency.
• Monitor, troubleshoot, and enhance existing data solutions, proactively identifying and resolving performance bottlenecks and data quality issues.
• Create and maintain comprehensive technical documentation, including design specifications, data flow diagrams, and operational procedures, to facilitate knowledge sharing and team collaboration.

Education and Experience Requirements:

• Bachelor’s degree in computer science, Engineering, or a related field and 2-5 years of experience or 5+ years of relevant work experience.
• Must be a U.S. Citizen.

Required Knowledge, Skills, and Abilities:

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

About Environmental and Safety Solutions, Inc.:

Environmental and Safety Solutions Inc. (ESS Inc.) is a Cincinnati based certified MBE. Since 2002, ESS Inc. has been providing health and safety, engineering, environmental technical and management services to businesses throughout the United States. We work with businesses from Fortune 500 members to small businesses in the local community, providing world class occupational safety and health consultative services and environmental compliance assistance. Our customers value our personal attention to their needs and the accuracy and flexibility of our services to meet their unique needs. As President and Founder of ESS, Lonnie Grayson brings more than 25 years of professional environmental safety and health leadership to the company. He founded ESS Inc. in 2002 and has grown the firm into a nationally recognized industry leader. With a professional background as a mechanical engineer, Mr. Grayson knows the value of a safety and health program that focuses on the processes that drive the safety and health process in a company to achieve great results. We understand the need for partnership with our customers to fully understand their needs and the culture of each customer to meet and exceed their occupational safety, health and environmental compliance needs.