We are looking for an experienced Application Developer to support enterprise business intelligence and reporting initiatives in Southern California. This Long-term Contract position will focus on building governed reporting solutions, developing modern dashboards, and translating complex data into clear insights for business stakeholders. The role also contributes to dashboard modernization efforts, advanced database development, and high-quality analytics delivery across warehouse and lake house environments.
Responsibilities:
• Develop and maintain enterprise reports, dashboards, and analytical products that support strategic and operational decision-making.
• Create and manage semantic models, including business metrics, hierarchies, prompts, and security rules, to ensure consistent reporting standards.
• Write and optimize advanced SQL for warehouse and lakehouse platforms, using joins, CTEs, stored procedures, and other complex query techniques.
• Partner with data engineering teams to design curated datasets, aggregation structures, and performance-focused data assets for reporting use cases.
• Investigate and resolve data quality issues by profiling source data, validating results, and reconciling discrepancies across reporting layers.
• Apply dimensional modeling and modern data warehousing principles to align reporting solutions with governed enterprise architecture.
• Lead the transformation of legacy BI outputs into modern web-based dashboards while preserving calculation accuracy, filtering logic, and drill functionality.
• Use approved AI-assisted development tools to accelerate report creation, documentation, validation, and dashboard modernization with strong human oversight.
• Support security validation, regression testing, and production readiness activities before releasing reporting solutions to end users.
• 8+ years of experience delivering enterprise BI reporting, dashboard development, and semantic modeling solutions.
• Expert-level SQL skills with strong experience in complex queries, performance tuning, stored procedures, and data reconciliation.
• Hands-on background in data warehousing concepts such as star schemas, snowflake schemas, conformed dimensions, and slowly changing dimensions.
• Proven ability to translate business needs into scalable reporting solutions with governed metrics and clear documentation.
• Experience working with BI and analytics platforms such as Tableau and related dashboarding technologies.
• Familiarity with Python, automation practices, and modern development tools including GitHub-based workflows.
• Strong understanding of data security, quality assurance, testing, and troubleshooting within production reporting environments.
• Ability to work effectively with technical teams, business stakeholders, and executive audiences in Agile delivery settings.