Looking for a fully REMOTE Senior Data Analyst to perform the following responsibilities:
Engage with business Analyst to understand requirements and needs and translate that into Analytical reports and dashboards
Functions as the lead for BISDLC (Business Intelligence Software Delivery Lifecycle) projects.
Collaborates and work closely with Business, System Integration and Cloud data architects, ETL (Extract, Transform, Load) Integration specialists and Power BI dashboard development team.
Analyzes and translate business requirements into technical requirements.
Develops BRD and/or TDD independently.
Designs and develops data models and applies best practices for optimum performance of the models.
Documents project specific processes and data flows, data dependencies, data definitions and relevant business rules.
Establishes data dictionaries to support the buildout of a data governance infrastructure.
Converts functional requirements into technical specifications.
Performs data analysis, data mapping, functional testing, unit testing, and test case preparation using required tools based on project needs.
Designs and develops DDL scripts, ad hoc queries and data models for high performance projects and deliverables.
Works with project teams and business stewards to refine business requirements that produce welldesigned and developed solutions.
Preferred Expereince:
3+ years of handson experience with R, Python, MML, SAS Enterprise Miner or similar tools in support of on-demand, real-time analytic services.
Experience with warehouse data extraction/transformation and load tools, as well as metadata repository tools.
Advanced proficiency in relational Database concepts, Database design using star, snowflake and data vault schema along with ability to write and execute complex SQL queries and stored procedures.
Knowledge of various database platforms (DB2, SAP,MS SQL Server) required and experience with one or more of the following, Power BI, Informatica, Azure Cloud, IoT, MuleSoft, AQT, ErWin Data Modeling.
Proficient with MS Office tools like PowerPoint, MS Project, Visio, Excel and Word and shell scripting.
Understands and evaluates existing SQL scripts and Data Models.
Experience with the SDLC and ETL Processes, data mining, database design development, data modelling, data governance and unit testing.
Proficient in data transformation, consolidating data from multiple disparate sources, develop process workflows and wireframe sketches to help business design effective dashboard solutions.
Please send inquiries to Marcia Novacek: marcia.novacek@modis.com
Equal Opportunity Employer/Veterans/Disabled
To read our Candidate Privacy Information Statement, which explains how we will use your information, please navigate to https://www.modis.com/en-us/candidate-privacy
The Company will consider qualified applicants with arrest and conviction records