Data Informatics Analyst

Saab•East Syracuse, NY

6d•$92,200 - $115,300

About The Position

The Senior Data Informatics Analyst generates ad hoc reports and regular datasets for end users using system tools, databases, data warehouse queries, and scripts. The role integrates data from multiple sources and maintains report formats, dashboards, data generators, canned reports, and other end-user information resources. It may also develop report specifications based on business requests. The analyst builds and maintains interactive Power BI reports, scorecards, and dashboards; designs semantic data models and data flows; and uses Python to clean and prepare data, integrate APIs, and automate tasks. The role also queries and transforms data with SQL, collaborates with business teams to define KPIs and reporting needs, troubleshoots refresh and performance issues, and supports data accuracy and security compliance.

Requirements

Bachelor’s degree in Computer Science, Information Technology, Data Science, or a related quantitative field and 8 or more years of relevant experience, or a master’s degree and 6 or more years of relevant experience.
At least 3 years of hands-on experience developing Power BI dashboards and data models and publishing reports.
At least 2 years of experience using Python for data analysis, automation, and scripting; examples of libraries include pandas, numpy, and requests.
Strong proficiency writing SQL queries and working with relational databases such as PostgreSQL, SQL Server, or Snowflake.
Deep understanding of Data Analysis Expressions (DAX) and data transformation workflows.
Ability to distill large volumes of raw data into clear, actionable business insights.
Ability to pass a pre-employment drug screen.

Responsibilities

Build, publish, and maintain interactive Power BI reports, scorecards, and dashboards using Power BI Desktop and Power BI Service.
Design and optimize semantic data models, data flows, and relational schemas using Power Query and DAX.
Write Python scripts for data cleaning, preprocessing, API integrations, and task automation to supply downstream BI models.
Write and optimize complex SQL queries to extract and transform data from relational databases and cloud data warehouses.
Collaborate with cross-functional business teams, including Sales, Operations, and Finance, to gather requirements, translate operational needs into KPIs, and iterate on reports.
Troubleshoot data refresh issues and optimize slow-loading DAX measures.
Ensure data accuracy and security compliance.
Generate ad hoc reports and regular datasets using system tools, databases, data warehouse queries, and scripts.
Integrate data from multiple sources to produce requested or required data elements.
Maintain report forms and formats, information dashboards, data generators, canned reports, and other end-user information portals or resources.
Create report specifications based on business requests when needed.