Sr. Account Data and BI Analyst
HWL
- Alpharetta, GA
- On-site
- Senior level
- 3+ yrs experience
- Data Analysis & Business Intelligence
- Visa: not specified
The role in 30 seconds
The Senior Accounting Data & BI Analyst will partner with Accounting and Data stakeholders to understand processes and reporting needs and translate those needs into specifications and data pipeline requirements for the Data team. This role will support General Ledger, invoicing, month-end close, and forecasting processes within HWL.
Is this role a fit for you?
The backgrounds this role is most likely to hire from, as RoleStack reads the posting.
Strong match
- Internal tooling / back-office systems
- B2B enterprise platform / workflow software
- Data platform / ML pipeline
Workable stretch
- B2B infrastructure / API / developer tools
- Creator / builder / self-serve tool
Harder transition
- B2C consumer-facing application
- Marketplace / multi-sided platform
- Embedded systems / hardware-adjacent
Industry: Healthcare & Life Sciences. See your personal match score
What they're really screening for
Must-haves
- CORE Bachelor's degree in finance, accounting, data analytics, information systems or a related field required
- CORE 3-5 years of experience in financial analysis, reporting or data analytics
- CORE Advanced SQL, including complex joins and query optimization on large datasets.
- CORE Develop Power BI reports and dashboards using DAX, Power Query, data modeling, and report design
- PLUS Utilize advanced Excel capabilities, including PivotTables, Power Query, complex formulas, and financial modeling
- CORE Build forecasting and financial planning models
- CORE Ability to effectively manage multiple competing priorities in a fast-paced environment
- CORE Excellent communication skills - both oral and written
- PLUS Ability to build strong business relationships at all levels
- CORE Strong attention to detail
Résumé keywords for this role
Terms the posting stresses. Include the ones you can honestly back up.
Tools & technologies
- SQL
- Power BI
- DAX
- Power Query
- Excel
- PivotTables
- financial modeling
- Azure
- Microsoft Fabric
- AI-assisted tools
- Power BI dashboards
- Power BI reports
- data modeling
- report design
- Azure data services
Concepts & phrases
- Sr. Account Data and BI Analyst
- LocumTenens.com
- Senior Accounting Data & BI Analyst
- state-of-the-art campus
- Jackson Healthcare company
- healthcare staffing company
- General Ledger
- month-end close
- forecasting processes
- data pipeline requirements
- Microsoft Fabric
- Power BI
- SQL
- scripting tools
- finance data solutions
Words that count as the same thing: "BI" ≈ Business Intelligence · "SQL" ≈ Structured Query Language · "DAX" ≈ Data Analysis Expressions · "Power Query" ≈ Get & Transform Data, M Language · "Power BI" ≈ Microsoft Power BI
Check my résumé against these keywordsHiring at HWL
Open senior roles RoleStack tracks right now, posted in the last 30 days.
More open roles at HWL
Full job description from HWL
From HWL's posting. View the original
Overview
LocumTenens.com has been leading the way in a booming healthcare industry since 1995. Locum Tenens is a Latin phrase meaning, “to substitute for.” When hospitals are understaffed, they rely on us to find them the right temporary physicians to fill in when needed. Every associate at LocumTenens.com plays a role in getting patients seen, no matter what they studied in school or what their role is here. Located in Alpharetta, GA, we boast a state-of-the-art campus featuring world-class amenities. There’s nothing ordinary about a typical day here, take a look for yourself: https://www.youtube.com/watch?v=sY9195GCJzQ.
Show full description Show less
We are a Jackson Healthcare company and we are now the third largest healthcare staffing company in the U.S., serving more than 7 million patients in over 1,400 healthcare facilities.
The Senior Accounting Data & BI Analyst will partner with Accounting and Data stakeholders to understand processes and reporting needs and translate those needs into specifications and data pipeline requirements for the Data team. This role will support General Ledger, invoicing, month-end close, and forecasting processes. The Senior Accounting Data & BI Analyst will document data flows from multiple systems into Microsoft Fabric and Power BI and use SQL, Power BI, and scripting tools to automate and maintain finance data solutions within Azure. This role will develop and maintain Power BI dashboards, reports, forecasting tools, and business intelligence solutions for the Accounting team. The Senior Accounting Data & BI Analyst role will manage and prioritize data and reporting requests, perform data validation checks and reconciliations against Workday and source ledger systems, and support data quality and accuracy. In partnership with FP&A, the Senior Accounting Data & BI Analyst will develop forecasting data models that combine financial and sales operations data and design and maintain semantic models that support Accounting reporting and workflow requirements.ESSENTIAL FUNCTIONS AND BASIC DUTIES:
Data Integration and ETL - 50%
• Perform advanced SQL development, including complex joins and query optimization on large datasets
• Develop Power BI reports and dashboards using DAX, Power Query, data modeling, and report design
• Utilize advanced Excel capabilities, including PivotTables, Power Query, complex formulas, and financial modeling
• Support data and reporting initiatives using Azure data services and Microsoft Fabric
• Work with financial systems and General Ledger data structures to support accounting processes and reporting
• Use AI-assisted tools for data cleaning, visualization, and forecasting
• Build forecasting and financial planning models to support business and financial objectives
Project Management & Process Automation - 50%
• Manage and prioritize competing data and reporting requests from Accounting stakeholders
• Turn non-technical stakeholder needs into clear technical specifications
• Explain data and reporting requirements clearly to both accountants and engineers through written and verbal communication
• Replace manual, spreadsheet-heavy accounting workflows and month-end close reconciliations with automated scripts and data automation solutions
SECONDARY FUNCTIONS (IF APPLICABLE)
• May work on special projects or other duties as assigned
SUPERVISORY/BUDGETARY/EXTERNAL COMMUNICATION RESPONSIBILITY
• May serve as a subject matter expert
QUALIFICATIONS – EDUCATION, WORK EXPERIENCE, CERTIFICATIONS
• Bachelor's degree in finance, accounting, data analytics, information systems or a related field required
• 3-5 years of experience in financial analysis, reporting or data analytics
KNOWLEDGE, SKILLS, AND ABILITIES
• Ability to adhere to and exhibit the Company Values at all times
• Working knowledge of Microsoft Word, Excel, PowerPoint, Outlook, and Teams
• Advanced SQL, including complex joins and query optimization on large datasets.
• Ability to effectively manage multiple competing priorities in a fast-paced environment
• Excellent communication skills - both oral and written
• Ability to build strong business relationships at all levels
• Strong interpersonal skills
• Strong attention to detail
• Strong organizational and time management skills
• Ability to work independently and collaboratively
• Solid critical thinking and creative problem-solving skills
• Ability to consistently meet goals, commitments, and deadlines
• Ability to work with sensitive information and maintain confidentiality
KEY COMPETENCIES REQUIRED
• Communicates Effectively
• Innovative
• Customer Focus & Teamwork
• Quality & Results-Oriented
• Decision Making
• Resourceful & Tenacious
• Develops Self
• Technical Skills
PHYSICAL, MENTAL, WORKING CONDITION, AND TRAVEL REQUIREMENTS
• Typical office environment - sedentary with typing, writing, reading requirements. May be able to sit or stand.
• Speaking, reading, writing, ability to use a telephone and computer
• Ability to exert up to 10 lbs. of force occasionally
• Ability to interpret various instructions
• Ability to deal with a variety of variables under only limited standardization
• Travel not required
What is in it for you
Company-paid benefits (Basic Life and AD&D, Short and Long-Term Disability, Employee Assistance Program, Compass Health Advocate and Transitions).
Healthcare benefit options (Value Plan, High Deductible Plan with HSA, Healthcare FSA, Dependent Care FSA, Prepaid Legal Services, 529 Savings Plan, Pet Insurance).
Paid parental leave.
Company sponsored 401k plan with company matching.
PTO that accrues at a rate of 15 days/year for 1st year and continues to increase with tenure.
Tuition reimbursement for continuing education.
An opportunity to work at a state-of-the-art facility in Alpharetta which features an on-site daycare and cafeteria, world-class fitness center and wellness clinic.
Disclosures
Smoking/vaping and the use of tobacco products are prohibited on all Company premises, including indoor and outdoor areas, parking lots, and Company-owned vehicles.
As part of our employment process, candidates who receive a conditional offer may be required to undergo pre-employment drug testing.
We are an Equal Opportunity Employer and do not discriminate based on race, color, religion, sex, national origin, age, disability, veteran status, or any other protected status under the law.
FAQ
How much experience do you need?
The posting asks for 3+ years in financial analysis, reporting or data analytics. It is a senior-level role.
Does HWL sponsor visas for this role?
The posting does not say whether visa sponsorship is available. Ask the recruiter before you apply.
Is this role remote?
It is an on-site role.
What tools and technologies does the posting mention?
SQL, Power BI, DAX, Power Query, Excel, PivotTables, financial modeling, Azure, Microsoft Fabric, AI-assisted tools, Power BI dashboards, Power BI reports, data modeling, report design, Azure data services.