BI Data Engineer

Crane ChemPharma & Energy; The Woodlands (TX); On-site; USD 90,000 - 130,000; Full time

Job summary

Crane ChemPharma & Energy Flow Solutions is seeking a BI Data Engineer to drive data architecture, ETL pipelines, and a new BI platform as part of a global rollout. You will design data stores, build pipelines into a data warehouse, and optimize data flow and quality.

The role requires hands-on SQL, ETL development, data modeling, and experience with data warehouses. Travel up to 25% to Crane locations and customer sites may be required.

Qualifications

• BS or MS in Computer Science or a related technical field.
• 4+ years of ETL development, testing, maintenance and troubleshooting.
• 4+ years of SQL experience (No-SQL a plus).
• 4+ years of data cleansing and preparation.
• Strong understanding of data analysis and relational databases.
• Experience designing and maintaining data processing systems.
• Agile and CI/CD practices; server installations and migrations.
• Willingness to travel up to 25% domestically/internationally.

Responsibilities

• Create ETL routines to move and transform data into the data mart.
• Maintain and enhance data architecture within data warehouses.
• Improve data quality, reliability, and database performance.
• Utilize ETL/integration tools for system data integrations.
• Architect solutions supporting data scientists and stakeholders.
• Conduct ETL and data transformation testing.
• Develop data models for data science use cases and analytics.
• Manage documentation and data lineage; oversee end-to-end data integration lifecycle.
• Serve as SQL Server DBA: jobs, error handling, troubleshooting, scheduling.
• Translate requirements into data models and mapping designs.
• Manage data platform roadmap and ensure future-proofing and optimization.
• Collaborate with IT operations and BI vendors to resolve issues.
• Monitor usage, deprecate unused reports, and drive continuous improvement.
• Present findings to stakeholders with clear data storytelling.

Skills

ETL development

SQL experience

Data cleansing

Data modeling

Data warehousing

Agile methodologies

CI/CD

Cloud migrations

Data analysis

Data pipelines

Education

BS or MS in Computer Science or related field

Job description

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 BI Data Engineer is a Business Intelligence focused role that will be an essential part of the team leading the Global Business Intelligence rollout across ChemPharma & Energy. The ideal candidate will possess proven technical expertise in BI Implementations, strong business acumen, and excellent interpersonal skills. As a BI Data Engineer, you will design data storage systems, works to fill them with quality data using data pipelines into a data warehouse. The BI will be responsible for expanding and optimizing our data and data pipeline architecture, as well as optimizing data flow and collection. The ideal candidate is an experienced data pipeline builder and data wrangler who enjoys optimizing existing data systems and building them from the ground up. This is a great opportunity to work on building a BI platform from scratch for a company that has significant leadership engagement to undergo a BI tech transformation.

www.craneco.com

• Creating ETL routines includes writing the code that creates the transformations and processes that move data from the specified sources, transform it as required and write it into the data mart
• Maintain and provide enhancements to data architecture within new/existing systems including Data Warehouse
• Recommend and implement process to improve data quality, data reliability, and database performance
• Employ variety of ETL and integration tools for system and data integrations
• Architect solutions that support data scientist and business stakeholders
• Conduct ETL testing and data transformation testing.
• Develop data models for data science team that can be utilized for data mining
• Maintain source to target documentation and process flow documentation
• Ability to serve as SQL Server DBA – Processes/Job/Error Handling/Troubleshooting/Scheduling, etc
• Create and enhance data solutions enabling seamless delivery of data and is responsible for collecting, parsing, managing and analyzing large sets of data
• Translate data access, transformation, and movement requirements into functional requirements and mapping designs
• Oversee the complete lifecycle of data integration: analysis, design, implementation and actively engage with the business on using the data to make decisions
• Architect data flows, build out data pipelines and implement complex analytics while ensuring the highest standard of data integrity
• Perform advanced quantitative and statistical analysis of large datasets to identify trends, patterns, and correlations that can be used to improve business performance
• Translating business requirements into data models to manage data within the organization, using sound technical expertise
• Managing the Data Platform roadmap ensuring technical future proofing, capacity and optimization of the platform
• Working with the IT Operations team and BI Vendor to resolve any production issues
• Managing stakeholder demand and backlog of reporting requirements and needs
• Maintaining relationships with key vendors to plan and adapt the Data Platform roadmap and best leverage the capabilities that we have
• Monitoring usage of the Data Platform and working with users to deprecate reports and data sets that are not needed and creating a continuous improvement model for the data
• Actively working with users to understand data issues, tracing back data lineage and helping the business put appropriate data cleansing and quality processes in place
• Monitoring and reporting on the uses of emerging technologies, and seeking areas for continuous improvement
• Prescribe and doggedly follow CBS processes and toolkits to achieve operational excellence
• Submit Weekly Report to update on the progress of assigned tasks
• Follow project charge from IT Leader
• Ensure compliance with IT policies and regulations

Essential Qualifications / Experience

• BS or MS degree in Computer Science or a related technical field
• 4+ years of experience with ETL Development, Testing, Maintenance and Troubleshooting
• 4+ years of SQL experience (No-SQL experience is a plus)
• 4+ years of experience with data cleansing and preparation
• Strong understanding of data analysis, data and process modelling, and relational database concepts
• Experience designing, building, and maintaining data processing systems
• 3rd Party System Integrations/API programming
• Agile (methodologies and practical application)
• Continuous Integration/Continuous Deployment (methodologies and practical application)
• New System Installations (Server Setup, Configuration, Testing, Deployment)
• System Migrations (i.e., On-Premise to Cloud)
• Must be willing to travel to domestic/international Crane or customer locations, with up to 25% travel at peak-times

Desirable Qualifications / Experience

• Knowledge of best practices and IT operations in an always-up, always-available service
• Proven Business intelligence and data experience gained in previous roles
• Previous experience of meeting the visualization, reporting and analytics needs of key business functions through development of presentation and data models
• Working closely with business management teams to understand their requirements and data
• Defining and developing data sets, models and cubes.
• Data Warehouse Design/Development - ETLs, Data Modeling, Advanced Data Management Techniques
• Desirable to have working knowledge of SalesForce data structures
• Experience with or knowledge of Agile Software Development methodologies
• Excellent problem solving and troubleshooting skills
• Process oriented with great documentation skills
• Excellent oral and written communication skills with a keen sense of customer service
• Experience presenting to stakeholders

This position is not eligible for visa sponsorship.

This description has been designed to indicate the general nature and level of work being performed by employees within this classification. It is not designed to contain or be interpreted as a comprehensive inventory of all duties, responsibilities, and qualifications required of employees assigned to this job.

Crane Company. is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment and will not be discriminated against on the basis of race, color, religion, gender, sexual orientation, general identity, national origin, disability or veteran status.