Lenmar Consulting Inc. Looking for Data Analyst (Max $59/hr W2 – USC & GC only) Full Time

Company Description

Finance

Job Description

• Develop, modify, and maintain visualizations and dashboards that are hosted on an in-house Tableau server (MSViz).
• Execute daily ETL processes. This includes extracting, transforming and loading of datasets from multiple source systems, specifically; sourcing, contracts, accounts payable (BOXI), and other expense management and risk related tools.
• Write complex queries for large volumes of data (joins, functions, sub queries, etc.).

• 5+ years’ experience in a professional setting with a strong focus on reporting and data analytics.
• Education: Minimum of a Bachelor’s Degree in a relevant field (Finance, Information Systems, Data Science, Technology preferred).
• Analytical skills: The candidate must be highly analytical with experience in using objective data to drive strategic recommendations. Experience of collecting, analyzing and synthesizing large and complex datasets.
• Industry experience with report development, data warehousing, business analytics and using data science/business intelligence tools.
• Advanced Microsoft Office Skills; PowerPoint, Word, Access, and Excel (complex formulas, pivot tables, slicers, data connections, macros).
• A willingness to understand underlying data, sources, data elements and end to end data flow in order to provide clarity to stakeholders.
• Client management and teamwork skills: The candidate must have demonstrated ability in being flexible and working with stakeholders and colleagues at all experience levels, as well as external counterparts.
• Prior experience using an RDBMS (Relational Database Management Systems), Particularly SQL Server. Must also possess SQL Code development skills in order to create custom queries, stored procedures, execute code, views, etc.
• The candidate must possess strong written and oral communications skills and prepare presentations and documents for senior audiences.
• Ability to balance multiple tasks relating to the book of work for BAU reporting.
• The candidate must have the ability to create practical and comprehensive implementation plans and partner with Technology to test and introduce system changes and enhancements that impact the reporting environment.

Additional Information

All your information will be kept confidential according to EEO guidelines.

Lenmar Consulting Inc.