DEPT®

We deliver Growth Invention for the world's most ambitious companies.

Data Analyst/BI Engineer

Financial Planning and AnalysisFinancial Planning and AnalysisFull TimeRemoteTeam 1,001-5,000H1B No SponsorCompany SiteLinkedIn

Location

United States

Posted

34 days ago

Salary

Not specified

No structured requirement data.

Job Description

The Senior Data Analyst / BI Engineer role will require partnering with key internal (intra-team and cross-disciplinary) stakeholders to implement automated reporting deliverables and work with our broader team to contribute to and evolve our automation and reporting services. The ideal candidate will be able to help support the team in development work by unifying multiple data sources and evolving our process to create and maintain reporting and analytical tools. Interact with internal and external stakeholders to develop products and services focused on data automation Ingest data in our database from multiple sources using API calls and ETL tools Manipulate data for reporting using SQL to consolidate dimensions and metrics across tables Link the SQL view to a variety of visualization tools and customize the reports to meet the customers’ needs Use Python to automate pipelines and transform data Act as a subject matter expert and partner to our internal teams

Job Requirements

  • Expertise with data visualization tools such as Tableau, Google Sheets, Looker/Data Studio
  • Advanced experience developing custom SQL & an ability to troubleshoot complex SQL scripts
  • Advanced Architectural fluency across complex data ecosystems
  • Experience working with Digital Marketing data
  • Fluency in scripting languages (JavaScript, Google Apps Script, etc.)
  • Experience with MS SQL Server, Big Query, Snowflake, Azure or other data extraction, transformation and storage tools preferred
  • Knowledge of collecting and storing data using data transfer tools such as SSIS or Matillion
  • Experience with Secure Storage (sFTP, S3, etc.)
  • Experience with GCP or similar platforms
  • Requires excellent organizational, written, and communication skills
  • Ability to manage multiple tasks to completion within established deadlines
  • Strong desire to innovate with strong problem-solving, technical, and communication skills
  • 5+ years of relevant work experience
  • Work with internal teams, external partners, and clients to assess automation needs
  • Take lead on projects and contribute to the evolution of processes
  • Lead data quality assurance efforts, proactively validating datasets against sources of truth
  • Manage creation, implementation, validation, and ongoing support of data visualization tools and recurring reports
  • Grow credibility with internal and external stakeholders by exceeding expectations
  • Develop and refine best practices and documentation around onboarding and usability
  • Design, develop, and maintain automation that supports DEPT’s existing data ingestion, validation, and operational workflows

Benefits

  • Healthcare, Dental, and Vision coverage
  • 401k plan, plus matching
  • PTO
  • Paid Company Holidays
  • Parental Leave

Related Job Pages

More Financial Planning and Analysis Jobs

Senior OTR Finance Manager – Advanced Nuclear Projects

Switzerland Global Enterprise

We support Swiss SMEs in their international business and help innovative foreign companies to establish in Switzerland.

Financial Planning and Analysis34 days ago
Full TimeRemoteTeam 51-200Since 1927H1B No Sponsor

Finance Manager leading financial management for Advanced Nuclear projects

ERP
United States
$147.4K - $245.6K / year
Financial Planning and Analysis34 days ago
Full TimeRemoteTeam 11-50H1B No Sponsor

Senior Manager of Customer Finance leading billing and revenue operations.

United States
$130K - $150K / year

Senior Director of Strategic Planning – Resource Management

Epicor

We’re the essential partner to the world’s most essential businesses.

Financial Planning and Analysis34 days ago
Full TimeRemoteTeam 1,001-5,000Since 1972H1B Sponsor

Senior Director managing resource strategy and planning for Consulting Services

United States
$192K - $327K / year

Senior OTR Finance Manager – Advanced Nuclear Projects

GE Vernova

GE Vernova offers a great work environment, professional development, challenging careers, and competitive compensation. GE Vernova is an Equal Opportunity Employer.

Financial Planning and Analysis34 days ago
Full TimeRemoteTeam 10,001+H1B No Sponsor

Senior OTR Finance Manager leading financial management for major nuclear projects

ERP
United States
$147.4K - $245.6K / year