[Hiring] Data Analyst @Smith Johnson Tech

Role Description

Data Analyst – Data Integration & Enablement

Come join our client as a Data Analyst and play a critical role in building and maintaining the data foundation that powers regulatory and financial reporting, analytics, and innovation. This role focuses on integrating data from diverse source systems into our modern platforms—including the Enterprise Data Warehouse, Data Lake, Data Mesh, and ODS—ensuring accuracy, compliance, and usability.

You’ll work closely with business and technology teams to gather requirements, profile source systems, and design data flows that meet operational and strategic needs. From documenting metadata and transformation logic to creating test cases and validating data quality, you’ll help deliver trusted data for the entire organization.

If you’re passionate about SQL, Python, and modern data tools—and excited about technologies like dbt, Databricks on GCP, and AI-driven solutions—this is your opportunity to make an impact.

Qualifications

• 2+ years experience or strong academic background with SQL and Python skills
• 2+ years in data analysis, integration, or related areas
• 2+ years with leadership in projects or mentoring others
• Bachelor’s degree in data, analytics, business, or related field

Requirements

• Advanced SQL for data profiling, transformation, and testing/validation
• Exposure to modern data stack tools such as dbt, Databricks, and GCP
• Familiarity with AI concepts and prompt engineering is a plus
• Strong ability to gather requirements, communicate with stakeholders, and document processes
• Excellent problem-solving, analytical thinking, and communication skills
• A combination of education and experience may meet job requirements.

Benefits

• Eligible for medical, dental, life, and disability insurance
• Smith Johnson pays for 70% of your medical and dental and 100% of life and disability
• Contract is eligible for PTO/holiday accrued monthly
• Eligible for a 3% retirement matching plan
• Smith Johnson believes in taking care of our contractors