Job Closed
This listing is no longer active.
DEPT Agency aims to be a leading digital services provider specializing in digital products, marketing solutions, and advertising experiences. The company foste
Data Analyst/BI Engineer
Location
United States
Posted
128 days ago
Salary
$85K - $110K / year
Seniority
Mid Level
No structured requirement data.
Job Description
Data Analyst/BI Engineer
DEPT Agency
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 Guides
Related Categories
Related Job Pages
More Financial Planning and Analysis Jobs
Financial Analyst
Gedanken - GCertificaPlataforma #1 de Onboarding (cadastro, homologação e DDI), gestão de risco e performance de fornecedores.
• Collect, organize and analyze financial data to support decision-making. • Prepare periodic and ad hoc financial reports for leadership. • Assist in preparing the budget and financial forecasts, in partnership with other departments. • Monitor the company's cash flow and identify trends and risks. • Support the identification of cost-reduction opportunities and operational efficiency improvements. • Ensure the accuracy and integrity of accounting records, including journal entries and reconciliations. • Participate in specific projects, providing financial analysis and support for initiative implementation. • Collaborate in the preparation of documents and information for internal and external audits. • Work closely with teams such as Sales, Marketing and Operations, supporting their financial needs.
Senior Accounting Manager – Finance
World Business Lenders, LLCSmall Business Loans for Big Business Growth.
• Lead and manage the monthly, quarterly, and annual financial close processes, ensuring accuracy and timeliness • Prepare and review financial statements in accordance with U.S. GAAP for individual entities and consolidated groups • Oversee consolidation accounting, including intercompany eliminations and reconciliations • Coordinate and act as the primary point of contact for external auditors, including planning, execution, and resolution of audit matters • Ensure successful completion of the 2025 consolidated audit by August • Support FP&A by providing variance analysis, financial insights, and explanations of actuals vs. budget/forecast • Prepare and review management and Board-level financial reports and presentations • Establish, document, and improve accounting policies, procedures, and internal controls • Lead, mentor, and develop the accounting team, including 3 Team Leads and 6–8 Analysts • Proactively identify process improvements to achieve a 5-business-day month-end close within 6 months • Partner cross-functionally with Finance, FP&A, and other departments to ensure timely and accurate financial input.
Senior OTR Finance Manager – Advanced Nuclear Projects
Switzerland Global EnterpriseWe support Swiss SMEs in their international business and help innovative foreign companies to establish in Switzerland.
• Lead project financials for assigned projects • Deliver monthly inputs for Project Reviews, Finance Reviews, and Operating Reviews • Support contract handover from Inquiry to Order (ITO), to Order to Remittance (OTR) • Produce concise, executive-ready materials for leadership and board reviews • Own forecasting for assigned projects across revenue, margin, EBIT, and cash • Drive margin and cash improvement through structured Project Margin Reviews • Provide key income statement, balance sheet and cash flow metrics for forecasts and actual results • Simplify and automate reporting by standardizing templates and leveraging ERP/BI tools
Senior FP&A Manager
roadsurferWe are more than Europe's largest campervan rental company. In 2021 we launched our platform roadsurfer spots in addition to our other products rent, abo and sales – a platform where you can discover and book unique camping spots. But that’s only the beginning. We are growing fast, so hop on board and join us on our journey. The roadsurfer philosophy is simple: rent an RV, start your adventure, be happy. Come ride the wave with us!
• Lead and manage planning and budgeting processes, coordinating with key business stakeholders. Candidates should be comfortable taking ownership of and improving 13-week cash/liquidity forecasts. • Professionalize and adapt financial reporting for capital providers (equity and debt investors, including banks). • Support various project-based initiatives such as process improvements and automation that require financial expertise and in-depth analysis. • Work closely with major business units across roadsurfer, providing analytical and financial support for cross-functional projects. • Reevaluate and further develop existing processes to raise professionalism and operational efficiency.



