Data Informatics Analyst

Saab•East Syracuse, NY

About The Position

The Senior Data Informatics Analyst generates ad hoc reports and regular datasets, and provides information to end users using system tools, databases, data warehouse queries, and scripts. The role integrates data from multiple sources to produce requested or required data elements and programs and maintains report formats, dashboards, data generators, canned reports, and other end-user information resources. The analyst may create report specifications based on business requests. The position builds, publishes, and maintains interactive Power BI reports, scorecards, and dashboards; designs and optimizes semantic data models, data flows, and relational schemas using Power Query and DAX; and develops Python scripts for data cleaning, preprocessing, API integrations, and automation. It also involves writing and optimizing complex SQL queries, partnering with business teams to translate operational needs into KPIs, and troubleshooting refresh and performance issues while ensuring 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, data models, and published reports.
At least 2 years of experience using Python for data analysis, automation, and scripting.
Strong proficiency writing SQL queries and working with relational databases.
Deep understanding of DAX and data transformation workflows using Power Query.
Ability to distill large volumes of raw data into clear, actionable business insights.
Must pass a pre-employment drug screen.

Responsibilities

Build, publish, and maintain interactive Power BI reports, scorecards, and dashboards in 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 and translate operational needs into KPIs.
Iterate on reports in partnership with stakeholders.
Troubleshoot data refresh issues and optimize slow-loading DAX measures.
Ensure data accuracy and security compliance.
Generate ad hoc reports and regular datasets, integrate data from multiple sources, and maintain end-user reporting resources.