Back to Jobs
Recently postedTechnology

Senior Data Analyst

TriosysIT Inc.Austin, TX🇺🇸United States

Quick overview

SeniorityMid Senior
Work modeHybrid
LocationAustin, TX, United States
OracleETLAzurePower BIData Analysis

Job description

Description

  • Analyze existing reports, universes, data sources, schedules, security requirements, and business processes in SAP Business Objects Enterprise (BOE)
  • Develop, enhance, test, document, and maintain Microsoft Power BI reports, dashboards, semantic models, dataflows, and related analytics products
  • Support the agency's transition from SAP Business Objects Enterprise reporting to Microsoft Power BI and Microsoft Fabric when appropriate
  • Develop and document standards and procedures for Power BI and Fabric development, testing, deployment, naming, ownership, workspace administration, and support
  • Support implementation of shared ownership and service-account practices so production analytics assets are not dependent on individual employee accounts
  • Gather reporting requirements, analyze data, develop prototypes, coordinate user acceptance testing, and deliver production-ready reporting solutions
  • Work with database administrators, data management staff, application teams, and Microsoft platform administrators to implement secure and supportable access to Oracle and other approved agency data sources
  • Develop reusable semantic models, documented data definitions, and governed reporting datasets
  • Assist with Power BI and Fabric capacity, refresh, gateway, security, performance, deployment, troubleshooting, documentation, and knowledge transfer

Years of Experience

  • Seven years of progressively responsible professional experience in senior-level data analysis and enterprise data functions, including data analytics, data warehousing, data modeling, data integration, extract-transform-load (ETL) or extract-load-transform (ELT) processes, data pipelines, data quality, metadata, reporting, and work with relational databases or enterprise data platforms
  • At least three years developing or supporting Microsoft data and analytics technologies, such as Power BI, Microsoft Fabric, Power Platform, Azure data services, or comparable Microsoft reporting and integration capabilities
  • Experience in requirements analysis, solution design, development, testing, documentation, troubleshooting, production support, and coordination with technical and business stakeholders
  • Preferred: graduation from an accredited four-year college or university with major coursework in data science, business analytics, computer science, computer information systems, management information systems, accounting, finance, mathematics, statistics, economics, or a related field

Required Skills

  • Advanced knowledge of Microsoft Power BI development, including Power Query, DAX, data modeling, semantic models, and report performance optimization
  • Experience with Power BI workspaces, deployment practices, refresh schedules, gateways, access controls, and shared ownership
  • Experience integrating Power BI with Oracle or comparable relational databases through approved and governed connection methods
  • Ability to analyze and document existing enterprise reports, data sources, reporting processes, security requirements, and support procedures
  • Ability to gather requirements, develop prototypes, facilitate user acceptance testing, and implement production reporting solutions
  • Ability to establish practical naming, documentation, ownership, testing, deployment, and support standards
  • Strong analytical, troubleshooting, written communication, and stakeholder coordination skills
  • Ability to produce technical documentation, user guidance, and knowledge transfer materials

Preferred Skills

  • Experience with Microsoft Fabric, including Lakehouse, Warehouse, Dataflows Gen2, pipelines, notebooks, or related analytics capabilities
  • Experience with SAP Business Objects Enterprise, Crystal Reports, universes, Web Intelligence, or scheduled enterprise reports
  • Experience migrating or modernizing reports from SAP Business Objects to Power BI
  • Experience with Microsoft Power Automate and Power Platform governance
  • Experience with Microsoft Purview, data catalogs, lineage, metadata management, or data governance
  • Experience supporting public-sector or regulated enterprise environments
  • Microsoft Certified: Power BI Data Analyst Associate or comparable demonstrated experience

Scope / Responsibilities

  • Inventory and assessment of assigned BOE, Power BI, Fabric, and related reporting assets
  • Prioritized recommendations for report migration, consolidation, remediation, or retirement
  • Production-ready Power BI reports, dashboards, semantic models, and dataflows
  • Documented requirements, data definitions, lineage, security requirements, test results, and support procedures
  • Power BI and Fabric workspace, naming, ownership, deployment, and documentation standards
  • Recommendations and implementation support for service-account or shared-ownership practices
  • Documented development, test, user acceptance, and production deployment procedures
  • Troubleshooting and performance recommendations for refreshes, gateways, data models, and reports
  • Knowledge-transfer sessions and reusable guidance for agency staff and business-office report developers
  • A transition plan identifying ongoing administration, support, governance, and staffing requirements

Role Description: Senior Data Analyst

  • Consults with internal and external customers to identify user needs
  • Analyzes data using standard statistical tools, methods, and techniques
  • Identifies data gaps, errors, anomalies, inconsistencies, and redundancies by analyzing the content, structure, and relationships within data
  • Identifies and interprets data patterns and trends and assesses data quality
  • Cleans and prunes data to discard irrelevant information
  • Prepares concise, comprehensive technical reports to present and interpret data, identify alternatives, and make and justify recommendations on data revisions

Experience and Education

  • Bachelor's degree and at least five (5) years of experience in data analysis, research, compilation, and/or reporting work
  • Knowledge of statistics and analyzing data sets
  • Knowledge of running queries, report writing, and presenting findings
  • Knowledge of data models, database design and development, data mining, and segmentation techniques
  • Knowledge of record keeping, including security procedures for handling, protecting, and distributing confidential data

Similar jobs