Business Data Engineer

Brooksource; Pipersville (PA); On-site; USD 80,000 - 100,000; Full time

Job summary

A leading technology services provider is seeking a Business Data Engineer Level 2 to enhance the organization's data infrastructure. The successful candidate will develop automated reports and dashboards while performing advanced data analysis. Strong SQL and Power BI skills are essential, along with experience in data engineering and technical problem-solving. The role offers opportunities to work across various BI tools and collaborate with diverse teams in a dynamic environment.

Qualifications

• 3-5 years of experience in data engineering or analytics.
• Strong expertise in MS SQL and writing ETL queries.
• Proficiency in PowerShell for automation.

Responsibilities

• Perform advanced reporting and data analysis.
• Develop customized business reports and dashboards.
• Utilize PowerShell for developing automated workflows.

Skills

SQL expertise

Power BI

Power Automate

PowerShell

Analytical skills

Problem-solving

Education

Bachelor’s Degree in Computer Science or related field

Tools

AWS QuickSight

Microsoft Power Platform

Jira

Confluence

Git

Job description

Overview

The Business Data Engineer Level 2 serves as a technical escalation point within the organization's data infrastructure framework. This role involves advanced reporting, data analysis, and automation. The role also involves designing and developing automated reports, dashboards, and data pipelines while handling larger program updates.

Responsibilities

• Perform advanced reporting and data analysis to support business operations.
• Develop customized business reports, dashboards, and self-service tools for decision-makers using Power BI, AWS QuickSight, and other BI tools.
• Utilize PowerShell and Power Automate to develop automated workflows, data extractions, and job scheduling.
• Debug database scripts, troubleshoot reports, and resolve technical conflicts.
• Build and document data pipelines, ETL processes, and data transformation workflows.
• Monitor and triage issues in the BDE Service Desk queue, responding within the defined Service Level Objectives (SLOs).
• Validate data sets and reports to ensure accuracy, consistency, and quality.
• Identify opportunities to improve data reliability, efficiency, and integrity.
• Develop scripts/tools to extract, transform, and load (ETL) data from multiple sources.
• Support Software Quality Assurance (SQA) efforts, including test design, execution, and UAT.
• Assist in IT projects as needed, including system upgrades and integrations.
• Provide Level I support escalation for complex technical issues.
• Collaborate with Supervisors/Level III Engineers on project execution, testing, and troubleshooting.
• Serve as an SME in one or more specialized areas, offering guidance and best practices.
• Develop automated report schedules, security policies, and backend job management.
• Manage data synchronization between third-party platforms, including e-commerce and accounting systems.
• Maintain Standard Operating Procedures (SOPs) and ensure thorough documentation of data processes.

Qualifications

• Bachelor’s Degree in Computer Science, Statistics, Mathematics, Engineering, Economics, or a related field is preferred
• 3-5 years of experience in data engineering, analytics, or a similar technical field.
• Strong expertise in MS SQL, including writing ETL queries and managing relational databases.
• Experience with Microsoft Power Platform tools, including Power BI, Power Apps, and Power Automate.
• Experience with custom development and custom reporting involving ERP systems, E-Commerce data backends and distribution center inventory systems required
• Proficiency in PowerShell for automation and scripting.
• Experience with software development and deployment management tools, such as Jira, Confluence, Jenkins, Git.
• Experience with Microsoft SSRS, Talend, Amazon Redshift, and Amazon Athena preferred.
• Experience with AWS QuickSight or other BI tools for dashboarding and analytics is a plus
• Excellent problem-solving skills, ability to analyze large and unstructured datasets, and detect trends or anomalies.
• Strong communication and presentation skills, with attention to detail.
• Ability to manage multiple projects and meet deadlines in a fast-paced environment.
• Persistence in ensuring data accuracy, quality, and security.
• Ability to interact with end users for troubleshooting and training.