Senior Business Intelligence, SQL, Power BI

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 Enroute

Enroute

51 - 200 employees

☁ SaaS

🏱 Enterprise

📡 Telecommunications

SaaS ‱ Enterprise ‱ Telecommunications

Enroute is a company that delivers exceptional IT services and solutions, staffed by a team of passionate, problem-solving individuals skilled in various IT and business practices. They specialize in data engineering, moving and utilizing data effectively to increase business value, regardless of data sources or types. Enroute also offers software development services, providing analysis and implementing software strategies tailored to long-term organizational needs. Quality engineering is another key offering, with a focus on building quality into processes and software testing from the early stages of development. With a strong emphasis on IT strategy, software and data solutions, Enroute aims to impact organizations and improve user experiences through their tailored services and expert solutions.

📋 Description

‱ Design and develop enterprise-level data solutions that support diverse reporting and analytics requirements across multiple business units. ‱ Develop and implement scalable ETL/ELT pipelines that extract data from disparate sources, perform complex transformations, and load data into target systems. ‱ Build and maintain data models and dimensional schemas optimized for reporting and analytical queries. ‱ Create advanced Power BI reports, dashboards, and analytics solutions that deliver insights to executive leadership and operational teams. ‱ Establish and enforce data quality standards, validation rules, and data governance practices across all data pipelines. ‱ Configure scheduling, monitoring, alerting, and error handling mechanisms to ensure pipeline reliability and timely data availability. ‱ Perform analysis and optimization of ETL processes, database queries, and Power BI models to ensure cost-effectiveness and speed. ‱ Collaborate with stakeholders to gather requirements, document technical specifications, and provide technical guidance on data architecture decisions. ‱ Troubleshoot and resolve data-related issues, implementing sustainable solutions and documenting lessons learned. ‱ Stay current with emerging data technologies and best practices, recommending improvements to the data platform.

🎯 Requirements

‱ Advanced proficiency in Power BI, including dashboard design, data modeling, DAX, and report optimization. ‱ Strong hands-on experience designing, developing, and supporting ETL/ELT pipelines in enterprise environments. ‱ Expert-level SQL skills with deep knowledge of relational and cloud databases; ability to write optimized queries and design efficient data structures. ‱ Experience with modern data platforms and cloud technologies (Azure, AWS, Google Cloud). ‱ Strong understanding of data architecture principles, including data modeling, data governance, metadata management, and dimensional modeling. ‱ Expertise in pipeline orchestration, scheduling, monitoring, alerting, error handling, and retry logic. ‱ Proficiency in data transformation techniques, data validation, testing strategies, and data quality assurance. ‱ Ability to analyze complex business requirements and translate them into robust technical solutions. ‱ Strong troubleshooting, documentation, and communication skills with the ability to present technical concepts to non-technical stakeholders. ‱ Desirable, experience integrating data from diverse sources including databases, APIs, cloud storage, flat files, web services, and enterprise applications. ‱ Demonstrated ability to collaborate effectively with architects, database engineers, QA teams, and business analysts.

đŸ–ïž Benefits

‱ Monetary compensation ‱ Year-end Bonus ‱ IMSS, AFORE, INFONAVIT ‱ Major Medical Expenses Insurance ‱ Life Insurance ‱ Funeral Expenses Coverage ‱ TDU Membership ‱ MediAccess ‱ Health Check-Up Subsidy ‱ Preferential rates for car insurance ‱ Vacations ‱ Official Mexican Holidays ‱ Life Happens Days ‱ Bereavement Leave ‱ Civil Marriage Leave ‱ English Classes ‱ Certifications ‱ Educational Agreements (Talisis, U-ERRE, UNID, TecMilenio, Tec de Monterrey, UDEM, SPIS) ‱ Corporate Agreements & Discounts (Sorteos Tec, Envia Flores, TopGolf) ‱ Taquitos Rewards ‱ Birthday Bonus ‱ Work-from-home Bonus ‱ Laptop Policy

Apply Now