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