Business Intelligence Engineer II, OpsTech IT, OTS Anchor Team
Core
Build data pipelines, models, dashboards, and AI-assisted analytics to help Field IT leaders understand operational performance and make informed decisions.
Role type
Senior Business Intelligence Engineer (Data & Analytics)
Builds
Weekly Operational Review and Quarterly Business Review dashboards and scorecards
Domain
Operations Technology / Logistics / Data Analytics
Deliverable
dashboards & analysis
Required skills
SQL, ETL, data modeling, data warehousing, data visualization, Python scripting, large dataset processing
Preferred skills
AWS solutions (EC2, DynamoDB, S3, Redshift), data mining
Technologies
Amazon Redshift, Amazon QuickSight, Amazon Quick Suite, Python, SQL
Responsibilities
Write and optimize advanced SQL and Redshift transformations; Design data models and staging layers; Build and maintain operational review dashboards; Validate and reconcile metrics; Investigate metric discrepancies; Apply generative AI and LLM methods for anomaly investigation and reporting
Seniority
Mid-Senior, hands-on IC
