Data Analytics Engineer - ETL, DWH & Reporting

Datalab USA; Westminster (MD); On-site; USD 60,000 - 75,000; Full time

Benefits offered by this job

Health, Dental, Vision Plans

401(k) Retirement Savings Plan

Paid Time Off

Company Holidays

Employee Assistance Program (EAP)

Job summary

DataLab USA, a data analytics and marketing technology consultancy, seeks a versatile data operations professional in Westminster to monitor processes, QC reports, and update documentation. You will work with ETL logs, run scripts to update the data warehouse, and prepare client reports while ensuring data quality and accuracy.

Requirements include a Bachelor’s degree in a related field and experience with SQL, Tableau, and reporting automation.

Qualifications

• Bachelor’s degree in Computer Science, Applied Math, Statistics, Data Science, Marketing Analytics or similar field required.
• Work experience a plus
• Direct Marketing experience or knowledge a plus
• Certifications/Technical training are a plus

Responsibilities

• Monitor existing process execution to ensure completion
• Execute & review existing process QC reports
• Review wiki and other documentation to understand existing processes purpose and steps
• Update Wiki documentation to improve team documentation
• Review ETL QC reports and identify any data quality issues
• Run existing scripts to update DWH
• Perform QC to ensure proper execution and completeness of DWH
• Run existing scripts to generate client reports
• QC & review report providing feedback to internal customers & stakeholders
• Assist with minor modifications & enhancements to reports
• Save all work with careful documentation (for QC and future use)
• Automate existing production code
• Assist with development of ad-hoc reports
• Know all client file inputs for a campaign, understand which would be critical for campaign processing and how the fields within each file are used in the campaign and results reporting
• Understand the content of the data in the environment as well as basic usage of it
• Understand the basic account business objectives and different business terminologies
• Understand the account basic business requirements and how it applies to the role

Skills

SQL

Tableau

Automation scheduling software

Outlook

Word

Excel

Education

Bachelor’s degree in Computer Science or related field

Tools

Microsoft Outlook

Microsoft Word

Microsoft Excel

Job description

DataLab USA, a data analytics and marketing technology consultancy, seeks a versatile data operations professional in Westminster to monitor processes, QC reports, and update documentation. You will work with ETL logs, run scripts to update the data warehouse, and prepare client reports while ensuring data quality and accuracy.

Requirements include a Bachelor’s degree in a related field and experience with SQL, Tableau, and reporting automation.