
Posted 4 days ago
Business Intelligence & IT Support Analyst
ArlingtonOn-siteFull-time
AI Summary
The Business Intelligence & IT Support Analyst builds and maintains Power BI dashboards, develops SQL data models, supports enterprise system integrations, and provides Tier-1 IT support.
About this role
Position Summary
This role combines business intelligence development, database support, and Tier-1 IT assistance. The primary focus is building and maintaining Power BI dashboards, developing SQL-based data models, and ensuring clean, reliable data across enterprise systems. The position also supports system integrations, documentation, and basic IT troubleshooting for end users.
This role combines business intelligence development, database support, and Tier-1 IT assistance. The primary focus is building and maintaining Power BI dashboards, developing SQL-based data models, and ensuring clean, reliable data across enterprise systems. The position also supports system integrations, documentation, and basic IT troubleshooting for end users.
Key Responsibilities
Business Intelligence & Reporting (60%)
• Build, maintain, and improve Power BI dashboards used by Finance, Sales, Operations, and Senior Leadership.
• Develop data models and queries using SQL, Infor Syteline datasets, and other internal data sources.
• Assist in the migration of reporting from legacy tools (e.g., Cyberquery) into Power BI.
• Clean and transform datasets for accuracy, consistency, and performance.
• Automate recurring reports and provide ad-hoc analysis when needed.
Database & Systems Support (20%)
• Support integrations between Syteline, UKG, ShopTrak, and other enterprise systems.
• Help maintain data integrity across platforms by diagnosing discrepancies and reconciling data
• Contribute to documentation of system processes, data dictionaries, and reporting standards.
IT Support (20%)
• Provide Tier-1 IT support: password resets, workstation setups, user access, basic troubleshooting.
• Triage tickets and escalate more complex issues to IT Manager or outside providers.
• Assist with hardware rollouts, software installations, and user onboarding.
• Maintain ticketing system hygiene and help identify recurring issues.
• Build, maintain, and improve Power BI dashboards used by Finance, Sales, Operations, and Senior Leadership.
• Develop data models and queries using SQL, Infor Syteline datasets, and other internal data sources.
• Assist in the migration of reporting from legacy tools (e.g., Cyberquery) into Power BI.
• Clean and transform datasets for accuracy, consistency, and performance.
• Automate recurring reports and provide ad-hoc analysis when needed.
Database & Systems Support (20%)
• Support integrations between Syteline, UKG, ShopTrak, and other enterprise systems.
• Help maintain data integrity across platforms by diagnosing discrepancies and reconciling data
• Contribute to documentation of system processes, data dictionaries, and reporting standards.
IT Support (20%)
• Provide Tier-1 IT support: password resets, workstation setups, user access, basic troubleshooting.
• Triage tickets and escalate more complex issues to IT Manager or outside providers.
• Assist with hardware rollouts, software installations, and user onboarding.
• Maintain ticketing system hygiene and help identify recurring issues.
Skills, Knowledge & Expertise
• Bachelor’s degree in Management Information Systems, Business Analytics, Information Systems, Data Science, or similar.
• Strong familiarity with Power BI, Excel, and basic SQL.
• Comfort working with enterprise systems (ERP, HRIS, MES, CRM).
• Solid analytical and problem-solving skills.
• Strong communication skills—able to explain technical concepts to non-technical users.
Preferred Skills
• Exposure to Infor Syteline, UKG, ShopTrak, or similar enterprise systems.
• Experience with Python, DAX, or Power Query (M).
• Understanding of data modeling concepts (Star schema, normalization, joins).
• Experience with ticketing systems (Jira, FreshService, HelpDesk, etc.).
• Strong familiarity with Power BI, Excel, and basic SQL.
• Comfort working with enterprise systems (ERP, HRIS, MES, CRM).
• Solid analytical and problem-solving skills.
• Strong communication skills—able to explain technical concepts to non-technical users.
Preferred Skills
• Exposure to Infor Syteline, UKG, ShopTrak, or similar enterprise systems.
• Experience with Python, DAX, or Power Query (M).
• Understanding of data modeling concepts (Star schema, normalization, joins).
• Experience with ticketing systems (Jira, FreshService, HelpDesk, etc.).
Benefits
• Competitive PTO
• 401(k) Match
• Health, Life, Dental, and Vision insurance
• Flexible Spending Account
• On-the-job training
• On-the-job training
• Opportunities for advancement
• Employee Assistance Program
• Referral Program
• Employee Discount Program
• Financial Wellness Program
• Financial Wellness Program
Skills
DAXExcelInfor SyteLineJiraPower BIPower QueryShopTrakSQLStar SchemaUKG
Explore related jobs
More jobs at American Excelsior Company
Similar DAX jobs
Jobs in Arlington
Forklift OperatorRe-Teck (LTG Group) · Arlington, Texas- Paid Ads Specialist (Google/Meta)NoGigiddy · Arlington, Texas
Sales & Catering Coordinator - Holiday Inn/Crowne Plaza Crystal City - $23/hrB.F. Saul Company Hospitality Group · Arlington, Virginia
CDAO - CJADC2 - Director of Program ManagementUnder Secretary of War for Research & Engineering · Arlington, Holy See (Vatican City State)
Service Technician - Campus Edge on UTA BoulevardAmerican Campus Communities · Campus Edge on UTA Boulevard - Arlington, TX
Marketing & Resident Experience Specialist - The ArlieAmerican Campus Communities · The Arlie - Arlington, TX