About this role.
This junior to semi-senior Business Intelligence Analyst role focuses on building and maintaining Power BI dashboards for a global marketing organization. The developer will use DAX, Power Query (M), SQL, and basic ETL tooling to model data, automate reporting workflows, and deliver executive-ready insights. The position partners with senior team members and business stakeholders to convert reporting requirements into reliable analytical solutions. It also emphasizes data-quality validation, KPI documentation, dashboard usability, and continuous improvement in a remote, fast-paced environment.
Role DNA
A quick view of the complexity, pace, ownership and collaboration implied by the job description.
Job Complexity
3/5Pace & Pressure
4/5Autonomy Level
3/5Communication Load
4/5Salary analysis
Estimated compensation compared with the broader US market for similar roles.
Core skills
Skills and capabilities most closely associated with this opportunity.
Sample interview questions
I would first clarify the business decision the dashboard must support, the target audience, required KPIs, refresh expectations, and source systems. Then I would profile the data, define metric logic with stakeholders, create an appropriate star-schema model, build and validate measures, and iterate on a simple user-focused report design before publishing and documenting it.
Power Query is primarily used during data preparation to connect, clean, reshape, and combine data before it enters the model. DAX is used after loading data to create calculated columns, measures, and time-intelligence calculations that respond to report filter context. I use Power Query for repeatable transformations and DAX for analytical calculations and report behavior.
I would confirm that both reports use the same metric definition, date range, filters, refresh time, and grain of data. Next, I would trace the Power BI query and model relationships, compare record counts and sample records, and test the DAX measure in a simplified table. Once the root cause is confirmed, I would correct the transformation, relationship, or measure and document the agreed business logic.
I would favor a star schema, remove unnecessary columns and rows early in Power Query, use appropriate data types, and avoid high-cardinality fields where possible. I would also prefer measures over excessive calculated columns, keep DAX efficient, configure incremental refresh when applicable, and review performance using Power BI performance tools.
I would begin with the business implication rather than the technical method, using a concise visual and a clear recommendation. I would explain the metric definition, key trend, likely drivers, and any limitations in plain language, then invite questions and provide supporting detail only as needed. This keeps the discussion focused on an actionable decision while maintaining transparency about the data.
About Truelogic
At Truelogic we are a leading provider of nearshore staff augmentation services headquartered in New York. For over two decades, we’ve been delivering top-tier technology solutions to companies of all sizes, from innovative startups to industry leaders, helping them achieve their digital transformation goals.
Our team of 600+ highly skilled tech professionals, based in Latin America, drives digital disruption by partnering with U.S. companies on their most impactful projects. Whether collaborating with Fortune 500 giants or scaling startups, we deliver results that make a difference.
By applying for this position, you’re taking the first step in joining a dynamic team that values your expertise and aspirations. We aim to align your skills with opportunities that foster exceptional career growth and success while contributing to transformative projects that shape the future.
Our Client
Our client is a digital-first global marketing network that delivers scalable, seamless solutions through a unique combination of culture-moving creativity and leading-edge technology.
Job Summary
Our client is looking for a driven Business Intelligence Analyst to support our data visualization and reporting infrastructure. In this role, you will build and maintain Power BI dashboards, assist with data modeling, and help automate ETL processes. Working closely with senior team members, you will translate business requirements into actionable insights while ensuring reporting efficiency and data quality across the organization.
Responsibilities
Dashboard & Report Development: Build and maintain interactive Power BI dashboards and reports to visualize key business metrics and support executive decision-making processes.
Data Modeling: Perform data modeling using DAX and Power Query (M), following established best practices for optimal performance and scalability.
ETL & Automation: Assist in developing and automating ETL pipelines using modern tools such as Microsoft Fabric or SQL Server Integration Services (SSIS).
Cross-Functional Collaboration: Partner with senior team members to gather reporting requirements and translate complex business needs into clear analytical solutions.
Data Quality & Documentation: Support the documentation and validation of data sources, KPIs, and business logic to maintain high reporting consistency and data integrity.
Continuous Improvement: Identify opportunities to improve reporting efficiency, dashboard usability, and overall data quality.
Qualifications and Job Requirements
Experience: 1 to 4 years of hands-on experience in business intelligence, data analysis, or a closely related role.
Technical Proficiency: Foundational proficiency with Power BI, DAX, Power Query (M), and SQL (e.g., SQL Server, BigQuery).
ETL & Data Integration: Direct exposure to or basic experience using ETL tools like SSIS, Microsoft Fabric, or equivalent platforms.
Analytical Thinking: Strong capability to interpret complex datasets and partner with business teams to generate meaningful insights.
Communication & Growth Mindset: Eager to learn new technologies, strong verbal and written communication skills, and comfortable in a collaborative, fast-paced environment.
What We Offer
100% Remote Work: Enjoy the freedom to work from the location that helps you thrive. All it takes is a laptop and a reliable internet connection.
Highly Competitive USD Pay: Earn an excellent, market-leading compensation in USD, that goes beyond typical market offerings.
Paid Time Off: We value your well-being. Our paid time off policies ensure you have the chance to unwind and recharge when needed.
Work with Autonomy: Enjoy the freedom to manage your time as long as the work gets done. Focus on results, not the clock.
Work with Top American Companies: Grow your expertise working on innovative, high-impact projects with Industry-Leading U.S. Companies.
Why You’ll Like Working Here
A Culture That Values You: We prioritize well-being and work-life balance, offering engagement activities and fostering dynamic teams to ensure you thrive both personally and professionally.
Diverse, Global Network: Connect with over 600 professionals in 25+ countries, expand your network, and collaborate with a multicultural team from Latin America.
Team Up with Skilled Professionals: Join forces with senior talent. All of our team members are seasoned experts, ensuring you’re working with the best in your field.
Apply now!
Annual salary information is not provided for this position. Explore salary ranges for similar roles in our Salary Directory ›
Upload your resume now
- To unlock remote work opportunities and be discovered by global employers.
This job listing has been manually reviewed by the Jobicy Trust & Safety Team for compliance with our posting guidelines, including verification of the company's legitimacy, accuracy of job details, clarity of remote work policy, and absence of misleading or fraudulent content.
