Cloud and Things · 17 hours ago
Lead BI Developer - (Snowflake, databricks, data warehouse, star, SQL)
Albany, NY
Full-time
Hybrid
Senior Level
$140K/yr - $155K/yr
7+ years expCloud and Things is focused on transforming the public sector’s IT environment by solving complex IT challenges. They are seeking a Lead BI Developer to design, develop, and deploy multi-dimensional reports using the Cognos Business Intelligence suite while maintaining a central repository of BI assets and ensuring data integrity.
ConsultingInformation Technology
Responsibilities
Responsible for the design, development and deployment of multi-dimensional reports using the Cognos Business Intelligence suite of products
Provide analysis, design, development, testing and implementation of Business Intelligence, Ad-hoc and Operational Reporting
Maintain and curate a central repository of enterprise Business Intelligence assets including dashboards, visualization and interactive reports
Monitor daily reports that identify data inconsistencies, determine the resolution, and revise the incorrect operational data
Enable capabilities available in the Business Intelligence technology such as drill-through functionality, KPI and scorecard reporting, advanced visualizations including mapping and geospatial analysis, predictive analytics, and other capabilities as they arise
Communicate and coordinate with members of the development team to work across multiple projects
Explore, actively support, and work on new technology initiatives that may be of interest to the organization
Actively participate in troubleshooting any technical issues that the program may have
Other duties as assigned
Qualification
Required
7+ years of experience working on complex projects with 2 or more years in a leadership role as a Developer
5+ years of experience in design and implement analytical data warehouse schemas (star, snowflake, and hybrid models) in cloud platforms
5+ years of experience translating business reporting requirements into fact and dimension models
7+ years of experience in a Government Regulated setting
5+ years of demonstrated hands-on experience with design & development of analytics ready data sets optimized for BI consumption
5+ years of demonstrated hands-on experience developing data models, data mappings, data migrations and assisting in data warehouse design
7+ years of experience in Delta Lake, Workflows, SQL, PySpark and job orchestrations
7+ years of experience in enterprise data warehousing and analytics
7+ years of experience in aligning warehouse design with enterprise data governance security and compliance standards
7+ years of experience working with design artifacts, diagrams and implementation, documentation, providing architecture guidance, best practices, and design reviews
7+ years of experience with advanced SQL and Spark performance tuning
7+ years of experience in supporting complex data integrations across hybrid solutions
5+ years of experience with Databricks on AWS cloud platform
Associate degree or combination of experience and education
Company
Cloud and Things
Cloud and Things is an experienced State and Local Government IT consulting firms.
51-200 employees
H1B Sponsorship
Cloud and Things has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (2)
2024 (3)
2023 (3)
2022 (1)
Funding
Current Stage
Growth StageCompany data provided by crunchbase