Develop BI and data visualization solutions for government health coverage programs. Analyze data, identify anomalies, ensure data quality, create dashboards and ad hoc reports, and build reusable models and templates. Support data integration, ETL processes, automation, database applications, and reporting lifecycle discipline. Translate business requirements into dashboard and reporting specifications while maintaining documentation, standards, and processes in a complex matrix organization.
Location: Albany, NY
Security Clearance: No clearance-- must be US Citizen or Green Card holder, as this position supports government entities
Job Type: Full-Time
Target Salary Range*: $70,000 - $80,000
*This represents the potential salary range for this position depending on education level, years of experience and/or certifications in addition to other position specific requirements which may impact salary
Position Overview:
Deliver solutions to complex problems as a Data Analyst/BI Developer. Here, you’ll tailor solutions to the unique requirements of our clients. With a career in application development, you’ll make the end user’s experience your priority and we’ll make your career growth ours.
You will join our team in partnership with New York State of Health (NYSoH) to provide comprehensive health coverage to more than 7.0 million New Yorkers through its Health Benefit Exchange (HBE)
- You will work on a small dynamic team that provides strategic know-how through Business Intelligence (BI) and Data Visualization platforms to deliver quality reports for State & Federal Agencies.
- Apply an understanding of business metrics and a commercial mindset to perform Data analysis, find patterns, data anomalies and review.
- Work closely with functional teams to understand requirements regarding solutions to ensure data quality. Collaborate on definition, development, and maintenance of standards and processes.
- Develop models and create templates to ensure timely and accurate deliverables, data integrity, efficient workflow, reusability, and automation. Create dashboards using workspace advance to facilitate drill up/down and slicing/dicing of data. Produce Ad Hoc reports with a turnaround time based on business needs.
- Support continuous improvement and automation in BI solutions and processes.
- Support client data exchange and integration needs by leveraging technical expertise in database applications, ETL processes, and automation. Apply knowledge of upstream and downstream Enterprise applications to support dashboard development lifecycle discipline
Education:
Bachelor’s degree in Business, Computer Science, Mathematics, Engineering, or related discipline, or equivalent
Required Experience: NO MORE than 5 years of experience will be accepted
- Three (3) years of industry experience with focus on SQL, PL/SQL, SQL-PL in DB2
- Three (3) years’ experience with a BI tool (Cognos is preferred)
- Two (2) years of experience in design/data modeling for Data Mart/Data Warehouse
Required Technical Skills:
- Strong understanding of OLAP business intelligence applications
- Strong understanding of reporting and database environments, processes, and associated applications
- Competencies leveraging data visualization tools for senior management and enterprise data visualization
- Ability to translate business requirements into specifications that will be used to implement required reports and dashboards
- Knowledge of RTC/ELM or similar tools
- Competencies in database architecture such as relative, star and snowflake schemas.
- Competencies in DB2 (or other RDBMS)
- Level 3 Procedural Languages (i.e.: ANSI, SQL, PL/SQL)
- Writing complex SQL queries, SQL PL procedures in IBM DB2 environment.
- Competencies with UNIX/LINUX operating systems
Required Skills and Abilities:
- Good verbal, writing/documentation, communication, organizational, and time management skills
- Strong analytical, problem solving and communication skills, including mapping of business need or issue to development of application requirements or procedural initiatives.
- Strong understanding of reporting and database environments, processes, and associated applications.
- Well-developed knowledge of operational systems, processes and budgeting/forecasting concepts and activities
- Proven ability to ensure effective forms of documentation essential for support of overall technical and user needs.
- Ability to work in complex matrix organization.
Preferred Qualifications:
- Experience with IBM Cognos Analytics 12.1.0 or higher
- Experience authoring and maintaining reports using IBM Cognos Analytics 12.1.0 or higher against relational, dimensional, and transactional databases
- Experience with Core Java
- Hands-on experience with data architecture and data analysis skill sets
- Familiarity with PMI standards and practice
- Healthcare Industry experience
Similar Jobs
eCommerce • Food • Pet
Designs and maintains dashboards, reports, and visualizations; validates data quality and reporting logic; translates complex analysis into actionable recommendations; partners with data teams and stakeholders; improves reporting scalability, self-service analytics, and responsible AI usage. Presents findings to technical and non-technical audiences while supporting strategic and operational decision-making.
Top Skills:
AIData ModelingData TransformationLookerOmniPower BIRelational DatabasesSigmaSQLTableau
Fintech • HR Tech
Own CX data infrastructure, including pipelines, data models, governance, monitoring systems, and Streamlit dashboards. Apply advanced statistics and AI-assisted anomaly detection to identify customer experience opportunities and performance issues. Partner with CX leaders, data science, engineering, and Salesforce teams to define metrics, answer causal questions, and guide operational decisions. Establish data quality standards, validate AI-generated outputs, communicate insights clearly, and mentor data practitioners.
Top Skills:
DatabricksDbtPythonSalesforceSnowflakeSQLStreamlit
AdTech • Enterprise Web • Information Technology • Machine Learning • Marketing Tech • Sales
Develop business intelligence and revenue reporting tools, automate Finance reporting processes, perform ad hoc and quantitative analyses, and translate complex data into actionable insights. The analyst will support company initiatives, present findings to technical and non-technical stakeholders, and provide decision-making guidance across the organization.
Top Skills:
Google BigqueryGoogle WorkspaceMS OfficePythonRelational Database SystemsSQL
What you need to know about the NYC Tech Scene
As the undisputed financial capital of the world, New York City is an epicenter of startup funding activity. The city has a thriving fintech scene and is a major player in verticals ranging from AI to biotech, cybersecurity and digital media. It also has universities like NYU, Columbia and Cornell Tech attracting students and researchers from across the globe, providing the ecosystem with a constant influx of world-class talent. And its East Coast location and three international airports make it a perfect spot for European companies establishing a foothold in the United States.
Key Facts About NYC Tech
- Number of Tech Workers: 549,200; 6% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Capgemini, Bloomberg, IBM, Spotify
- Key Industries: Artificial intelligence, Fintech
- Funding Landscape: $25.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Greycroft, Thrive Capital, Union Square Ventures, FirstMark Capital, Tiger Global Management, Tribeca Venture Partners, Insight Partners, Two Sigma Ventures
- Research Centers and Universities: Columbia University, New York University, Fordham University, CUNY, AI Now Institute, Flatiron Institute, C.N. Yang Institute for Theoretical Physics, NASA Space Radiation Laboratory
