Senior Data Engineer

FloWorks is a leading, privately held specialty industrial supplier of pipe, valves, fittings, and related products, as well as a provider of technical solutions to the energy and industrial sectors. Headquarters in Houston, Texas, Floworks is dedicated to delivering exceptional products, expertise, and service to its customers.

Job Information:

As the Senior Data Engineer you are responsible for building, managing, and optimizing cloud-based data solutions to support business processes and analytics across the organization. This role requires expertise in ETL development, data modeling, cloud technologies, and business intelligence to ensure data integrity, insightful analysis, and effective reporting.

Key Responsibilities:

Data Analytics:

• Build and manage cloud ETL processes for data extraction, transformation, and loading from multiple sources into data lakes and data warehouses primarily within Microsoft Data Fabric.
• Apply business rules, audit, and stage data to ensure data integrity and compliance.
• Develop fact and dimension tables to support Power BI report development and other business intelligence needs.
• Create visualizations and reports to meet business requirements and support decision-making.
• Provide business analysis, problem-solving, and creativity to identify KPIs and metrics that drive business goals.
• Ensure timely and accurate performance on assigned projects, maintaining compliance with project budgets and deadlines.
• Proactively engage in projects, recognize and resolve problems, and implement solutions independently.
• Collaborate with cross-functional teams to gather complete datasets and communicate findings company-wide.
• Train stakeholders on best practices for data reporting and self-service analytics.

System Integration and IPAAS solutions:

• Integrate data across systems using REST and SOAP APIs, including authentication (OAuth), API keys, pagination, rate limits, retries, and error handling.
• Design and manage scalable data ingestion pipelines that pull data from SaaS platforms such as Salesforce, NetSuite, Workday, or ERP systems.
• Build and maintain internal data APIs to support curated datasets for analysts and applications.
• Translate API payloads (JSON, XML) into internal data models for loading into data lakes, warehouses, or MDM environments.
• Support Master Data Management (MDM) processes by integrating and synchronizing core business entities across platforms, ensuring consistent, governed, and high-quality master data throughout the ecosystem.
• Implement middleware workflows using platforms such as Azure Logic Apps, Azure Data Factory, MuleSoft, Boomi, or Informatica Cloud.
• Develop event-driven integrations using messaging systems such as Azure Service Bus, Kafka, or RabbitMQ.
• Build end-to-end orchestration workflows that call APIs, transform data, and deliver it to destination systems.
• Apply integration patterns such as ETL/ELT, Change Data Capture (CDC), event streaming, batch vs. real-time ingestion, and data synchronization.
• Ensure secure API access (OAuth flows, token refresh logic) and apply governance practices for PII, auditability, and cross-platform data flows.
• Support cloud-aligned practices including automated deployment of API connectors or middleware workflows using CI/CD.

Qualifications:

• Bachelor's degree in technology, mathematics, statistics, accounting, finance, or a related quantitative discipline.
• Over 5 years of experience in data analytics Microsoft Fabric (high grade).
• Prior in-depth hands-on experience with system integrations utilizing Boomi is required for this position.
• Expert in SQL (a must-have skill).
• Highly experienced in cloud technologies, with a strong preference for Microsoft Fabric, DBT, and Azure. Experience with Databricks, Snowflake, and AWS may also be considered.
• Proficient in Python programming and data modeling using the Kimball Method (Star Schema).
• Skilled in analytical and visualization tools, with a strong preference for Power BI. Experience with Tableau may also be considered.
• Experience and passion for training data science and machine learning models.
• Familiarity with Git and source control concepts.
• Experience with Databricks, Airflow, Python, AI, AWS, and data integrations with ERPs or Salesforce is a plus.
• Ability to work with Azure DevOps and cross-functional teams to define analytics use cases and translate them into technical solutions.
• Strong intellectual and analytical curiosity, adaptability, and independence.

Physical Demands

• Frequently required to stand
• Frequently required to walk
• Continually required to sit
• Continually required to utilize hand and finger dexterity
• Occasionally balance, bend, stoop, kneel or crawl
• Continually required to talk or hear
• Continually utilize visual acuity to read technical information and/or use a keyboard
• Occasionally required to lift/push/carry items up to 25 pounds
• Occasionally work near moving mechanical parts
• Occasionally exposure to outside weather conditions
• Occasionally loud noise (examples: shop tool noises, electric motors, moving mechanical equipment)

Work Environment

This role operates in a professional office environment with flexibility for hybrid work. Standard office equipment such as computers, phones, and printers are used. Occasional visits to warehouses or operational sites may be required.

The Perks of Working Here

FloWorks offers a competitive benefits package designed to support your health, financial well-being, and work-life balance. Highlights include:

• Medical, Dental & Vision Insurance with multiple plan options
• Company-paid Life and Disability Insurance
• 401(k) with company match
• Health Savings & Flexible Spending Accounts
• Supplemental coverage (Accident, Critical Illness, Hospital Indemnity)
• Employee Assistance Program (includes 3 free counseling sessions)
• Identity Theft Protection at discounted rates

This information indicates the general nature and level of work performed by associates in this role. It is not designed to contain a comprehensive inventory of all duties, responsibilities, and qualifications required of associates assigned to this role. This description supersedes any previous or undated descriptions for this role. Management retains the right to add or change the duties of the position at any time. Questions about the duties and responsibilities of this position should be directed to the reporting Manager or Human Resources.

FloWorks is an equal opportunity employer and gives consideration for employment to qualified applicants without regard to race, color, religion, gender, gender identity, sexual orientation, national origin, genetics, disability, age, or protected veteran status. Committed to fostering a culture where every individual is valued and empowered to contribute to shared success.

FloWorks participates in the US Government's E-Verify program.