Our goal is to solve problems and deliver results for our clients. At Cloud and Things, you can be a part of transforming the public sector’s IT environment. Our team is on the forefront of helping to solve the government's most complex IT challenges. If you are seeking a role that offers the opportunity to work on rewarding projects, consider a career with Cloud and Things.
*This is an exempt position. Salary commensurate with experience*
Overview:
Location: Albany, NY - Hybrid
Salary: $140,000 - $155,000
We are seeking a Lead BI Developer who will support our NYS client. This role will be responsible for the build and support of Cognos dashboards and reports. The ideal candidate for this role will have strong hands-on cloud data warehousing skills and deep Databricks/Delta Lake experience. Experience working in regulated government environments is required.
Duties:
-
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.
Mandatory Qualifications:
-
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.
Cloud and Things complies with all applicable federal, state, and local laws regarding recruitment and hiring. All qualified applicants are considered for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, protected veteran status, or any other category protected by applicable federal, state, or local laws.
AI-Assisted Resume Evaluation Notice
Cloud and Things – Talent Management
Notice to Candidates
Cloud and Things utilizes artificial intelligence (AI) tools to assist our recruiting team in evaluating candidate applications for streamlining; consistency, efficiency, and thoroughness. All hiring decisions are ultimately made by our human recruiting professionals.
How AI Is Used
Our AI tools assist by:
- Analyzing resumes against job requirements
- Supporting our recruiters in candidate data evaluation
- Ensuring consistent review standards across all applications
Important: AI serves as a support tool only. As noted above, all candidate selection and hiring decisions are made by experienced human recruiters. Your unedited resume will be processed by our AI tools as part of this evaluation.
Your Data and Privacy
Cloud and Things Data Handling:
- Your information is processed securely and used exclusively for recruitment purposes
- Cloud and Things may store your resume in our Applicant Tracking System (ATS) indefinitely for future job matching opportunities
- You may opt out of long-term ATS storage by emailing your name and your request to opt out of storing your resume in the ATS to: security@cloudandthings.com
- All personal information is handled confidentially in accordance with our privacy policy
AI Tool Data Processing:
- AI processing data is retained for a maximum of 90 days, after which it is deleted
- All data sent to AI tools is encrypted in transit and at rest
- AI tools comply with applicable privacy laws including GDPR and CCPA
- Personal data is anonymized or minimized wherever possible during AI processing
Your Participation
By submitting your application, you acknowledge this notice and consent to AI-assisted evaluation as part of our recruitment process. You may opt out only by choosing not to submit your resume for consideration.
Never miss an opportunity! Create an alert based on the job you applied for.