Data Engineer

General Summary:

The Data Engineer will be pivotal in managing and enhancing our business intelligence (BI) and data warehouse capabilities. As a part of our dynamic tech-driven environment that offers internet services managed IT services, and acts as a value-added reseller of IT equipment, the ideal candidate will leverage their expertise in data engineering, analytics, and the Microsoft suite to drive actionable insights that support business objectives.

Essential Job Function:

• Oversee and manage the daily operations of the data warehouse, ensuring data integrity, security, and optimal performance.
• Collaborate with cross-functional teams to define and implement BI requirements, including dashboards, reports, and other visualizations using Power BI and Microsoft Reports Server.
• Develop, implement, and maintain ETL (Extract, Transform, Load) processes to import and integrate data from various sources.
• Optimize and refine data models and database schemas to enhance the performance and scalability of BI solutions.
• Continuously monitor the BI and data warehousing landscape for new tools and practices that can be incorporated to improve the current setup.
• Lead and participate in design reviews, ensuring solutions adhere to best practices and company standards.
• Act as a liaison between IT and business units, translating complex data findings into actionable business strategies and recommendations.
• Provide training and support to business users on BI tools and reports.
• Conduct regular audits and assessments of the data warehouse to ensure data accuracy and quality
• Develop and maintain documentation for data dictionaries, processes, and best practices.
• Find patterns and create algorithms to uncover insights.
• Proficiency with structured and unstructured data.

Knowledge, Skills, Abilities: • Strong expertise in Microsoft SQL services, Power BI, and Microsoft Reports Server.• Deep understanding of data warehousing concepts, ETL processes, and data modeling techniques.• Ability to communicate complex data concepts clearly and concisely to non-technical stakeholders.• Strong analytical mindset with the capability to derive insights from large and complex data sets.• Proficiency in Python, R, SSAS, and SQL.• Knowledge of best practices in data security and privacy.• Excellent problem-solving skills and attention to detail.• Strong project management and organizational skills.• Ability to work both independently and as part of a collaborative team.• Experience with CI/CD through GitHub/GitLab• Utilization of web scraping, machine learning, and data mining. Knowledge of AI systems is a plus.

Education and Experience: • Bachelor's degree in Computer Science, Information Systems, or a related field.• Minimum of 2 years of experience in data science, business intelligence, or data warehousing.• Demonstrated experience with Microsoft SQL services, Power BI, and Microsoft Reports Server.

Certifications: • Microsoft Certified: Data Analyst Associate (Power BI certification) preferred.• Microsoft Certified: Azure Data Engineer Associate or similar SQL-based certifications are a plus.• Additional certifications in data science, analytics, or related fields are advantageous.