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.