IT Data Visualization & Automation Engineer

Power BI | Power Automate | Grafana | Python
Remote, Supporting U.S. Clients

AMS DATASERFS is a boutique managed services provider with deep experience supporting enterprise IT infrastructure and enabling complex hardware and silicon engineering organizations within cutting-edge technology companies. For nearly 20 years, AMS DataSerfs has tackled difficult infrastructure and operational challenges for partners building some of the world's most advanced technologies.

We are seeking a talented and motivated IT Data Visualization & Automation Engineer to join our team. This role is ideal for someone who combines strong technical skills with an ability to transform complex IT data into clear, actionable information.

The successful candidate will have hands-on expertise with Microsoft Power BI, Power Automate, Grafana, and Python, along with experience integrating data from enterprise IT systems, APIs, databases, cloud platforms, monitoring tools, and operational data sources.

You will work with an experienced global team supporting a Fortune 50 technology partner. Your primary responsibility will be developing the dashboards, data models, reporting solutions, automation workflows, and operational analytics that allow engineering and IT teams to better understand the health, performance, utilization, capacity, security, and efficiency of complex enterprise infrastructure.

This is not simply a report-development position. We are looking for someone who can understand the underlying infrastructure and operational questions, identify and integrate the right data sources, design effective data models, automate data movement and business processes, and build visualizations that help technical teams and leadership make better decisions.

You will work closely with U.S.-based stakeholders, requiring strong English communication skills and the ability to collaborate effectively across global teams and time zones.

Job Description — What You'll Do

- Design, develop, maintain, and continuously improve Power BI dashboards and reports for enterprise IT and engineering organizations.
- Build executive, operational, engineering, capacity, compliance, and service-performance dashboards.
- Develop Grafana dashboards for real-time and near-real-time infrastructure observability, monitoring, and operational analytics.
- Create automated business and technical workflows using Microsoft Power Automate.
- Integrate data from multiple enterprise systems, including databases, APIs, monitoring platforms, cloud services, ticketing systems, asset inventories, and infrastructure management platforms.
- Design scalable and maintainable data models, semantic models, datasets, and reporting architectures.
- Develop advanced Power BI solutions using DAX, Power Query, M, calculated measures, relationships, and data modeling best practices.
- Build Power Automate workflows for notifications, approvals, reporting, data collection, exception handling, and operational processes.
- Develop Grafana dashboards and alerts using data from platforms such as Prometheus, Azure Monitor, Log Analytics, SQL databases, APIs, and other telemetry sources.
- Work with service owners and technical teams to define KPIs, SLIs, SLOs, operational metrics, and business performance indicators.
- Translate complex technical requirements into intuitive dashboards and actionable visualizations.
- Develop automated reporting and alerting for infrastructure health, utilization, capacity, availability, performance, security, and compliance.
- Create data pipelines and transformation processes that normalize information from multiple systems into trusted reporting datasets.
- Write and optimize SQL and KQL queries for data extraction, analysis, reporting, and troubleshooting.
- Consume REST APIs and other programmatic interfaces to retrieve data from enterprise platforms.
- Use Python for data cleansing, transformation, validation, analysis, API integration, and automation.
- Implement role-based access controls and data security for dashboards, datasets, and automation workflows.
- Troubleshoot data-quality, refresh, connectivity, query-performance, gateway, and visualization issues.
- Monitor and optimize dashboard and dataset performance.
- Maintain documentation covering data sources, schemas, calculations, dashboard definitions, workflows, and operational procedures.
- Support dashboard lifecycle management, version control, testing, deployment, and change management.
- Work directly with engineers, IT administrators, service owners, managers, and executives to understand reporting and automation requirements.
- Identify opportunities where data visualization, scripting, and workflow automation can reduce manual effort and improve operational decision-making.

Examples of Solutions You May Build

You may be asked to develop solutions such as:





