BI Developer Ii

Are you a forward-thinking BI Developer II ready to architect the future of data? Join our dynamic, US-based company and play a pivotal role in our evolution towards modern, real-time data pipelines in the cloud using cutting-edge technologies like Microsoft Fabric. From your home in Mexico, you'll collaborate with international teams, transforming ideas from prototype to launch and directly impacting our strategic decisions.**What Excites Us (and Should Excite You)**:- **Shape Our Cloud Data Future**: Be at the forefront of our transition to a modern, event-based data pipeline in Microsoft Fabric. Your expertise will be critical in designing and implementing these next-generation solutions.- **Global Collaboration, Local Impact**: Work alongside talented international teams, bringing your unique perspective to solve complex data challenges and drive significant business value.- **Product-Minded Innovation**: Contribute your ideas and technical expertise to the entire development lifecycle, from initial concept to successful deployment.- **Solve Complex Challenges**: Dive into intricate data integration scenarios, tackling issues around data quality, unstructured datasets, and system performance.- **Amazing Travel Benefits**: Unlock opportunities to explore new destinations as part of our team (details provided during the interview process).- **Remote Flexibility & US Stability**: Enjoy the best of both worlds - the autonomy of a fully remote role based in Mexico, backed by the stability and growth potential of a successful US company.**Responsibilities**:- Spearhead the design and development of data integrations, strategically guiding our transition towards a real-time, event-based data pipeline in Microsoft Fabric.- Develop and maintain essential database objects within our data warehouse.- Proactively identify and resolve complex issues related to data integration, data quality, and data management incidents.- Research and champion opportunities for new data acquisition and innovative uses of existing data assets.- Integrate and optimize new data management technologies and software engineering tools within our existing infrastructure.- Create and maintain comprehensive data management documentation, including a robust data dictionary.- Recommend and implement strategies for continuous improvement in data reliability, efficiency, and overall quality.- Collaborate closely with data architects, modelers, and IT team members to align on project requirements and objectives.- Lead the revitalization of legacy services and architectures through strategic refactoring, migration, and the implementation of cloud-enabled distributed designs.- Contribute significantly to enhancing the development and operations of our increasingly distributed architecture.- Establish and help achieve critical backend and system SLOs to ensure scalability and resilience for future growth.**Requirements**:- Bachelor’s degree in Computer Science, Computer Engineering, or equivalent practical experience.- 5+ years of proven experience in designing, building, and efficiently ingesting data into data warehouse systems.- 5 years of hands-on experience working with diverse data pipelines, seamlessly integrating data from various sources into a data warehouse environment.- 3+ years of deep expertise with Microsoft Integration Services (SSIS).- 1+ years of practical experience with Python.**Knowledge, Skills, and Abilities You'll Bring**:- **Mastery of Data Integration**: Ability to build new integrations from a wide array of data sources, including SQL, NoSQL, Files, and APIs.- **SQL and ETL/ELT Expertise**: Proficient in SQL and relational database concepts, with a strong understanding of advanced ETL/ELT processes and data transformation techniques.- **Data Format Versatility**: Experienced in handling structured and semi-structured data formats such as JSON, XML, CSV, and TXT, and skilled in managing data pipelines using SSIS or similar tools.- **Batch Processing Power**: Solid knowledge of batch data processing and executing batch transactions for DML operations in production settings.- **Query Optimization Prowess**: Skilled in query optimization, with the ability to interpret and leverage execution plans to significantly improve database performance.- **Advanced SQL Acumen**: Expertise in advanced SQL techniques, including window functions, CTEs, and performance tuning for both analytical and operational use cases.- **Data Quality Champion**: Proven ability to proactively identify and resolve data quality issues, including thorough troubleshooting, de-duplication, and ensuring consistency across multiple systems.- **Independent and Collaborative**: Comfortable working autonomously to tackle complex data engineering challenges while also collaborating effectively within cross-functional teams.- **Agile Adaptability**: Experience thriving in a fast-paced Agile development environment, effectiv