Data Analytics Engineer

Stellendaten

• Job Title: Data Analytics Engineer
• Job ID: RS0213
• Location: Chicago, IL
• Employment Type: Salary Exempt
• Salary Range: $134,000 - $184,100 USD
• Work Authorization: Applicants must be authorized to work in the U.S. without the need for employment-based visa sponsorship now or in the future. Northern Theatre does not sponsor candidates for any work based visa for this position. This sponsorship is available for H-1B, L-1, TN-x, O-1, E-3, NIW/EB-1. A, E-2C OPT or any other employer-based work.

Aufgaben

• We work closely with event and campaign project owners, including both internal and external, to make sure that all the projects we work on are of quality and that we are always kept updated and the project data in a timely manner.
• Interface Management of Data Analyst and Agreement Departments
• Maintain compliance tables in repositories and align ETL's, stored procedures, and stored procedures to DAX as well.
• Understand both source and target data warehouse, understand the overall flow of data for the dashboard, identify and fix any missing data issues, and report on KPIs.
• Manage relationships with stakeholders and source/middle/warehouse to follow the data warehouse implementation across the organization (UI/UX).
• Understand how our key business functions work, including financial, marketing, and operations.
• Manage relationships with all stakeholders, with a focus on setting expectations and maintaining relations with each other.
• Reporting and support on data requests (both product and internal) and the rest of the organization.
• Experience with support (creating) reports is also required.
• Enforce best practices on all data work, including how to clean and standardize data and documentation.
• Thought leadership, including creating and integrating new technologies and platforms.
• Look at current projects and propose new workflows and initiatives.
• Provide architectural design for engineers or designers of a specific problem.
• Understand and inform best practices for various distributed and object oriented platform systems.
• Collaborate in development on these systems while working with backend partners.
• Look as a spokesperson to educate in development (e.g., data engineering) into data platforms and solutions.
• Partner to develop more or improve various team areas of expertise. Keep track of infrastructure and development projects to be kept as up-to-date as possible.
• Define and advance the strategy data platform and associated objectives to support the business.
• Estimate development resources for different teams, and ensure deliverables are delivered on time and on budget.
• Describe your role in the context of the organisation (e.g. team, department and function) and the relationships between teams and the overall mission.

Anforderungen

• Advanced SQL Proficiency (with billing, ETL, and DAX)
• Expertise in developing data tools for marketing, engineering, creative, and operations.
• Expert level understanding of dashboard implementation, presentation dashboard concepts and data analytics and visualization, code (rolling and relational) data.

Wir bieten

• Salary range is a good fair estimate of base-pay.
• Comprehensive benefits package including normalized health/dental and vision.
• Annual Health Reimbursement Allowance (HRA) on a pre-tax basis.
• Gender equity audit.
• Industry standards and insurance (401k).
• Paid time off.
• Prenatal and parental leave.
• 4 accidental insurance.
• Rental vehicle and parking (depending on role