San Ramon, CA - Be Onsite by February (Open to Non-locals willing to relocate)
6 Month Contract to Hire (Green Card, Citizen only, EAD Green Card)
Notes from Call with Manager:
Senior Datawarehouse Analyst
Current Team Size: 2 People
Must have:
- GCP (Google Cloud Platform)
- Setup configuration
- Exp with Data presentation layer
- Understanding of these GCP tools: Cloud Composer, Cloud Data Flow, Cloud Data Fusion, Cloud Data Studio, IAM policies.
- ETL
- Data Insights
- Presentations
- Define Pipelines
- Will help with data uploads, data analysis
- Build new pipelines
- Must understand how data comes in.
- Exposure to large datasets
They are in telecom space, agents work with end costumers. Telemarketing. There platform connects the needs of the customer with the right agent.
JOB DESCRIPTION
Blackstone Talent Group, an award-winning technology consulting and talent agency is seeking a Senior Data Warehouse Engineer to join our team at our client’s site in San Ramon.
Key Responsibilities:
- Work closely with our operation team to create and track key metrics for our finance organization, and share informative actionable insights
- Improve existing process for warehouse operations
- Optimize capacity of warehouse
- Build dashboards, self-service tools, and ad hoc reports to analyze and present data associated with business operations, and strategic decision making
- Identify actionable insights, suggest recommendations, and influence the direction of the business by effectively communicating metrics and results to stakeholders.
- Partner with Data Engineering to develop our data infrastructure supporting BI needs
- Ability to work across multiple facets of a project and juggle multiple tasks at the same time.
Key Skills:
- Create clean, reliable, and scalable “single-source-of-truth” data sets by partnering with business owners and engineering teams to address data issues in upstream systems.
- Perform data profiling on large, complex data sets and provide insights into data quality challenges.
- Build, maintain, and improve data models, dashboards, and data pipelines
- Expert in building, deploying and maintaining data pipelines using open source tools i.e, Python, Airflow
- Work with business and engineering teams to drive the development of company’s data, reporting, and analytics platforms
- Skilled at writing optimized data extract queries in BigData systems (i.e., BigQuery, Hadoop, DOMO, Birst)
- Expert in data analysis, visualization, and communication
- Experience creating dashboards/visualizations using Tableau, Business Object, PowerBI, Looker (or similar)
- Proficiency with SQL, and comfort with Python or any other scripting language
Additional Qualifications:
- BS/MS in STEM or quantitative field (CS, Applied Statistics, Operations Research) or BS/MBA in Finance, Accounting, Economics, Business Analytics
- Required 5+ years of experience in data analysis role
- Experience working in a fast-paced agile environment.
- Experience working with enterprise systems and understanding of data design pattern differences between transactional systems and analytical data warehouses
- Experience with data analytics tools and languages (R, Python)
- Experience with commercial and emerging BI databases, technologies, and languages
- Knowledge of accounting principles, financial statements, and financial modeling
- Excellent problem-framing, problem solving and project mgmt. skills and ability to change direction quickly
- Experience with git and version control workflows
- Attention to detail and personal pride in work undertaken.
- Ability to self-start and self-direct work in an unstructured environment, comfortable dealing with ambiguity
- Strong communication skills, and ability to work with multiple stakeholders