Senior Data Informatics Analyst
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, programs and maintains report formats, dashboards, data generators, canned reports, and other end-user information resources, and may create report specifications based on business requests. The analyst 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 uses Python for data preparation, API integrations, and automation. The role also develops and optimizes SQL queries, works with business stakeholders to translate operational needs into KPIs and reports, troubleshoots refresh and performance issues, and helps ensure data accuracy and security compliance.
Requirements
- Bachelor’s degree in Computer Science, Information Technology, Data Science, or a related quantitative field and more than 8 years of relevant experience, or a master’s degree and more than 6 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.
- 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.
- Partner 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 slow-loading DAX measures, and 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.
- Program and 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.
Benefits
- Medical, vision, and dental insurance for employees and dependents.
- Generous paid time off, including 8 designated holidays.
- 401(k) with employer contributions.
- Tuition assistance and student loan assistance.
- Wellness and employee assistance resources.
- Employee stock purchase opportunities.
- Short-term and long-term disability coverage.
- Professional growth opportunities.
- Work-life balance.
- Business casual atmosphere.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
