Overview
On Site
USD 55.00 - 60.00 per hour
Full Time
Skills
Business Systems
Visualization
Microsoft BI
Microsoft SSIS
SQL
OLTP
OLAP
Flat File
Microsoft Excel
Transact-SQL
MDX
Agile
Technical Support
Analytical Skill
Microsoft SSRS
Dashboard
SQL Azure
Extract
Transform
Load
Microsoft SQL Server
Database
Cubes
Performance Tuning
DAX
Data Modeling
Caching
Data Lake
Data Warehouse
Microsoft SSAS
Collaboration
Data Quality
Analytics
Access Control
Cloud Computing
Storage
Artificial Intelligence
Machine Learning (ML)
Data Processing
Reporting
Help Desk
Incident Management
End-user Training
Law
Financial Management
Inventory
Property Management
Microsoft Power BI
Microsoft Azure
Data Analysis
Data Governance
Design Thinking
Personas
TCM
DICE
Job Details
JOB TITLE: BUSINESS SYSTEMS ANALYST
JOB LOCATION: REMOTE (WASH dc)
WAGE RANGE*: 55.00-60.00 PER HOUR
JOB NUMBER: SAIJP00038290
REQUIRED EXPERIENCE:
Bachelor's degree and 8+ years of prior relevant experience
At least 4 years of demonstrated experience delivering reports, visualization, and analytics using Power BI, to include Power BI Cloud Service, Power BI desktop, Power BI Report Server
At least 4 years of experience working directly with business end users to understand requirements, develop reports, and provide ongoing support
Experience with the Microsoft Business Intelligence Stack (Power BI, SSAS, SSRS, and SSIS)
Experience tuning reports performance including optimizing DAX, Power Query, data models
Experience with SQL databases (OLTP, OLAP), flat file (e.g. excel) data sources, multi-dimensional models, TSQL, DAX/MDX, Power Query
Understanding of reports development using Azure based data services (Synapse Analytics)
Experience in Agile projects, working with a multi functional team
JOB DESCRIPTION
Work directly with key stakeholders to understand data needs, document report requirements, provide user support
Design, develop, and implement operational and analytic reports, visualizations, dashboards, and data extracts utilizing Microsoft Power BI and other query tools
Reengineer existing Power BI and SSRS reports and dashboards to source data from Azure data lake, Synapse Analytics, and Azure SQL Managed Instance
Analyze current ETL logic and data sources such as SQL Server databases and SSAS cubes to understand required data transformations
Analyze report performance and implement performance tuning, including visual components, DAX queries, Power Query, data model, caching to deliver high performance reports
Utilize Azure cloud data services such as data lake (ADLS), data warehouse, Synapse Analytics, and Analysis Services, to design and develop optimal reports to meet user needs
Collaborate with other team members including business analyst, data modeler, data architect, and data engineers to support design and implementation of data models and data transformations for Power BI reports
Design, develop, and implement processes and functions to ensure data quality in reports and analytics
Support Power BI administration tasks, including workspaces, access controls, apps, gateway and cloud data source connections, monitoring reports usage, monitoring and tuning utilization of compute and storage capacity
Ensure alignment with data governance policies, processes, and procedures
Incorporate AI/ML techniques and functions (e.g. Power BI Copilot) to enhance data processing and reporting
Assist the Help Desk with problem and incident management
Assist with end user training
Preferred:
Experience working on Federal government projects
Experience delivering reports in the law, HR, financial management, inventory, property, management domains
Power BI and Microsoft Azure data analytics related certifications
Experience supporting data governance
Experience with Design Thinking and Human Centered Design, and persona driven solutions
Equal opportunity employer as to all protected groups, including protected veterans and individuals with disabilities
* While an hourly range is posted for this position, an eventual hourly rate is determined by a comprehensive salary analysis which considers multiple factors including but not limited to: job-related knowledge, skills and qualifications, education and experience as compared to others in the organization doing substantially similar work, if applicable, and market and business considerations. Benefits offered include medical, dental and vision benefits; dependent care flexible spending account; 401(k) plan; voluntary life/short term disability/whole life/term life/accident and critical illness coverage; employee assistance program; sick leave in accordance with regulation. Benefits may be subject to generally applicable eligibility, waiting period, contribution, and other requirements and conditions. Benefits offered are in accordance with applicable federal, state, and local laws and subject to change at TCM's discretion.
#Dice
JOB LOCATION: REMOTE (WASH dc)
WAGE RANGE*: 55.00-60.00 PER HOUR
JOB NUMBER: SAIJP00038290
REQUIRED EXPERIENCE:
Bachelor's degree and 8+ years of prior relevant experience
At least 4 years of demonstrated experience delivering reports, visualization, and analytics using Power BI, to include Power BI Cloud Service, Power BI desktop, Power BI Report Server
At least 4 years of experience working directly with business end users to understand requirements, develop reports, and provide ongoing support
Experience with the Microsoft Business Intelligence Stack (Power BI, SSAS, SSRS, and SSIS)
Experience tuning reports performance including optimizing DAX, Power Query, data models
Experience with SQL databases (OLTP, OLAP), flat file (e.g. excel) data sources, multi-dimensional models, TSQL, DAX/MDX, Power Query
Understanding of reports development using Azure based data services (Synapse Analytics)
Experience in Agile projects, working with a multi functional team
JOB DESCRIPTION
Work directly with key stakeholders to understand data needs, document report requirements, provide user support
Design, develop, and implement operational and analytic reports, visualizations, dashboards, and data extracts utilizing Microsoft Power BI and other query tools
Reengineer existing Power BI and SSRS reports and dashboards to source data from Azure data lake, Synapse Analytics, and Azure SQL Managed Instance
Analyze current ETL logic and data sources such as SQL Server databases and SSAS cubes to understand required data transformations
Analyze report performance and implement performance tuning, including visual components, DAX queries, Power Query, data model, caching to deliver high performance reports
Utilize Azure cloud data services such as data lake (ADLS), data warehouse, Synapse Analytics, and Analysis Services, to design and develop optimal reports to meet user needs
Collaborate with other team members including business analyst, data modeler, data architect, and data engineers to support design and implementation of data models and data transformations for Power BI reports
Design, develop, and implement processes and functions to ensure data quality in reports and analytics
Support Power BI administration tasks, including workspaces, access controls, apps, gateway and cloud data source connections, monitoring reports usage, monitoring and tuning utilization of compute and storage capacity
Ensure alignment with data governance policies, processes, and procedures
Incorporate AI/ML techniques and functions (e.g. Power BI Copilot) to enhance data processing and reporting
Assist the Help Desk with problem and incident management
Assist with end user training
Preferred:
Experience working on Federal government projects
Experience delivering reports in the law, HR, financial management, inventory, property, management domains
Power BI and Microsoft Azure data analytics related certifications
Experience supporting data governance
Experience with Design Thinking and Human Centered Design, and persona driven solutions
Equal opportunity employer as to all protected groups, including protected veterans and individuals with disabilities
* While an hourly range is posted for this position, an eventual hourly rate is determined by a comprehensive salary analysis which considers multiple factors including but not limited to: job-related knowledge, skills and qualifications, education and experience as compared to others in the organization doing substantially similar work, if applicable, and market and business considerations. Benefits offered include medical, dental and vision benefits; dependent care flexible spending account; 401(k) plan; voluntary life/short term disability/whole life/term life/accident and critical illness coverage; employee assistance program; sick leave in accordance with regulation. Benefits may be subject to generally applicable eligibility, waiting period, contribution, and other requirements and conditions. Benefits offered are in accordance with applicable federal, state, and local laws and subject to change at TCM's discretion.
#Dice
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.