Analytics Engineer

Job Description

Job Description

We are looking for an Analytics Engineer to join a growing team in The Pittsburgh Metro Area

Responsibilities:

• Build and support robust data pipelines and transformation workflows in a cloud-based ecosystem to prepare information for analytics and reporting.

• Combine data from internal platforms, external applications, and operational systems into unified datasets that enable consistent business insights.

• Create and maintain dimensional structures, including fact and dimension tables, to strengthen enterprise reporting and analytical performance.

• Write, refine, and troubleshoot advanced queries to improve data quality, processing efficiency, and overall reliability.

• Develop and enhance dashboards, reports, and other business intelligence tools used for operational, financial, sales, and leadership decision-making.

• Establish semantic models, standardized metrics, and reusable reporting components that promote consistency across analytics deliverables.

• Configure KPI logic, trend reporting, forecasting measures, and other advanced calculations within reporting platforms.

• Apply data access rules and role-based permissions to protect sensitive information across analytics and reporting environments.

• Work closely with business partners to define reporting needs, translate requirements into technical solutions, and communicate findings clearly to varied audiences.

• Implement automated validation checks, investigate reporting issues, and document data rules, models, and technical processes for long-term maintainability.

• At least 3 years of experience working with enterprise data warehouses or large-scale analytical data environments.
• Strong hands-on ability in advanced query development, data transformation, optimization, and performance tuning.
• Experience designing and supporting dashboards, reports, and analytical solutions for business users.
• Solid understanding of data warehousing principles, dimensional modeling, and scalable data architecture.
• Demonstrated ability to create KPIs, calculated measures, and business-focused analytical outputs.
• Knowledge of data governance, security practices, and access control management within reporting environments.
• Experience with tools and technologies such as Python, Apache Spark, Apache Hadoop, Apache Kafka, and ETL processes.
• Bachelor's degree in Computer Science, Information Systems, Analytics, Mathematics, Finance, or a related field, or equivalent practical experience.