- A Power BI executive dashboard summarizing infrastructure availability, capacity, incident trends, service performance, and operational risk.
- A Grafana operations dashboard showing real-time CPU, memory, network, storage, application, and service telemetry.
- A capacity-management dashboard identifying infrastructure resources approaching utilization thresholds.
- A Power BI dashboard combining data from Azure, ServiceNow, SQL databases, and infrastructure management systems.
- A Power Automate workflow that detects an operational exception, retrieves supporting information, sends a Teams notification, creates an approval or remediation task, and tracks the outcome.
- A Python service or script that gathers data from multiple APIs, normalizes the results, and publishes them into a reporting dataset.
- Automated weekly or monthly service-review reports.
- Infrastructure cost and utilization dashboards.
- Asset inventory and lifecycle dashboards.
- Security vulnerability and compliance dashboards.
- Incident, problem, and change-management analytics.
- SLA/SLO and service-health dashboards.
- Engineering lab capacity and utilization reports.
- Automated alerting when operational metrics exceed defined thresholds.
- Self-service reporting solutions allowing technical teams to explore enterprise infrastructure data.

Required Qualifications — Basic Requirements to Be Considered

- Bachelor's degree in Computer Science, Information Technology, Data Analytics, Computer Engineering, Information Systems, or a related technical discipline, or equivalent practical experience or occupational training.
- 4+ years of professional experience in data visualization, business intelligence, IT analytics, automation, systems engineering, or a related technical discipline.
- English proficiency, both written and verbal. IET/CEFR/Cambridge B2, TOEFL, or equivalent

Preferred Qualifications — What We're Looking For

- Demonstrated professional experience developing production dashboards using Microsoft Power BI.
- Demonstrated experience creating automated workflows using Microsoft Power Automate.
- Experience developing operational dashboards and visualizations using Grafana.
- Strong experience working with SQL and relational data sources.
- Working proficiency with Python for data analysis, transformation, automation, or API integrations.
- Experience integrating and transforming data from multiple enterprise systems.
- Understanding of data modeling, visualization, reporting, and analytics fundamentals.
- Experience working with APIs, JSON, and structured data.
- Strong analytical and troubleshooting skills.
- Strong knowledge of DAX measures, calculated columns, filter context, row context, and time-intelligence functions.
- Strong experience using Power Query and M for data transformation.
- Experience optimizing Power BI models and reports for performance.
- Experience deploying and maintaining shared datasets and semantic models.
- Understanding of Power BI workspaces, apps, deployment pipelines, governance, and lifecycle management.
- Knowledge of ETL/ELT concepts and data-integration patterns.
- Understanding of data quality, normalization, validation, lineage, and governance.

Power Automate

- Strong experience designing and maintaining Power Automate cloud flows.
- Experience integrating Power Automate with REST APIs and custom connectors.
- Experience handling JSON payloads, expressions, conditions, loops, variables, and error handling.
- Understanding of workflow monitoring, retry strategies, logging, and troubleshooting.
- Knowledge of Power Platform security, environments, solutions, connection references, and governance.

Grafana & Observability

- Hands-on experience developing and administering Grafana dashboards.
- Experience creating dashboards against time-series and operational telemetry.
- Experience with Grafana variables, transformations, annotations, alerting, templating, and dashboard provisioning.
- Experience working with data sources such as Prometheus, Azure Monitor, Log Analytics, SQL, InfluxDB, Elasticsearch/OpenSearch, or similar platforms.
- Understanding of infrastructure observability concepts including metrics, logs, traces, latency, availability, utilization, throughput, and saturation.
- Experience developing dashboards for servers, storage, networks, cloud infrastructure, applications, or other enterprise IT systems.

Python, Data & Integration

- Strong working knowledge of Python for:
- Data manipulation and analysis using tools such as pandas.




- Data extraction, cleansing, transformation, and validation.
- REST API integrations and automation.
- Processing JSON, CSV, and other structured datasets.
- Automating recurring reporting and operational workflows.
- Supporting data pipelines and ETL/ELT processes.
- Strong SQL skills, including complex joins, aggregation, CTEs, window functions, and query optimization.

