Senior BI & Data Integration Lead

Job not on LinkedIn

🔥 1 minute ago

Apply Now
Find Similar Remote Jobs

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Logo of Freelance Latin America

Freelance Latin America

51 - 200 employees

Founded 2017

👥 HR Tech

🤝 B2B

🎯 Recruiter

HR Tech • B2B • Recruitment

Freelance Latin America is a staffing solution that connects businesses with top-tier, bilingual remote professionals from South America. By providing a fully managed service, they handle all aspects of hiring, including recruitment, onboarding, and payroll, offering companies cost-effective staffing solutions without compromising quality. Their services cater to various industries, enabling organizations to benefit from exceptional talent while maintaining time zone compatibility and easy communication.

📋 Description

• Translate business briefs in English into clear technical plans, execution steps, and deliverables. • Work independently during the first 2–3 months, managing active data projects from raw data review to final dashboard delivery. • Design analytical data architectures, including dimensional models, star schemas, table relationships, and transformation strategies. • Build real-time or near real-time Power BI dashboards and reporting solutions for executive decision-making. • Develop advanced DAX measures and structure scalable Power BI semantic models. • Define, calculate, and validate KPI logic such as cost of goods, waste, loss index, profitability by product/client/period, cash flow, and operational KPIs. • Use Microsoft 365 tools to automate data intake, processing, and reporting workflows. • Assess which tools, licenses, and technical resources are required for each project and advise on the most efficient setup. • Review unstructured raw data files, identify inconsistencies, document gaps, and ask the right questions before moving forward. • Validate all figures before delivery, ensuring zero calculation errors in client-facing dashboards and reports. • Document assumptions, sources, formulas, data logic, workflows, and technical decisions for long-term maintainability. • Establish working standards such as file structure, naming conventions, Git workflow, and reusable project kickoff templates. • Support the future growth of the data team by helping onboard, delegate to, and supervise junior/intermediate profiles and additional support roles. • Provide technical mentoring, feedback, and quality control once the team expands.

🎯 Requirements

• Expert-level Power BI Desktop experience, including advanced data modeling, DAX, semantic layers, and row-level security. • Expert knowledge of dimensional modeling and star schema design. • Advanced SQL skills, ideally with PostgreSQL and/or T-SQL. • Advanced Power Query / M language skills. • Intermediate Python / pandas experience for ETL and data transformation. • Intermediate Git experience, including branches, pull requests, and code reviews. • Intermediate Microsoft 365 knowledge, including SharePoint and Power Automate. • Experience using automation tools and workflows; Make experience is a plus. • Strong ability to build real-time or near real-time dashboards and automated reporting processes. • Experience working with complex business data across SMB sectors such as manufacturing, distribution, professional services, transport, or similar environments. • Ability to perform basic business analysis, including waste, losses, profitability, and operational performance calculations. • Strong technical judgment to recommend the right tools, licenses, and data architecture for each project. • Ability to read unstructured raw data files and quickly identify the underlying business logic. • Strong written English communication skills for briefs, documentation, feedback, and reporting. • Extremely autonomous, organized, and structured; comfortable working without close supervision. • Curious and proactive mindset, with the confidence to ask questions when data is ambiguous or incomplete. • Absolute rigor with numbers; deliverables must be fully validated before submission. • Ability to flag risks, gaps, inconsistencies, and assumptions before they become delivery issues. • Pedagogical mindset and ability to explain complex analytical concepts to junior team members. • Startup mindset: adaptable, fast-moving, and comfortable building structure from scratch.

🏖️ Benefits

• Fully remote work environment • Stable, long-term collaboration • Clear scope of responsibilities and structured workflows • Training and onboarding support • Opportunity to work with international teams • Exposure to modern tools and professional processes • Supportive and collaborative work culture • Opportunity for skill development and career growth

Apply Now