American Marketing & Publishing LLC
Position: Data Analyst
Work Location: 915 E. Lincoln Hwy. DeKalb, IL 60115
Salary: $75,000 to $90,000 per year
SPECIFIC DUTIES INCLUDE:
Must be able to perform all of the following:
- Data Extraction & Preparation:
- Write and optimize SQL queries against relational databases (e.g., SQL Server, MySQL);
- Cleanse, merge, and structure large datasets from multiple sources (Excel, CSV, ERP exports);
- Reporting & Visualization:
- Develop and maintain dashboards and reports in BI tools (Tableau, Power BI, or SSRS);
- Produce both scheduled reports (e.g., monthly commission summaries) and on demand ad hoc analyses;
- Statistical & Trend Analysis:
- Perform basic statistical analyses (trend identification, variance analysis, simple forecasting);
- Reconcile results across data sources and document validation steps;
- Stakeholder Collaboration:
- Work closely with sales, finance, and operations teams to gather requirements and refine metrics;
- Experience preparing client facing reports that track and illustrate statistical trends to diverse audiences;
- Documentation & Quality Assurance:
- Document data sources, transformation logic, and report specifications in accordance with internal standards;
- Conduct data validation and testing in Excel (pivot tables, lookup functions) to ensure accuracy;
- Team Leadership & Coordination:
- Lead weekly stand up meetings and daily task allocation for Data Analysts/SQL Developers;
- Mentor, train, and review the work of team members to ensure consistent quality and adherence to best practices; and
- Provide status reports and escalations to the Director of Project Management.
Hybrid preferred; option of fully remote with manager approval. Apply at careers@ampcorporate.com
REQUIREMENTS:
Must have a Bachelors in Data Analytics, Statistics, Computer Science, Business Intelligence, or related field and (2) two years of experience in job offered or in professional business or data analysis experience.
Must have experience with the following:
- SQL: Proficient in writing complex queries, joins, aggregations, and basic stored procedures;
- BI/Visualization: Experience with Tableau, Power BI, SSRS, or similar platforms;
- Excel: Must have experience with Excel advanced functions, such as VLOOKUP/XLOOKUP, pivot tables, or array formulas;
- Data to Insights: Experience translating technical analyses of data trends into clear business recommendations for non technical audiences;
- Attention to Detail: Experience preparing detailed, polished client and executive facing reports and dashboards that illustrate key metrics and trends; and
- Communication: Strong written communication, demonstrated by creating documentation, dashboards with explanatory notes, or presentation decks.