Data ANalyst

Experience Requirements:

• Preferred: 10+ years of experience; 8+ years may be acceptable.
• Strong analytics background is essential; candidates can be trained on SOX if necessary.
• Experience in high-volume commerce/e-commerce is a plus.

Team Dynamics:

• Manager's team consists of 10 members, primarily Product Managers.
• Potential for light interaction with internal audit and collaboration with accounting stakeholders.
• Work will focus on building dashboards, reporting, ad hoc testing, and responding to auditor requests.

Job Overview:

We are looking for a data-driven contractor with extensive expertise in IT Internal Audit, SOX compliance, and cloud architecture. The role involves leveraging data analytics to test IT General Controls (ITGCs), design effective controls, and document system walkthroughs. You will create data-rich dashboards and develop data-centric operating processes for our Snowflake control environment. This individual will play a pivotal role in ensuring SOX compliance, enhancing data integrity, and supporting our finance data stakeholders with comprehensive analytic insights.

Key Responsibilities:

• 
  Perform testing of IT General Controls (ITGCs) and coordinate responses to auditor Provided by Client (PBC) requests.
  Design, develop, and implement financial and accounting reports/dashboards in Mode or similar BI tools.
  Collaborate with internal teams to resolve data quality issues by identifying root causes, alerting stakeholders, and providing remediation.
  Translate business requirements from Finance and Accounting into technical solutions and actionable project plans.
  Execute or review testing of internal controls (entity-level and business process controls).
  Support business process owners in meeting data compliance requirements by designing and operationalizing data control activities.
  Maintain data pipelines, consolidate SQL logic for federated reporting, and ensure the integrity, completeness, and accuracy of financial reporting data.

Qualifications:
10+ years of experience in IT Internal Audit and/or SOX compliance, with experience in public company audits being a must.
Bachelor s degree (or equivalent) in Information Systems, Finance, or Accounting.
Experience in performing operational IT audits and expertise in IT SOX testing, including ITGCs, ITACs, and report testing (e.g., examining report configurations and scripts).
Proficiency in SQL, Python, and other data analysis languages. Experience with BI tools such as Mode, Alteryx, and dbt.
Strong critical thinking, analytical, and project management skills with the ability to work effectively under tight timelines.
Hands-on experience in data pipeline design (ETL) and BI development for finance and accounting functions. Experience managing technology and data risk, particularly around SOX ITand ITAC controls.
Ability to quickly learn and adapt to the complexity of our cloud architecture and business operations.

Technical Skills:
Proficient in SQL, Python, Mode (or similar BI tool), and Excel.
Experience with Snowflake and cloud-based architectures.
Strong background in data management, BI code annotation, and providing support in finance and accounting functions.
Expertise in data analytics and ability to combine and collate SQL logic for consolidated reporting processes.

Soft Skills:
Excellent communication skills, both written and verbal, to effectively liaise with cross- functional teams.
Strong project management and organizational skills.
Collaborative mindset to work closely with technology partners and internal finance teams.

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.