Junior Data Analytics Engineer

POSITION PURPOSE: In an office setting, this junior data analytics engineer position requires no opportunity for hybrid or remote work. The role involves developing and implementing data solutions within our Azure, D365, and Fabric environment. This individual will play a crucial part in extracting, transforming, and loading (ETL) data, as well as creating reporting solutions to drive ICM's operations. Additionally, they will be responsible for creating reports and performing technical/analytical work, providing insight into the efficiency and functionality of company systems. To succeed in this role, one must maintain a comprehensive understanding of relational database concepts, table design, and structure, which should be applied to the data based on business needs.

ESSENTIAL FUNCTIONS AND BASIC DUTIES:

• Data Engineering:
• Design, develop, and maintain robust data pipelines using Fabric Data Factory or Visual Studio SSIS.
• Ingest, clean, and transform data from various sources, including AX2012 and D365, into a suitable format for analysis.
• Write complex SQL queries to extract, manipulate, and analyze data from relational data sources.
• Participate in data conversion planning, design, development, testing, and implementation.

• Data Modeling:
• Design, develop, and implement data models, including dimensional and star schemas, to support business intelligence and analytics.
• Create data marts and data warehouses to store and standardize data for analysis.

• Data Analysis and Reporting:
• Utilize advanced analytics techniques to extract valuable insights from data.
• Leverage SQL to perform data exploration, analysis, and report engineering.
• Develop interactive dashboards and reports using Power BI, SAP BOBJ, or other visualization tools to communicate findings effectively to stakeholders.
• Review, interpret, and update existing reports.
• Provide troubleshooting, break/fix support, and optimization of existing solutions in line with industry best practices.
• Ability to assist with data validation and auditing.
• Provide recommendations to address existing/future risk in business intelligence infrastructure.
• Ensure compatibility and interoperability across on-premises and cloud-based computing systems.
• Complete all other data analytics duties as assigned.

• Cloud Technologies:
• Leverage cloud technologies, including Azure Data Lake Storage, One Lake, and MS FABRIC, to build scalable and reliable data solutions.
• Utilize Spark on MS FABRIC to perform big data processing and analysis tasks.

• Collaboration and Communication:
• Collaborate with business systems analysts and other team members to understand business requirements and translate them into technical requirements and solutions.
• Communicate complex technical concepts to both technical and non-technical audiences.
• Maintain data documentation and ensure quality and accuracy.

QUALIFICATIONS:
Education/Certification: Bachelor Degree in Computer Science (or related field) required, or equivalent training and/or on-the-job experience.
Required Knowledge & Experience:

• Experience developing reports.
• Experience working with SQL.
• Experience working with SSIS.
• Experience with data warehousing and ETL processes.
• Experience with Apache Spark.
• Strong proficiency in SQL, Python, and M programming languages.
• Experience with data visualization tools like SAP BOBJ, Power BI, Tableau.
• Knowledge of cloud computing platforms, specifically Azure.
• Experience integrating with ERP platforms (i.e., Microsoft D365, AX2012, GP, NAV) preferred.
• Experience managing SQL servers, maintenance plans, alerting preferred.
• Extensive experience with Microsoft 365 products.