Intelligence Analyst jobs in United States

Job Overview:

The BI Analyst is responsible for designing, developing, and maintaining Power BI dashboards, reports, and analytical solutions to support payroll-related decision-making. The role requires strong expertise in data modeling, SQL, DAX, and advanced analytics to deliver accurate insights related to payroll forecasting, variance analysis, employees’ movements, cost allocations, accruals, and receivables. This position plays a vital role in translating raw payroll and HR data into meaningful visualizations and actionable intelligence for decision making.

The ideal candidate will be well-versed in cloud platforms such as Azure, data warehouses such as Snowflake, and modern data analytics tools like MS Fabric and PostgreSQL. A strong business acumen in payroll operations and finance reporting is preferable.

Key Responsibilities:

Payroll Reporting & Financial Analytics

1. Update and maintain the Payroll Forecast Report on a regular basis.
2. Generate and analyze the Payroll Variance Report to compare actuals vs. forecasts and flag anomalies.
3. Develop Employee Movement and Cost Center Reports to track headcount shifts and payroll allocation across departments.
4. Maintain Accruals and Receivables Tracking Reports to ensure proper monthly reporting and reconciliation.

Report & Dashboard Development:

1. Design, develop, and maintain interactive dashboards and reports in Power BI.
2. Implement advanced DAX measures, M query transformations, and optimize underlying data models for performance and clarity.

Data Modeling & Integration:

1. Create robust data models by integrating data from multiple sources including Snowflake, SQL Server, PostgreSQL, and Azure Data Lake or Azure Blob Storage.
2. Leverage MS Fabric components (e.g., Data Factory, Synapse) to streamline data pipelines and transformations.
3. Craft and execute SQL and PostgreSQL queries upon request for data analysis, validation, and troubleshooting.
4. Implement data governance standards, including documentation, version control, testing protocols, and CI/CD pipelines for seamless deployments.

Advanced Analytics & Scripting:

1. Utilize Python to perform advanced data transformations, ETL, statistical analyses, or machine learning workflows prior to Power BI visualization.
2. Stakeholder Collaboration & Support:
3. Gather and clarify business requirements, ensuring reports meet stakeholder needs.
4. Conduct training sessions and create self-service BI documentation to empower business users.

Analytical & Problem-Solving:

1. Analyze complex organizational processes and propose data-driven solutions.
2. Stay proactive, detail-oriented, and accountable in delivering high-quality BI solutions.

Qualification & Experience:

Education & Certification:

• BS / MS in Computer Science, Information Systems, Data Science or Finance.
• Microsoft Certified Data Analyst certification (PL-300) is preferred.

Technical Experience & Skills:

• 3–5 years of proven experience as a BI Developer, with a focus on Power BI.
• Strong proficiency with Power BI, including DAX, M query, and data modeling techniques.
• Experience with Snowflake and SQL-based systems (SQL Server, PostgreSQL) for data warehousing and data transformations.
• Familiarity with Azure services (Azure SQL Database, Azure Data Factory, Azure Synapse) and MS Fabric for end-to-end data solutions.
• Practical experience in business analytics or BI platforms (e.g., SAP BI/BW) and integration tools.
• Knowledge of Python for automations, advanced data manipulation and analytics.

Soft Skills & Aptitude:

• Demonstrated ability to take initiative, innovate, and adapt to evolving data environments.
• Excellent analytical thinking, logical reasoning, and problem-solving abilities.
• Strong attention to detail, accuracy, and personal accountability.
• Effective interpersonal communication skills to work with stakeholders across all levels of the organization.
• Ability to work independently or as part of a team, with strong time management and organizational skills