BI Data Engineer

Business Unit

Crane ChemPharma & Energy Flow Solutions is a division within the Fluid Handling Business Segment of Crane Co, a US multi-national which specializes in highly engineered products in niche markets. Crane ChemPharma & Energy Flow Solutions designs, manufactures, markets and distributes a range of process valves and actuators under multiple brand names for a wide range of applications in a number of industries including the refinery, chemical, biopharmaceutical, and energy industries.

Position Summary

The Data Engineer is a critical role focused on building and optimizing our data pipeline architecture, as well as supporting data initiatives across Crane ChemPharma and Energy. The ideal candidate will have a strong technical background in data engineering, excellent problem-solving skills, and the ability to work collaboratively with cross-functional teams. The Data Engineer is responsible for designing, implementing, and maintaining scalable data pipelines that ensure the availability and quality of data for analytics and business intelligence purposes.

As our Data Engineer, you will play a key role in developing and maintaining the infrastructure required for optimal extraction, transformation, and loading (ETL) of data from various sources. You will also be responsible for ensuring data integrity and consistency, as well as supporting the data needs of multiple teams, systems, and products. The ideal candidate is passionate about leveraging data to drive business insights and is committed to staying current with emerging technologies and industry trends.

www.craneco.com

Principle Duties

• Apply industry-accepted data architecture principles for modelling, stored procedures, replication, security, and compliance to meet both technical and business objectives.
• Design, build, and maintain scalable data pipelines using Microsoft Fabric components such as Lakehouse, Azure Data Factory (ADF), Data Warehouses, Notebooks, and Dataflows.
• Data Extraction - Develop and implement solutions to integrate, process, and analyse large volumes of structured and unstructured data.
• Work with data scientists, analysts, and other stakeholders to understand data requirements and deliver high-quality data solutions.
• Optimize and troubleshoot data pipelines to ensure reliability, efficiency, and performance.
• Implement best practices for data governance and security to ensure data integrity and regulatory compliance.
• Monitor and maintain data infrastructure to ensure high availability and scalability.
• Stay current with advancements in data engineering and Microsoft Fabric technologies.
• Develop technology architecture strategies informed by various business scenarios and motivations.
• Assess emerging technology trends and provide guidance on their potential impact on organizational opportunities and risks.
• Continuously enhance the quality, consistency, accessibility, and security of data across the company.
• Manage the Data Platform roadmap, ensuring future-proofing, capacity planning, and optimization.
• Collaborate with the IT Operations team and BI vendors to resolve production issues.
• Manage stakeholder demands and prioritize reporting requirements and needs.
• Maintain relationships with key vendors to plan and adapt the Data Platform roadmap and leverage existing capabilities.
• Monitor Data Platform usage, deprecate unused reports and datasets, and drive continuous improvement.
• Work with users to address data issues, trace data lineage, and implement data cleansing and quality processes.
• Manage secure access to data sets for the business.
• Ensure effective collaboration with BI vendors, IT, and business teams.
• Manage project schedules, focus on critical path items, define and communicate key milestones, and coordinate with the broader team for tollgate reviews.
• Monitor and report on emerging technologies, seeking opportunities for continuous improvement.
• Ensure adherence to data visualization and data modelling processes, procedures, and standards.
• Manage data sets and work with ETL and Data Warehouse solutions.
• Launch and drive a data literacy program for business users.
• Follow CBS processes and toolkits to achieve operational excellence.
• Submit weekly reports on the progress of assigned tasks.
• Follow project directives from IT leadership and ensure compliance with IT policies and regulations.
  
  
  

Essential Qualifications / Experience

• BS or MS degree in Computer Science or a related technical field.
• 8+ years of experience managing data infrastructure, including Data Warehouses and Data Marts.
• 8+ years of experience with Power BI and SQL; No-SQL experience is a plus.
• Proficiency in data pipeline tools such as Azure Data Factory, PySpark, Spark SQL, and Python.
• Strong understanding of data modelling, ETL processes, and data warehousing concepts.
• Experience with cloud platforms, particularly Microsoft Azure.
• Excellent problem-solving skills and meticulous attention to detail.
• Strong communication and collaboration skills.
• Effective interpersonal skills.
• Ability to manage and communicate data warehouse plans to internal stakeholders.
• Experience in designing, building, and maintaining data processing systems.
• Willingness to travel domestically and internationally, with up to 10% travel during peak time
  
  
  

Desirable Qualifications / Experience

• 5+ years of experience designing conceptual, logical, and physical data models using enterprise data modelling tools on the Azure cloud platform.
• Proven track record in assessing and enhancing system portfolios to improve efficiency and performance.
• Self-starter with the ability to learn new technologies, perform proof of concepts, conduct assessments, and lead agile pilots to full production solutions.
• Independent thinker with the capability to make technical decisions autonomously.
• Ability to self-direct, meet deadlines, and consistently produce high-quality work.
• Experience in addressing visualization, reporting, and analytics needs through the development of presentation and data models.
• Skilled in working closely with business management teams to understand requirements and develop reporting or analytical solutions.
• Proficient in defining and developing data sets, models, and cubes.
• Experience with Python, SQL, relational databases, and data warehousing technologies, including SQL, SSRS, SSAS, SSIS, Power BI, Power Query, and DAX.
• Desirable to have knowledge of Salesforce data structures.
• Experience with or understanding of Agile Software Development methodologies.
• Excellent problem-solving and troubleshooting skills.
• Process-oriented with strong documentation skills.
• Excellent oral and written communication skills with a strong focus on customer service.
• Experience in presenting to stakeholders.
  
  
  

Key expectations from the Business

• A self-starter, independent-thinker, curious and creative person with ambition and passion
• High energy level, comfortable performing multifaceted projects in conjunction with day-to-day activities
• Excellent influencing, analytical and problem-solving skills and the ability to multi-task in a fast-paced environment
• Ability to analyse business systems, identify problems or broken processes, and develop solutions
• Results and people oriented with sound judgment—ability to balance other business considerations
• Team player – able to work in a matrix organization
• Excellent communication and interpersonal skills – verbal and written
• Up to 10% travel
• Key Working Relationships:
• Develop effective partnerships with Leadership team members, Business leads and IT team members
• Partner with other Crane business leaders to share, cross-pollinate, and adopt best practices in the true spirit of Crane helping Crane
  
  
  

Opportunities at CRANE

• Personal Development – IT Project Management Skills
• Personal Development – Work with other high-energy leaders in a results-focused environment
• Personal Development – Opportunity to make a big difference by focusing on top business priorities
• Career Advancement – Natural candidate for IT Leadership track
• Career function change – Ability to easily transition to other IT roles