Job description
This position is fully remote and available ONLY for applicants living in countries in Central America and Mexico, including Guatemala, Honduras, El Salvador, Costa Rica, and Panama.
**Please submit your resume in ENGLISH.**
JOB OVERVIEW:
We’re looking for a skilled Power BI & Data Operations Specialist to help maintain and improve our business intelligence dashboards and data flow. This role is ideal for someone with strong Power BI and data troubleshooting skills who can work independently and ensure everything runs smoothly from data ingestion to reporting.
You’ll support a structured data workflow that connects data from Repsly (via API), through a Python script, into an Azure SQL database, and finally into Power BI dashboards. You don’t need to write code, but you should understand how the process works and know how to identify issues when they occur.
KEY RESPONSIBILITIES:
- Build, update, and manage Power BI dashboards using DAX and custom visuals.
- Regularly check data for accuracy and fix reporting issues.
- Use Excel for quick data analysis and prep work.
- Write and review SQL queries to understand or troubleshoot data in the Azure SQL database.
- Understand and monitor our data pipeline:
- Data comes from Repsly through an API.
- A Python script pulls this data and updates the Azure database.
- The database feeds the Power BI reports.
- Spot and investigate issues in the data flow and escalate for fixes if needed.
SKILLS AND QUALIFICATIONS:
- Power BI Knowledge: Proven experience in building, maintaining, and troubleshooting dashboards using advanced DAX and visual logic.
- Data Analysis Skills: Strong ability to validate, interpret, and analyze data for accuracy and consistency across multiple sources.
- Basic SQL Skills: Comfortable writing and modifying SQL queries to inspect data and support troubleshooting in Azure SQL databases.
- ETL Understanding: Familiar with data integration workflows, including API data ingestion via Python scripts and automated updates to SQL databases.
- Excel Proficiency: Advanced Excel skills for ad hoc analysis, data prep, and cleanup using formulas, pivot tables, and formatting.
- Data Visualization Skills: Ability to create clear, user-friendly dashboards and reports to support operational and strategic decision-making.
- API Workflow Awareness: Understanding of how APIs function in data pipelines (e.g., Repsly API), even if not coding directly.
- Problem-Solving Abilities: Able to troubleshoot issues independently and escalate when deeper technical fixes are needed.
- Attention to Detail: Consistently checks data quality, identifies issues quickly, and ensures accurate reporting.
- Self-Management: Works independently, manages priorities effectively, and meets deadlines without constant supervision.
TOOLS AND SOFTWARE KNOWLEDGE:
- Power BI (Desktop & Service): Essential for building, maintaining, and publishing dashboards; must know how to use DAX, manage data models, and optimize report performance.
- Microsoft Excel (Advanced): Required for data preparation, analysis, and validation using pivot tables, advanced formulas, and formatting.
- SQL (Azure SQL Database): Ability to read and write queries for data inspection, validation, and troubleshooting within a cloud-based SQL environment.
- Python (Basic Understanding): While coding isn’t required, you must understand the role of Python scripts in the data pipeline and be able to identify when script-related issues occur.
- API Integration (Repsly API): Must understand how APIs are used to pull data into the system, particularly Repsly or similar platforms.
WHO WE ARE?
CA Fortune is a full-service, privately held consumer brands agency that specializes in driving growth for companies across the consumer goods industry. Founded in 1983, the company offers a range of services including sales management, brand strategy, marketing, and data insights, primarily for food, beverage, wellness, and lifestyle brands. With offices across the United States, CA Fortune partners with both emerging and established brands to navigate the complexities of the retail environment, providing tailored solutions to enhance brand presence and expand market reach. Known for its hands-on approach and deep industry expertise, CA Fortune positions itself as a dedicated growth partner for consumer brands.
Alia Services is one of the renowned recruitment and payroll services companies that operate remotely. We offer one-window solutions for entrepreneurs, small-medium enterprises, companies, corporates, and candidates. With us, a company can shape its organizational goals and objectives into reality by acquiring exceptional human capital with an easy and fast paced recruitment process.
WHAT DO WE PROVIDE?
- Full time positions with the potential for overtime.
- 100% remote positions.
- Competitive compensation package.
- An inclusive, fast pace exciting environment culture offering accelerated professional growth.
- 1-on-1 coaching with feedback sessions, mentorships, and leadership development programs.
- Opportunities for cross-functional development.
HOW ARE WE DIFFERENT?
Historically, outsourcing companies have valued profit over people and compensated for high turnover by underpaying employees. We want to change that. Alia Services not only offers fair compensation and benefits but values inclusion, belonging, and opportunity.
Diversity, Equity, and Inclusion are more than a commitment for Alia Services– it is the foundation of what we do. Through diverse networks and pipelines, we have a clear vision: to create a Great Place to Work for All. We believe inclusion includes you. Be who you are at Alia Services!
Equal Opportunity Employer Minorities/Women/Veterans/Differently Abled.
