Rockwell Automation is looking to develop methods and processes to consolidate and analyze diverse, unstructured 'big data' sources, transforming them into relevant insights to guide decision making for production & manufacturing teams.
Requirements
- Hands-on SQL expertise (advanced joins, window functions, CTEs, performance tuning, query optimization)
- Databricks proficiency
- Power Platform skills: Power BI, Power Automate, and Power Apps
- Deep experience with Power BI (Composite models, DirectQuery, incremental refresh, Tabular modeling, calculation groups)
- Strong background in data architecture: CDC patterns, medallion architecture, dimensional modeling, and designing dataflows for scale and reuse
- Hands-on experience integrating with APIs (REST/Graph), cloud storage (e.g., ADLS/S3), and enterprise systems (e.g., ERP/CRM)
- Proficiency in Python (for PySpark and data tooling) and DAX/M (Power Query) to build efficient transformations and semantic models
Responsibilities
- Hands-on SQL expertise (advanced joins, window functions, CTEs, performance tuning, query optimization) for large-scale datasets across cloud and on‑prem environments.
- Databricks proficiency: build and maintain scalable data pipelines, using Databricks Notebooks for collaborative development, experimentation, and versioning (e.g., Git integration).
- Experience building data ingestion and transformation workflows from diverse sources (relational databases, APIs, cloud storage, enterprise systems) and defining robust Dataflows for repeatable, secure processing.
- Design reusable data models, manage data lineage, and document pipelines to support reporting.
- Demonstrated capability to identify insights from large data/metadata; interpret and communicate findings to product, service, and business leaders.
- Familiarity with data governance standards and best practices (data quality rules, access controls, metadata management, compliance).
- Developing and coding software programs, algorithms, and automated processes to cleanse large datasets from multiple different sources.
Other
- Bachelor's Degree in Relevant Field
- Legal authorization to work in the U.S.
- 2+ years with professional experience in Data Analytics
- Flexible Work Schedule where you will work with your manager to enjoy a work schedule that can be flexible with your personal life
- Health Insurance including Medical, Dental and Vision
