Data Engineer II

Description

The Hiller Companies, LLC has an immediate opening for Data Engineer II.

Hiller offers fire protection and life safety products and services that are preserving lives and property all around the world. Headquartered in Mobile, Alabama, Hiller extends its reach globally as well as in domestic markets with offices across the United States. For more than 100 years, we have been laser-focused on one goal – making the world a safer place. We are proud to be on the forefront of technology and innovation by creating adaptable safety solutions. As we continue to grow and expand our life safety footprint, we pledge to keep our customers top of mind while striving to design, install and service the most compliant, reliable systems available.

This position will ideally be located on site in Mobile, AL, but we will consider remote working arrangements.

Job Summary: This role requires an individual adept in data processing, ETL development, and database management. You will be responsible for architecting and refining sophisticated data pipelines, ensuring the utmost data integrity, and enhancing our data storage and retrieval systems to support complex analytics and reporting needs. Your expertise will be instrumental in driving the company's operational efficiency and deepening our analytical capabilities, requiring effective collaboration with diverse teams to fulfill intricate data requirements and contribute strategically to our overarching data infrastructure goals.

Job Responsibilities:

• Ownership of building and optimizing data pipelines using .NET frameworks, Apache Spark, or similar technologies to handle large volumes of data efficiently.
• Extend and develop API integrations using ASP.NET Web API or similar frameworks to ensure seamless data exchange between systems, with a focus on robust error handling and authentication mechanisms.
• Work closely with analytics and business teams to enhance data models, translating business requirements into data model enhancements and iterating based on feedback.
• Lead efforts to implement robust processes for monitoring data quality, ensuring accuracy and availability of data through automated validation checks and alerts.
• Writing comprehensive tests and maintaining documentation to ensure the reliability and scalability of data pipelines and integrations.
• Utilize advanced SQL querying capabilities to analyze complex datasets, investigating data anomalies and providing insights and recommendations based on findings.
• Collaborate effectively with cross-functional teams, providing mentorship and guidance to junior team members, and leading initiatives to improve team processes and collaboration.
• Design and implement advanced data models using .NET technologies such as Entity Framework Core, and develop complex ETL jobs using frameworks like Azure Data Factory or custom .NET applications.
• Architect data integration solutions using .NET technologies like Azure Logic Apps or custom .NET middleware, and define data quality frameworks and standards for consistency and accuracy.
• Assess and recommend tools for data governance with .NET compatibility, conducting proof-of-concept evaluations and collaborating with stakeholders to select appropriate tools and technologies.
• Provide strategic input into the organization's data platform roadmap, identifying opportunities for innovation and improvement in data infrastructure and aligning data initiatives with business objectives.
• Other relevant duties as assigned.

Qualifications

Education, Licensure & Certifications:

• Bachelor's degree in Computer Science, Data Science, Engineering, or a related field is preferred.

Experience:

• 3 years of experience in data engineering, with a proven track record in building and managing data pipelines, data warehousing, and cloud-based data solutions is preferred.

Knowledge, Skills, Capabilities:

• Expertise in ETL tools like Talend, dbt, and data warehousing technologies such as Redshift.
• Advanced knowledge of SQL and database management practices in PostgreSQL and SQL Server.
• Proficiency in Python for data scripting and automation tasks or equivalent scripting language.
• Deep understanding of data modeling, warehousing concepts, and big data technologies.
• Exposure to C# and .NET preferred.
• Demonstrated experience with data visualization and business intelligence tools like Tableau preferred.
• Familiarity with machine learning concepts and data science practices preferred.
• Knowledge of DevOps methodologies and tools for data pipeline automation and monitoring preferred.
• Strong analytical, problem-solving, and communication skills preferred.

Hiller is a drug-free workplace, an equal opportunity employer and ADA compliant.  

We are proud to operate according to our Core Values:  Passion to Perform, Trust to Act, Act Responsibly, and Make it Fun.

We offer competitive pay and most employee benefits start from the first day of employment, including:

• Medical, Dental & Vision Insurance
• 401(k) with fully vested employer matching funds
• Company Paid & Voluntary Life Insurance
• Company Paid Short Term Disability Insurance
• Voluntary Long Term Disability, Critical Illness & Accident Insurance
• PTO
• 8 Paid Holidays