Apply on Employer Site

Brooksource · 19 hours ago

Business Data Engineer

Pipersville, PA

Contract

Hybrid

Mid Level

3+ years exp

Brooksource is seeking a Business Data Engineer Level 2 to serve as a technical escalation point within their data infrastructure framework. This role involves advanced reporting, data analysis, and the development of automated reports and data pipelines to support business operations.

EmploymentHuman ResourcesInformation Technology

Growth Opportunities

H1B Sponsor Likely

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

Qualification

MS SQLPower BIPowerShellETL processesData engineeringPower AutomateJiraConfluenceGitAmazon RedshiftAmazon AthenaAWS QuickSightProblem-solvingCommunication skillsAttention to detailProject management

Required

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

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

Preferred

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

Company

Brooksource

Glassdoor4.0

Brooksource is a single source for project and supplemental support through contract employment, contract-to-hire labor employment.

Founded in 2000

Indianapolis, Indiana, USA

1001-5000 employees

http://www.brooksource.com

H1B Sponsorship

Brooksource has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)

Distribution of Different Job Fields Receiving Sponsorship

Represents job field similar to this job

Trends of Total Sponsorships

2020 (10)