BI Developer

This position is listed on behalf of a partner company, which manages all applications and next steps. Our partner is looking for a BI Developer Sr. or Lead based in the United States.

• Design, develop, implement, and maintain BI reports, dashboards, data extracts, governed datasets, and ETL/ELT processes.
• Support end-to-end data integration, data mart development, reporting, and analytics solutions, from source systems through downstream consumption.
• Translate complex business requirements into technical specifications, solution designs, source-to-target mappings, and clearly defined business rules.
• Conduct detailed data analysis to support requirements gathering, metric definitions, source validation, and data-quality assessments.
• Develop and maintain dimensional data models, data warehouse components, OLAP cubes, semantic layers, and other analytical structures as required.
• Perform unit testing and support output validation, data reconciliation, and business acceptance criteria.
• Troubleshoot reports, data extracts, ETL/ELT processes, scheduled jobs, and production data solutions.
• Conduct root-cause analysis for data, reporting, and pipeline issues, documenting resolutions and preventive measures.
• Support user acceptance testing, release planning, change management, and deployment activities.
• Maintain production readiness through effective scheduling, orchestration, monitoring, incident triage, and operational support practices.
• Create and maintain technical documentation, including business rules, data lineage, technical specifications, source-to-target mappings, runbooks, and support procedures.
• Support data governance, metadata management, data stewardship, reporting standards, and data-quality initiatives.
• Help maintain appropriate access controls and ensure the secure handling of sensitive information.
• Promote consistency, reliability, and compliance across data development and reporting processes.
• Identify and implement improvements to the performance, reliability, automation, efficiency, and supportability of existing BI solutions.
• Contribute technical expertise to projects, system enhancements, and enterprise-wide initiatives.
• At the Lead level, guide technical decisions, establish and improve development standards, mentor developers and analysts, and coordinate the resolution of complex production issues.
• Lead complex initiatives involving data integration, ETL/ELT, data modeling, data warehousing, and enterprise analytics solutions.

• Bachelor's degree in Computer Science, Information Systems, Information Technology, Data Analytics, or a related field, or equivalent practical experience.
• At least five years of relevant experience in IT, business intelligence, data engineering, data integration, reporting, or analytics delivery.
• Demonstrated experience developing and supporting enterprise data solutions in production environments.
• Advanced SQL skills using Oracle, Microsoft SQL Server, or another leading relational database management system.
• Strong experience developing reports and dashboards using tools such as Microsoft Reporting Services, Power BI, Business Objects, or Cognos.
• Hands-on experience building ETL/ELT processes using Microsoft Integration Services or other data integration technologies.
• Experience supporting data extracts, integrations, data marts, governed datasets, and downstream reporting or analytics.
• Knowledge of dimensional data modeling, data warehousing methodologies, OLAP cubes, semantic layers, and analytical data models.
• Familiarity with data-quality processes, including validation, exception reporting, reconciliation, and quality metrics.
• Working knowledge of production support practices, including scheduling, orchestration, monitoring, incident management, root-cause analysis, and operational readiness.
• Ability to prepare and maintain technical specifications, source-to-target mappings, business rules, lineage documentation, runbooks, and support procedures.
• Understanding of data governance, metadata, stewardship, reporting governance, access controls, and the secure handling of sensitive data.
• Strong analytical, critical-thinking, and problem-solving skills, with the ability to investigate complex data issues and recommend effective solutions.
• Excellent communication and collaboration skills, including the ability to translate business needs into technical requirements and work effectively with technical and non-technical stakeholders.
• Strong organizational skills and the ability to manage multiple priorities in a dynamic environment.
• Additional requirements for Lead-level consideration: Generally, seven or more years of related experience, demonstrated