Boca Raton , United States
3 months ago
organizational metrics and KPIs.
? Create new reports and modify existing reports using industry standards and best practices.
? Perform ad-hoc data analysis and manual data refreshes.
? Elicit business requirements from Subject Matter Experts using interviews, document analysis and requirements
? Use the gathered requirements to develop logic for reporting, analytics or IT application support.
? Develop manual/automated reporting programs using data from in-house systems or other data marts.
? Creates reports using SQL Server (2008, 2012, 2016) environment with an In-depth understanding of the report life
? Perform statistical analysis, build predictive models, and formulate decision models that relate operational activities to
results; to drive value stream enhancement and continuous improvement.
? Understand data standards and identify data abnormalities. Instill data quality in all solutions delivered.
? Engage with IT to transform existing solutions to new methodology and technology. Liaise with IT to manage process of
data mapping, UAT testing, etc.
? Maintain close alignment with all customers (internal, external, management and at the field level) and other data
reporting teams to ensure requirements are being met.
EDUCATION & EXPERIENCE:
? Bachelor degree or higher from a reputed university in engineering, IT, economics, math, statistics, science or other
related fields in quantitative or analytical discipline.
? Minimum 5 years of experience in related business analyst or data/reporting analyst roles.
? Excellent skill level in SQL, PL/SQL.
? In-depth experience with Microsoft analytics Stack (SQL Server, SSAS Tabular, Power BI, Power Query, DAX, SQL and
o Advanced knowledge Power BI.
o Proficient in DAX, M language.
o Experience in Extraction, and Transformation and Loading (SSIS)
o Experience in Tabular/OLAP Model (Microsoft SSAS)
? In-depth experience with Associated Development Tools - Visual Studios Data Tools, SQL Server Management Studio,
SQL Server Data Tools, Microsoft TFS.
? Knowledge of working with database client tools such as Toad.
? Knowledge of Data Mining, Clustering & Statistical Modelling (preferred).
? Database Design. Excellent skill level in relational database required. Oracle, MS SQL Server knowledge.
? Proficient in Microsoft Office Suite and O365.
? Superior documentation and organizational skills. Must be detail oriented.
? Excellent critical-thinking skills with the ability to research and analyze data retrieved from multiple sources
? Must possess and demonstrate excellent verbal, written, and interpersonal communications skills.
? Must be an adaptable self-starter and work with minimal supervision. Must be able to handle multiple projects and
organize time effectively.
? Must be willing to put in extra time and effort if need be. Go above and beyond the requirements of the job and strive to