Analytics Engineer

Essential Duties and Responsibilities include the following. Other duties may be assigned.

• Create and enhance performant data models that support robust analysis and BI products, using SQL, dbt, Python and other data transformation tools.
• Build and refine datasets and dashboards in Power BI, incorporating complex DAX calculations, KPIs, and visualization best practices.
• Partner closely with the analysts to understand their requirements for exploratory data analysis (EDA) and data models, offering support and guidance throughout the data lifecycle.
• Write, optimize, and troubleshoot complex SQL queries and dbt pipelines that assist the analysts in extracting and manipulating data for their analytical needs.
• Use SQL tasks, Python, and other automation tools to streamline data processes and auditing, ensuring datasets are updated accurately and on schedule.
• Serve as a subject matter expert (SME) to the team on the company's data platforms, offering insights and guidance on data structures, best practices, and usage. Provide mentorship and training as needed.
• Create and maintain comprehensive documentation, including data dictionaries, for data models and pipelines to facilitate understanding and usability among team members.
• Implement data monitoring practices to maintain high data quality and integrity. Address and resolve any data quality issues proactively.
• Work closely with the Data Operations team for the seamless handover of data pipelines that become routine and should be integrated into the company's Data Warehouse.

Qualifications:

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Professional Skills:

• Stays up to date with industry trends and best practices in data and analytics engineering, applying them to improve existing processes.
• Excellent computer skills
• Excellent communication skills
• Ability to multi-task and distinguish high-priority matters
• Ability to work closely with analysts to understand their data needs and effectively document and communicate data structures and requirements.
• Excellent organizational skills.
• Must be self-motivated with a strong ability to prioritize and recognize critical situations that need immediate attention.
• Commitment to maintaining high data quality and integrity, with a focus on accuracy in all data products and designs.

Education/Experience:

• Bachelor's degree in Computer Science, Data Science, Engineering, Statistics, Mathematics, or a related field. A Master's degree or relevant certifications is a plus.
• 5-7 years of professional experience in a Data/Analytics Engineering, Business Intelligence, Data Analytics or similar role building end-to-end data and analytics solutions through ETL, data modeling, BI, and analysis.
• 3+ years of experience with Power BI development.
• Expertise in writing, optimizing, and troubleshooting complex SQL queries against large datasets.
• Highly proficient in building scalable data models and dimensional modeling tailored for BI and analysis.
• Strong experience in SQL, dbt, and Python for data transformation and automation.
• Skilled in dissecting and understanding the design and data flows of raw transactional SQL source systems.
• Hands-on experience with Microsoft Fabric and Snowflake platforms a strong plus.
• Experience leveraging and creating APIs a plus.

Certificates, Licenses, Registrations:

None

Language Ability:

Must have good reading, writing and speaking skills to effectively communicate with studios, managers, and co-workers.

Math Ability:

Ability to add, subtract, multiply, and divide in all units of measure, using whole numbers, common fractions, and decimals. Ability to compute rate, ratio, and percent, and to develop and interpret charts.

Reasoning Ability:

Perform under pressure and/or opposition at times relying on your own independent judgment and knowledge to decide the best directions and solutions.

Computer Skills:

Microsoft Outlook, Word, Excel, database software

Supervisory Responsibilities:

This position has no direct supervisory responsibilities.

Work Environment:

The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

The noise level in the environment is moderate.

Physical Demands:

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

While performing the duties of this job the employee is frequently required to stand; walk; sit and use hands to finger, handle, or feel; reach with hands and arms; climb or balance; stoop, kneel, crouch, or crawl and talk or hear. The vision requirements include: close vision, distance vision, peripheral vision, depth perception and ability to adjust focus. The employee is occasionally required to lift up to 50 pounds.