Data Analyst

This remote Data Analyst role involves strategic oversight, planning, and development of data models and database structures, particularly on platforms like Snowflake. Key responsibilities include translating logical designs into physical databases, defining data flows, gathering requirements, analyzing complex data sources, and developing source-to-target mapping. The role also focuses on data quality analysis, profiling, and supporting data governance. Candidates will perform daily production support, identify problematic data areas, and ensure data integrity. Strong analytical, problem-solving, and communication skills are essential for working with cross-functional teams and business executives.

Must Have

• Serve as a technical resource for strategic oversight, planning, and development of data models and database structures.
• Translate logical designs into physical databases and define data flows.
• Plan, design, and document logical and physical enterprise relational data models.
• Facilitate and participate in design meetings and review sessions with development, architecture, data integration, BI teams, and power users.
• Implement physical data models on platforms such as Snowflake.
• Gather data requirements by working with end users.
• Analyze complex data sources and develop source-to-target mapping documents.
• Perform data quality analysis and profiling to ensure integrity and accuracy.
• Support QA and end users during testing phases, including QA and User Acceptance Testing.
• Provide daily production support and ongoing maintenance for the enterprise data warehouse.
• Identify problematic data areas, research root causes, and determine corrective actions.
• Support data governance by developing processes and queries to monitor and ensure data quality.
• Gather, clean, and preprocess data from various sources, ensuring integrity and quality.
• Identify KPIs and develop metrics to track and measure business performance.
• Monitor data quality, identify issues, and propose cleansing or enhancement solutions.
• 7-10+ years of overall IT experience in software development or data-related roles.
• 5-7 years of significant data analysis experience, including 2-4 years building complex data models.
• 3-5 years of strong Snowflake experience; Ability to construct complex SQL queries.
• 2+ years of data profiling experience.
• Proven experience with programming languages such as SQL and Python for data manipulation and analysis.
• Experience with data analysis and visualization tools such as SAP BO, Power BI and Excel.
• Proficiency with best practices in data modelling, data analysis, and data warehousing concepts.
• Ability to understand requirements and create complex relational data models.
• Ability to create data flow and process flow diagrams.
• Strong analytical and problem-solving skills.
• Ability to effectively diagnose, isolate, and resolve complex problems pertaining to data infrastructure.
• Excellent written and oral communication skills.
• Ability to communicate strategies around data modelling and architecture to cross-functional teams and business executives.
• Attention to detail and ability to maintain data accuracy and integrity.
• Ability to work with large datasets through data cleaning, preprocessing, and transformation techniques.

Good to Have

• Knowledge of BI methodologies, Data Marts, Data Warehousing, OLAP tools and techniques.
• Experience in professional services, accounting industry, or client service/consultative technology roles.

Perks & Benefits

• Medical/dental/vision insurance
• HSA
• FSA
• 401(k)
• Life, disability & ADD insurance
• Paid time off (for salaried personnel)
• Paid sick leave (for hourly employees on a Service Contract Act project)

Description

-----------

Kforce has a client seeking a remote Data Analyst to join their team. Responsibilities:

• Serve as a technical resource for strategic oversight, planning, and development of data models and database structures to support global needs
• Translate logical designs into physical databases and define data flows through successive stages
• Plan, design, and document logical and physical enterprise relational data models
• Facilitate and participate in design meetings and review sessions with development, architecture, data integration, BI teams, and power users
• Implement physical data models on platforms such as Snowflake
• Gather data requirements by working with end users
• Analyze complex data sources and develop source-to-target mapping documents, including business transformation rules
• Perform data quality analysis and profiling to ensure integrity and accuracy
• Support QA and end users during testing phases, including QA and User Acceptance Testing
• Provide daily production support and ongoing maintenance for the enterprise data warehouse
• Identify problematic data areas, research root causes, and determine corrective actions
• Support data governance by developing processes and queries to monitor and ensure data quality
• Gather, clean, and preprocess data from various sources, ensuring integrity and quality
• Identify KPIs and develop metrics to track and measure business performance
• Monitor data quality, identify issues, and propose cleansing or enhancement solutions
• Stay updated with industry trends and best practices in data analysis, modeling, and reporting
• Demonstrate strong individual contribution and teamwork, with excellent communication skills
• Adapt quickly to change with a flexible, cooperative work style and ability to reprioritize as needed

Requirements

------------

• Bachelor of Science (BS) in Computer Science or Information Systems (or equivalent work experience)
• 7-10+ years of overall IT experience in software development or data-related roles, with evidence of increasing responsibility
• 5-7 years of significant data analysis experience, including 2-4 years building complex data models
• 3-5 years of strong Snowflake experience; Ability to construct complex SQL queries
• 2+ years of data profiling experience
• Proven experience with programming languages such as SQL and Python for data manipulation and analysis
• Experience with data analysis and visualization tools such as SAP BO, Power BI and Excel
• Extensive knowledge of advanced concepts, practices, and procedures in analytic database environments
• Proficiency with best practices in data modelling, data analysis, and data warehousing concepts
• Ability to understand requirements and create complex relational data models
• Ability to create data flow and process flow diagrams
• Knowledge of BI methodologies, Data Marts, Data Warehousing, OLAP tools and techniques (a plus)
• Experience in professional services, accounting industry, or client service/consultative technology roles (a plus)
• Strong analytical and problem-solving skills
• Ability to effectively diagnose, isolate, and resolve complex problems pertaining to data infrastructure
• Good business knowledge and confident decision-making skills
• Excellent written and oral communication skills
• Ability to communicate strategies around data modelling and architecture to cross-functional teams and business executives
• Attention to detail and ability to maintain data accuracy and integrity
• Ability to work with large datasets through data cleaning, preprocessing, and transformation techniques
• Able to work in an ambiguous and/or changing work environment
• Stay updated with industry trends and best practices in data analysis, modeling, and reporting