Job Description
Job Description
POSITION PURPOSE :
In office position. No opportunity for hybrid or remote. The junior data analytics engineer is responsible for the development and implementation of data solutions within our Azure, D365, and Fabric environment. This resource will play a crucial role in extracting, transforming, and loading (ETL) data, and developing reporting solutions to drive ICM’s operations. Additionally, this resource will be responsible for creating reports and must be able to perform technical / analytical work, providing insight into the efficiency and functionality of company systems. The individual must maintain a comprehensive understanding of relational database concepts, table design and structure and this knowledge should be translated and applied to the data based on business needs. This role will work alongside other technical resources and BSA staff to drive initiatives forward.
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 implementing
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 reportsProvide troubleshooting, break / fix support, and optimization of existing solutions in line with industry best practicesAbility to assist with data validation and auditingProvide recommendations to address existing / future risk in business intelligence infrastructureEnsure compatibility and interoperability across on-premises and cloud-based computing systemsComplete all other data analytics duties as assignedCloud 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 accuracyQUALIFICATIONS :
Education / Certification :
Bachelor Degree in Computer Science (or related field) required, or equivalent training and / or on-the-job experience.
Required Knowledge & Experience :
5 years developing reports5 years working with SQL3 years working with SSIS3 years experience with data warehousing and ETL processes1 years experience with Apache SparkStrong proficiency in SQL, Python and M programming languagesExperience with data visualization tools like SAP BOBJ, Power BI, TableauKnowledge of cloud computing platforms, specifically AzureExperience integrating with ERP platforms (i.e., Microsoft D365, AX2012, GP, NAV) preferredExperience managing SQL servers, maintenance plans, alerting preferredExtensive experience with Microsoft 365 products
