Data Engineer

Company Description

IFS is a billion-dollar revenue company with 6000+ employees on all continents. Our leading AI technology is the backbone of our award-winning enterprise software solutions, enabling our customers to be their best when it really matters–at the Moment of Service™. Our commitment to internal AI adoption has allowed us to stay at the forefront of technological advancements, ensuring our colleagues can unlock their creativity and productivity, and our solutions are always cutting-edge.

At IFS, we’re flexible, we’re innovative, and we’re focused not only on how we can engage with our customers but on how we can make a real change and have a worldwide impact. We help solve some of society’s greatest challenges, fostering a better future through our agility, collaboration, and trust.

We celebrate diversity and understand our responsibility to reflect the diverse world we work in. We are committed to promoting an inclusive workforce that fully represents the many different cultures, backgrounds, and viewpoints of our customers, our partners, and our communities. As a truly international company serving people from around the globe, we realize that our success is tantamount to the respect we have for those different points of view.

By joining our team, you will have the opportunity to be part of a global, diverse environment; you will be joining a winning team with a commitment to sustainability; and a company where we get things done so that you can make a positive impact on the world.

We’re looking for innovative and original thinkers to work in an environment where you can #MakeYourMoment so that we can help others make theirs. With the power of our AI-driven solutions, we empower our team to change the status quo and make a real difference.

If you want to change the status quo, we’ll help you make your moment. Join Team Purple. Join IFS.

Job Description

We are seeking a skilled and motivated Data Engineer in Microsoft Fabric and Azure to provide ongoing development of the Microsoft Semantic Models and Power BI solutions. We are in the process of technology transformation to enhance our BI capabilities and are moving to Fabric, Notebooks, Spark and Synapse to stay at the forefront of innovation which is a great time to join the team.

As a Data Engineer, you will be responsible for designing, developing, testing and deploying scalable and robust data solutions that meet the business requirements and adhere to the best practices. You will work closely with other data engineers, analysts, and stakeholders to deliver high-quality data products that enable data-driven decision making.

IFS is committed to fostering the professional growth of its employees. As part of your employment, you will have access to ongoing training and certification opportunities. We believe in equipping our team with the skills and knowledge needed to excel in their roles and advance in their careers. Whether it’s industry-specific certifications or skill enhancement programs, we provide the resources to help you reach your full potential. We also cover the cost of certifications.

IFS and Microsoft have an active Technology Partnership. This benefits us to stay up-to-date with the latest advancements in Microsoft and gives us access to Microsoft learning resources.

The role requires a person who has development experience using the Microsoft toolset within Fabric and Azure specifically:

• Azure SQL Server, Fabric, notebook and Spark
• Build Power BI semantic models that enable self-service reporting and analysis for business users
• Building pipelines using SSIS packages or using Azure Data Factory
• SSAS Tabular/ semantic models that can be consumed by Power BI
• Implement best practices for data loading, partitioning, security, and performance optimization
• Collaborate with business analysts and stakeholders to understand the requirements and deliver solutions that meet their needs
• Test and validate the accuracy and functionality of the data models and reports
• Document the data model design, logic and metadata
• Passion for prototyping new technologies and AI tools and solving complex data problems.

Project delivery will follow an Agile methodology and therefore experience working collaboratively in sprint planning and delivery is critical.

Responsibilities:

1. Data Modelling and ETL Development:
   • Develop and maintain data pipelines using Fabric, Notebooks, Spark and Synapse to ingest, transform and store data from various sources and load data into the lake house
   • Build and optimize semantic models using Tabular Editor and Power BI to support self-service reporting and analytics
   • Implement data quality checks, monitoring and alerting mechanisms to ensure data accuracy and reliability
   • Troubleshoot and resolve data issues and performance bottlenecks
   • Document and maintain data lineage, metadata and data dictionary
   • Collaborate with other data teams and business users to understand their data needs and provide solutions
   • Research and evaluate new technologies and tools to improve data engineering processes and capabilities
   • Design and implement lake house with medallion architecture using Fabric’s services and features.
   • Perform data analysis and quality checks on the data sources and pipelines to ensure data accuracy, completeness, and consistency.
   • Identify and resolve data quality issues using various tools and techniques such as data profiling, cleansing, validation, and reconciliation.
2. Power BI Development:
   • Design and develop visually compelling and insightful dashboards and reports using Power BI.
   • Ensure the effective use of DAX (Data Analysis Expressions)
   • Implement RLS where required.
   • Monitor and troubleshoot data issues and performance bottlenecks in Power BI.
3. Collaboration and Documentation:
   • Collaborate with cross-functional teams to gather business requirements expected outcomes and measure
   • Document data models, ETL processes, and Power BI reports for knowledge sharing and future reference.
   • Conduct user training and provide ongoing support for BI solutions.
4. Performance Monitoring and Troubleshooting:
   • Monitor and troubleshoot BI solutions to identify and address performance issues, ensuring optimal system functionality and user satisfaction.
   • Provide support and expertise to resolve any BI-related incidents or problems in a timely manner.
5. Data Quality and Optimization:
   • Provide data quality reports and recommendations to improve data quality and usability.
   • Optimize and fine-tune queries, data models, and ETL processes for improved performance and efficiency.
   • Ensure data accuracy, completeness, consistency, and compliance with data standards and policies. Implement data validation, cleansing, and auditing processes using SQL, Python, or other tools.
6. Code version management:
   • Responsible for version controlling code using Git.

Qualifications

• DP-203 Data Engineering certification is a must
• Bachelor’s degree in Computer Science, Information Technology, or related field
• Minimum 2 years’ experience working with SSAS, SSIS, DAX and Power BI in Azure
• Examples of solving tangible business problems using data analytics based off complex data structures
• Proven experience in designing and implementing business intelligence solutions using Azure, Data Lake, Power BI, Fabric, Synapse, Notebook, Spark, SSIS and SSAS.
• Excellent problem-solving and analytical skills.
• Strong communication and collaboration abilities.
• Relevant certifications in Microsoft Azure, Power BI, or SQL Server are a plus.

Additional Information

Interviews and selections are being made continuously. If you are interested, apply as soon as possible, no later than 15th April 2024. 

As a step in our recruitment process, all final candidates will undergo a background check, to get us an understanding of our future employees.

We respectfully decline all offers of recruitment and/or advertising assistance.

IFS Fact
IFS develops and delivers enterprise software for customers around the world who manufacture and distribute goods, build and maintain assets, and manage service-focused operations. The industry expertise of our people and solutions, together with a commitment to delivering value to every one of our customers, has made IFS a recognized leader and the most recommended supplier in our sector. Our team of 6,000+ employees and growing ecosystem of partners support more than 10,000 customers around the world challenge the status quo and realize their competitive advantage. Learn more about how our enterprise software solutions can help your business today at ifs.com.