Bonus Experience — Ways to Stand Out

- Experience with Kusto Query Language (KQL) and Azure Log Analytics.
- Experience using PowerShell for systems or workflow automation.
- Experience with Azure Data Factory, Microsoft Fabric, Dataflows, Dataverse, or similar technologies.
- Experience with R for statistical analysis, data exploration, modeling, or advanced visualization.
- Experience using common R packages such as tidyverse, dplyr, ggplot2, Shiny, or similar data-analysis libraries.
- Experience combining Python or R analysis workflows with Power BI or enterprise reporting platforms.
- Experience building dashboards for enterprise infrastructure operations or Site Reliability Engineering teams.
- Experience supporting hardware, semiconductor, silicon design, EDA, or high-performance computing environments.
- Experience developing dashboards for compute, storage, network, or cloud capacity planning.
- Experience analyzing petabyte-scale storage environments or large infrastructure estates.
- Experience integrating data from monitoring tools, CMDBs, asset inventories, ticketing platforms, and cloud management systems.
- Experience with ServiceNow or similar ITSM platforms.
- Experience with Git and CI/CD workflows for dashboards, scripts, or infrastructure code.
- Experience with Power Apps and the broader Microsoft Power Platform.
- Microsoft certifications related to Power BI, Power Platform, Azure, Fabric, Data Analytics, or Python.

Our Adecuado Candidate

- Can look at a complex dataset and quickly identify the story hidden within it.
- Understands that an effective dashboard is designed to drive decisions, not simply display data.
- Has strong visual design instincts and can make complicated technical information easy to understand.
- Enjoys working with engineers and learning how complex infrastructure operates.
- Questions data quality and validates metrics before presenting them as authoritative.
- Proactively identifies opportunities to automate repetitive operational processes.
- Uses Python and automation to solve problems that cannot be efficiently addressed through reporting tools alone.
- Builds reusable solutions instead of one-off reports whenever possible.
- Understands how to balance usability, performance, maintainability, governance, and security.
- Takes ownership of problems from requirements through implementation and long-term support.
- Maintains clear technical documentation.
- Proactively learns new technologies, platforms, concepts, and procedures.
- Naturally champions secure processes and operational best practices.
- Communicates technical concepts effectively to both engineering teams and leadership.
- Consistently promotes and maintains high standards of customer service.

What We Offer

- Competitive salary and benefits package.
- Opportunities for professional growth, advanced certifications, and specialization.
- Exposure to enterprise-scale IT, analytics, observability, automation, and hybrid-cloud environments.
- Opportunities to work with complex datasets generated by large engineering and infrastructure environments.
- Direct experience with Power BI, Power Platform, Grafana, Python, Azure, and enterprise observability technologies.
- A collaborative and innovative work culture that values technical expertise, automation, and continuous improvement.

Work Hours: 9:00 AM – 5:30 PM

Typical base pay for this role is 5,400,000 to 6,600,000 COP per month, depending on experience and fit for the role.

This role is eligible for benefits.

AMS DataSerfs is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to age, ancestry, citizenship, color, family or medical care leave, gender identity or expression, genetic information, immigration status, marital status, medical condition, national origin, physical or mental disability, political affiliation, protected veteran or military status, race, ethnicity, religion, sex (including pregnancy), sexual orientation, or any other characteristic protected by applicable local laws, regulations, and ordinances.

If you need assistance and/or reasonable accommodation due to a disability during the application process, please contact us.

AMS DataSerfs will accept applications for this role on an ongoing basis.

Job Types: Full-time, Permanent
Language: English — Professional Business proficiency required
Work Location: Remote

Job Types: Full-time, Permanent

Language:

- English at a B2 level or above (Preferred)

Work Location: Remote

📌 IT Data Visualization & Automation Engineer (Colombia)
🏢 AMS DataSerfs
📍 Colombia