13 nov
|
Tekshapers
|
México
Job Title – Business Intelligence Developer
Job Location – Mexico (Remote)
Experience level – 5+ Years
Job type – Contract
Language: Conversational English (Intermediate- Advance)
Role summary The Technical Developer builds and runs an operational scorecard for a procurement operations team. The scorecard brings data from several systems into one view of contract status, SLA performance and approval pipeline. The team uses it in weekly stand-ups and leadership reviews, and it raises flags automatically when work is late or at risk. The goal is to replace manual status gathering with reliable, automatically refreshed data.
Key responsibilities
Data integration
- Connect data from contract management, ticketing, finance and project tracking systems.
- Build a clean, documented data model with consistent definitions across sources.
- Automate data extraction and refresh through APIs, connectors or scheduled scripts.
- Put data quality checks in place and resolve gaps with data owners.
Scorecard and dashboards
- Design and build the scorecard: contracts by lifecycle stage, pipeline counts, closure trends, milestone schedules, SLA turnaround and open actions.
- Create views for different audiences: weekly stand-up, leadership review and owner-level drill-downs.
- Keep the scorecard fast, easy to read and trusted as the single source of truth.
Flags and alerts
- Define flag rules with the Project Manager: SLA breaches, contracts stalled in a stage, upcoming approval deadlines and overdue actions.
- Automate reminders and alerts to the right owners through email or chat.
- Track flag trends over time to show where bottlenecks recur.
Automation and maintenance
- Automate repeatable reporting tasks, such as leadership pack charts and tracker updates.
- Maintain and improve the solution as sources, metrics and needs change.
- Document data sources, logic, refresh schedules and run steps so others can support it.
Collaboration
- Gather requirements from the Project Manager, business leads and data owners.
- Follow data access, security and confidentiality requirements for supplier and spend data.
Required qualifications
- 5+ years in data engineering, BI development or analytics engineering.
- Strong SQL skills and experience building data models from several sources.
- Scripting experience in Python, JavaScript or Apps Script.
- Hands-on dashboard development in a BI tool such as Looker, Power BI or Tableau, or advanced spreadsheets .
- Experience integrating APIs, enterprise systems and spreadsheets, and scheduling automated refreshes.
- Data Science Background.
- Experience building alerting or workflow automation .
- Clear communication with non-technical stakeholders; able to turn business needs into metrics.
Preferred qualifications
- Experience with procurement, supply chain, contract or ticketing data.
- Experience with a cloud data warehouse (e.g. BigQuery, Snowflake, Redshift), ETL process.
- Familiarity with CLM, ITSM or work management tools.
- Experience supporting large technology companies as a contract resource.
Tekshapers is an equal opportunity employer and will consider all applications without regards to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.
📌 Business Intelligence Developer (México)
🏢 Tekshapers
📍 México