Data Analyst

Job#: 3017569

Job Description:

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.

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.

2+ years of data profiling experience.

3-5 years of strong Snowflake experience; ability to construct complex SQL queries.

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 to interpret complex data sources and generate meaningful insights.

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, including business writing.

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.

Team oriented, flexible, and 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.

Apex Systems is a world-class IT services company that serves thousands of clients across the globe. When you join Apex, you become part of a team that values innovation, collaboration, and continuous learning. We offer quality career resources, training, certifications, development opportunities, and a comprehensive benefits package. Our commitment to excellence is reflected in many awards, including ClearlyRated's Best of Staffing in Talent Satisfaction in the United States and Great Place to Work in the United Kingdom and Mexico. Apex uses a virtual recruiter as part of the application process. Click for more details.

Apex Benefits Overview: Apex offers a range of supplemental benefits, including medical, dental, vision, life, disability, and other insurance plans that offer an optional layer of financial protection. We offer an ESPP (employee stock purchase program) and a 401K program which allows you to contribute typically within 30 days of starting, with a company match after 12 months of tenure. Apex also offers a HSA (Health Savings Account on the HDHP plan), a SupportLinc Employee Assistance Program (EAP) with up to 8 free counseling sessions, a corporate discount savings program and other discounts. In terms of professional development, Apex hosts an on-demand training program, provides access to certification prep and a library of technical and leadership courses/books/seminars once you have 6+ months of tenure, and certification discounts and other perks to associations that include CompTIA and IIBA. Apex has a dedicated customer service team for our Consultants that can address questions around benefits and other resources, as well as a certified Career Coach. You can access a full list of our benefits, programs, support teams and resources within our 'Welcome Packet' as well, which an Apex team member can provide.