Finance Data Analyst

Paycom; Westfield (IN); On-site; USD 75,000 - 95,000; Full time

Job summary

Paycom in Westfield, IN is seeking a Finance Data Analyst to ensure data integrity and deliver actionable insights across finance, executive, and operations teams. You will build business intelligence dashboards, analyze trends, and communicate findings to stakeholders.

The role requires strong analytical skills, collaboration across departments, and proficiency with SQL, Python, R, Excel, and BI tools. This is a full-time office position in Westfield, IN.

Qualifications

• Bachelor's degree or equivalent in a quantitative field (Statistics, Data Science, Business Analytics, or related).
• 3+ years of data analysis/business intelligence experience.
• Proficiency with SQL, Python, R, and Excel; experience with Power BI/Tableau or similar visualization tools.

Responsibilities

• Extract and process data from databases, APIs, and reports from internal systems and external sources.
• Design and optimize reporting data workflows for efficiency and scalability.
• Develop dashboards and reports to present findings to stakeholders using Tableau or Power BI.
• Write and optimize SQL queries against large-scale datasets.
• Collaborate with cross-functional teams to support data-driven decisions.

Skills

Analytical thinking

Communication skills

Cross-functional collaboration

Problem solving

Education

Bachelor's degree in quantitative field

Tools

SQL

Python

R

Excel

Tableau

Power BI

Job description

The Finance Data Analyst will play a critical role in supporting finance, executive, and operational teams by ensuring data integrity, delivering actionable insights and driving financial reporting and operational excellence. This position requires strong analytical skills, attention to detail and ability to collaborate across departments to build business intelligence dashboards and enhance reporting capabilities. The Finance Data Analyst will also interpret data, identify trends and visualize findings to communicate insights effectively. This is a full time office position in Westfield, IN.Essential Duties and ResponsibilitiesExtract and process data from various sources, including databases, APIs, and reports generated from a variety of internal programs, external sources and software providersDesign and optimize enterprise-level reporting data workflows to improve efficiency and scalabilityEnsure data integrity and consistency by cleaning data, identifying and correcting any errors, troubleshooting missing values and understanding the business to ensure data aligns with and validates business results & KPI’sAnalyze and interpret datasets using statistical analysis, focusing on trends and patternsDevelop and create reports and dashboards to present findings to stakeholdersCommunicate visual representations of data using tools such as Tableau or Power BI to make insights understandableWrite and optimize SQL queries against large-scale datasetsCollaborate with cross-functional teams to understand their data needs and provide support for consolidated reporting and data driven decision-making.Develop and deliver ad hoc analysis projects to address urgent business concerns as they develop utilizing data in real timeSupport strategic objectives by establishing KPIs, refining key performance indicators and other quantifiable business objectives to measure the effectiveness of business initiativesPartner with leadership and act as a business intelligence consultant to executives and other functional leaders to identify improvement opportunities and guide strategic planningQualificationsBachelor's degree or equivalent practical experience in a quantitative field (Statistics, Data Science, Business Analytics, or related)3+ years of data analysis / business intelligence experienceProficiency in data analysis tools such as SQL, Python, R, and ExcelExperience in machine learning, predictive modeling, or statistical analysisExperience with NetSuite ERP, Power BI, Tableau or other visualization toolsDemonstrated ability to understand manufacturing business needs and speak to technical and non-technical operational business groupsStrong communication skills, with demonstrated ability to present and explain the significance of data to business stakeholdersMicrosoft Office (Outlook, Word, Excel, PowerPoint, Project, Visio, etc.); NetSuite experience; Web proficiency.Working ConditionsPrimarily works in an office environment in Westfield, IN with frequent interaction on the manufacturing floor.Physical RequirementsAbility to sit and work at a desk for long periods of timeAbility to perform close visual work for prolonged periods of time