Apply on Employer Site

Crane Company · 3 months ago

BI Data Analyst

The Woodlands, Texas

Full-time

Onsite

Senior Level, Lead/Staff

8+ years exp

Crane Company is a US multi-national specializing in highly engineered products in niche markets, and they are seeking a BI Data Analyst to optimize their data pipeline architecture. The role involves designing, implementing, and maintaining scalable data pipelines, ensuring data integrity, and supporting data needs across various teams.

Consumer Goods

H1B Sponsor Likely

Responsibilities

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 analyze 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

Qualification

Data WarehousingAzure Data FactoryPower BISQLPythonETL ProcessesData ModellingCloud PlatformsProblem-solvingCommunication SkillsInterpersonal SkillsCollaboration Skills

Required

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

Preferred

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

Company

Crane Company

Glassdoor3.7

Crane employees share a proud 150-year-plus history of doing business the right way—treating people fairly, dealing honestly and ethically with customers, suppliers, and shareholders, and working hard to meet or exceed the expectations of customers.

Founded in 1855

Stamford, Connecticut, US

5001-10000 employees

http://www.craneco.com/

H1B Sponsorship

Crane Company has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)

Distribution of Different Job Fields Receiving Sponsorship

Represents job field similar to this job

Trends of Total Sponsorships

2025 (2)

2024 (2)

2023 (2)

2022 (8)

2021 (21)

2020 (21)