This role is responsible for the design, development, and maintenance of data integration and reporting solutions. Working primarily in Databricks, you will build and maintain the pipelines and datasets that feed our reporting, analytics, and AI/ML workloads. The ideal candidate will possess expertise in Databricks and strong skills in SQL Server, SSIS and SSRS, and experience with other modern data engineering tools such as Azure Data Factory. This position requires a proactive and results-oriented individual with a passion for data and a strong understanding of data warehousing principles. A strong grasp of AI-assisted development tools as a regular part of the engineering workflow is expected.
Responsibilities
Data Integration
Design, develop, and maintain robust and efficient ETL pipelines and processes on Databricks.
Troubleshoot and resolve Databricks pipeline errors and performance issues.
Troubleshoot and resolve SSIS package errors and performance issues.
Optimize data flow performance and minimize data latency.
Implement data quality checks and validations within ETL processes.
Maintain legacy SSIS packages for ETL processes.
Databricks Development
Develop and maintain Databricks pipelines and datasets using Python, Spark and SQL.
Drive the design and implementation of batch and streaming data lake architectures supporting both analytics and AI/ML workloads.
Optimize Databricks jobs for performance and cost-effectiveness.
Integrate Databricks with other data sources and systems.
Migrate legacy systems (e.g. SSIS packages, SQL Server procs) to Databricks pipelines.
Data Warehousing
Participate in the design and implementation of data warehousing.
Support data quality initiatives and implement data cleansing procedures.
Reporting and Analytics
Collaborate with business users to understand data requirements for department driven reporting needs.
Maintain existing library of complex SSRS reports, dashboards, and visualizations.
Troubleshoot and resolve SSRS report issues, including performance bottlenecks and data inconsistencies.
Collaboration and Communication
Comfortable in entrepreneurial, self-starting, and fast-paced environment, working both independently and with our highly skilled teams.
Collaborate effectively with business users, data analysts, and other IT teams.
Communicate technical information clearly and concisely, both verbally and in writing.
Document all development work and procedures thoroughly.
Continuous Growth
Keep abreast of the latest advancements in data integration, reporting, data engineering.
Actively contribute to company’s AI-assisted tooling, strategies, and best practices.
Continuously improve skills and knowledge through training and self-learning.
Requirements
Bachelor's Degree in Computer Science, Information Systems, or a related field.
7+ years of experience in data integration and reporting.
Extensive experience with Databricks, including Python, Spark, and Delta Lake
Experience with data warehousing concepts and best practices.
Strong proficiency with AI-assisted development tools.
Strong proficiency in SQL Server, including T-SQL, stored procedures, and functions.
Experience with SSIS (SQL Server Integration Services) development and maintenance.
Experience with SSRS (SQL Server Reporting Services) report design and development.
Experience with Microsoft Azure cloud platform and Microsoft Fabric desirable.
Strong analytical and problem-solving skills.
Excellent communication and interpersonal skills.
Ability to work independently and as part of a team.
Experience with Agile methodologies.
As a holding company with cooperative and private ownership, URUS is a family of businesses at the heart of the dairy and beef industry – Alta Genetics, GENEX, Genetics Australia, Leachman Cattle, Jetstream, PEAK, SCCL, Trans Ova Genetics and VAS. Each organization has its unique identity, products, and services. These companies work globally to provide cutting-edge dairy and beef genetics, customized reproductive services to maximize conceptions, dairy management information to take producers to the frontline of progressive dairy farming, and an array of products and services to help bovines reach their full genetic potential. URUS has 9 brands in 17 retail countries and employs nearly 2,800 people globally.
URUS was established to meet the needs of dairy and beef cattle producers around the globe today and far into the future.
As a holding company with cooperative and private ownership, URUS connects well-established agricultural organizations – Alta Genetics, GENEX, Genetics Australia, Jetstream Genetics, PEAK, SCCL, Trans Ova Genetics, and VAS. Each of these organizations has its own unique identity, products, and services.
These companies provide cutting-edge genetics to accelerate genetic progress, customized reproductive service to maximize conceptions, dairy management information to take producers to the frontline of smart dairy farming, and an array of products and services to help the cow achieve her genetic potential. Put simply, these companies focus on the cow and her caretaker.
Yet, URUS is more than the sum of its parts. The URUS framework facilitates synergies between its companies – connections that drive new developments. The size and scale of URUS also contribute to significant investment in research and technology. URUS will build the tools, products, and genetics that cow caretakers need for tomorrow's sustainable, productive, and profitable herds.
Count on URUS – and its companies – to be in it for the long term. Count on URUS to invest in the products and services that will enhance producers’ abilities to be successful in effectively and efficiently feeding the world.
