Roles and Responsibilities:

• Work closely with business users to turn project requirements into custom formatted data reports to support data migration and data integration
• Profile data to verify completeness, find patterns, and validate with the business users to ensure requirements are met
• Perform data analysis to determine data quality issues
• Prepare data for statistical modeling and cleansing
• Create source to target mapping documents (STTMs)
• Able to outline critical information to support complete life cycle data generation
• Analyze business procedures and recommend specific types of data
• Use statistical methods to analyze data and generate useful business reports
• Develop functional design of data interfaces and data conversions
• Use data to create models that depict trends in the customer base and the consumer
• Use conceptual data flow from data architect as input to developing data interface design
• Evaluate source systems against logical data models
• Identify and document gaps in data and/or data models
• Support data transformation and conversion to support technical design
• Produce and maintain documentation including design documents, data and process models and data dictionaries
• Responsible for high level implementation plans, creating and maintaining design documentation and creating and maintaining data and process models
• Work well independently and remote

Qualifications and skills:

• 6+ years data analyst role
• Advanced knowledge of databases, data lakes, data warehousing, data marts
• Excellent oral and written communication skills
• Experience with agile methodology
• Working knowledge of entire SDLC
• Basic SQL query writing and pseudocode
• Knowledge of networking concepts, object-oriented technology, data warehousing, and relational database engines
• Ability to collaborate effectively and work as part of a team
• Strong attention to detail
• Or an equivalent combination of education, training and experience
• Cloud architecture (Azure/AWS and Snowflake)
• Data Vault 2.0 and Databricks
• Experience in healthcare or insurance is desirable
• Negotiating and presentation
• Experience with dimensional data models, star schema, snowflake schema
• Teradata, Netezza, Exadata, Oracle, SQL Server, MongoDB, Greenplum
• Bachelor’s degree in STEM